[ZBX-16385] Zabbix creates 20000 connections to the mysql server Created: 2019 Jul 17  Updated: 2020 Jun 15  Resolved: 2020 Jun 15

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 4.0.10
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Arkadiy Assignee: Renats Valiahmetovs (Inactive)
Resolution: Incomplete Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

CentOS Linux release 7.6.1810 (Core)



 Description   

Unfortunately, I don't know how to reproduce this. 

Symptoms:

  1. I'm getting these errors in /var/log/zabbix/zabbix_server.log:
    562182:20190717:180358.072 [Z3005] query failed: [2013] Lost connection to MySQL server during query [update problem set r_eventid=368546388,r_clock=1563375754,r_ns=235192960,userid=0 where eventid=
    367996910;
    update problem set r_eventid=368546387,r_clock=1563375754,r_ns=245660521,userid=0 where eventid=367990352;
    update problem set r_eventid=368546386,r_clock=1563375766,r_ns=733935539,userid=0 where eventid=368336399;
  2. "netstat -anlp | grep :6033 | grep TIME_WAIT -wc" shows 20000+ TIME_WAIT connections to my proxysql mysql load balancer. When I "kill -9 zabbix_server", this number goes down to the normal 500-100.

I suspect that some weird error is happening on the side of proxysql, however zabbix_server tries to immediately create a new connection to the proxysql load balancer and that's what's worrying me.

Is there a way to slow it down?

 



 Comments   
Comment by Elina Kuzyutkina (Inactive) [ 2019 Jul 18 ]

Hello Arkadiy,
Looks like there can be proxysql misconfiguration. Also please, make sure that your MySQL configuration is optimized as much as possible to fit your hardware?
What rules do you have for proxysql?
Regards, Elina

Comment by Renats Valiahmetovs (Inactive) [ 2020 Jun 15 ]

This issue has not been updated for more than 14 days. We are automatically closing this issue, but if the problem is not yet resolved and requires additional work, you may reopen it within the next 30 days by commenting on the ticket.

Best Regards,

Generated at Fri Apr 26 21:40:23 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.