[Tracker-discuss] Serialization error

Izak Burger izak at upfrontsystems.co.za
Wed Apr 18 09:33:00 CEST 2007


Hi all,

I recall that at some point someone asked about this error but I lost 
the thread that was in.  Occasionally this error is mailed to roundup-admin:

Tracker: ERROR: could not serialize access due to concurrent update

While working on another postgresql based project I noticed that this 
error is a postgresql error.  It occurs when you do things inside a 
transaction and you set the isolation level to serializable.  The 
documentation says you have to watch out for failures and be prepared to 
retry.

Here's a link: 
http://www.postgresql.org/docs/8.1/interactive/transaction-iso.html

I'm mentioning this here as it might mean (on the one hand) that some 
attention needs to be given to the database part of roundup, and (on the 
other hand) it at least explains where that error comes from.

regards,
Izak


More information about the Tracker-discuss mailing list