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
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"
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.
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.
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.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
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.