Skip site navigation (1) Skip section navigation (2)

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

From: Balamurugan Mahendran <balamurugan(at)adaptavant(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme
Date: 2010-11-27 11:39:35
Message-ID: AANLkTimXAPNCAPY+zPtMuR8jRDDNc2KbfYWwfaM_F=y4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I think I got, what you look for.


root(at)acti-db-bala:~# sudo -u postgres gdb -q -c /var/lib/pgsql/data/core
/var/lib/pgsql/bin/postgres
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...Reading symbols from
/usr/lib/debug/lib/libdl-2.9.so...done.
done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/libm.so.6...Reading symbols from
/usr/lib/debug/lib/libm-2.9.so...done.
done.
Loaded symbols for /lib/libm.so.6
Reading symbols from /lib/libc.so.6...Reading symbols from
/usr/lib/debug/lib/libc-2.9.so...done.
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...Reading symbols from
/usr/lib/debug/lib/ld-2.9.so...done.
done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /lib/libnss_files.so.2...Reading symbols from
/usr/lib/debug/lib/libnss_files-2.9.so...done.
done.
Loaded symbols for /lib/libnss_files.so.2
Reading symbols from /var/lib/pgsql/lib/uniqueidentifier.so...done.
Loaded symbols for /var/lib/pgsql/lib/uniqueidentifier.so
Reading symbols from /lib/libuuid.so.1...done.
Loaded symbols for /lib/libuuid.so.1
Core was generated by `postgres: postgres acti [local] COPY    '.
Program terminated with signal 11, Segmentation fault.
[New process 32591]
#0  strlen () at ../sysdeps/x86_64/strlen.S:48
48      ../sysdeps/x86_64/strlen.S: Permission denied.
        in ../sysdeps/x86_64/strlen.S
(gdb) bt full
#0  strlen () at ../sysdeps/x86_64/strlen.S:48
No locals.
#1  0x00002b08dae084f2 in uniqueidentifier_in () from
/var/lib/pgsql/lib/uniqueidentifier.so
No locals.
#2  0x00000000006ca2ed in InputFunctionCall ()
No locals.
#3  0x000000000050defe in CopyFrom ()
No locals.
#4  0x0000000000510a4e in DoCopy ()
No locals.
#5  0x0000000000612a56 in standard_ProcessUtility ()
No locals.
#6  0x000000000060e907 in PortalRunUtility ()
No locals.
#7  0x000000000060fa7d in PortalRunMulti ()
No locals.
#8  0x0000000000610222 in PortalRun ()
No locals.
#9  0x000000000060c671 in exec_simple_query ()
No locals.
#10 0x000000000060d8c7 in PostgresMain ()
No locals.
#11 0x00000000005dc6ce in ServerLoop ()
No locals.
#12 0x00000000005dd3ff in PostmasterMain ()
No locals.
#13 0x00000000005810e8 in main ()
No locals.
Current language:  auto; currently asm
(gdb)


Thanks,
Bala


On Sat, Nov 27, 2010 at 4:36 PM, Balamurugan Mahendran <
balamurugan(at)adaptavant(dot)com> wrote:

> I can give you access to my Instance, if you would like to try. you just
> need to give me your IP, so that I can white list to allow access.
>
> Thanks,
> Bala
>
>
> On Sat, Nov 27, 2010 at 4:33 PM, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au
> > wrote:
>
>> On 11/27/2010 06:58 PM, Balamurugan Mahendran wrote:
>>
>>> (gdb) bt
>>> #0  strlen () at ../sysdeps/x86_64/strlen.S:48
>>> #1  0x0000000000000000 in ?? ()
>>> (gdb)
>>> #0  strlen () at ../sysdeps/x86_64/strlen.S:48
>>> #1  0x0000000000000000 in ?? ()
>>>
>>
>> Grr. Corrupt stack. That's pretty much a useless backtrace. Thanks for
>> trying - sometimes a good backtrace is really useful.
>>
>> Is there any chance you can simplify your data down to something you can
>> post? Chop bits out of the schema and COPY data until you find the smallest
>> SQL script that still crashes?
>>
>> --
>> Craig Ringer
>>
>
>

In response to

Responses

pgsql-bugs by date

Next:From: Nikhil SontakkeDate: 2010-11-27 14:21:28
Subject: Favorable i--)
Previous:From: Balamurugan MahendranDate: 2010-11-27 11:06:02
Subject: Re: BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group