SOLVED: SQL Error insert into <table> Duplicate entry for key PRIMARY

[frankt]

Hi,

We ran in to problems where no resources (templates/graphs/etc) could be added, resulting in error messages about duplicate keys. Thanks to this post, I've written the script below which repaired our database.


For tables with a PRIMARY key, zabbix records what the...

[narlinux]

Hi,

I am facing an issue that I cannot do anything else after many searches.

Consider the Linux template, I use that to monitor 100 nodes and it reports disk usage if it exceeded 80%. So far we everything is fine now.

Now consider that I want to monitor 30 of those...

[TuxOtaku]

Okay, so I have a set of Zabbix instances which I am performing nightly backups on via mysqldump. The backups are taken in three "stages" (three separate .sql files).

The stages are set up as follows:

Stage 1:
Bare Schema

Stage 2:
...