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

Tatsuo Ishii ishii at postgresql.org
Thu Jul 12 00:16:58 JST 2012


> 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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list