Hi,
As you can see from the version we are running our Zabbix has been running fine for a couple years now, but after a few harddrives ran out of space the SQL are not happy anymore.
Nothing is updating and the log show the eventid's is reset to 1 every time we restart the zabbix server even though our "events" table have 14 000 000+ events in it.
"query failed: [1062] Duplicate entry '1765' for key 'PRIMARY' [insert into events (eventid,source,object,objectid,clock,ns,value)"
We are running one server with 4 active and 1 passive proxy/250vps/250 hosts/7500 items/2700 trigegrs. The database is a Galera MySQL cluster and each Proxy are running MySQL. All InnoDB. The Server leave 99% of the data collection to the Proxies.
I have tried shutting down the Zabbix-Server and follow https://www.zabbix.com/forum/showthr...hlight=eventid setting the AUTO_INCREMENT even though as far as I can see the "eventid" table in our Zabbix distribution are not using autoincrement but the older "ids" method. Our "ids" table did not include any row for "events" and it did not help adding it.
Does anyone know how I can make our Zabbix Server use the correct id number(s) and collect the data from the proxies again?
Thank you in advance,
Almaza
As you can see from the version we are running our Zabbix has been running fine for a couple years now, but after a few harddrives ran out of space the SQL are not happy anymore.
Nothing is updating and the log show the eventid's is reset to 1 every time we restart the zabbix server even though our "events" table have 14 000 000+ events in it.
"query failed: [1062] Duplicate entry '1765' for key 'PRIMARY' [insert into events (eventid,source,object,objectid,clock,ns,value)"
We are running one server with 4 active and 1 passive proxy/250vps/250 hosts/7500 items/2700 trigegrs. The database is a Galera MySQL cluster and each Proxy are running MySQL. All InnoDB. The Server leave 99% of the data collection to the Proxies.
I have tried shutting down the Zabbix-Server and follow https://www.zabbix.com/forum/showthr...hlight=eventid setting the AUTO_INCREMENT even though as far as I can see the "eventid" table in our Zabbix distribution are not using autoincrement but the older "ids" method. Our "ids" table did not include any row for "events" and it did not help adding it.
Does anyone know how I can make our Zabbix Server use the correct id number(s) and collect the data from the proxies again?
Thank you in advance,
Almaza