[pgpool-hackers: 4162] Bug in SI mode

[Tatsuo Ishii]

I found a nasty bug in SI mode.
Executing following simple SQL causes an error.

select * from t1;
vacuum t1;
ERROR: VACUUM cannot run inside a transaction block

For the select, pgpool automatically executes it in an explicit
transaction. Unfortunately, pgpool forgot to close the transaction
except the load balance node. So if the load balance node was 2,
transactions on node 0 and 1 were not closed. And vacuum was executed
on node 0 in an explicit transaction, which caused the error.

The fix was already pushed, back to 4.2 stable where SI mode was
introduced.

https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=050be475d738ab4f8268dce21e2e5361b7dbcbee

Best reagards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp