pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Samuel Stearns <SStearns@internode.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Shoaib Mir <shoaibmir@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgres Crash
Date: Fri, 10 Dec 2010 14:35:12 +1030
Message-ID: <68B59BEDCD36854AADBDF17E91B2937A07844CD04A@EXCHMAIL.staff.internode.com.au> (raw)
In-Reply-To: <13055.1291952802@sss.pgh.pa.us>
References: <68B59BEDCD36854AADBDF17E91B2937A07844CD029@EXCHMAIL.staff.internode.com.au>
	<AANLkTikYRT15R61-ZByCzs_PoMT50JHbQFWeymeYjtjn@mail.gmail.com>
	<68B59BEDCD36854AADBDF17E91B2937A07844CD02E@EXCHMAIL.staff.internode.com.au>
	<13055.1291952802@sss.pgh.pa.us>

Thanks Tom,

We don't have gdb.  We have mdb and pstack.  From the core:

[root@udrv] # mdb /opt/postgres/8.3-community/bin/postmaster /root/core 
Loading modules: [ libc.so.1 ld.so.1 ]
> ::status
debugging core file of postmaster (32-bit) from udrv
file: /opt/postgres/8.3-community/bin/postmaster
initial argv: /opt/postgres/8.3-community/bin/postmaster -F
threading model: multi-threaded
status: process terminated by SIGSEGV (Segmentation Fault)
> ::regs
%cs = 0x003b            %eax = 0x083b7fe0 
%ds = 0x0043            %ebx = 0x00000000 
%ss = 0x0043            %ecx = 0x00000000 
%es = 0x0043            %edx = 0x00000000 
%fs = 0x0000            %esi = 0x00000001 
%gs = 0x01c3            %edi = 0x00000005 

 %eip = 0x081a8562 ConnCreate+0xb6
 %ebp = 0x08047c88
%kesp = 0x00000000

%eflags = 0x00010206
  id=0 vip=0 vif=0 ac=0 vm=0 rf=1 nt=0 iopl=0x0
  status=<of,df,IF,tf,sf,zf,af,PF,cf>

   %esp = 0x08047c78
%trapno = 0xe
   %err = 0x6

 [root@udrv] # pstack /root/core 
core '/root/core' of 771:       /opt/postgres/8.3-community/bin/postmaster -F
 081a8562 ConnCreate (5) + b6
 081a791b ServerLoop (8047e68, 83b7930, 2, fead58be, 8047e68, 83c28b8) + db
 081a73f1 PostmasterMain (2, 83b7930) + ab5
 08164e3a main     (2, 8047e44, 8047e50) + 17a
 080891fa _start   (2, 8047ed0, 8047efb, 0, 8047efe, 8047f2e) + 7a
>

Sam

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Friday, 10 December 2010 2:17 PM
To: Samuel Stearns
Cc: Shoaib Mir; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres Crash 

Samuel Stearns <SStearns@internode.com.au> writes:
> Tom, no useful messages in the log prior.  I do have a 47M core dump.  What should I do with that?

If you use gdb, try

	$ gdb /path/to/postmaster /path/to/corefile
	gdb> bt
	... useful info here ...
	gdb> quit

I think the preferred debugger on Solaris might not be gdb, but if so
you'll need to consult its docs to find out how to get a stack trace.

			regards, tom lane



view thread (22+ messages)  latest in thread

Message-ID: <68B59BEDCD36854AADBDF17E91B2937A07844CD04A@EXCHMAIL.staff.internode.com.au>
Permalink:  ../68B59BEDCD36854AADBDF17E91B2937A07844CD04A@EXCHMAIL.staff.internode.com.au/
Also on:    postgresql.org/message-id/68B59BEDCD36854AADBDF17E91B2937A07844CD04A@EXCHMAIL.staff.internode.com.au

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: SStearns@internode.com.au, tgl@sss.pgh.pa.us, shoaibmir@gmail.com
  Subject: Re: Postgres Crash
  In-Reply-To: <68B59BEDCD36854AADBDF17E91B2937A07844CD04A@EXCHMAIL.staff.internode.com.au>
  References: <68B59BEDCD36854AADBDF17E91B2937A07844CD029@EXCHMAIL.staff.internode.com.au> <AANLkTikYRT15R61-ZByCzs_PoMT50JHbQFWeymeYjtjn@mail.gmail.com> <68B59BEDCD36854AADBDF17E91B2937A07844CD02E@EXCHMAIL.staff.internode.com.au> <13055.1291952802@sss.pgh.pa.us> <68B59BEDCD36854AADBDF17E91B2937A07844CD04A@EXCHMAIL.staff.internode.com.au>

* 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