Re: [BUGS] BUG #5107: Lock never released

2009-10-14 Thread Chris Browne
t...@sss.pgh.pa.us (Tom Lane) writes: > "Christian DUPONT" writes: >> I use slony 1 v 1.2.14. >> After an unexpected stop, several tables remained locked : > > Is it possible that the locks are being held by a prepared transaction? > Next time it happens, look into the pg_prepared_xacts status vi

Re: [BUGS] BUG #5107: Lock never released

2009-10-09 Thread Tom Lane
"Christian DUPONT" writes: > I use slony 1 v 1.2.14. > After an unexpected stop, several tables remained locked : Is it possible that the locks are being held by a prepared transaction? Next time it happens, look into the pg_prepared_xacts status view. If it's not that, it seems like this must

[BUGS] BUG #5107: Lock never released

2009-10-09 Thread Christian DUPONT
The following bug has been logged online: Bug reference: 5107 Logged by: Christian DUPONT Email address: christian.dup...@cegelec.com PostgreSQL version: 8.3 Operating system: RHEL 5 Description:Lock never released Details: Hi, I use slony 1 v 1.2.14. After an un