[ZBX-2897] Zabbix eats up MySQL server connections Created: 2010 Aug 18 Updated: 2017 May 30 Resolved: 2011 Aug 20 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Server (S) |
Affects Version/s: | 1.8.2 |
Fix Version/s: | 1.8.7, 1.9.6 (beta) |
Type: | Incident report | Priority: | Major |
Reporter: | troy dias | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Hardware: Centos 5.3 (x86_64) |
Issue Links: |
|
Description |
Almost once a day, the MySQL database stops accepting connections, which causes zabbix-server to stop. A 'show processlist' indicates most connection threads are attempting to update: UPDATE ids SET nextid=nextid+1 WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' Doubling max_connections on MySQL doesn't help. The problem seems to occur more frequently when more users are viewing the webUI dashboard. |
Comments |
Comment by richlv [ 2010 Aug 19 ] |
correlation with web frontend usage might be similar to deadlock issue |
Comment by troy dias [ 2010 Aug 20 ] |
A 'show engine innodb status' during the outage indicates a fair few of the following: ------------------ ------------------ I've converted the 'ids' table from innodb to myisam incase it is a resource issue. |
Comment by Alexander Vladishev [ 2011 Aug 20 ] |
Fixed in |