Skip site navigation (1) Skip section navigation (2)

HS/SR on AIX

From: Steve Singer <ssinger(at)ca(dot)afilias(dot)info>
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: HS/SR on AIX
Date: 2010-08-24 21:39:57
Message-ID: 4C743C2D.1060209@ca.afilias.info (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
I think I've been able to reproduce the issue floating around with 
streaming replication on AIX.


LOG:  could not bind IPv6 socket: The socket name is already in use.
HINT:  Is another postmaster already running on port 5433? If not, wait 
a few seconds and retry.
LOG:  database system was shut down in recovery at 2010-08-24 21:08:37 UTC
LOG:  entering standby mode
cp: cannot stat `/opt/rg/data_tb3/steve/wals/000000010000000000000001': 
A file or directory in the path name does not exist.
LOG:  redo starts at 0/1000020
LOG:  record with zero length at 0/1012280
cp: cannot stat `/opt/rg/data_tb3/steve/wals/000000010000000000000001': 
A file or directory in the path name does not exist.
FATAL:  could not load library 
"/opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so":         0509-022 Cannot 
load module /opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so.
                 0509-150   Dependent module libpq.a(libpq.so.5) could 
not be loaded.
                 0509-022 Cannot load module libpq.a(libpq.so.5).
                 0509-026 System error: A file or directory in the path 
name does not exist.
                 0509-022 Cannot load module 
/opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so.
                 0509-150   Dependent module 
/opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so could not be loaded.


This worked fine with beta2 but now seems to be an issue on beta4.

If I do
export LIBPATH=/opt/dbs/pgsql9-beta2/lib/
before starting the standby postmaster then it seems to work.

I haven't yet tried running truss to try to look at where it is looking 
for libpq from.  liblibpqwalreceiver is being linked with this

gcc -maix64 -O2 -Wall -Wmissing-prototypes -Wpointer-arith 
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing 
-fwrapv -g  -o libpqwalreceiver.so liblibpqwalreceiver.a 
-Wl,-bE:liblibpqwalreceiver.exp -L../../../../src/port 
-Wl,-bmaxdata:0x80000000,-bbigtoc  -L/opt/freeware/lib 
-Wl,-blibpath:/opt/dbs/pgsql9-beta2/lib:/opt/freeware/lib:/usr/lib:/lib 
  -Wl,-bnoentry -Wl,-H512 -Wl,-bM:SRE -L../../../../src/interfaces/libpq 
-lpq -Wl,-bI:../../../../src/backend/postgres.imp


I'll try to look into this a bit more tomorrow or thursday.


-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2010-08-24 22:34:11
Subject: why restrict role "public" but not "Public"?
Previous:From: Robert HaasDate: 2010-08-24 21:17:12
Subject: Re: git: uh-oh

pgsql-admin by date

Next:From: Rosser SchwarzDate: 2010-08-24 21:43:07
Subject: Re: replication solution
Previous:From: Kevin GrittnerDate: 2010-08-24 21:30:42
Subject: Re: trouble restoring database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group