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

[Olivier NOEL]

2011/8/22 Olivier NOEL <nolivfr at gmail.com>:
>> Yes, f and t are boolean values.
>> pgpool-II calls pgpool_walrecrunning() in postgres database.
>> Can you select pgpool_walrecrunning() in postgres database?
>
> I will try to import the sql to the postgres database.

It works now

2011-08-22 11:38:12 LOG:   pid 10931: find_primary_node: primary node id is 0

but Pgpool still sends DML and DDL queries to one slave, the second
one (node id 2) :

2011-08-22 11:38:47 DEBUG: pid 10963: wait_for_query_response: waiting
for backend 2 completing the query
2011-08-22 11:38:47 LOG:   pid 10963: pool_send_and_wait: Error or
notice message from backend: : DB node id: 2 backend pid: 33857
statement:  message: cannot execute UPDATE in a read-only transaction

For the record, here is the backend part of my configuration file.

backend_hostname0 = 'fpg01'
backend_port0 = 5432
backend_weight0 = 1
backend_hostname1 = 'fpg02'
backend_port1 = 5432
backend_weight1 = 2
backend_hostname2 = 'fpg03'
backend_port2 = 5432
backend_weight2 = 2


>> --
>> Toshihiro Kitagawa
>> SRA OSS, Inc. Japan
>>
>>
>