Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 2976A6336EF
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  6 Aug 2010 16:54:20 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 26917-05; Fri,  6 Aug 2010 19:54:12 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from exprod7og110.obsmtp.com (exprod7og110.obsmtp.com [64.18.2.173])
	by mail.postgresql.org (Postfix) with SMTP id B9E016330B6;
	Fri,  6 Aug 2010 16:54:11 -0300 (ADT)
Received: from source ([209.85.215.175]) by exprod7ob110.postini.com
	([64.18.6.12]) with SMTP
	ID DSNKTFxoYdkeKo4FhoHsJtkz7uOZEL65f4Kt@postini.com;
	Fri, 06 Aug 2010 12:54:11 PDT
Received: by eyf5 with SMTP id 5so3096768eyf.20
	for <multiple recipients>; Fri, 06 Aug 2010 12:54:08 -0700 (PDT)
Received: by 10.213.114.67 with SMTP id d3mr4674985ebq.77.1281124448806;
	Fri, 06 Aug 2010 12:54:08 -0700 (PDT)
Received: from [192.168.1.117] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi
	[88.195.122.240])
	by mx.google.com with ESMTPS id v59sm2899857eeh.4.2010.08.06.12.53.57
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Fri, 06 Aug 2010 12:54:02 -0700 (PDT)
Message-ID: <4C5C6853.40301@enterprisedb.com>
Date: Fri, 06 Aug 2010 22:53:55 +0300
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fi-FI;
	rv:1.9.1.10) Gecko/20100619 Iceowl/1.0b1 Icedove/3.0.5
MIME-Version: 1.0
To: Alanoly Andrews <alanolya@invera.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] postgres 9.0 crash when bringing up hot standby
References: <09B23E7BF70425478C1330D893A722C602FEC019BD@MailSVR.invera.com>
	<AANLkTinbaJ3mZ+W5HiYAc+C5ez-pOUFUt+_ajeSsbG26@mail.gmail.com>
In-Reply-To: <AANLkTinbaJ3mZ+W5HiYAc+C5ez-pOUFUt+_ajeSsbG26@mail.gmail.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.2 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_MED=-2.3
X-Spam-Level: 
X-Archive-Number: 201008/49
X-Sequence-Number: 35298

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