I very recently migrated from 1.8.10 on MySQL to 2.0.5 on PostgreSQL and did not migrate any history or trend data. I only migrated the config. I enabled partitioning as detailed here https://www.zabbix.org/wiki/Docs/howto/zabbix2_postgresql_autopartitioning

Afterwards, I attempted to copy the CPU Utilization graph from the Linux OS Template to my own template, but this caused a deadlock on the items table.

I then attempted to manually reproduce this graph and could only save 4 items before producing this deadlock.

After upgrading to 2.0.6 today, I was able to add a 5th item, but not a 6th. I set the DBSyncers down to 1, and it did not help.

Below is the error produced in the Web UI:

pg_query(): Query failed: ERROR: deadlock detected
DETAIL: Process 26553 waits for ShareLock on transaction 160469663; blocked by process 16935.
Process 16935 waits for ShareLock on transaction 160469658; blocked by process 26553.
HINT: See server log for query details.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."items" x WHERE "itemid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x" [include/db.inc.php:511]
Error in query [INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) VALUES ('26223','6992','82599','0','3','990099','0','2','0')] [ERROR: deadlock detected
DETAIL: Process 26553 waits for ShareLock on transaction 160469663; blocked by process 16935.
Process 16935 waits for ShareLock on transaction 160469658; blocked by process 26553.
HINT: See server log for query details.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."items" x WHERE "itemid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"]
SQL statement execution has failed "INSERT INTO graphs_items (gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type) VALUES ('26223','6992','82599','0','3','990099','0','2','0')".

Attached is the pgsql log corresponding to the above error.

Forum: https://www.zabbix.com/forum/showthread.php?p=130638#post130638