Re: BUG #1015: Got a signal 11 while trying to create a temp table - Mailing list pgsql-bugs

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, 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)

(gdb) bt
#0  0x0819b684 in LogicalTapeWrite ()
#1  0x0819da13 in ApplySortFunction ()
#2  0x0819cf10 in tuplesort_getdatum ()
#3  0x080ea656 in ExecSort ()
#4  0x080e07ae in ExecProcNode ()
#5  0x080eaf6f in ExecGroup ()
#6  0x080e07ef in ExecProcNode ()
#7  0x080e5302 in ExecAgg ()
#8  0x080e07bb in ExecProcNode ()
#9  0x080df3a5 in ExecutorEnd ()
#10 0x080de8ac in ExecutorRun ()
#11 0x0813c4bd in ProcessQuery ()
#12 0x0813a898 in pg_exec_query_string ()
#13 0x0813b93f in PostgresMain ()
#14 0x0811f37b in ClosePostmasterPorts ()
#15 0x0811ee03 in ClosePostmasterPorts ()
#16 0x0811dc36 in PostmasterMain ()
#17 0x0811d3a6 in PostmasterMain ()
#18 0x080f5113 in main ()
#19 0x42015704 in __libc_start_main () from /lib/tls/libc.so.6
(gdb)


These settings are used:
/proc/sys/kernel/shmmax =3D 500000000
shared_buffers =3D 33000
sort_mem =3D 98304
fsync =3D false

The explain's of both query's:

stats=3D# explain select * from blocks;
                                QUERY PLAN
---------------------------------------------------------------------------
 Seq Scan on blocks  (cost=3D100000000.00..100000020.00 rows=3D1000 width=
=3D130)
(1 row)

stats=3D# explain select hostid, sum(amount) from blocks group by hostid;
                                        QUERY PLAN
----------------------------------------------------------------------------
---------------
 Aggregate  (cost=3D100000069.83..100000077.33 rows=3D100 width=3D8)
   ->  Group  (cost=3D100000069.83..100000074.83 rows=3D1000 width=3D8)
         ->  Sort  (cost=3D100000069.83..100000072.33 rows=3D1000 width=3D8)
               Sort Key: hostid
               ->  Seq Scan on blocks  (cost=3D100000000.00..100000020.00
rows=3D1000 width=3D8)
(5 rows)

stats=3D#

I hope this gives you some more info,

Aarjan

----- Original Message -----=20
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "aarjan langereis" <a.j.langereis@chello.nl>
Cc: <pgsql-bugs@postgresql.org>
Sent: Sunday, December 21, 2003 6:13 PM
Subject: Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp
table


> "aarjan langereis" <a.j.langereis@chello.nl> 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 result in psql)
> > select hostid, sum(amount) from blocks group by hostid; crashed (3,2M
> > records used)
>
> Hm.  What do you have sort_mem set to?  Does the EXPLAIN output show
> different plans for these queries?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>