View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - consistency checks - ProjeQtOr
 

consistency checks

More
21 Nov 2018 16:37 #1 by Durou C
consistency checks was created by Durou C
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.
Attachments:

Please Log in or Create an account to join the conversation.

More
21 Nov 2018 16:39 #2 by Durou C
Replied by Durou C on topic consistency checks
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]

Please Log in or Create an account to join the conversation.

More
21 Nov 2018 19:13 #3 by babynus
Replied by babynus on topic consistency checks
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.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
22 Nov 2018 09:44 #4 by Durou C
Replied by Durou C on topic consistency checks
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.

Please Log in or Create an account to join the conversation.

More
23 Nov 2018 17:56 #5 by Durou C
Replied by Durou C on topic consistency checks
I do not understand I have a lot of error.

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.046 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.

Login Form