[pgpool-general: 719] Re: Load Balancing / Streaming Replication / Isolation Level serializable
Tatsuo Ishii
ishii at postgresql.org
Thu Jul 12 23:04:50 JST 2012
Thanks for quick review of my patch!
Glad to hear that it works for your application.
Also we will look into it the new issues.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> Hi,
>
> On Thu, Jul 12, 2012 at 4:15 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>
>> Fixed. Patch attached.
>
> very cool. I can confirm that the patch fixes the issue! Thanks a lot!
>
> And now, let me be mean and show you the next, very much related
> issue, though this time it doesn't matter for me, but it should
> probably be fixed for completeness sake too:
>
> pilif at tali:~|⇒ psql -h pgpool demovendor
> psql (9.1.1, server 9.1.4)
> Type "help" for help.
>
> demo=> begin work;
> BEGIN
> demo=> set transaction isolation level serializable;
> ERROR: kind mismatch among backends. Possible last query was: "set
> transaction 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: "set
> transaction 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
>
> (this is pgpool 3.1.1 with your patch applied)
>
> So same issue for using "set transaction isolation level" without also
> specifying "read write"
>
> Again, this is just nit-picking, but who knows what code relies on
> just set transaction isolation level (ours doesn't :p)
>
> Philip
More information about the pgpool-general
mailing list