Re: BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

Thanks for your immediate reply!!. Happy Thanks Giving day!!

postgres(at)acti-db-bala:~$ uname -a
Linux acti-db-bala 2.6.16.33-xenU #2 SMP Wed Aug 15 17:27:36 SAST 2007
x86_64 GNU/Linux
postgres(at)acti-db-bala:~$ cat /etc/issue
Ubuntu 9.04 \n \l

Also I used to compile by the below command

./configure --prefix=/var/lib/pgsql --with-perl --with-libxml
--enable-debug

Sorry, I cannot share my backup/dump file, also its about 25Gigs. Please let
me know how to trace this.

Log :

root(at)acti-db-bala:~# gdb -p 10574
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html
>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Attaching to process 10574
Reading symbols from /var/lib/pgsql/bin/postgres...done.
Reading symbols from /usr/lib/libxml2.so.2...Reading symbols from
/usr/lib/debug/usr/lib/libxml2.so.2.6.32...done.
done.
Loaded symbols for /usr/lib/libxml2.so.2
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/libm.so.6...done.
Loaded symbols for /lib/libm.so.6
Reading symbols from /lib/libc.so.6...done.
Loaded symbols for /lib/libc.so.6
Reading symbols from /lib/libz.so.1...Reading symbols from
/usr/lib/debug/lib/libz.so.1.2.3.3...done.
done.
Loaded symbols for /lib/libz.so.1
Reading symbols from /lib/ld-linux-x86-64.so.2...done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /lib/libnss_files.so.2...done.
Loaded symbols for /lib/libnss_files.so.2
0x00002ae79777648f in poll () from /lib/libc.so.6
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb) set pagination off
(gdb) set logging file /opt/debuglog.txt
(gdb) set logging on
Copying output to /opt/debuglog.txt.
(gdb) cont
Continuing.

Program received signal SIGQUIT, Quit.
0x00002ae79777648f in poll () from /lib/libc.so.6
(gdb)
Continuing.

Program exited normally.
(gdb)

Thanks,
Bala

On Sat, Nov 27, 2010 at 5:26 AM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au>wrote:

> On 11/27/2010 02:06 AM, Bala Murugan wrote:
>
>>
>> The following bug has been logged online:
>>
>> Bug reference: 5773
>> Logged by: Bala Murugan
>> Email address: b2m(at)a-cti(dot)com
>> PostgreSQL version: 9.0.1
>>
>
> From ubuntu packages? compiled yourself? from 3rd party repository?
>
> Operating system: Ubuntu
>>
>
> Which ubuntu? 10.04? 10.10?
>
> 32-bit x86, 64-bit x64, or other?
>
> Description: DEBUG: reaping dead processes DEBUG: server process
>> (PID 10007) was terminated by signal 11: Segme
>> Details:
>>
>> I am trying to upgrade my postgres version to latest 9.0.1, when I try to
>> restore server process keep on crash exactly after COPY command.
>>
>
> DEBUG: server process (PID 10007) was terminated by signal 11:
>> Segmentation
>> fault
>>
>
> It'd be helpful to be able to get a backtrace of this crash. You may need
> to install debuginfo packages to do that, or (if you compiled it yourself)
> do so with --enable-debug .
>
>
> http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD
>
> Alternately, if you're able to post a compressed copy of the data dump
> somewhere so someone else can test it that'd be handy. I realize you
> probably can't do that, though.
>
> --
> Craig Ringer
>