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

After 6.2.4 upgrade Mysql scripts missing

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 6.2.4
    • None
    • None
    • Ubuntu Server 22.04

      After doing regular repository upgrades I started having issues.  The dashboard is showing connection problems.  After checking the server log I see query failing from duplicate keys.

      //2034:20221116:144613.895 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '75264-1668627504-511228930' for key 'PRIMARY'
  2034:20221116:144613.920 skipped 662 duplicates
  2034:20221116:144613.949 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '78867-1668627507-475734921' for key 'PRIMARY'
  2034:20221116:144613.966 skipped 381 duplicates
  2034:20221116:144614.028 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '82258-1668627507-549981878' for key 'PRIMARY'
  2034:20221116:144614.040 skipped 394 duplicates

      I thought I would run the sql scripts initialize the databases and the mysql scripts are missing from /usr/share/doc/zabbix-sql-scripts/

            zabbix.support Zabbix Support Team
            r3dl0c Don Petrowski
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: