Re: [HACKERS] postgres 9.0 crash when bringing up hot standby

On 06/08/10 17:31, Fujii Masao wrote:
> 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
>> (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.

So, loading libpqwalreceiver library crashes. It looks like it might be
pthread-related. Perhaps something wrong with our makefiles, causing
libpqwalreceiver to be built with wrong flags? Does contrib/dblink work?
If you look at the build log, what is the command line used to compile
libpqwalreceiver, and what is the command line used to build other
libraries, like contrib/dblink?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com