From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Alanoly Andrews <alanolya@invera.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] postgres 9.0 crash when bringing up hot standby
Date: Fri, 06 Aug 2010 22:53:55 +0300
Message-ID: <4C5C6853.40301@enterprisedb.com> (raw)
In-Reply-To: <AANLkTinbaJ3mZ+W5HiYAc+C5ez-pOUFUt+_ajeSsbG26@mail.gmail.com>
References: <09B23E7BF70425478C1330D893A722C602FEC019BD@MailSVR.invera.com>
<AANLkTinbaJ3mZ+W5HiYAc+C5ez-pOUFUt+_ajeSsbG26@mail.gmail.com>
On 06/08/10 17:31, Fujii Masao wrote:
> On Fri, Aug 6, 2010 at 10:10 PM, Alanoly Andrews<alanolya@invera.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: heikki.linnakangas@enterprisedb.com, alanolya@invera.com, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] postgres 9.0 crash when bringing up hot standby
In-Reply-To: <4C5C6853.40301@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox