База PostgreSQL 8.4 и сервер Zabbix 1.8.4 разнесены.
Через некоторое время работы в логах такие ошибки:
Через некоторое время работы в логах такие ошибки:
Code:
2678:20110303:171913.402 [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)] 2679:20110303:171913.403 [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'] 2678:20110303:171913.403 [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'] 2679:20110303:171913.404 [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] 2679:20110303:171913.406 [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)] 2678:20110303:171913.406 [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'] 2679:20110303:171913.409 [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'] 2678:20110303:171913.409 [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]
Comment