[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