Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-25 Thread Tom Lane
"aarjan langereis" <[EMAIL PROTECTED]> writes: > I've got gdb from the RPM's from redhat 9. Whould that RPM be wrong then? > Or do you mean that I have to recompile the database? You need to recompile Postgres. If you are using an RPM distribution of Postgres, I think you can get the source RPM (

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-25 Thread aarjan langereis
ROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 24, 2003 4:15 PM Subject: Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table > "aarjan langereis" <[EMAIL PROTECTED]> writes: > > I reproduced the crash and got a good core-file (w

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-24 Thread Tom Lane
"aarjan langereis" <[EMAIL PROTECTED]> writes: > I reproduced the crash and got a good core-file (with the symbols, see > below). The only thing is: it's 390Mb :( .. even after gzip it's big: 250Mb. > Would that be a problem for you? (I have the bandwith if you want) No point in sending it to me,

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-24 Thread aarjan langereis
Sorry I made a mistake , the coredump is only 25 Mb :D   Aarjan - Original Message - From: aarjan langereis To: [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 10:49 AM Subject: Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-24 Thread aarjan langereis
Ok, just now I understand that 'ulimit' is a bashbuiltin :P. So I fixed that;)I reproduced the crash and got a good core-file (with the symbols, seebelow). The only thing is: it's 390Mb :( .. even after gzip it's big: 250Mb.Would that be a problem for you? (I have the bandwith if you want)(g

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-21 Thread Tom Lane
"aarjan langereis" <[EMAIL PROTECTED]> writes: > I don't see that "ulimit -c 0".. nowhere in the script. Where do I have to > put the "ulimit -c unlimited"? I'd suggest adding it to the pg_ctl script. > Select * from blocks; gave me the whole table (I didn't look at all records, > but got a resul

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-21 Thread aarjan langereis
1390618 records used) select hostid, sum(amount) from blocks where blockdate::date between '2003-02-01' and '2003-07-01' group by hostid; worked (1202952 records used) To me it seems to be the size of it all... Yours, Aarjan - Original Message ----- From: "Tom Lane&q

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-20 Thread Tom Lane
"aarjan langereis" <[EMAIL PROTECTED]> writes: > How do I get a "debugger backtrace" ? Find the "core" file left by the crashed backend --- it should be in $PGDATA/base/yourdbnumber/core and have a file date equal to the time of the crash. If you don't find one, it's likely that the postmaster wa

Fw: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-20 Thread aarjan langereis
I tried to reply to you but that doesn't work. So I try it through here..   Yours,   Aarjan - Original Message - From: aarjan langereis To: Tom Lane Sent: Saturday, December 20, 2003 3:17 PM Subject: Fw: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-19 Thread aarjan langereis
)stats=#Yours,Aarjan- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]>To: <[EMAIL PROTECTED]>Cc: "PostgreSQL Bugs List" <[EMAIL PROTECTED]>Sent: Friday, December 19, 2003 4:41 AMSubject: Re: [BUGS] BUG #1015: Got a signal 11 while trying to creat

Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-18 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > I tried to create a temp table and got my back-end restarting because of a signal 11. Hmm. Can you get a debugger backtrace from the core dump? > It seems to me, and please correct me if I’m wrong, that there is a limit to the > size that a j

[BUGS] BUG #1015: Got a signal 11 while trying to create a temp table

2003-12-18 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1015 Logged by: Aarjan Langereis Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: RedHat Linux 9 kernel 2.4.20-20.9 Description:Got a signal 11 while trying to create a temp table Det