I can see the following lines in /tmp/pgpool.log:
......
2011-09-01 22:57:34 ERROR: pid 22975: check_replication_time_lag: DB node is
valid but no persistent connection
2011-09-01 22:57:34 DEBUG: pid 22936: health_check: 1 th DB node status: 3
2011-09-01 22:57:36 LOG: pid 23019: starting recovering node 1
2011-09-01 22:57:36 ERROR: pid 23019: start_recover: could not connect master
node.
2011-09-01 22:57:38 DEBUG: pid 22936: starting health checking
2011-09-01 22:57:38 DEBUG: pid 22936: health_check: 0 th DB node status: 1
2011-09-01 22:57:38 DEBUG: pid 22975: pool_ssl: SSL requested but SSL support
is not available
2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: auth kind: 0
2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: parameter status data received
2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: parameter status data received
2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: backend key data received
2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: transaction state: I
2011-09-01 22:57:39 DEBUG: pid 22936: health_check: 1 th DB node status: 3
2011-09-01 22:57:39 ERROR: pid 22975: connect_inet_domain_socket: connect()
failed: Connection refused
2011-09-01 22:57:39 ERROR: pid 22975: make_persistent_db_connection: connection
to localhost(5445) failed
2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: T
2011-09-01 22:57:39 DEBUG: pid 22975: num_fileds: 1
2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: D
2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: C
2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: Z
2011-09-01 22:57:39 ERROR: pid 22975: check_replication_time_lag: DB node is
valid but no persistent connection
2011-09-01 22:57:43 DEBUG: pid 22936: starting health checking
......
________________________________
From: Sandeep Thakkar <sandee...@yahoo.com>
To: Jose Mendoza <jose.mend...@autonomy.com>; "pgpool-general@pgfoundry.org"
<pgpool-general@pgfoundry.org>
Sent: Friday, September 2, 2011 10:10 AM
Subject: Re: [Pgpool-general] online recovery fails on HPUX
# Logging directory
logdir = '/tmp'
________________________________
From: Jose Mendoza <jose.mend...@autonomy.com>
To: pgpool-general@pgfoundry.org
Sent: Wednesday, August 31, 2011 10:28 PM
Subject: Re: [Pgpool-general] online recovery fails on HPUX
What does your pgpool.conf say about logging:
# Logging directory
logdir = '/var/log'
Jose
Autonomy Ops
verificare tua hinc
From:pgpool-general-boun...@pgfoundry.org
[mailto:pgpool-general-boun...@pgfoundry.org] On Behalf Of Sandeep Thakkar
Sent: Wednesday, August 31, 2011 4:58 AM
To: Sandeep Thakkar; pgpool-general@pgfoundry.org
Subject: Re: [Pgpool-general] online recovery fails on HPUX
I see following two lines when the pcp_recovery_node is
fired.. Also, I cannot find recovery.log, but recovery.conf is present in
standby cluster directory..
....
2011-08-31 05:49:22 LOG: pid 20430: starting
recovering node 1
2011-08-31 05:49:22 ERROR: pid 20430: start_recover: could not connect master
node.
....
The pg_hba.conf has the following entry:
# "local" is for Unix domain
socket connections only
local
all
all
trust
# IPv4 local connections:
host
all
all
127.0.0.1/32 trust
# IPv6 local connections:
host
all
all
::1/128
trust
host
replication
edb
127.0.0.1/32
trust
________________________________
From:Sandeep
Thakkar <sandee...@yahoo.com>
To: "pgpool-general@pgfoundry.org"
<pgpool-general@pgfoundry.org>
Sent: Tuesday, August 30, 2011 2:44 PM
Subject: [Pgpool-general] online recovery fails on HPUX
Hi,
I'm using Postgres Plus Advanced Server on HP-UX 11.31 and found that the
online recovery does not work here.
pgPool version is 3.0.3-4
$pcp_recovery_node -d 20 localhost 9898 edb edb 1
DEBUG: send: tos="R", len=41
DEBUG: recv: tos="r", len=21, data=AuthenticationOK
DEBUG: send: tos="D", len=6
DEBUG: recv: tos="e", len=20, data=recovery failed
DEBUG: command failed. reason=recovery failed
BackendError
DEBUG: send: tos="X", len=4
I can see the following in the log:
....
LOG: incomplete startup packet
LOG: connection failed during start up processing: user= database=
....
Moreover, I do not see pgpool_recovery_node statement in the log, so wondering
if it is really getting executed. I have tried my scripts on Linux and it
worked all fine. So, there is no issue with the pgpool.conf or my basebackup
and other files.. Could this be an issue of HPUX?
Thanks.
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
