Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
until the 7.3.0 version, I've a lot of error appears when i had consistency checks.
Projeqtor say that the anomaly is checked, but if i did a new scan, it's exactly the same.
extract of log file:
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] For query : update planningelement set realWork='448.01338' , plannedWork='470.22941' , realCost='197434.74' , plannedCost='205507.53' , expectedProgress='28336' where id=2160
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/PlanningElement.php:413]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #4 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #5 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #6 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #7 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #8 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #9 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #10 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #11 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #12 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:15:42.218 ** ERROR ** [V7.3.0] #13 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] For query : delete from kpihistory where idKpiDefinition=1 and refType='Project' and refId=376 and kpiDate='2018-11-21'
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1819]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:819]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #2 SqlElement->purge called at [/var/www/projeqtor/model/KpiValue.php:85]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #3 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #5 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #6 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #7 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #8 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #9 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:52.219 ** ERROR ** [V7.3.0] #10 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:52.220 ** ERROR ** [V7.3.0] #11 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:52.220 ** ERROR ** [V7.3.0] #12 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:15:52.220 ** ERROR ** [V7.3.0] #13 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:15:52.220 ** ERROR ** [V7.3.0] #14 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:15:52.220 ** ERROR ** [V7.3.0] #15 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:15:52.220 ** ERROR ** [V7.3.0] #16 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:15:52.220 ** ERROR ** [V7.3.0] #17 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:16:12.157 ===== TRACE ===== NEW CONNECTED USER 'fca' (using remember me feature)
2018-11-21 16:16:33.224 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:16:33.224 ** ERROR ** [V7.3.0] For query : update planningelement set needReplan='1' where id=1072
2018-11-21 16:16:33.224 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:16:33.224 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:16:33.224 ** ERROR ** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:16:33.224 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:798]
2018-11-21 16:16:33.224 ** ERROR ** [V7.3.0] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:606]
2018-11-21 16:16:33.225 ** ERROR ** [V7.3.0] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:16:33.225 ** ERROR ** [V7.3.0] #5 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:16:33.225 ** ERROR ** [V7.3.0] #6 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:16:33.225 ** ERROR ** [V7.3.0] #7 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('1', 'Project', '376', 'D', '2018-11-21', '20181121', '201847', '201811', '2018', '1.1811023622047', '1', '0')
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1193]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:992]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:90]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #4 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #5 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #7 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #8 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #9 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #10 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #11 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #12 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:16:43.265 ** ERROR ** [V7.3.0] #13 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:16:43.266 ** ERROR ** [V7.3.0] #14 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:16:43.266 ** ERROR ** [V7.3.0] #15 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:16:43.266 ** ERROR ** [V7.3.0] #16 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:16:43.266 ** ERROR ** [V7.3.0] #17 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:16:43.266 ** ERROR ** [V7.3.0] #18 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] For query : update kpivalue set kpiValue='1.1144578313253' where id=88
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:75]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #5 KpiValue->calculateKpi called at [/var/www/projeqtor/model/PlanningElement.php:608]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #6 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #7 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #8 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:17:24.232 ** ERROR ** [V7.3.0] #9 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] For query : update kpivalue set kpiValue='1.7566666666667' where id=77
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:75]
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:234]
2018-11-21 16:17:34.233 ** ERROR ** [V7.3.0] #5 KpiValue->consolidate called at [/var/www/projeqtor/model/KpiValue.php:122]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #7 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #8 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #9 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #10 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #11 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #12 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #13 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #14 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #15 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #16 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #17 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:17:34.234 ** ERROR ** [V7.3.0] #18 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] For query : delete from kpihistory where idKpiDefinition=1 and refType='Project' and refId=184 and kpiDate='2018-11-21'
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1819]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:819]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #2 SqlElement->purge called at [/var/www/projeqtor/model/KpiValue.php:85]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #3 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #5 KpiValue->calculateKpi called at [/var/www/projeqtor/model/PlanningElement.php:608]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #6 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #7 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #8 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:18:15.239 ** ERROR ** [V7.3.0] #9 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] For query : delete from kpihistory where idKpiDefinition=1 and refType='Organization' and refId=1 and kpiDate='2018-11-21'
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1819]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #1 SqlElement->purgeSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:819]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #2 SqlElement->purge called at [/var/www/projeqtor/model/KpiValue.php:85]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #3 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #4 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:234]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #5 KpiValue->consolidate called at [/var/www/projeqtor/model/KpiValue.php:122]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #7 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #8 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #9 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #10 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:18:25.240 ** ERROR ** [V7.3.0] #11 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:18:25.241 ** ERROR ** [V7.3.0] #12 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:18:25.241 ** ERROR ** [V7.3.0] #13 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:18:25.241 ** ERROR ** [V7.3.0] #14 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:18:25.241 ** ERROR ** [V7.3.0] #15 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:18:25.241 ** ERROR ** [V7.3.0] #16 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:18:25.241 ** ERROR ** [V7.3.0] #17 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:18:25.241 ** ERROR ** [V7.3.0] #18 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:19:06.245 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:19:06.245 ** ERROR ** [V7.3.0] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('1', 'Project', '184', 'D', '2018-11-21', '20181121', '201847', '201811', '2018', '1.1144578313253', '1', '0')
2018-11-21 16:19:06.245 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:19:06.245 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1193]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:992]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:90]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #4 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #5 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:121]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #6 KpiValue->calculateKpi called at [/var/www/projeqtor/model/PlanningElement.php:608]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #7 PlanningElement->simpleSave called at [/var/www/projeqtor/model/ProjectMain.php:980]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #8 ProjectMain->setNeedReplan called at [/var/www/projeqtor/model/Assignment.php:316]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #9 Assignment->save called at [/var/www/projeqtor/model/Assignment.php:384]
2018-11-21 16:19:06.246 ** ERROR ** [V7.3.0] #10 Assignment->saveWithRefresh called at [/var/www/projeqtor/tool/saveImputation.php:134]
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('1', 'Organization', '1', 'D', '2018-11-21', '20181121', '201847', '201811', '2018', '1.7566666666667', '3', '0')
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1193]
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:992]
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/KpiValue.php:90]
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] #4 KpiValue->storeHistory called at [/var/www/projeqtor/model/KpiValue.php:77]
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] #5 KpiValue->save called at [/var/www/projeqtor/model/KpiValue.php:234]
2018-11-21 16:19:16.288 ** ERROR ** [V7.3.0] #6 KpiValue->consolidate called at [/var/www/projeqtor/model/KpiValue.php:122]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #7 KpiValue->calculateKpi called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:206]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #8 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #9 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #10 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #11 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #12 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #13 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #14 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #15 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #16 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #17 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #18 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/Assignment.php:232]
2018-11-21 16:19:16.289 ** ERROR ** [V7.3.0] #19 Assignment->save called at [/var/www/projeqtor/tool/saveLeftWork.php:44]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] Exception-[40001] SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] For query : update planningelement set realWork='241.77793' , plannedWork='353.60225' , marginWork='-86.37249' where id=1925
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1492]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #3 SqlElement->save called at [/var/www/projeqtor/model/PlanningElement.php:413]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #4 PlanningElement->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:178]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #5 ProjectPlanningElementMain->save called at [/var/www/projeqtor/model/ProjectPlanningElementMain.php:281]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #6 ProjectPlanningElementMain->updateSynthesisProject called at [/var/www/projeqtor/model/PlanningElement.php:805]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #7 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #8 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #9 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/PlanningElement.php:776]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #10 PlanningElement->updateSynthesisObj called at [/var/www/projeqtor/model/PlanningElement.php:807]
2018-11-21 16:19:55.447 ** ERROR ** [V7.3.0] #11 PlanningElement->updateSynthesis called at [/var/www/projeqtor/model/PlanningElement.php:460]
2018-11-21 16:19:55.448 ** ERROR ** [V7.3.0] #12 PlanningElement->save called at [/var/www/projeqtor/model/ActivityPlanningElementMain.php:211]
2018-11-21 16:19:55.448 ** ERROR ** [V7.3.0] #13 ActivityPlanningElementMain->save called at [/var/www/projeqtor/model/persistence/SqlElement.php:1613]
2018-11-21 16:19:55.448 ** ERROR ** [V7.3.0] #14 SqlElement->saveDependantObjects called at [/var/www/projeqtor/model/persistence/SqlElement.php:1551]
2018-11-21 16:19:55.448 ** ERROR ** [V7.3.0] #15 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:986]
2018-11-21 16:19:55.448 ** ERROR ** [V7.3.0] #16 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:655]
2018-11-21 16:19:55.448 ** ERROR ** [V7.3.0] #17 SqlElement->save called at [/var/www/projeqtor/model/ActivityMain.php:397]
2018-11-21 16:19:55.448 ** ERROR ** [V7.3.0] #18 ActivityMain->save called at [/var/www/projeqtor/tool/saveObject.php:78]
2018-11-21 16:19:56.829 ===== TRACE ===== DISCONNECTED USER 'fca'
2018-11-21 16:24:53.121 ** ERROR ** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:24:53.121 ** ERROR ** [V7.3.0] For query : select * from status where id in (select distinct idStatus from indicatordefinition) order by sortOrder asc
2018-11-21 16:24:53.121 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:24:53.121 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:24:53.121 ** ERROR ** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:24:53.121 ** ERROR ** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:24:53.121 ** ERROR ** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:25:14.035 ** ERROR ** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:25:14.035 ** ERROR ** [V7.3.0] For query : select * from status where id in (select distinct idStatus from indicatordefinition) order by sortOrder asc
2018-11-21 16:25:14.035 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:25:14.035 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:25:14.035 ** ERROR ** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:25:14.035 ** ERROR ** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:25:14.035 ** ERROR ** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:25:19.387 ** ERROR ** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:25:19.387 ** ERROR ** [V7.3.0] For query : select * from status where id in (select distinct idStatus from delay) order by sortOrder asc
2018-11-21 16:25:19.387 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:25:19.388 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:25:19.388 ** ERROR ** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:25:19.388 ** ERROR ** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:25:19.388 ** ERROR ** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:25:24.381 ** ERROR ** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:25:24.381 ** ERROR ** [V7.3.0] For query : select * from status where id in (select distinct idStatus from delay) order by sortOrder asc
2018-11-21 16:25:24.381 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:25:24.381 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:25:24.381 ** ERROR ** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:25:24.381 ** ERROR ** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:25:24.381 ** ERROR ** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:26:01.898 ** ERROR ** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:26:01.898 ** ERROR ** [V7.3.0] For query : select * from status where id in (select distinct idStatus from emailtemplate) order by sortOrder asc
2018-11-21 16:26:01.898 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:26:01.898 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:26:01.898 ** ERROR ** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:26:01.898 ** ERROR ** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:26:01.898 ** ERROR ** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
2018-11-21 16:26:06.698 ** ERROR ** [V7.3.0] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idStatus' in 'field list'
2018-11-21 16:26:06.698 ** ERROR ** [V7.3.0] For query : select * from status where id in (select distinct idStatus from emailtemplate) order by sortOrder asc
2018-11-21 16:26:06.698 ** ERROR ** [V7.3.0] Strack trace :
2018-11-21 16:26:06.698 ** ERROR ** [V7.3.0] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2371]
2018-11-21 16:26:06.698 ** ERROR ** [V7.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:6703]
2018-11-21 16:26:06.698 ** ERROR ** [V7.3.0] #2 SqlElement->getExistingStatus called at [/var/www/projeqtor/view/objectList.php:169]
2018-11-21 16:26:06.698 ** ERROR ** [V7.3.0] #3 include called at [/var/www/projeqtor/view/objectMain.php:63]
There are locks.
Fixing Consistency issues may jave impact on many items, more over if many issues are identified.
So try and execute consistency fixing without any other user connected.
Also try it after restart of db process.
I had close the projeqtor application. I had restart projeqtor computer, i had restart service apache2
and, in admin mode, I had fixe the issues.
when I scan after fixed, they always all appears... I don't understand, what's wrond...
if I open some tickets with error, I can show more real time that nobody enter, projeqtor add real time alone in many tickets...
so all of real time are wrong.
I do not understand I have a lot of error.