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

[Olivier NOEL]

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.

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
>>
>