Hi Guys, Here you are:
na...@goldbolt:~$ gdb /usr/local/pgsql/bin/postgres core GNU gdb 6.8-debian ... warning: Can't read pathname for load map: Input/output error. 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/ld-linux-x86-64.so.2...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib/libnss_compat.so.2...done. Loaded symbols for /lib/libnss_compat.so.2 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/libnss_nis.so.2...done. Loaded symbols for /lib/libnss_nis.so.2 Reading symbols from /lib/libnss_files.so.2...done. Loaded symbols for /lib/libnss_files.so.2 Core was generated by `postgres: randir lovehunter 127.0.0.1(33247) SELECT '. Program terminated with signal 11, Segmentation fault. [New process 11764] #0 0x0000000000453415 in slot_deform_tuple () (gdb) (gdb) backtrace #0 0x0000000000453415 in slot_deform_tuple () #1 0x000000000045383a in slot_getattr () #2 0x0000000000550dac in ExecHashGetHashValue () #3 0x0000000000552a98 in ExecHashJoin () #4 0x0000000000543368 in ExecProcNode () #5 0x0000000000552aa6 in ExecHashJoin () #6 0x0000000000543368 in ExecProcNode () #7 0x0000000000552aa6 in ExecHashJoin () #8 0x0000000000543368 in ExecProcNode () #9 0x0000000000557251 in ExecSort () #10 0x0000000000543290 in ExecProcNode () #11 0x0000000000555308 in ExecMergeJoin () #12 0x0000000000543380 in ExecProcNode () #13 0x0000000000557251 in ExecSort () #14 0x0000000000543290 in ExecProcNode () #15 0x0000000000540e92 in standard_ExecutorRun () #16 0x00000000005ecc27 in PortalRunSelect () #17 0x00000000005edfd9 in PortalRun () #18 0x00000000005e93a7 in exec_simple_query () #19 0x00000000005ea977 in PostgresMain () #20 0x00000000005bf2a8 in ServerLoop () #21 0x00000000005c0037 in PostmasterMain () #22 0x0000000000569b48 in main () Current language: auto; currently asm Thanks, Daniel Craig Ringer wrote: > On 10/12/2009 5:12 AM, Daniel Nagy wrote: >> The following bug has been logged online: >> >> Bug reference: 5238 >> Logged by: Daniel Nagy >> Email address: nagy.dan...@telekom.hu >> PostgreSQL version: 8.4.1 >> Operating system: Debian Lenny 5.0.3 x86_64. Kernel: 2.6.31.6-grsec >> Description: frequent signal 11 segfaults >> Details: >> >> I got postgres segfaults several times a day. > > > http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD > > -- > Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
