[Pgpool-general] Error with streaming/balancing / pgpool 3.0.4
Olivier NOEL
nolivfr at gmail.com
Mon Aug 22 09:52:35 UTC 2011
2011/8/22 Olivier NOEL <nolivfr at gmail.com>:
> 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
I forgot the query on the second slave :
postgres=> select pgpool_walrecrunning();
pgpool_walrecrunning
----------------------
t
(1 ligne)
Slave 1 :
postgres=> select pgpool_walrecrunning();
pgpool_walrecrunning
----------------------
t
(1 ligne)
Master :
postgres=# select pgpool_walrecrunning();
pgpool_walrecrunning
----------------------
f
(1 ligne)
More information about the Pgpool-general
mailing list