PostgreSQL errors

[bradc]

I'm seeing a huge amount of these errors in the postgresql main log:

2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: select max(eventid) from events where eventid between 100000000000000 and 199999999999999
2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: insert into ids (nodeid,table_name,field_name,nextid) values (1,'events','eventid',100000000000000)
2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid'
2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: select nextid from ids where nodeid=1 and table_name='events' and field_name='eventid'
2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: select max(eventid) from events where eventid between 100000000000000 and 199999999999999
2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: insert into ids (nodeid,table_name,field_name,nextid) values (1,'events','eventid',100000000000000)
2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: update ids set nextid=nextid+1 where nodeid=1 and table_name='events' and field_name='eventid'
2011-11-09 16:36:29 CST ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-11-09 16:36:29 CST STATEMENT: select nextid from ids where nodeid=1 and table_name='events' and field_name='eventid'

I found it because the log had completely filled my disk drive. After deleting the log and restarting it logged 60322 lines of this in the time it took me to count to 5 in my head.

Any ideas?

[bradc]

This is from the zabbix log:

12483:20111109:165431.020 [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 (1,'events','eventid',100000000000000)]
12483:20111109:165431.020 [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=1 and table_name='events' and field_name='eventid']
12483:20111109:165431.020 [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=1 and table_name='events' and field_name='eventid']
12483:20111109:165431.021 [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 100000000000000 and 199999999999999]
12483:20111109:165431.021 [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 (1,'events','eventid',100000000000000)]
12483:20111109:165431.021 [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=1 and table_name='events' and field_name='eventid']

[f.koch]

Hi, which is your zabbix server version?

[bradc]

1.8.8

The more time I spend with this the more I think that this distributed mode configuration is what we in the software industry call a "steaming pile of crap" and my mistake was trying to use it.