Hi,
Thanks for the great tool and support ..!!
I am facing the error log below. Which is making application very slow.
What is the actual problem for getting this error and how can i overcome of resolve it.?
Kindly advice me...
2018-09-27 09:42:06.779 ***** ERROR ***** [V7.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-09-27 09:42:06.779 ***** ERROR ***** [V7.1.3] For query : update planningelement set realWork='246.81' , plannedWork='333.46' , expectedProgress='309' where id=5635
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] Strack trace :
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] #0 Sql->query called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:1487]
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] #1 SqlElement->updateSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:981]
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] #2 SqlElement->saveSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:650]
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] #3 SqlElement->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:418]
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] #4 PlanningElement->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/ActivityPlanningElementMain.php:211]
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] #5 ActivityPlanningElementMain->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:770]
2018-09-27 09:42:06.780 ***** ERROR ***** [V7.1.3] #6 PlanningElement->updateSynthesisObj called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:801]
2018-09-27 09:42:06.781 ***** ERROR ***** [V7.1.3] #7 PlanningElement->updateSynthesis called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:224]
2018-09-27 09:42:06.781 ***** ERROR ***** [V7.1.3] #8 Assignment->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:371]
2018-09-27 09:42:06.781 ***** ERROR ***** [V7.1.3] #9 Assignment->saveWithRefresh called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/tool/saveImputation.php:134]
2018-09-27 09:42:57.785 ***** ERROR ***** [V7.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] For query : update planningelement set validatedDuration='523' where id=454
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] Strack trace :
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] #0 Sql->query called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:1487]
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] #1 SqlElement->updateSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:981]
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] #2 SqlElement->saveSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:793]
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] #3 SqlElement->saveForced called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:601]
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] #4 PlanningElement->simpleSave called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/ProjectMain.php:951]
2018-09-27 09:42:57.786 ***** ERROR ***** [V7.1.3] #5 ProjectMain->setNeedReplan called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:304]
2018-09-27 09:42:57.787 ***** ERROR ***** [V7.1.3] #6 Assignment->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:371]
2018-09-27 09:42:57.787 ***** ERROR ***** [V7.1.3] #7 Assignment->saveWithRefresh called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/tool/saveImputation.php:134]
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('1', 'Project', '455', 'D', '2018-09-27', '20180927', '201839', '201809', '2018', '0.08604206500956', '1', '0')
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] Strack trace :
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] #0 Sql->query called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:1188]
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] #1 SqlElement->insertSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:987]
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] #2 SqlElement->saveSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:650]
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] #3 SqlElement->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:90]
2018-09-27 09:43:48.793 ***** ERROR ***** [V7.1.3] #4 KpiValue->storeHistory called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:77]
2018-09-27 09:43:48.794 ***** ERROR ***** [V7.1.3] #5 KpiValue->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:121]
2018-09-27 09:43:48.794 ***** ERROR ***** [V7.1.3] #6 KpiValue->calculateKpi called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:603]
2018-09-27 09:43:48.794 ***** ERROR ***** [V7.1.3] #7 PlanningElement->simpleSave called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/ProjectMain.php:951]
2018-09-27 09:43:48.794 ***** ERROR ***** [V7.1.3] #8 ProjectMain->setNeedReplan called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:304]
2018-09-27 09:43:48.794 ***** ERROR ***** [V7.1.3] #9 Assignment->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:371]
2018-09-27 09:43:48.794 ***** ERROR ***** [V7.1.3] #10 Assignment->saveWithRefresh called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/tool/saveImputation.php:134]
2018-09-27 09:44:39.798 ***** ERROR ***** [V7.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-09-27 09:44:39.798 ***** ERROR ***** [V7.1.3] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('2', 'Organization', '1', 'W', '2018-09-27', '20180927', '201839', '201809', '2018', '0.092992125984252', '1143', '0')
2018-09-27 09:44:39.798 ***** ERROR ***** [V7.1.3] Strack trace :
2018-09-27 09:44:39.798 ***** ERROR ***** [V7.1.3] #0 Sql->query called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:1188]
2018-09-27 09:44:39.798 ***** ERROR ***** [V7.1.3] #1 SqlElement->insertSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:987]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #2 SqlElement->saveSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:650]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #3 SqlElement->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:90]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #4 KpiValue->storeHistory called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:77]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #5 KpiValue->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:234]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #6 KpiValue->consolidate called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:122]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #7 KpiValue->calculateKpi called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:603]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #8 PlanningElement->simpleSave called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/ProjectMain.php:951]
2018-09-27 09:44:39.799 ***** ERROR ***** [V7.1.3] #9 ProjectMain->setNeedReplan called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:304]
2018-09-27 09:44:39.800 ***** ERROR ***** [V7.1.3] #10 Assignment->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:371]
2018-09-27 09:44:39.800 ***** ERROR ***** [V7.1.3] #11 Assignment->saveWithRefresh called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/tool/saveImputation.php:134]
2018-09-27 09:45:30.804 ***** ERROR ***** [V7.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-09-27 09:45:30.804 ***** ERROR ***** [V7.1.3] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('2', 'Project', '455', 'W', '2018-09-27', '20180927', '201839', '201809', '2018', '4.51325', '80.00000', '0')
2018-09-27 09:45:30.804 ***** ERROR ***** [V7.1.3] Strack trace :
2018-09-27 09:45:30.804 ***** ERROR ***** [V7.1.3] #0 Sql->query called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:1188]
2018-09-27 09:45:30.804 ***** ERROR ***** [V7.1.3] #1 SqlElement->insertSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:987]
2018-09-27 09:45:30.804 ***** ERROR ***** [V7.1.3] #2 SqlElement->saveSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:650]
2018-09-27 09:45:30.804 ***** ERROR ***** [V7.1.3] #3 SqlElement->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:90]
2018-09-27 09:45:30.805 ***** ERROR ***** [V7.1.3] #4 KpiValue->storeHistory called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:77]
2018-09-27 09:45:30.805 ***** ERROR ***** [V7.1.3] #5 KpiValue->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:137]
2018-09-27 09:45:30.805 ***** ERROR ***** [V7.1.3] #6 KpiValue->calculateKpi called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:603]
2018-09-27 09:45:30.805 ***** ERROR ***** [V7.1.3] #7 PlanningElement->simpleSave called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/ProjectMain.php:951]
2018-09-27 09:45:30.805 ***** ERROR ***** [V7.1.3] #8 ProjectMain->setNeedReplan called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:304]
2018-09-27 09:45:30.805 ***** ERROR ***** [V7.1.3] #9 Assignment->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:371]
2018-09-27 09:45:30.805 ***** ERROR ***** [V7.1.3] #10 Assignment->saveWithRefresh called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/tool/saveImputation.php:134]
2018-09-27 09:46:21.810 ***** ERROR ***** [V7.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-09-27 09:46:21.810 ***** ERROR ***** [V7.1.3] For query : insert into kpihistory ( idKpiDefinition , refType , refId , kpiType , kpiDate , day , week , month , year , kpiValue , weight , refDone ) values ('2', 'Organization', '1', 'W', '2018-09-27', '20180927', '201839', '201809', '2018', '0.092992125984252', '1143', '0')
2018-09-27 09:46:21.810 ***** ERROR ***** [V7.1.3] Strack trace :
2018-09-27 09:46:21.810 ***** ERROR ***** [V7.1.3] #0 Sql->query called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:1188]
2018-09-27 09:46:21.810 ***** ERROR ***** [V7.1.3] #1 SqlElement->insertSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:987]
2018-09-27 09:46:21.810 ***** ERROR ***** [V7.1.3] #2 SqlElement->saveSqlElement called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/persistence/SqlElement.php:650]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #3 SqlElement->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:90]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #4 KpiValue->storeHistory called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:77]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #5 KpiValue->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:234]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #6 KpiValue->consolidate called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/KpiValue.php:138]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #7 KpiValue->calculateKpi called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/PlanningElement.php:603]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #8 PlanningElement->simpleSave called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/ProjectMain.php:951]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #9 ProjectMain->setNeedReplan called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:304]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #10 Assignment->save called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/model/Assignment.php:371]
2018-09-27 09:46:21.811 ***** ERROR ***** [V7.1.3] #11 Assignment->saveWithRefresh called at [/opt/lampp/htdocs/bctpqms/projeqtor7.3/tool/saveImputation.php:134]
2018-09-27 09:47:13.816 ***** ERROR ***** [V7.1.3] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-09-27 09:47:13.817 ***** ERROR ***** [V7.1.3] For query : update planningelement set plannedEndDate='2018-09-28' , realEndDate='2018-09-28' , plannedDuration='33' , realDuration='33' , realWork='19' , plannedWork='19' where id=6796
2018-09-27 09:47:13.817 ***** ERROR ***** [V7.1.3] Strack trace :