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 - Page 2 - ProjeQtOr
 
 

SQL Exception on elements updates

More
14 Apr 2014 17:03 #7 by Iaurkano
Yes but, very strange to need to increase this time out, because the current value 50 seconds seems to be huge for an update or one record.

In my case, this appears when i want to update a status in an activity.

thank's,

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

More
14 Apr 2014 17:42 #8 by Iaurkano
last information

i restarted the apache server, and the message does not appear any more.

i'm going to migrate to 4.2.2 version and will check if the issue still present.

So it seems it's not a Database issue.....

see you...

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

More
14 Apr 2014 19:06 #9 by babynus

i restarted the apache server, and the message does not appear any more.

So possibly you has some existing PHP session with not comitted transaction locking some tables.

So it seems it's not a Database issue.....

Possibly you have some configuration that enables to have very long peristent transaction (no timeout ?)

i'm going to migrate to 4.2.2 version and will check if the issue still present.

Latest version is 4.2.3 ;)

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: Iaurkano

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

More
15 Apr 2014 15:10 - 15 Apr 2014 15:10 #10 by Iaurkano
After investigation, i found how to generate the problem :

1- i perform multiple updates, for activity status (at least) .
2- an error occurs during multiple update because a status cannot be changed because of the workflow. In the 3.4.4 version, Projectorria does not indicate any errors, the hourglass stay indefinitely, and i must close firefox to exit projectorria. after reconnection I get the MySQL Error, on the record where the error occurs.

This issue does not appear with 4.2.2, so i m going to migrate ASAP.

Hi all.
Last edit: 15 Apr 2014 15:10 by Iaurkano.
The following user(s) said Thank You: babynus

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

Moderators: babynusprotion
Time to create page: 0.032 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.