[pgpool-committers: 1832] pgpool: Fix jdbc DML fails when operated in raw mode and auto commit is

Muhammad Usama m.usama at gmail.com
Tue May 6 20:08:08 JST 2014


Fix jdbc DML fails when operated in raw mode and auto commit is off.

When autocommit is off, bind() needs to start a transaction (if not
already in) for DMLs and do an insert lock if sequences are used in
replication mode. The fix was made into pgpool-II
3.3.2. Unfortunately, the fix forgot that it should be applied only
for replication mode. For other mode, that is not needed at all. The
bug reported in #92 happens when operated in raw mode and auto commit
is off.  When parse() executes it does not start a transaction because
we are in raw mode.  Then bind() starts a transaction by issuing
"BEGIN" which destroys the unnamed statement and the failure occurs.

Per bug #92.

Branch
------
EXCEPTION_MGR

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=290880f4a51afca14e2c6fd3b57d9fbd83a4bb98
Author: Tatsuo Ishii <ishii at postgresql.org>

Modified Files
--------------
src/protocol/pool_proto_modules.c |   37 ++++++++++++++++++++-----------------
1 file changed, 20 insertions(+), 17 deletions(-)



More information about the pgpool-committers mailing list