I think I got, what you look for.
r...@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 < balamuru...@adaptavant.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 <cr...@postnewspapers.com.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 >> > >