View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Not able to make changes to dates or modify description - ProjeQtOr
 

Not able to make changes to dates or modify description

More
12 Dec 2015 05:55 #1 by iconic
Not able to make changes to dates or modify description was created by iconic
Every time I try change the Validate or Request Dates or try to modify any field of an activity I received this error "
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"

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

More
12 Dec 2015 15:12 #2 by babynus
Replied by babynus on topic Not able to make changes to dates or modify description
Check your MySql configuration.
ProjeQtOr need tranactional updates.
This is only possible with InnoDb engine.
If your MySql is configured to use only MyIsam files, ProjeQtOr won't work correctly.
Babynus
Administrator of ProjeQtOr web site

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

More
18 Dec 2015 00:22 #3 by iconic
Replied by iconic on topic Not able to make changes to dates or modify description
Our Web Engineer has checked and he has confirmed that all tables are InnoDB only.
So there must be another problem.

What can we do now?

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

More
18 Dec 2015 12:30 - 18 Dec 2015 12:30 #4 by babynus
Replied by babynus on topic Not able to make changes to dates or modify description
It is clerly a MySql configuration or runtime issue.

Many threads can be found on the subject.
stackoverflow.com/questions/6000336/how-...ait-timeout-exceeded
stackoverflow.com/questions/5836623/gett...ction-even-though-im

Summary of advises :

1) Change lock_wait_tieout in my.ini
[mysqld]
innodb_lock_wait_timeout=120
Not a very good idea IMO, but worth a try

2) Kill any sleeping thread on the database

3) Maybe a clean restart of database could help removing exiting locks
Babynus
Administrator of ProjeQtOr web site
Last edit: 18 Dec 2015 12:30 by babynus.

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

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