Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-12 Thread Tom Lane
Maksim Likharev [EMAIL PROTECTED] writes: So following modification seems to fixed all PG (7.3/7.3.3)crashes on Solaris ( NON C LOCALE ) Given that the problem is Solaris' tendency to write more data than the specified output buffer length allows, I'd think this is still risking a core dump

Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-12 Thread Maksim Likharev
] [GENERAL] PG crash on simple query, story continues Maksim Likharev [EMAIL PROTECTED] writes: So following modification seems to fixed all PG (7.3/7.3.3)crashes on Solaris ( NON C LOCALE ) Given that the problem is Solaris' tendency to write more data than the specified output buffer length

Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-11 Thread Maksim Likharev
So following modification seems to fixed all PG (7.3/7.3.3)crashes on Solaris ( NON C LOCALE ) selfuncs.c line 2356: I changed: xfrmsize = strlen(val) + 32;/*arbitrary pad value here...*/ to xfrmsize = strxfrm(NULL, val, 0) + 32; so basically instead of wild guess of transformed string size

Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-08 Thread Maksim Likharev
After upgrade on 7.3.3 we have following: signal 11 #0 0x254f38 in pfree () #1 0x1fde44 in convert_to_scalar () #2 0x1faafc in scalarineqsel () #3 0x1fd574 in mergejoinscansel () #4 0x14fec8 in cost_mergejoin () #5 0x16b820 in create_mergejoin_path () #6 0x155048 in sort_inner_and_outer ()

Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-08 Thread Maksim Likharev
Hi, I have very interesting suspicion: See my comments ! convert_string_datum ... !this is my case if (!lc_collate_is_c()) { /* Guess that transformed string is not much bigger than original */ xfrmsize = strlen(val) + 32;/* arbitrary

Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-08 Thread Tom Lane
Maksim Likharev [EMAIL PROTECTED] writes: On failure, strxfrm() returns (size_t)-1. Not according to the Single Unix Specification, Linux, or HP-UX; I don't have any others to check. But anyway, that is not causing your problem, since palloc(0) would complain not dump core. I am on SunOS

Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-08 Thread Maksim Likharev
I would referrer dump that gar.xxg, and put PG on Linux, but this is not up to me. Thanks for the help. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 3:58 PM To: Maksim Likharev Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [GENERAL] PG