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

Duplicate entry for key 'dashboard_user.PRIMARY' [insert into dashboard_user (dashboard_userid,dashboardid,userid,permission)

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 5.4.0beta2
    • 5.4.0rc2, 5.4 (plan)
    • Server (S)
    • Team B
    • Sprint 76 (May 2021)
    • 0.125

    Description

      While upgrading 5.4.0beta2 to 5.4.0rc1 the log prints:

      Starting Zabbix Server. Zabbix 5.4.0rc1 (revision 77013e0).
      Press Ctrl+C to exit.     7:20210512:151902.822 Starting Zabbix Server. Zabbix 5.4.0rc1 (revision 77013e0).
           7:20210512:151902.822 ****** Enabled features ******
           7:20210512:151902.822 SNMP monitoring:           YES
           7:20210512:151902.822 IPMI monitoring:           YES
           7:20210512:151902.822 Web monitoring:            YES
           7:20210512:151902.822 VMware monitoring:         YES
           7:20210512:151902.822 SMTP authentication:       YES
           7:20210512:151902.822 ODBC:                      YES
           7:20210512:151902.822 SSH support:               YES
           7:20210512:151902.822 IPv6 support:              YES
           7:20210512:151902.822 TLS support:               YES
           7:20210512:151902.822 ******************************
           7:20210512:151902.822 using configuration file: /etc/zabbix/zabbix_server.conf
           7:20210512:151902.880 current database version (mandatory/optional): 05030080/05030080
           7:20210512:151902.880 required mandatory version: 05030201
           7:20210512:151902.880 starting automatic database upgrade
           7:20210512:151902.941 completed 0% of database upgrade
           7:20210512:151902.976 completed 1% of database upgrade
           7:20210512:151903.019 completed 2% of database upgrade
           7:20210512:151903.087 completed 3% of database upgrade
           7:20210512:151903.118 completed 4% of database upgrade
           7:20210512:151903.130 completed 5% of database upgrade
           7:20210512:151903.172 completed 6% of database upgrade
           7:20210512:151903.251 completed 7% of database upgrade
           7:20210512:151903.278 completed 8% of database upgrade
           7:20210512:151903.344 completed 9% of database upgrade
           7:20210512:151903.373 completed 10% of database upgrade
           7:20210512:151903.450 completed 11% of database upgrade
           7:20210512:151903.853 [Z3005] query failed: [1062] Duplicate entry '34' for key 'dashboard_user.PRIMARY' [insert into dashboard_user (dashboard_userid,dashboardid,userid,permission) values (34,160,31, 2)]
           7:20210512:151903.858 database upgrade failed 

      Attachments

        Issue Links

          Activity

            People

              MVekslers Michael Veksler
              aigars.kadikis Aigars Kadikis
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: