Weird mysql error

Community Support
1

Hi,

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.

https://bugs.mysql.com/bug.php?id=112089

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/chambresdhotes.org/public_html/cgi-bin/community.cgi 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!

Andy

2

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

3

Hi,

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)

Cheers

Andy