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.
I have one project who doesn't want to calculate gantt planning. I don't why ? I have this on log file:
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] For query : update assignment set idle='1' where refType='Meeting' and refId=74
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] Strack trace :
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1504]
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:981]
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:650]
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] #3 SqlElement->save called at [/var/www/projeqtor/model/MeetingMain.php:438]
2018-06-07 10:42:51.243 ** ERROR ** [V7.1.1] #4 MeetingMain->save called at [/var/www/projeqtor/tool/saveObject.php:78]
I have try to restart the Projeqtor machine, nothing happen !
it is on V7.1.1 version
Hello, I have exactly the same problem since the update of V7.0.9. Version V7.1.1 is not in question.
So I'm waiting like you a little patch that will provide a solution.
See you.
It is a lock issue : 2 users trying to update same item.
If transactions are long (many things to update on same operation) like on planning calculation, this may happen.
So if 2 project Leader plan 2 big projects at the same time, this may happen. On of the calculations can be an automated done (if enabled).
I've added an improvement on V7.1.2 to try and reduce transaction duration, starting transaction just before updates, at end of planning calculation instead of starting it at begining of calculation.... (Ticket #3426)
This may reduce locks.
If locks persits :
- try a cold restart of database
- try to calculate planning when no-one else in connected
this is very strange, i have some project with correct calculation planning, and other without !
I have close the projeqtor program, I'm alone connected.
I try to calculate planinig with just 3 activities open and it's failed!
Please help me because I have a meeting with Gantt update and I can't do it.