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

postgresql unique key constraint violation causes server to stop

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6.4
    • Fix Version/s: 1.8.2, 1.9.0 (alpha)
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Linux 2.6.27-gentoo-r8 #1 SMP Fri Mar 13 04:38:14 CET 2009 x86_64 Intel(R) Xeon(R) CPU E5405 @ 2.00GHz GenuineIntel GNU/Linux

      Description

      from my log:
      20946:20091005:160035 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "trends_pkey"
      [insert into trends (clock,itemid,num,value_min,value_avg,value_max) values (1254751200,22170,1,965.478261,965.478261,965.478261)]
      20946:20091005:160035 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
      [update items set nextcheck=1254751227,prevvalue=lastvalue,prevorgvalue='4569905065.000000',lastvalue='965.478261',lastclock=1254751222 where itemid=22170]
      20946:20091005:160035 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
      [select distinct function,parameter,itemid,lastvalue from functions where itemid=22170]
      20347:20091005:160036 One child process died. Exiting ...

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              svrkispm svrki
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: