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

history.push inserts duplicated history rows

XMLWordPrintable

    • Prev.Sprint, S24-W34/35
    • 1

      Steps to reproduce:

      1. Send history.push without clock and ns a few times in one second.

      Result:
      Zabbix Server tries to insert row with ns=0.

      3259167:20240626:161246.524 [Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERROR:  duplicate key value violates unique constraint "21645_11430_history_str_pkey"
      DETAIL:  Key (itemid, clock, ns)=(2531417, 1719407565, 0) already exists. 

      It leads to 100% utilization of history syncer internal processes and false alerts, because of nodata.
      Expected:
      If clock or ns are not present, history.push must populate them with current timestamp.
      Or clock and ns must be required.

       

            azazuks Andrejs Zazuks
            NexonSU Ruslan Aznabaev
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 7h
                7h