Hello,
My current version is Openerp V8 and pgsql server 9.3.
I keep getting this error from the log file and it seems to be the cause of slow operation on my system (confirming delivery orders and checking availability,...)
2014-08-11 10:29:05 ICT ERROR: deadlock detected
2014-08-11 10:29:05 ICT DETAIL: Process 38270 waits for ShareLock on transaction 36549; blocked by process 23702.
Process 23702 waits for ShareLock on transaction 36548; blocked by process 38270.
Process 38270: update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33840)
Process 23702: update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33703)
2014-08-11 10:29:05 ICT HINT: See server log for query details.2014-08-11 10:29:05 ICT STATEMENT: update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33840)
2014-08-11 10:29:27 ICT ERROR: could not obtain lock on row in relation "res_users"
2014-08-11 10:29:27 ICT STATEMENT: SELECT id FROM res_users WHERE id=1 FOR UPDATE NOWAIT
2014-08-11 10:29:25 ICT ERROR: could not serialize access due to concurrent update
2014-08-11 10:29:25 ICT STATEMENT: update stock_quant set "qty"=1.0,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (33799)
Is this a coding issue or hardware / server configuration issue ?
Thank you.