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

Error calculate planning V7.0.9

More
23 May 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 Log in or Create an account to join the conversation.

More
23 May 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.047 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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