From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Alanoly Andrews <alanolya(at)invera(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: postgres 9.0 crash when bringing up hot standby |
Date: | 2010-08-06 14:31:03 |
Message-ID: | AANLkTinbaJ3mZ+W5HiYAc+C5ez-pOUFUt+_ajeSsbG26@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
On Fri, Aug 6, 2010 at 10:10 PM, Alanoly Andrews <alanolya(at)invera(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alanoly Andrews | 2010-08-06 15:17:03 | Re: postgres 9.0 crash when bringing up hot standby |
Previous Message | Alanoly Andrews | 2010-08-06 13:10:15 | postgres 9.0 crash when bringing up hot standby |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-08-06 14:31:13 | Re: CommitFest 2010-07 week three progress report |
Previous Message | Fujii Masao | 2010-08-06 14:22:59 | Re: default of max_stack_depth |