<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Right. PgPool <b>thinks</b> that backend 0 is down, but it's
actually up and running.<br>
<br>
Where do I look to see why Pgpool thinks backend 0 is down even
though backend 0 is actually up?<br>
<br>
<div class="moz-cite-prefix">On 1/26/23 20:57, Tatsuo Ishii wrote:<br>
</div>
<blockquote type="cite"
cite="mid:20230127.115736.1122874289108760790.t-ishii@sranhm.sra.co.jp">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">psql on FISPCCPGS405a port 5432 says that pg_is_in_recovery() = 'f'
(that is correct), while psql on FISPCCPGS405a port 9999 says that
pg_is_in_recovery() = 't'.
That is incorrect, and certainly why "psql --host=localhost
--port=9999" drops me into a read only transaction.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
Because backend 0 is in down status, Pgpool-II thinks backend 0 is out
of use and sends all queries to backend 1.
So you need to solve the problem, i.e. backend0 is in down status
problem first.
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">What should I look for (logging is debug3") to resolve this?
$ hostname
FISPCCPGS405a
$ grep FISPCCPGS405[ab] pgpool.conf
backend_hostname0 = 'FISPCCPGS405a'
backend_hostname1 = 'FISPCCPGS405b'
hostname0 = 'FISPCCPGS405a'
hostname1 = 'FISPCCPGS405a'
$ psql --host=localhost --username=postgres --port=9999 -c "\x" -c
"show pool_nodes;"
Expanded display is on.
-[ RECORD 1 ]----------+--------------------
node_id | 0
hostname | FISPCCPGS405a
port | 5432
status | down <<<<<<<<<<<<<<
pg_status | up <<<<<<<<<<<<<<
lb_weight | 0.666667
role | primary
pg_role | primary
select_cnt | 0
load_balance_node | false
replication_delay | 0
replication_state |
replication_sync_state |
last_status_change | 2023-01-26 13:31:04
-[ RECORD 2 ]----------+--------------------
node_id | 1
hostname | FISPCCPGS405b
port | 5432
status | up <<<<<<<<<<<<<<<
pg_status | up <<<<<<<<<<<<<<<
lb_weight | 0.333333
role | standby
pg_role | standby
select_cnt | 0
load_balance_node | true
replication_delay | 0
replication_state |
replication_sync_state |
last_status_change | 2023-01-26 13:31:04
--
Born in Arizona, moved to Babylonia.
_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Born in Arizona, moved to Babylonia.</div>
</body>
</html>