Ad Widget

Collapse

Problem with zabbix 1.8.2 and postgres 8.3.8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • f-kons
    Junior Member
    • Aug 2009
    • 3

    #1

    Problem with zabbix 1.8.2 and postgres 8.3.8

    Problem:

    OS: openSUSE 11.1
    zabbix: 1.8.2
    postgres: 8.3.8

    Clean zabbix install (create database, then fill it by scripts from 'create' directory).
    After starting server:
    - clients cannot connect
    - postgres logs filled by errors (error log grows fast up to hundred megabytes):
    ...
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: insert into ids (nodeid,table_name,field_name,nextid) values (0,'events','eventid',0)
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid'
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: select max(eventid) from events where eventid between 0 and 99999999999999
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: insert into ids (nodeid,table_name,field_name,nextid) values (0,'events','eventid',0)
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid'
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid'
    2010-07-04 08:29:18 MSD zabbix zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
    2010-07-04 08:29:18 MSD zabbix zabbix КОМАНДА: select max(eventid) from events where eventid between 0 and 99999999999999
    ...

    - zabbix server log filled by errors:
    ...
    19587:20100704:082918.333 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [insert into ids (nodeid,table_name,field_name,nextid) values (0,'events','eventid',0)]
    19587:20100704:082918.334 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
    19587:20100704:082918.334 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
    19587:20100704:082918.334 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [select max(eventid) from events where eventid between 0 and 99999999999999]
    19587:20100704:082918.334 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [insert into ids (nodeid,table_name,field_name,nextid) values (0,'events','eventid',0)]
    19587:20100704:082918.335 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
    19587:20100704:082918.335 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
    19587:20100704:082918.335 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
    [select max(eventid) from events where eventid between 0 and 99999999999999]
    ...
    Last edited by f-kons; 04-07-2010, 07:08.
Working...