Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id DF4AB19F3CD
	for <pgsql-general@postgresql.org>;
	Mon, 11 Jun 2012 04:50:07 -0300 (ADT)
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1SdzNy-00067Y-Dc
	for pgsql-general@postgresql.org; Mon, 11 Jun 2012 07:50:06 +0000
Received: by dady13 with SMTP id y13so5034321dad.19
	for <pgsql-general@postgresql.org>;
	Mon, 11 Jun 2012 00:49:47 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:x-gm-message-state;
	bh=QXT45K4iV3x3cRggUPKo2LujGKYENOlJBjEvhaZ1zdw=;
	b=D5IiDyrtSYeRkS0+UGnIUzY3gOk8rw4LlI5HFdGAcgR78p6ibFSwE3dxHZTTFXv+iz
	2UBKPc30X7t2H4+ZmxNxtytvS5IEzFu9t0Ck2VAo5AImbXD3lYXDG7X/NtmOqfBGWqqH
	Bu8KRJgiVGhaZ3KuNbvzCLdzTxpYJjTmACjx5kHPDBrkL758Dx5oYwhYCLEY1TisGjwr
	udETK1OzVn90A17mVqNIA6LuzmqcbhQsXl7ETaokz1p87a6MP2SV2heZ62HKEXrieWZp
	okNh8SmFOJhPvIfFjRZT8/cazLxbVk3BYyQkKKvt7Mva1X7YutbBaEtLKiLnzykY+cY6
	qj2g==
Received: by 10.68.200.104 with SMTP id jr8mr24299030pbc.9.1339400987484;
	Mon, 11 Jun 2012 00:49:47 -0700 (PDT)
Received: from ayaki.localdomain (office1.postnewspapers.com.au.
	[150.101.171.128])
	by mx.google.com with ESMTPS id vp4sm17601639pbc.61.2012.06.11.00.49.44
	(version=SSLv3 cipher=OTHER); Mon, 11 Jun 2012 00:49:46 -0700 (PDT)
Message-ID: <4FD5A315.600@ringerc.id.au>
Date: Mon, 11 Jun 2012 15:49:41 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: Benson Jin <benson.jin@troo.com>
CC: pgsql-general@postgresql.org
Subject: Re: Segmentation Fault
References: <843420470.254405.1339385687611.JavaMail.root@troo.com>
In-Reply-To: <843420470.254405.1339385687611.JavaMail.root@troo.com>
Content-Type: multipart/alternative;
	boundary="------------060105010101020709040003"
X-Gm-Message-State: 
 ALoCoQmTqYfcQorjygrvlc760FmBw2vGl6aBr4/D5N02UKSqaJjDBgZSaBicP5kt8K5H+2GIW2HY
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201206/206
X-Sequence-Number: 187986

This is a multi-part message in MIME format.
--------------060105010101020709040003
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 06/11/2012 11:34 AM, Benson Jin wrote:
> Hi All,
>
> We are having a problem with our streaming replication read only node. 
> It has crashed a few times with a couple of different reasons, mostly 
> "segmentation fault".

Any chance of examining a core dump and getting a stack trace?

http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

--
Craig Ringer

--------------060105010101020709040003
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 06/11/2012 11:34 AM, Benson Jin
      wrote:<br>
    </div>
    <blockquote
      cite="mid:843420470.254405.1339385687611.JavaMail.root@troo.com"
      type="cite">
      <style type="text/css">p { margin: 0; }</style>
      <div style="font-family: arial,helvetica,sans-serif; font-size:
        12pt; color: #666666"><font color="#666666" face="arial,
          helvetica, sans-serif" size="3">Hi All,</font>
        <div style="color: rgb(102, 102, 102); font-family: arial,
          helvetica, sans-serif; font-size: 12pt; "><br>
        </div>
        <div style="color: rgb(102, 102, 102); font-family: arial,
          helvetica, sans-serif; font-size: 12pt; ">We are having a
          problem with our streaming replication read only node. It has
          crashed a few times with a couple of different reasons, mostly
          "segmentation fault". <br>
        </div>
      </div>
    </blockquote>
    <br>
    Any chance of examining a core dump and getting a stack trace?<br>
    <br>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    <a
href="http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD">http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD</a><br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------060105010101020709040003--