View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL Exception on elements updates - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

SQL Exception on elements updates

More
14 Avr 2014 11:50 #1 by Iaurkano
Hi Babynus,

sometimes, on elements update I received an SQL Exception ERROR. like this :
2014-04-11 10:33:40 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2014-04-11 10:33:40 ***** ERROR *****    For query : update activity set idStatus='4' , done='1' , doneDate='2014-04-11' , result='Modif page + controller + requête prévisions'  where id=758
2014-04-11 10:33:40 ***** ERROR *****    Strack trace :
2014-04-11 10:33:40 ***** ERROR *****    #0 Sql->query called at [D:\xampp\htdocs\projectorria\model\persistence\SqlElement.php:666]
2014-04-11 10:33:40 ***** ERROR *****    #1 SqlElement->updateSqlElement called at [D:\xampp\htdocs\projectorria\model\persistence\SqlElement.php:399]
2014-04-11 10:33:40 ***** ERROR *****    #2 SqlElement->saveSqlElement called at [D:\xampp\htdocs\projectorria\model\persistence\SqlElement.php:308]
2014-04-11 10:33:40 ***** ERROR *****    #3 SqlElement->save called at [D:\xampp\htdocs\projectorria\model\Activity.php:233]
2014-04-11 10:33:40 ***** ERROR *****    #4 Activity->save called at [D:\xampp\htdocs\projectorria\tool\saveObject.php:56]

or like this :
2014-04-11 10:20:36 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2014-04-11 10:20:36 ***** ERROR *****    For query : update planningelement set realEndDate='2014-04-11' , realDuration='2' , plannedWork='0.18' , leftWork='0' , realWork='0.18' , progress='100' , plannedCost='54' , leftCost='0' , realCost='54'  where id=1085
2014-04-11 10:20:36 ***** ERROR *****    Strack trace :
2014-04-11 10:20:36 ***** ERROR *****    #0 Sql->query called at [D:\xampp\htdocs\projectorria\model\persistence\SqlElement.php:666]
2014-04-11 10:20:36 ***** ERROR *****    #1 SqlElement->updateSqlElement called at [D:\xampp\htdocs\projectorria\model\persistence\SqlElement.php:399]
2014-04-11 10:20:36 ***** ERROR *****    #2 SqlElement->saveSqlElement called at [D:\xampp\htdocs\projectorria\model\persistence\SqlElement.php:308]
2014-04-11 10:20:36 ***** ERROR *****    #3 SqlElement->save called at [D:\xampp\htdocs\projectorria\model\PlanningElement.php:318]
2014-04-11 10:20:36 ***** ERROR *****    #4 PlanningElement->save called at [D:\xampp\htdocs\projectorria\model\PlanningElement.php:513]
2014-04-11 10:20:36 ***** ERROR *****    #5 PlanningElement->updateSynthesisObj called at [D:\xampp\htdocs\projectorria\model\PlanningElement.php:531]
2014-04-11 10:20:36 ***** ERROR *****    #6 PlanningElement->updateSynthesis called at [D:\xampp\htdocs\projectorria\model\Assignment.php:150]
2014-04-11 10:20:36 ***** ERROR *****    #7 Assignment->save called at [D:\xampp\htdocs\projectorria\model\Assignment.php:228]
2014-04-11 10:20:36 ***** ERROR *****    #8 Assignment->saveWithRefresh called at [D:\xampp\htdocs\projectorria\tool\saveImputation.php:100]

We are using a MySQL 5.0.51a server.

regards.

Please Connexion or Create an account to join the conversation.

More
14 Avr 2014 13:25 #2 by babynus
It seem you have an issue with locking policy or timeout.

Locking policy could be pessimisting, so that you lock table on every update.
And/or timeout is (much) too small.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
14 Avr 2014 14:14 #3 by Iaurkano
so, if i anderstand well, it's a Database configuration issue ?

i'm right ?

thank's. .

Please Connexion or Create an account to join the conversation.

More
14 Avr 2014 14:45 #4 by babynus
Yes.
1) message "Lock wait timeout exceeded" is quite clear
2) no issue for all other users

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
14 Avr 2014 15:27 #5 by Iaurkano
But, as far as i know this message appear only on row lock not on table lock.

timeout is set to default value : 50 seconds, there is probably another issue which generate this one.

i'm investigating..

Please Connexion or Create an account to join the conversation.

More
14 Avr 2014 15:32 #6 by babynus
Found some hint here :
www.tonyspencer.com/2008/10/23/if-you-ge...tarting-transaction/

innodb_lock_wait_timeout = 500

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.054 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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