[ZBX-18839] Zabbix 4.0 send message every 15 min Zabbix database is down Created: 2021 Jan 05  Updated: 2021 Jan 06  Resolved: 2021 Jan 06

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

Type: Incident report Priority: Trivial
Reporter: Yuriy Lukashov Assignee: Zabbix Support Team
Resolution: Commercial support required Votes: 0
Labels: zabbix-server-mysql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 7, 5.5.64-MariaDB MariaDB Server


Attachments: PNG File Selection_142.png     PNG File Selection_143.png    

 Description   

Hello.
History.
2021.01 Zabbix server send alert Zabbix database is down.
I opened the log and see next

2394:20210101:104244.277 [Z3005] query failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.message,a.status,a.retries,e.source,e.object,e.objectid from alerts a left join events e on a.eventid=e.eventid where alerttype=0 and a.status=3 order by a.alertid]
2370:20210101:104244.325 [Z3005] query failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [begin;]
2370:20210101:104244.325 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
2370:20210101:104244.325 database is down: reconnecting in 10 seconds

I rebooted the server and check database. Database work well, web work well.
Zabbix server health in dashboards not have problem.
Zabbix agent for localhost check mysql and show this for graph.
But now every 15 min I got message for email Zabbix server database is down.
I set debug level 4 but I not see error message.
I create dump and open on dump on new database(zabbix2).
I did Trancate table history,history_str,history_uint,history_log,history_text and did mysqlcheck, restart zabbix-server use zabbix2 database.
But nothing changed, every 15 min message Zabbix database is down.

Why I get this messages if database work well ?
What logic uses the zabbix-server what make conclusion Zabbix database is down ?

Thanks.



 Comments   
Comment by Dmitrijs Lamberts [ 2021 Jan 06 ]

Please be advised that this section of the tracker is for bug reports only. The case you have submitted can not be qualified as one, so please reach out to [email protected] for commercial support or consultancy services. Alternatively, you can also use our IRC channel or community forum (https://www.zabbix.com/forum) for assistance. With that said, we are closing this ticket. Thank you for understanding.

Comment by Yuriy Lukashov [ 2021 Jan 06 ]

Thanks for response.
But if database is work well and zabbix send message every 15 min it not bug ?
It the links for same problem from community
https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/53068-zabbix-database-down
https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/49937-zabbix-watchdog-database-is-down
https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/397618-alert-zabbix-database-is-down-every-15-minutes
Thanks.

Generated at Sun Apr 06 07:22:51 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.