Re: [Pgpool-general] pgpool losing queries

2010-02-27 Thread Daniel Codina
Thanks for answering Tatsuo, The test I did was: 1) for loop inserting 50 values to a table. 2) stop one of the servers (in that moment the client in the loop gives the error I commented) 3) The online backup starts and works perfectly. 4) I look for all the values in the table, and, in fact,

Re: [Pgpool-general] JDBC autocommit and hanging locks

2010-02-27 Thread Tatsuo Ishii
I'm confused. Even if pgpool-II sends sync message to one of the backend servers, backend will not close the transaction if it's in an explicit transaction. Thus the shared lock will remain, right? I think just sending sync message to all backend servers does not solve the whole problem. IMO what