Suse 10 (s390x) with Zabbix 1.8.4 and Postgresql 8.1 deadlock

[aj2011]

Hi guys,

I get some erroe message in a postgresql.log

2011-02-08 09:52:15 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:20 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 86
2011-02-08 09:52:20 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:25 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 86
2011-02-08 09:52:25 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:30 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 87
2011-02-08 09:52:30 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:35 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 88
2011-02-08 09:52:35 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:40 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 86
2011-02-08 09:52:40 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:45 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 87
2011-02-08 09:52:45 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:50 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 86
2011-02-08 09:52:50 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:52:55 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 87
2011-02-08 09:52:55 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:53:00 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 87
2011-02-08 09:53:00 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:53:07 BRST zabbix ZABBIX ERROR: deadlock detected
2011-02-08 09:53:07 BRST zabbix ZABBIX DETAIL: Process 16847 waits for ShareLock on transaction 25057834; blocked by pro
cess 16204.
Process 16204 waits for ShareLock on transaction 25057832; blocked by process 16847.
2011-02-08 09:53:07 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:53:07 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:53:07 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:53:07 BRST zabbix ZABBIX ERROR: syntax error at or near "," at character 87
2011-02-08 09:53:07 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block
2011-02-08 09:53:07 BRST zabbix ZABBIX ERROR: current transaction is aborted, commands ignored until end of transaction
block

Does anyone know if there is some bug between versions with Zabbix 1.8.4 and Postgresql 8.1 ?


I'm using a Suse Linux Enterprise Server 10 SP3 (s390x) with Zabbix 1.8.4 and Postgresql 8.1.

[BDiE8VNy]

Hi,

same with CentOS-5 and PostgreSQL-8.4.5.

The error occures by making simultanous changes of several objects.
Adding more then one System to a Template for example produces this error. Doing it only for one system works.