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

Prochaines sessions de formation

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

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

More
19 Juil 2016 09:25 #7 by babynus
Replied by babynus on topic General error 2006 MySql has fone away Error in log file
Check out timeouts in your MySql configuration (my.ini or my.cnf)
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
19 Juil 2016 10:02 #8 by nicop
Replied by nicop on topic General error 2006 MySql has fone away Error in log file
OK found the problem. Not sure why?

Changed the general cron sleep time (in seconds) back to default of 10 sec. Was 60 sec
Changed the alert generation cron delay (in seconds) back to 30 sec. Was 60 sec

Please Connexion or Create an account to join the conversation.

More
19 Juil 2016 13:11 #9 by babynus
Replied by babynus on topic General error 2006 MySql has fone away Error in log file
Sure it was linked to MySql timeouts

With CRON delay of 60s, you should be over MySql tilmeout.
So when MySql detected idle connection for this timeout delay (possibly 30s), it automatically closed the connection.
So the next tile you tried to use it, it was "gone away"
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
02 Mai 2018 16:21 #10 by Innfreds74
Replied by Innfreds74 on topic General error 2006 MySql has fone away Error in log file
Hello,

Sorry to reopen this issue but I have exactly the same problem with my setup (PHP 7.0.24 - mySQL 5.6)
I've hosted a Projeqtor 6.4.4 on my provider's server and my Cron is stopping abnormally from time to time and I have tons of Exception errors in log files

Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

I've tried to put 10s in General Cron Tempo, 30s for alerts, and 100s for alerts check put I still have the same problem.

You mentionned to change mysql.ini on server but it is a mutualized server so I don't have access to setup
Could you give me some guidance to solve this issue.

Thx

F.G.

Please Connexion or Create an account to join the conversation.

More
04 Mai 2018 10:26 #11 by babynus
Replied by babynus on topic General error 2006 MySql has fone away Error in log file
Hi,

Difficult to investigate with so few information.
Only information we have is that MySql server seem to have been disconnected...

Possibly it's a way the hosted server works : closing connection from time to time to release resources.
ProjeQtOr has no mecanism to retreive from "cutting" connections.
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
04 Mai 2018 10:26 #12 by babynus
Replied by babynus on topic General error 2006 MySql has fone away Error in log file
Hi,

Difficult to investigate with so few information.
Only information we have is that MySql server seem to have been disconnected...

Possibly it's a way the hosted server works : closing connection from time to time to release resources.
ProjeQtOr has no mecanism to retreive from "cutting" connections.
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

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

Login Form