[Z3005] query failed: [2006] MySQL server has gone away

[bschmidt001]

There is a Zabbix bug ZBX-6163, that was fixed in version 2.5.0 forward. I realize that upgrading is always a possibility, but for various reasons, we are fixed on version 2.4.2 for some time.

Would it be possible for someone, anyone, to provide an updated version of the appropriate file(s) that result from the patch being applied to 2.4.2, if that is possible?

The patch shows:

Index: src/libs/zbxdb/db.c
================================================== =================
--- src/libs/zbxdb/db.c (révision 32992)
+++ src/libs/zbxdb/db.c (copie de travail)
@@ -181,6 +181,8 @@
zbx_free(connect);
#elif defined(HAVE_MYSQL)
conn = mysql_init(NULL);
+ my_bool reconnect = 1;
+ mysql_options(conn, MYSQL_OPT_RECONNECT, &reconnect);

if (!mysql_real_connect(conn, host, user, password, dbname, port, dbsocket, CLIENT_MULTI_STATEMENTS))
{