[Z30005] The client was disconnected by the server because of inactivity.

[aram535]

Hi,

I just installed Zabbix in my home lab and am having a small issue.

Setup on ESXi 7, same vSwitch, same network:

zabbix running on RHEL 8, selinux disabled, firewall disabled for now
mysql running Ubuntu 20.04.2 LTS, firewall disabled for now

Zabbix version: 5.4.3
Mysql version: 8.0.26

69835:20210808:063133.624 [Z3005] query failed: [4031] The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior. [select u.userid,u.roleid,r.type from sessions s,users u,role r where s.userid=u.userid and s.sessionid='015107f59fc50b8c0fe123338dcd6ecc' and s.status=0 and u.roleid=r.roleid]
69831:20210808:063143.884 [Z3005] query failed: [4031] The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior. [select u.userid,u.roleid,r.type from sessions s,users u,role r where s.userid=u.userid and s.sessionid='015107f59fc50b8c0fe123338dcd6ecc' and s.status=0 and u.roleid=r.roleid]
69837:20210808:063205.333 [Z3005] query failed: [4031] The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior. [select u.userid,u.roleid,r.type from sessions s,users u,role r where s.userid=u.userid and s.sessionid='015107f59fc50b8c0fe123338dcd6ecc' and s.status=0 and u.roleid=r.roleid]
69821:20210808:063613.244 [Z3005] query failed: [4031] The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior. [select u.userid,u.roleid,r.type from sessions s,users u,role r where s.userid=u.userid and s.sessionid='015107f59fc50b8c0fe123338dcd6ecc' and s.status=0 and u.roleid=r.roleid]

If you look at a bunch of the errors (not included above), notice the odd time difference between the entries: 1, 73, 58, 46, 134, 20, 177, 69, 17, 5, 11, 215, 61, 20, 10, 62, 408, 294, 326, 294, 10, 71, 51, 273, 21, 102

Checking around the forum, I have tried the following:

Increased the timeout for the mysql server:

interactive_timeout = 86400
wait_timeout = 86400

Changed the IPv4 timeout to 300 (default 7200):
net.ipv4.tcp_keepalive_time=300

Zabbix-server config:
DBHost=192.168.1.16
DBName=zabbix
DBPassword=.....
DBPort=3306
DBSchema=zabbix
DBUser=zabbix
LogFileSize=0
LogFile=/var/log/zabbix/zabbix_server.log
LogSlowQueries=3000
PidFile=/var/run/zabbix/zabbix_server.pid
SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
StartPollers=30
StartIPMIPollers=1
StartPollersUnreachable=10
StartTrappers=30
StartPingers=10
StartDiscoverers=10
StartHTTPPollers=10
StartTimers=1
StartDBSyncers=4
StatsAllowedIP=127.0.0.1,192.168.1.0/24,zabbix
Timeout=4

Any help would be appreciated.