Weird mysql error


I’m aware this is a mySQL / DBI issue more, but I’m wondering if anyone had any suggestions:

WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.

While this is annoying on crons (as it keeps causing STDOUT, when no output is meant to be!), I think it is also causing an error. The weird part, is that this error only seems to come up with a mobile connection when accessing the site. Its fine on wifi!

The system encountered a fatal error:
Can’t call method “fetchrow_hashref” on an undefined value at /home/chambres/web/ line 140.

GT::SQL::error => Failed to execute quer​y: ‘SELECT * FROM comm_sessions WHERE sess_id = ?’: Got packets out of order

This server has been running for ages without any problems, so it seems too much of a coincidence this has come around on the same time as the other MYSQL_OPT_RECONNECT issue

Thanks for any suggestions!


its more likely user side issue not hestiacp mysql related, update your script with support mysql driver.


It actually was related to the mySQL update mentioned in the URL above. The only fix was to revert back to an older libmysqlclient21:

 sudo apt install libmysqlclient21=8.0.19-0ubuntu5
 sudo apt-mark hold libmysqlclient21

Its odd how that affected the mobile data of the site only. It hasn’t affected any other servers with Hestia + the same setup. Anyway, at least its working now :slight_smile: (Ubuntu are rolling out their own fix it seems to rectify this issue)