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

history.push inserts duplicated history rows

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 7.0.4rc1, 7.2.0alpha1
    • 7.0.0
    • Server (S)
    • None
    • 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.

       

            dgoloscapov Dmitrijs Goloscapovs
            NexonSU Ruslan Aznabaev
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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