[pgpool-general: 716] Re: Load Balancing / Streaming Replication / Isolation Level serializable

[Tatsuo Ishii]

>> in an application of ours, we have a very small amount of transactions
>> that need to run in serializable isolation level.
>> 
>> Unfortunately it seems that pgpool 3.1.1 (stock Ubuntu Precise
>> Package) insists on sending commands to start such a transaction to
>> the slave (using streaming replication):
>> 
>> pilif at tali:~|⇒  psql  -h pgpool demo
>> psql (9.1.1, server 9.1.4)
>> Type "help" for help.
>> 
>> demo=> begin work isolation level serializable;
>> ERROR:  kind mismatch among backends. Possible last query was: "begin
>> work isolation level serializable;" kind details are: 0[C] 1[E: cannot
>> use serializable mode in a hot standby]
>> HINT:  check data consistency among db nodes
>> ERROR:  kind mismatch among backends. Possible last query was: "begin
>> work isolation level serializable;" kind details are: 0[C] 1[E: cannot
>> use serializable mode in a hot standby]
>> HINT:  check data consistency among db nodes
>> The connection to the server was lost. Attempting reset: Succeeded.
>> demo=>
>> 
>> This doesn't make sense to me as according to
>> http://www.pgpool.net/docs/latest/doc/pgpool-en.html there's a
>> specific provision in the code not to do that.
>> 
>> Any idea what's going on here?
> 
> Usually a software which does not work as advertised is called
> buggy:-) Will look into this.

Fixed. Patch attached.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: serializable-v31.patch
Type: text/x-patch
Size: 5064 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120712/37cb0ed3/attachment.bin>