On Fri, Aug 6, 2010 at 10:10 PM, Alanoly Andrews <alanolya@xxxxxxxxxx> wrote: > I’m testing “hot standby” using “streaming WAL records”. On trying to bring > up the hot standby, I see the following error in the log: Thanks for the report! > LOG: database system was interrupted; last known up at 2010-08-05 14:46:36 > LOG: entering standby mode > LOG: restored log file "000000010000000000000007" from archive > LOG: redo starts at 0/7000020 > LOG: consistent recovery state reached at 0/8000000 > LOG: database system is ready to accept read only connections > cp: /pgarclog/pg1/000000010000000000000008: A file or directory in the path > name does not exist. > LOG: WAL receiver process (PID 1073206) was terminated by signal 11 > LOG: terminating any other active server processes > > There is a core dump. The debugger indicates the crash sequence as follows: > > (dbx) where > _alloc_initial_pthread(??) at 0x90000000049567c > __pth_init(??) at 0x900000000493ba4 > uload(??, ??, ??, ??, ??, ??, ??, ??) at 0x9fffffff0001954 > load_64.load(??, ??, ??) at 0x90000000004686c > loadAndInit() at 0x90000000047bd7c > dlopen(??, ??) at 0x90000000011cc4c > internal_load_library(libname = > "/apps/pg_9.0_b4/lib/postgresql/libpqwalreceiver.so"), line 234 in "dfmgr.c" > load_file(filename = "libpqwalreceiver", restricted = '\0'), line 156 in > "dfmgr.c" > WalReceiverMain(), line 248 in "walreceiver.c" > AuxiliaryProcessMain(argc = 2, argv = 0x0fffffffffffa8b8), line 428 in > "bootstrap.c" > StartChildProcess(type = WalReceiverProcess), line 4405 in "postmaster.c" > sigusr1_handler(postgres_signal_arg = 30), line 4227 in "postmaster.c" > __fd_select(??, ??, ??, ??, ??) at 0x90000000011805c > postmaster.select(__fds = 5, __readlist = 0x0fffffffffffd0a8, __writelist = > (nil), __exceptlist = (nil), __timeout = 0x0ffffffffffff0c0), line 229 in > "time.h" > unnamed block in ServerLoop(), line 1391 in "postmaster.c" > unnamed block in ServerLoop(), line 1391 in "postmaster.c" > ServerLoop(), line 1391 in "postmaster.c" > PostmasterMain(argc = 1, argv = 0x00000001102aa4b0), line 1092 in > "postmaster.c" > main(argc = 1, argv = 0x00000001102aa4b0), line 188 in "main.c" > > Any pointers on how to resolve the issue will be much appreciated. Sorry, I have no idea what's wrong :( Is the simple LOAD command successful on your AIX? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
