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

lld worker may produce failing SQL after minor upgrade to 7.0.4

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 7.0.5rc1, 7.2.0alpha1
    • None
    • Server (S)
    • None
    • S24-W40/41
    • 0.25

      After minor upgrade from 7.0.3 to 7.0.4 zabbix started to produce this randomly generated error:

      3836959:20240924:112709.954 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  null value in column "value" of relation "housekeeper" violates not-null constraint
      DETAIL:  Failing row contains (717095, events, triggerid, null).
       [insert into housekeeper (housekeeperid,tablename,field,value) values (717095,'events','triggerid',null);
      ]
      

      Note - minor automatic DB patching performed successfully.

      2 of 2 LLD workers produce it. I may assume this happening the a LLD rule is deleting lost resources.

      Filtered as "egrep "query failed" -A2 zabbix_server.log" is attached.
      Note - some IDs are repeating multiple times, some do not.

        1. filtered
          8 kB
          Oleksii Zagorskyi
        2. zbx_export_hosts-7.yaml
          1 kB
          Vladislavs Sokurenko

            vso Vladislavs Sokurenko
            zalex_ua Oleksii Zagorskyi
            Team A
            Votes:
            9 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated:
              Resolved: