ExportXMLWordPrintable

    • Type: Incident report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 8.0.0
    • Component/s: Server (S)
    • None
    • Environment:
      debian 12

      Steps to reproduce:

      1. follow upgrade as usual
      2. launch server service

      Result:
      1045589:20261109:162927.544 current database version (mandatory/optional): 07050119/07050119
      1045589:20261109:162927.544 required mandatory version: 08000000
      1045589:20261109:162927.544 mandatory patches were found
      1045589:20261109:162927.548 starting automatic database upgrade
      1045589:20261109:162927.752 [Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERREUR:  la valeur d'une clé dupliquée rompt la contrainte unique « trigger_rtdata_pkey »
      DETAIL:  La clé « (triggerid)=(36024) » existe déjà.
       [insert into trigger_rtdata (triggerid,value,lastchange,state,error)select t.triggerid,t.value,t.lastchange,t.state,t.error from triggers t where t.flags in (0,4) and exists ( select null from functions f join items i on f.itemid=i.itemid join hosts h on i.hostid=h.hostid where f.triggerid = t.triggerid and h.status<>3)]
      1045589:20261109:162927.752 database upgrade failed on patch 07050120, exiting in 10 seconds
      1045589:20261109:162928.742 Got signal [signal:15(SIGTERM),sender_pid:1045593,sender_uid:0,reason:0]. Exiting ...
      1045589:20261109:162928.742 Zabbix Server stopped. Zabbix 8.0.0 (revision c81e276e505).
      Expected:
      get a correct zabbix service up

            Assignee:
            Bartosz Nems
            Reporter:
            fondriest
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: