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]
...
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]
...