Zabbix 6.0 to 6.0.1 upgrade query failed due to primary key constraint:

[Gijs007]

I've just updated my Zabbix installation from 6.0 to 6.0.1, now the Zabbix server fails to start:

 1969:20220304:012520.474 One child process died (PID:1995,exitcode/signal:1). Exiting ...
1969:20220304:012521.096 PROCESS EXIT: 1995
1970:20220304:012521.096 HA manager has been paused
zabbix_server [1969]: Error waiting for process with PID 1995: [10] No child processes
1970:20220304:012521.262 HA manager has been stopped
1969:20220304:012521.269 syncing history data...
1969:20220304:012521.281 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '34342-1646353410-296475100' for key 'PRIMARY'
1969:20220304:012521.325 skipped 507 duplicates
1969:20220304:012521.356 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '40614-1646353506-672650600' for key 'PRIMARY'
1969:20220304:012521.361 skipped 2 duplicates
1969:20220304:012521.525 syncing history data... 100.000000%
1969:20220304:012521.525 syncing history data done
1969:20220304:012521.525 syncing trend data...
1969:20220304:012521.540 syncing trend data done
1969:20220304:012521.541 Zabbix Server stopped. Zabbix 6.0.1 (revision a80cb13868).

How do we fix this? I've already tried recreating the history and trend tables in MariaDB (MySQL fork).

[Roberto Machado]

I'm having the same error.

I reinstalled Zabbix, restored the backup and it remained the same.

I backed up the databases and removed MariaDB. I reinstalled, restored the backup and the error continues.

I checked all SElinux permissions and everything is fine, same as version 6.0.

I was already going crazy, thinking I was doing something stupid!

[Roberto Machado]

[ZBX-20697] Zabbix server crashes - ZABBIX SUPPORT