[Pgpool-general] Error with streaming/balancing / pgpool 3.0.4

[Olivier NOEL]

2011/8/22 Toshihiro Kitagawa <kitagawa at sraoss.co.jp>:
> Hello,
>
> On Fri, 19 Aug 2011 18:11:52 +0200
> Olivier NOEL <nolivfr at gmail.com> wrote:
>
>> Hello,
>>
>> new problem :
>>
>> 2011-08-19 17:52:03 LOG:   pid 8968: find_primary_node:
>> pgpool_walrecrunning does not exist
>>
>> 2011-08-19 18:01:25 LOG:   pid 8990: pool_send_and_wait: Error or
>> notice message from backend: : DB node id: 1 backend pid: 10280
>> statement:  message: cannot execute UPDATE in a read-only transaction
>>
>> Pgpool seems to send the DML queries to all the backends, instead of
>> just the master. Is it normal ? Same config file as above.
>
> It seems that you failed in installation of pgpool_walrecrunning().
> pgpool_walrecrunning() is the function that is necessary to recognize
> a primary node in pgpool-II 3.0.x.
> You have to execute install-functions.sh again.
> install-functions.sh can download from tutorial page.

I installed them afterwards, but still have these errors.

I will check the database.

> --
> Toshihiro Kitagawa
> SRA OSS, Inc. Japan
>
>> I followed this tutorial :
>> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting2/index.html
>>
>> Olivier
>>
>> 2011/8/17 Olivier NOEL <nolivfr at gmail.com>:
>> > 2011/8/17 Tatsuo Ishii <ishii at sraoss.co.jp>:
>> >> Are you able to connect to pgpool-II using psql?
>> >
>> > Yes I was able to connect to pgpool, but with the error and no queries
>> > was sent to the servers, pgpool crashed after the error.
>> >
>> > I moved back to the fresh snapshot I made after installing the OS and
>> > postgresql server (The servers are on VMware VMs), and I don't have
>> > the error anymore, only the ssl part : SSL requested but SSL support
>> > is not available.
>> >
>> > I am able to connect to pgpool and all queries are sent to the
>> > servers, but I still don't know where the error came from.
>> >
>> > Olivier.
>> >
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese: http://www.sraoss.co.jp
>> >>
>> >
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>
>