Serialization failures on PQ9.5

From: Sean Gong <sean(dot)gong(at)ebayta(dot)com>
To: odo(at)odoo(dot)com, pgsql-bugs(at)postgresql(dot)org
Cc: 许建龙 <jl(dot)xu(at)oscg(dot)biz>
Subject: Serialization failures on PQ9.5
Date: 2016-09-07 15:17:54
Message-ID: 41C74740-A321-4F3B-93EA-1BB9115B3C3A@ebayta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

I’m Sean Gong and we are a Odoo 9.0 enterprise version user.

I saw your thread (BUG #13681) on https://www.postgresql.org/message-id/flat/20151014164844(dot)3019(dot)25750%40wrigleys(dot)postgresql(dot)org#20151014164844(dot)3019(dot)25750(at)wrigleys(dot)postgresql(dot)org <https://www.postgresql.org/message-id/flat/20151014164844(dot)3019(dot)25750(at)wrigleys(dot)postgresql(dot)org#20151014164844(dot)3019(dot)25750@wrigleys.postgresql.org>.

Now, we are facing the same issue using 9.0e-20160504 with psql 9.5.4.
We are getting ERROR: could not serialize access due to concurrent update
When executing 2 same sql at same time:
UPDATE "stock_quant" SET "qty"=10.0,"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (271941)

Just want to know, is there any final solution for this bug? Has it been fixed on 9.5.4 or not?

Thank you very much and hope to hear from you soon!

Cheers,
Sean Gong
CIO of ebayta

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2016-09-07 15:58:55 Re: Serialization failures on PQ9.5
Previous Message t.katsumata1122 2016-09-07 13:42:42 BUG #14314: Mismatch of comment of a function.