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

SQL Exception on elements updates

More
14 Apr 2014 11:50 #1 by Iaurkano
SQL Exception on elements updates was created 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 Log in or Create an account to join the conversation.

More
14 Apr 2014 13:25 #2 by babynus
Replied by babynus on topic SQL Exception on elements updates
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 Log in or Create an account to join the conversation.

More
14 Apr 2014 14:14 #3 by Iaurkano
Replied by Iaurkano on topic SQL Exception on elements updates
so, if i anderstand well, it's a Database configuration issue ?

i'm right ?

thank's. .

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

More
14 Apr 2014 14:45 #4 by babynus
Replied by babynus on topic SQL Exception on elements updates
Yes.
1) message "Lock wait timeout exceeded" is quite clear
2) no issue for all other users
Babynus
Administrator of ProjeQtOr web site

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

More
14 Apr 2014 15:27 #5 by Iaurkano
Replied by Iaurkano on topic SQL Exception on elements updates
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 Log in or Create an account to join the conversation.

More
14 Apr 2014 15:32 #6 by babynus
Replied by babynus on topic SQL Exception on elements updates
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 Log in or Create an account to join the conversation.

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