Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25214

[Z3008] query failed due to primary key constraint

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 6.0.33
    • None
    • None
    • ubuntu 22.04, Mariadb-server-10.6 1:10.6.18-0ubuntu0.22.04.1

      I've upgraded the zabbix version from v5 to v6, did all the recommended db changes as described

      mysql zabbix < /usr/share/zabbix-sql-scripts/mysql/history_pk_prepare.sql

      mysql zabbix
      INSERT IGNORE INTO history SELECT * FROM history_old;
      INSERT IGNORE INTO history_uint SELECT * FROM history_uint_old;
      INSERT IGNORE INTO history_str SELECT * FROM history_str_old;
      INSERT IGNORE INTO history_log SELECT * FROM history_log_old;
      INSERT IGNORE INTO history_text SELECT * FROM history_text_old;

       

      Now the log continuously shows

      895830:20240911:072620.513 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28828-1726039579-0' for key 'PRIMARY'
895830:20240911:072622.297 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28821-1726039581-0' for key 'PRIMARY'
895830:20240911:072623.351 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28831-1726039582-0' for key 'PRIMARY'
895830:20240911:072624.479 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28828-1726039583-0' for key 'PRIMARY'
895830:20240911:072624.522 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28830-1726039583-0' for key 'PRIMARY'
895830:20240911:072627.053 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28828-1726039585-0' for key 'PRIMARY'
895830:20240911:072627.089 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28831-1726039585-0' for key 'PRIMARY'
895830:20240911:072628.493 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28830-1726039586-0' for key 'PRIMARY'
895830:20240911:072628.532 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28821-1726039586-0' for key 'PRIMARY'
895830:20240911:072631.120 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28830-1726039589-0' for key 'PRIMARY'
895830:20240911:072632.590 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28821-1726039591-0' for key 'PRIMARY'
895830:20240911:072632.597 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28828-1726039591-0' for key 'PRIMARY'
895830:20240911:072632.603 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '28831-1726039591-0' for key 'PRIMARY'

      There is already a ticket about this problem but it is closed and there is no solution mentioned.

      {}https://support.zabbix.com/browse/ZBX-23444

      I upgraded to v 7 but that did not change anything.

       

       

       

            zabbix.dev Zabbix Development Team
            buijs buijs
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: