Processing statistics fails for 1 site and stops for the rest...

[Ujjain Ice]

statistics: Unable to get database status for "rbeem": Lost connection to MySQL server during query
statistics: Unable to get database status for "rbeem": Lost connection to MySQL server during query
statistics: Unable to fetch info from MailLists: MySQL server has gone away
statistics: Unable to fetch info from MailLists: MySQL server has gone away
statistics: Unable to fetch info from Domain Services List : MySQL server has gone away
statistics: Unable to fetch info from Domain Services List : MySQL server has gone away
statistics: Unable to define client's ID: MySQL server has gone away
statistics: Unable to define client's ID: MySQL server has gone away
statistics: Unable to update disk usage information for domain: MySQL server has gone away
statistics: Unable to update disk usage information for domain: MySQL server has gone away

So only webalizer statistics of the sites from A to R are correctly updated. Statistics of rbeem+ to Z have not been processed last week.

Do you have a suggestion solving this issue?

 

[Satoriya]

Hi,

It is likelythe issue is related to insufficient MySQL timeouts, try increasing it in /etc/my.cnf:
wait_timeout = 28800
connect_timeout = 20

Hope, it helps!

 

[Ujjain Ice]

That won't work, because the query disconnects within 1 second and not after 20 seconds.