MySQL Server has gone away only plesk related processes

[knocx]

Observed:

Dec 31 04:13:05 ns1 statistics: Unable to start transaction of storing statistics data for xxxxx.com: MySQL server has gone away
Jan 1 04:16:26 ns1 statistics: Unable to start transaction of storing statistics data for xxxxx.com: MySQL server has gone away
Jan 2 04:22:18 ns1 statistics: Unable to start transaction of storing statistics data for xxxxx.com: MySQL server has gone away
Jan 2 14:36:15 ns1 statistics: Unable to start transaction of storing statistics data for xxxxx.com: MySQL server has gone away

looked into xxxxx.com , i saw that it has a huge log file , i deleted it the re-run the plesk statistics utility



Jan 2 16:01:43 ns1 statistics: Unable to start transaction of storing statistics data for yyyyy.com: MySQL server has gone away


but this time it stucked on yyyyy.com i checked yyyyy.com i saw that this domain is stopped and nothing more interesting


seems there are issues with plesk statistics utility

Plesk 8.2.1
CentOS5 PEA Kernel

i will be glad if any thing similar happened to anyone post it here

knocx

 

[Amin Taheri]

Did you ever get this resolved?

if not, I would recomend checking the psa and msyql log files, those may give you a tip on why the server is crashing or dropping your connection.

 

[knocx]

mysql server is not crashing

plesk statistics binary times out because of bad programming... resolved the issue

 

[FiX1l]

I've got the same problem, could you tell me how you fixed it?

 

[prosys]

we had that problem... one of the possible problem was the mysql timeout var in my.cnf...
we initially changed "wait_timeout=90" to ensure that mysql stays "clear" without hanging connections not closed by bad programmed websites... I'm at the moment testing "wait_timeout=300" to see if it stops again.

i'll update this thread as soon as we get the result.