postgres 9.0 crash when bringing up hot standby

From: Alanoly Andrews <alanolya(at)invera(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: postgres 9.0 crash when bringing up hot standby
Date: 2010-08-06 13:10:15
Message-ID: 09B23E7BF70425478C1330D893A722C602FEC019BD@MailSVR.invera.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers


Hello,

OS level = AIX 5.3 ML-8
Postgres version = 9.0 beta-4

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:

LOG: database system was interrupted; last known up at 2010-08-05 14:46:36 EDT
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.

Thanks.

Alanoly Andrews (alanolya(at)invera(dot)com<mailto:alanolya(at)invera(dot)com>)
Senior Software Engineer
Invera Inc.
Montreal, QC

****************************************************
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courriel est confidentiel et protg. L'expditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) dsign(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immdiatement, par retour de courriel ou par un autre moyen.
****************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fujii Masao 2010-08-06 14:31:03 Re: postgres 9.0 crash when bringing up hot standby
Previous Message Silvio Brandani 2010-08-06 11:56:53 Re: out of memory error

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Fowler 2010-08-06 13:43:52 Re: review: xml_is_well_formed
Previous Message Fujii Masao 2010-08-06 12:54:55 default of max_stack_depth