Re: [GENERAL] simple query terminated by signal 11

2006-06-22 Thread Thomas Chille
Thanks for your Tipps! Since it is repeatable in your machine, you can compile a new postgres version with "--enable-cassert" (enable assertions in code) and "--enable-debug" (enable gcc debug support) configuration. Then run it on your data and "bt" the core dump. I try to found out the reas

Re: [GENERAL] simple query terminated by signal 11

2006-06-20 Thread Qingqing Zhou
""Thomas Chille"" <[EMAIL PROTECTED]> wrote > > I don't know how to post it, because the size is 1,5 MB?! I try to > attch it as gzip. > No ... I mean the "bt" result of the core dump. $gdb -c bt > . > Program terminated with signal 11, Segmentation fault. > #0 0x080753c2 in DataFill () > (

Re: [GENERAL] simple query terminated by signal 11

2006-06-20 Thread Thomas Chille
Hi Qingqing, thanks for your reply! The postgresql version is 8.0.4 and runs on a debian based linux server with kernel 2.6.11.2. I never dealed with a core dump before. but after setting "ulimit -c 1024" i got it. I don't know how to post it, because the size is 1,5 MB?! I try to attch it a

Re: [GENERAL] simple query terminated by signal 11

2006-06-19 Thread Qingqing Zhou
""Thomas Chille"" <[EMAIL PROTECTED]> wrote > Hi List, > > i run in to an error while dumping a db. > > after investigating it, i found a possible corrupted table. but i am not sure. > and i dont know how i can repair it? could it be a harddrive error? > > > # now the error: SELECT * FROM hst_sale