View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] General error 2006 MySql has fone away Error in log file - ProjeQtOr
 
 

[SOLVED] General error 2006 MySql has fone away Error in log file

More
11 Jul 2016 13:45 #1 by nicop
Babynus

I have many errors in the log file and they all relate to one error. I can execute the sql statment without any errors.

2016-07-10 07:25:11.759 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2016-07-10 07:25:11.759 ***** ERROR ***** For query : select * from indicatorvalue where idle='0' and ( ( warningTargetDateTime<='2016-07-10 07:25:11' and warningSent='0') or ( alertTargetDateTime<='2016-07-10 07:25:11' and alertSent='0'))
2016-07-10 07:25:11.759 ***** ERROR ***** Strack trace :
2016-07-10 07:25:11.759 ***** ERROR ***** #0 Sql->query called at [/home/xxx/public_html/pm/model/persistence/SqlElement.php:1740]
2016-07-10 07:25:11.759 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/home/xxx/public_html/pm/model/Cron.php:341]
2016-07-10 07:25:11.759 ***** ERROR ***** #2 Cron->checkDates called at [/home/xxx/public_html/pm/model/Cron.php:295]
2016-07-10 07:25:11.760 ***** ERROR ***** #3 Cron->run called at [/home/xxx/public_html/pm/model/Cron.php:256]
2016-07-10 07:25:11.760 ***** ERROR ***** #4 Cron->relaunch called at [/home/xxxx/public_html/pm/tool/cronRelaunch.php:30]
2016-07-10 07:26:11.761 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2016-07-10 07:26:11.761 ***** ERROR ***** For query : select * from indicatorvalue where idle='0' and ( ( warningTargetDateTime<='2016-07-10 07:26:11' and warningSent='0') or ( alertTargetDateTime<='2016-07-10 07:26:11' and alertSent='0'))
2016-07-10 07:26:11.761 ***** ERROR ***** Strack trace :
2016-07-10 07:26:11.761 ***** ERROR ***** #0 Sql->query called at [/home/xxxx/public_html/pm/model/persistence/SqlElement.php:1740]
2016-07-10 07:26:11.761 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/home/xxxx/public_html/pm/model/Cron.php:341]
2016-07-10 07:26:11.761 ***** ERROR ***** #2 Cron->checkDates called at [/home/xxxx/public_html/pm/model/Cron.php:295]
2016-07-10 07:26:11.761 ***** ERROR ***** #3 Cron->run called at [/home/xxxx/public_html/pm/model/Cron.php:256]
2016-07-10 07:26:11.761 ***** ERROR ***** #4 Cron->relaunch called at [/home/xxxx/public_html/pm/tool/cronRelaunch.php:30]
2016-07-10 07:27:11.762 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

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

More
11 Jul 2016 20:40 #2 by babynus
Issues come from your CRON porcess.
Maybe you changed some configuration, but CRON does not take changes into account unless restarted.
Start to stop / restart CRON process (in admin screen)

Babynus
Administrator of ProjeQtOr web site

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

More
14 Jul 2016 17:17 #3 by nicop
I have Stopped and Started the cron again but the problem remains.
I have tried looking at the configuration but not sure where to look for what is causing the error.
If I execute the SQL statement in PHPadmin on the table it returns 0 rows but no error.
select * from indicatorvalue where idle='0' and ( ( warningTargetDateTime<='2016-07-10 07:26:11' and warningSent='0') or ( alertTargetDateTime<='2016-07-10 07:26:11' and alertSent='0'))

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

More
15 Jul 2016 16:54 #4 by babynus
It look like PHP has defined a persistent connection and lost it.

Does it happen all the time, or only during some period (for instance during database backup)

Babynus
Administrator of ProjeQtOr web site

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

More
15 Jul 2016 18:53 #5 by nicop
It happens all the time. It seems like every time the cron runs. I have attached the log file
Attachments:

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

More
19 Jul 2016 06:41 #6 by nicop
Hi Babynus
PHP ver on server 5.5.36
Did the following test:
Installed Xampp server on my PC. PPH 5.6.3
Copied the installed software from the server to my PC
Dumped the Mysql DB and imported to Xampp on my PC

All is working fine and the log file does not reflect any errors as above.
Any suggestions where I can start looking. Perhaps the Cron needs special access to a folder and does not have it on the web server.

Nico

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

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