Re: [BUGS] BUG #5238: frequent signal 11 segfaults

2009-12-12 Thread Tom Lane
Nagy Daniel writes: > Here's a better backtrace: The crash location suggests a problem with a corrupted tuple, but it's impossible to guess where the tuple came from. In particular I can't guess whether this reflects on-disk data corruption or some internal bug. Now that you have (some of) the

Re: [BUGS] BUG #5238: frequent signal 11 segfaults

2009-12-12 Thread Nagy Daniel
(gdb) p debug_query_string $1 = 12099472 Now I recompiled pg with --enable-debug and waiting for a new core dump. I'll post the backtrace and the debug_query_string output ASAP. Please let me know if there is anything more I can do. Thanks, Daniel Tom Lane wrote: > Nagy Daniel writes: >> (g

Re: [BUGS] BUG #5238: frequent signal 11 segfaults

2009-12-12 Thread Nagy Daniel
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

Re: [BUGS] BUG #5238: frequent signal 11 segfaults

2009-12-12 Thread Tom Lane
Nagy Daniel writes: > (gdb) p debug_query_string > $1 = 12099472 Huh, your stripped build is being quite unhelpful :-(. I think "p (char *) debug_query_string" would have produced something useful. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postg

Re: [BUGS] BUG #5237: strange int->bit and bit->int conversions

2009-12-12 Thread Tom Lane
Robert Haas writes: >> I'm not sure this fixes it, although I haven't tested.  When we take >> the /* store first fractional byte */ branch, destbitsleft is between >> 1 and 7 bits greater than srcbitsleft.  We then subtract 8 from >> destbitsleft, and the comment on the next line now asserts that

Re: [BUGS] BUG #5237: strange int->bit and bit->int conversions

2009-12-12 Thread Robert Haas
Woops, forgot to copy the list. On Sat, Dec 12, 2009 at 2:15 PM, Robert Haas wrote: > On Sat, Dec 12, 2009 at 2:00 PM, Tom Lane wrote: >> Roman Kononov writes: >>> The bitfromint8() and bitfromint4() are hosed. They produce wrong >>> results when the BIT size is more than 64 and 32 respectively

Re: [BUGS] BUG #5237: strange int->bit and bit->int conversions

2009-12-12 Thread Tom Lane
Roman Kononov writes: > The bitfromint8() and bitfromint4() are hosed. They produce wrong > results when the BIT size is more than 64 and 32 respectively, and the > BIT size is not multiple of 8, and the most significant byte of the > integer value is not 0x00 or 0xff. Hm, you're right, it's d

Re: [BUGS] BUG #5237: strange int->bit and bit->int conversions

2009-12-12 Thread Roman Kononov
The bitfromint8() and bitfromint4() are hosed. They produce wrong results when the BIT size is more than 64 and 32 respectively, and the BIT size is not multiple of 8, and the most significant byte of the integer value is not 0x00 or 0xff. For example: test=# select (11::int4<<23 | 11::int4):

Re: [BUGS] BUG #5238: frequent signal 11 segfaults

2009-12-12 Thread Tom Lane
Nagy Daniel writes: > (gdb) backtrace > #0 0x00453415 in slot_deform_tuple () > #1 0x0045383a in slot_getattr () > #2 0x00550dac in ExecHashGetHashValue () > #3 0x00552a98 in ExecHashJoin () > #4 0x00543368 in ExecProcNode () > #5 0x00552aa6 in