View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Error calculate planning V7.0.9 - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Error calculate planning V7.0.9

More
23 Mai 2018 10:45 #1 by Durou C
When I try to calculate planning general project, it's not working I have Error on log file:

2018-05-22 12:13:26.578 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:13:26.578 ***** ERROR ***** [V7.0.9] For query : delete from plannedwork where (idProject in (3, 87, 88, 221, 437, 5, 20, 33, 57, 68, 94, 124, 184, 187, 197, 222, 223, 224, 225, 232, 237, 240, 260, 348, 349, 350, 351, 364, 352, 366, 370, 375, 376, 380, 381, 388, 390, 392, 397, 400, 413, 415, 416, 417, 420, 421, 423, 425, 427, 428, 430, 432, 433, 435, 438, 439, 446, 450, 457, 458, 459, 460, 462, 463, 465, 466, 467, 469, 470, 471, 476, 477, 478, 479, 481, 482, 483, 484, 485) ) and idProject not in (0) and idProject in (16, 23, 24, 25, 1, 2, 94, 3, 83, 85, 86, 87, 88, 221, 84, 363, 437, 4, 5, 6, 7, 8, 9, 10, 11, 12, 104, 165, 267, 338, 13, 14, 17, 18, 19, 20, 21, 22, 26, 27, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 58, 59, 63, 60, 61, 62, 73, 208, 209, 210, 211, 212, 213, 214, 215, 216, 57, 182, 66, 33, 68, 69, 70, 71, 72, 76, 77, 79, 81, 90, 91, 92, 96, 97, 98, 100, 101, 106, 107, 108, 112, 114, 117, 118, 119, 120, 121, 123, 125, 126, 127, 128, 130, 147, 148, 149, 150, 151, 152, 153, 154, 155, 132, 134, 133, 136, 140, 141, 82, 111, 144, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 93, 80, 64, 65, 67, 74, 75, 89, 99, 105, 102, 103, 110, 116, 122, 166, 259, 245, 196, 304, 322, 347, 377, 113, 15, 28, 143, 109, 146, 95, 167, 168, 169, 179, 180, 170, 171, 172, 173, 174, 175, 176, 177, 178, 181, 115, 183, 200, 202, 203, 204, 205, 206, 201, 217, 218, 226, 227, 228, 229, 230, 258, 231, 124, 156, 157, 158, 159, 160, 161, 162, 163, 232, 197, 198, 199, 236, 325, 326, 327, 344, 362, 246, 249, 250, 251, 252, 253, 254, 255, 256, 247, 248, 266, 274, 275, 276, 277, 279, 280, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 296, 298, 299, 300, 301, 302, 303, 305, 306, 307, 278, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 324, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 343, 345, 346, 237, 260, 465, 467, 348, 349, 350, 351, 364, 352, 353, 354, 355, 356, 358, 361, 365, 375, 376, 381, 388, 397, 390, 392, 475, 428, 413, 369, 371, 372, 373, 379, 380, 44, 438, 439, 446, 423, 238, 240, 239, 222, 223, 224, 225, 235, 234, 378, 389, 391, 393, 394, 395, 396, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 414, 415, 416, 417, 420, 421, 422, 425, 430, 457, 471, 478, 450, 470, 427, 431, 432, 433, 435, 436, 454, 456, 463, 469, 474, 458, 459, 460, 461, 462, 466, 468, 473, 477, 476, 187, 188, 189, 190, 192, 241, 242, 244, 184, 185, 261, 262, 263, 264, 265, 268, 269, 270, 271, 272, 273, 297, 323, 341, 382, 186, 370, 366, 479, 480, 481, 482, 483, 484, 485)
2018-05-22 12:13:26.578 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:13:26.579 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1798]
2018-05-22 12:13:26.579 ***** ERROR ***** [V7.0.9] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:813]
2018-05-22 12:13:26.579 ***** ERROR ***** [V7.0.9] #2 SqlElement->purge called at [/var/www/projeqtor/model/PlannedWork.php:189]
2018-05-22 12:13:26.579 ***** ERROR ***** [V7.0.9] #3 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:14:21.586 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:14:21.586 ***** ERROR ***** [V7.0.9] For query : INSERT into plannedwork (idResource,idProject,refType,refId,idAssignment,work,workDate,day,week,month,year) VALUES ('13','184','Activity','2096','9266','0.05405','2018-07-24','20180724','201830','201807','2018'), ('13','184','Activity','2096','9266','0.79729','2018-07-25','20180725','201830','201807','2018'), ('13','184','Activity','2096','9266','0.14866','2018-07-26','20180726','201830','201807','2018'), ('12','184','Activity','2095','9264','0.19536','2018-06-19','20180619','201825','201806','2018'), ('12','184','Activity','2095','9264','0.28262','2019-01-03','20190103','201901','201901','2019'), ('12','184','Activity','2095','9264','1.08','2019-01-04','20190104','201901','201901','2019'), ('12','184','Activity','2095','9264','0.60418','2019-01-07','20190107','201902','201901','2019'), ('31','184','Activity','2098','9270','1.0155','2018-07-16','20180716','201829','201807','2018'), ('31','184','Activity','2098','9270','1.08','2018-07-17','20180717','201829','201807','2018'), ('31','184','Activity','2098','9270','0.06666','2018-07-18','20180718','201829','201807','2018'), ('52','184','Activity','2097','9268','0.04805','2018-07-03','20180703','201827','201807','2018'), ('52','184','Activity','2097','9268','1.03303','2018-07-04','20180704','201827','201807','2018'), ('18','184','Activity','2093','9260','0.13514','2018-06-05','20180605','201823','201806','2018'), ('18','184','Activity','2093','9260','0.94594','2018-06-06','20180606','201823','201806','2018'), ('18','184','Activity','2093','9260','0.75676','2018-06-11','20180611','201824','201806','2018'), ('18','184','Activity','2093','9260','0.13513','2018-06-12','20180612','201824','201806','2018'), ('39','184','Activity','2115','9360','0.59459','2018-06-25','20180625','201826','201806','2018'), ('39','184','Activity','2115','9360','0.40541','2018-06-26','20180626','201826','201806','2018'), ('6','184','Activity','2115','9361','0.54667','2018-07-06','20180706','201827','201807','2018'), ('6','184','Activity','2115','9361','0.53441','2018-07-09','20180709','201828','201807','2018'), ('8','184','Activity','2122','9385','0.75999','2018-06-15','20180615','201824','201806','2018'), ('8','184','Activity','2122','9385','0.32108','2018-06-18','20180618','201825','201806','2018'), ('9','184','Activity','2122','9386','0.831','2018-05-22','20180522','201821','201805','2018'), ('9','184','Activity','2122','9386','0.25008','2018-05-23','20180523','201821','201805','2018'), ('6','184','Activity','2122','9388','0.54659','2018-07-09','20180709','201828','201807','2018'), ('6','184','Activity','2122','9388','0.53449','2018-07-10','20180710','201828','201807','2018'), ('5','184','Activity','2123','9391','1.08','2018-05-22','20180522','201821','201805','2018'), ('8','184','Activity','2123','9392','0.27698','2018-06-22','20180622','201825','201806','2018'), ('8','184','Activity','2123','9392','0.65922','2018-06-25','20180625','201826','201806','2018'), ('8','184','Activity','2123','9392','0.14488','2018-06-26','20180626','201826','201806','2018'), ('9','184','Activity','2123','9393','0.83092','2018-05-23','20180523','201821','201805','2018'), ('9','184','Activity','2123','9393','0.25016','2018-05-24','20180524','201821','201805','2018'), ('6','184','Activity','2123','9395','0.54651','2018-07-10','20180710','201828','201807','2018'), ('6','184','Activity','2123','9395','0.53457','2018-07-11','20180711','201828','201807','2018'), ('8','184','Activity','2124','9399','0.73342','2018-06-26','20180626','201826','201806','2018'), ('8','184','Activity','2124','9399','0.34766','2018-06-27','20180627','201826','201806','2018'), ('9','184','Activity','2124','9400','0.58084','2018-05-24','20180524','201821','201805','2018'), ('9','184','Activity','2124','9400','0.50024','2018-05-25','20180525','201821','201805','2018'), ('6','184','Activity','2124','9402','0.54643','2018-07-11','20180711','201828','201807','2018'), ('6','184','Activity','2124','9402','0.53465','2018-07-12','20180712','201828','201807','2018'), ('8','184','Activity','2149','9489','0.5982','2018-06-27','20180627','201826','201806','2018'), ('8','184','Activity','2149','9489','0.48288','2018-06-28','20180628','201826','201806','2018'), ('9','184','Activity','2149','9490','0.33076','2018-05-25','20180525','201821','201805','2018'), ('9','184','Activity','2149','9490','0.75032','2018-05-28','20180528','201822','201805','2018'), ('39','184','Activity','2149','9491','0.59459','2018-06-26','20180626','201826','201806','2018'), ('39','184','Activity','2149','9491','0.40541','2018-06-27','20180627','201826','201806','2018'), ('6','184','Activity','2149','9492','0.54635','2018-07-12','20180712','201828','201807','2018'), ('6','184','Activity','2149','9492','0.53473','2018-07-13','20180713','201828','201807','2018'), ('12','352','Activity','1289','6826','0.27027','2019-01-07','20190107','201902','201901','2019'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-04','20180904','201836','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-05','20180905','201836','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-06','20180906','201836','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-07','20180907','201836','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-10','20180910','201837','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-11','20180911','201837','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-12','20180912','201837','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-13','20180913','201837','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-14','20180914','201837','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-17','20180917','201838','201809','2018'), ('8','458','Activity','1959','8900','0.1351351352','2018-09-18','20180918','201838','201809','2018'), ('8','458','Activity','1959','8900','0.0675675676','2018-09-19','20180919','201838','201809','2018'), ('12','458','Activity','1959','9080','0.20655','2019-01-07','20190107','201902','201901','2019'), ('12','458','Activity','1959','9080','0.19886','2019-01-08','20190108','201902','201901','2019'), ('12','376','Activity','1418','7434','0.88214','2019-01-08','20190108','201902','201901','2019'), ('12','376','Activity','1418','7434','1.08','2019-01-09','20190109','201902','201901','2019'), ('12','376','Activity','1418','7434','1.08','2019-01-10','20190110','201902','201901','2019'), ('12','376','Activity','1418','7434','1.08','2019-01-11','20190111','201902','201901','2019'), ('12','376','Activity','1418','7434','1.08','2019-01-14','20190114','201903','201901','2019'), ('12','376','Activity','1418','7434','1.08','2019-01-15','20190115','201903','201901','2019'), ('12','376','Activity','1418','7434','1.08','2019-01-16','20190116','201903','201901','2019'), ('12','376','Activity','1418','7434','1.08','2019-01-17','20190117','201903','201901','2019'), ('12','376','Activity','1418','7434','0.61191','2019-01-18','20190118','201903','201901','2019'), ('13','376','Activity','1418','7437','0.2027027028','2018-07-26','20180726','201830','201807','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-07-27','20180727','201830','201807','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-07-30','20180730','201831','201807','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-07-31','20180731','201831','201807','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-01','20180801','201831','201808','2018'), ('13','376','Activity','1418','7437','0.1351351352','2018-08-02','20180802','201831','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-03','20180803','201831','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-21','20180821','201834','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-22','20180822','201834','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-23','20180823','201834','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-24','20180824','201834','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-27','20180827','201835','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-28','20180828','201835','201808','2018'), ('13','376','Activity','1418','7437','0.1351351352','2018-08-29','20180829','201835','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-30','20180830','201835','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-08-31','20180831','201835','201808','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-03','20180903','201836','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-04','20180904','201836','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-05','20180905','201836','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-06','20180906','201836','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-07','20180907','201836','201809','2018'), ('13','376','Activity','1418','7437','0.1351351352','2018-09-10','20180910','201837','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-11','20180911','201837','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-12','20180912','201837','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-13','20180913','201837','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-14','20180914','201837','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-17','20180917','201838','201809','2018'), ('13','376','Activity','1418','7437','0.2027027028','2018-09-18','20180918','201838','201809','2018');
2018-05-22 12:14:21.586 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:14:21.586 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlDirectElement.php:83]
2018-05-22 12:14:21.586 ***** ERROR ***** [V7.0.9] #1 SqlDirectElement->execute called at [/var/www/projeqtor/model/PlannedWork.php:1093]
2018-05-22 12:14:21.587 ***** ERROR ***** [V7.0.9] #2 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:15:30.619 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:15:30.619 ***** ERROR ***** [V7.0.9] For query : delete from plannedwork where (idProject in (3, 87, 88, 221, 437, 5, 20, 33, 57, 68, 94, 124, 184, 187, 197, 222, 223, 224, 225, 232, 237, 240, 260, 348, 349, 350, 351, 364, 352, 366, 370, 375, 376, 380, 381, 388, 390, 392, 397, 400, 413, 415, 416, 417, 420, 421, 423, 425, 427, 428, 430, 432, 433, 435, 438, 439, 446, 450, 457, 458, 459, 460, 462, 463, 465, 466, 467, 469, 470, 471, 476, 477, 478, 479, 481, 482, 483, 484, 485) ) and idProject not in (0) and idProject in (16, 23, 24, 25, 1, 2, 94, 3, 83, 85, 86, 87, 88, 221, 84, 363, 437, 4, 5, 6, 7, 8, 9, 10, 11, 12, 104, 165, 267, 338, 13, 14, 17, 18, 19, 20, 21, 22, 26, 27, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 58, 59, 63, 60, 61, 62, 73, 208, 209, 210, 211, 212, 213, 214, 215, 216, 57, 182, 66, 33, 68, 69, 70, 71, 72, 76, 77, 79, 81, 90, 91, 92, 96, 97, 98, 100, 101, 106, 107, 108, 112, 114, 117, 118, 119, 120, 121, 123, 125, 126, 127, 128, 130, 147, 148, 149, 150, 151, 152, 153, 154, 155, 132, 134, 133, 136, 140, 141, 82, 111, 144, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 93, 80, 64, 65, 67, 74, 75, 89, 99, 105, 102, 103, 110, 116, 122, 166, 259, 245, 196, 304, 322, 347, 377, 113, 15, 28, 143, 109, 146, 95, 167, 168, 169, 179, 180, 170, 171, 172, 173, 174, 175, 176, 177, 178, 181, 115, 183, 200, 202, 203, 204, 205, 206, 201, 217, 218, 226, 227, 228, 229, 230, 258, 231, 124, 156, 157, 158, 159, 160, 161, 162, 163, 232, 197, 198, 199, 236, 325, 326, 327, 344, 362, 246, 249, 250, 251, 252, 253, 254, 255, 256, 247, 248, 266, 274, 275, 276, 277, 279, 280, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 296, 298, 299, 300, 301, 302, 303, 305, 306, 307, 278, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 324, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 343, 345, 346, 237, 260, 465, 467, 348, 349, 350, 351, 364, 352, 353, 354, 355, 356, 358, 361, 365, 375, 376, 381, 388, 397, 390, 392, 475, 428, 413, 369, 371, 372, 373, 379, 380, 44, 438, 439, 446, 423, 238, 240, 239, 222, 223, 224, 225, 235, 234, 378, 389, 391, 393, 394, 395, 396, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 414, 415, 416, 417, 420, 421, 422, 425, 430, 457, 471, 478, 450, 470, 427, 431, 432, 433, 435, 436, 454, 456, 463, 469, 474, 458, 459, 460, 461, 462, 466, 468, 473, 477, 476, 187, 188, 189, 190, 192, 241, 242, 244, 184, 185, 261, 262, 263, 264, 265, 268, 269, 270, 271, 272, 273, 297, 323, 341, 382, 186, 370, 366, 479, 480, 481, 482, 483, 484, 485)
2018-05-22 12:15:30.619 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:15:30.619 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1798]
2018-05-22 12:15:30.619 ***** ERROR ***** [V7.0.9] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:813]
2018-05-22 12:15:30.619 ***** ERROR ***** [V7.0.9] #2 SqlElement->purge called at [/var/www/projeqtor/model/PlannedWork.php:189]
2018-05-22 12:15:30.619 ***** ERROR ***** [V7.0.9] #3 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] For query : update assignment set notPlannedWork='0' where id=8993
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:16:25.604 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:17:16.611 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] For query : update assignment set notPlannedWork='0' where id=9315
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:17:16.612 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] For query : update assignment set notPlannedWork='0.13514' where id=9465
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:18:07.619 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:18:58.626 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] For query : update assignment set notPlannedWork='0.13514' where id=9466
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:18:58.627 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] For query : update assignment set notPlannedWork='0' where id=9107
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:19:49.634 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:20:40.641 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:20:40.641 ***** ERROR ***** [V7.0.9] For query : update assignment set notPlannedWork='0' where id=9108
2018-05-22 12:20:40.642 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:20:40.642 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:20:40.642 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:20:40.642 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:20:40.642 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:20:40.642 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:20:40.642 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] For query : update assignment set notPlannedWork='0' where id=9186
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:21:31.649 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-07-24' , plannedStartFraction='0.95' , plannedEndDate='2018-07-26' , plannedEndFraction='0.29' where id=9266
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:22:22.656 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:23:13.663 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-06-19' , plannedStartFraction='0.82' , plannedEndDate='2019-01-07' , plannedEndFraction='0.56' where id=9264
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:23:13.664 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-07-16' , plannedStartFraction='0.06' , plannedEndDate='2018-07-18' , plannedEndFraction='0.06' where id=9270
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:24:04.671 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:25:28.682 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:25:28.683 ***** ERROR ***** [V7.0.9] For query : delete from plannedwork where (idProject in (3, 87, 88, 221, 437, 5, 20, 33, 57, 68, 94, 124, 184, 187, 197, 222, 223, 224, 225, 232, 237, 240, 260, 348, 349, 350, 351, 364, 352, 366, 370, 375, 376, 380, 381, 388, 390, 392, 397, 400, 413, 415, 416, 417, 420, 421, 423, 425, 427, 428, 430, 432, 433, 435, 438, 439, 446, 450, 457, 458, 459, 460, 462, 463, 465, 466, 467, 469, 470, 471, 476, 477, 478, 479, 481, 482, 483, 484, 485) ) and idProject not in (0) and idProject in (16, 23, 24, 25, 1, 2, 94, 3, 83, 85, 86, 87, 88, 221, 84, 363, 437, 4, 5, 6, 7, 8, 9, 10, 11, 12, 104, 165, 267, 338, 13, 14, 17, 18, 19, 20, 21, 22, 26, 27, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 58, 59, 63, 60, 61, 62, 73, 208, 209, 210, 211, 212, 213, 214, 215, 216, 57, 182, 66, 33, 68, 69, 70, 71, 72, 76, 77, 79, 81, 90, 91, 92, 96, 97, 98, 100, 101, 106, 107, 108, 112, 114, 117, 118, 119, 120, 121, 123, 125, 126, 127, 128, 130, 147, 148, 149, 150, 151, 152, 153, 154, 155, 132, 134, 133, 136, 140, 141, 82, 111, 144, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 93, 80, 64, 65, 67, 74, 75, 89, 99, 105, 102, 103, 110, 116, 122, 166, 259, 245, 196, 304, 322, 347, 377, 113, 15, 28, 143, 109, 146, 95, 167, 168, 169, 179, 180, 170, 171, 172, 173, 174, 175, 176, 177, 178, 181, 115, 183, 200, 202, 203, 204, 205, 206, 201, 217, 218, 226, 227, 228, 229, 230, 258, 231, 124, 156, 157, 158, 159, 160, 161, 162, 163, 232, 197, 198, 199, 236, 325, 326, 327, 344, 362, 246, 249, 250, 251, 252, 253, 254, 255, 256, 247, 248, 266, 274, 275, 276, 277, 279, 280, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 296, 298, 299, 300, 301, 302, 303, 305, 306, 307, 278, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 324, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 343, 345, 346, 237, 260, 465, 467, 348, 349, 350, 351, 364, 352, 353, 354, 355, 356, 358, 361, 365, 375, 376, 381, 388, 397, 390, 392, 475, 428, 413, 369, 371, 372, 373, 379, 380, 44, 438, 439, 446, 423, 238, 240, 239, 222, 223, 224, 225, 235, 234, 378, 389, 391, 393, 394, 395, 396, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 414, 415, 416, 417, 420, 421, 422, 425, 430, 457, 471, 478, 450, 470, 427, 431, 432, 433, 435, 436, 454, 456, 463, 469, 474, 458, 459, 460, 461, 462, 466, 468, 473, 477, 476, 187, 188, 189, 190, 192, 241, 242, 244, 184, 185, 261, 262, 263, 264, 265, 268, 269, 270, 271, 272, 273, 297, 323, 341, 382, 186, 370, 366, 479, 480, 481, 482, 483, 484, 485)
2018-05-22 12:25:28.683 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:25:28.683 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1798]
2018-05-22 12:25:28.683 ***** ERROR ***** [V7.0.9] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:813]
2018-05-22 12:25:28.683 ***** ERROR ***** [V7.0.9] #2 SqlElement->purge called at [/var/www/projeqtor/model/PlannedWork.php:189]
2018-05-22 12:25:28.683 ***** ERROR ***** [V7.0.9] #3 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:26:23.690 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:26:23.690 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-07-03' , plannedStartFraction='0.96' , plannedEndDate='2018-07-04' , plannedEndFraction='0.96' where id=9268
2018-05-22 12:26:23.690 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:26:23.690 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:26:23.690 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:26:23.691 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:26:23.691 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:26:23.691 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:26:23.691 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-06-05' , plannedStartFraction='0.86' , plannedEndDate='2018-06-12' , plannedEndFraction='0.14' where id=9260
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:27:14.698 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-06-25' , plannedStartFraction='0.41' , plannedEndDate='2018-06-26' , plannedEndFraction='0.41' where id=9360
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:28:05.705 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-07-06' , plannedStartFraction='0.49' , plannedEndDate='2018-07-09' , plannedEndFraction='0.49' where id=9361
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:28:56.712 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-06-15' , plannedStartFraction='0.3' , plannedEndDate='2018-06-18' where id=9385
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:29:47.719 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:30:38.726 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:30:38.726 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-05-22' , plannedStartFraction='0.23' , plannedEndDate='2018-05-23' , plannedEndFraction='0.23' where id=9386
2018-05-22 12:30:38.726 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:30:38.726 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:30:38.727 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:30:38.727 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:30:38.727 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:30:38.727 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:30:38.727 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:31:29.733 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-07-09' , plannedStartFraction='0.49' , plannedEndDate='2018-07-10' , plannedEndFraction='0.49' where id=9388
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:31:29.734 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-05-22' , plannedEndDate='2018-05-22' where id=9391
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:32:20.741 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-06-22' , plannedStartFraction='0.74' , plannedEndDate='2018-06-26' , plannedEndFraction='0.32' where id=9392
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:33:11.748 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]
2018-05-22 12:34:02.755 ***** ERROR ***** [V7.0.9] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] For query : update assignment set plannedStartDate='2018-05-23' , plannedStartFraction='0.23' , plannedEndDate='2018-05-24' , plannedEndFraction='0.46' where id=9393
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] Strack trace :
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1475]
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:980]
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:792]
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/Assignment.php:239]
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] #4 Assignment->simpleSave called at [/var/www/projeqtor/model/PlannedWork.php:1104]
2018-05-22 12:34:02.756 ***** ERROR ***** [V7.0.9] #5 PlannedWork->plan called at [/var/www/projeqtor/tool/plan.php:48]

Please Connexion or Create an account to join the conversation.

More
23 Mai 2018 23:44 #2 by babynus
Yes, possibly planning 505 projects at the same time can be quite long and lead to locking tables, moreover if other users are wroking in the same time and entering work...
Try and use planned calculation to replan all project during the night...

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.040 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.