[pgpool-general: 5282] Re: No more master role in psql show pool nodes

Daniel Huhardeaux tech at tootai.net
Sat Jan 28 21:15:10 JST 2017


Le 28/01/2017 à 01:53, Tatsuo Ishii a écrit :
> Well, Pgpool-II 3.6.0 was realesed on last November. So it has been
> there for just 2 months and 8 days. Maybe you see the problem after
> upgrading to 3.6.0?

What I meaned is that servers are installed and running since 4 monthes. 
They where restarted since november, weekly security update.

[...]

>
>> Hi,
>>
>> I face following problem after a restart, it was working well since 4
>> monthes, no configuration changes.
>>
>> Node 0 should have role master! How to change role to master for node
>> 0/tooi-as-0005 ?
>>
>> Version: pgpool-II version 3.6.0 (subaruboshi) from Ubuntu 16.04.1
>>
>> Thanks for any hint.
>>
>>
>> on node 0
>>
>> psql show pool nodes:
>>
>>  node_id | hostname | port | status | lb_weight | role | select_cnt |
>>  load_balance_node | replication_delay
>> ---------+--------------+-------+--------+-----------+---------+------------+-------------------+-------------------
>>  0 | tooi-as-0005 | 55432 | up | 0.500000 | standby | 17308 | false | 0
>>  1 | tooi-as-0006 | 55432 | up | 0.500000 | standby | 9001 | true | 0
>> (2 lignes)
>>
>> postgres=# select pg_is_in_recovery();
>>  pg_is_in_recovery
>> -------------------
>>  f
>> (1 ligne)
>>
>>
>> on node 1
>>
>> psql show pool nodes:
>>
>>  node_id | hostname | port | status | lb_weight | role | select_cnt |
>>  load_balance_node | replication_delay
>> ---------+--------------+-------+--------+-----------+---------+------------+-------------------+-------------------
>>  0 | tooi-as-0005 | 55432 | up | 0.500000 | standby | 17309 | true | 0
>>  1 | tooi-as-0006 | 55432 | up | 0.500000 | standby | 9001 | false | 0
>> (2 lignes)
>>
>> postgres=# select pg_is_in_recovery();
>>  pg_is_in_recovery
>> -------------------
>>  t
>> (1 ligne)
>>
>> --
>> Daniel
>> TOOTAi Networks
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>


-- 
TOOTAi Networks


More information about the pgpool-general mailing list