From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | hackers(at)postgreSQL(dot)org |
Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Subject: | 6.5 cvs: can't drop table |
Date: | 1999-05-25 09:53:19 |
Message-ID: | Pine.GSO.3.96.SK.990525134044.7396A-200000@ra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
today I did some tests with current 6.5 from cvs and multiple joins.
I did unpredictable server crashes, i.e. sometimes query works
sometimes crashes. After about a hour of my experiments I can't drop table in
my test database:
13:55[mira]:~/app/sql>mkjoindata.pl --joins 10 --rows 20 | psql test
mkjoindata.pl - is my test script specially rewritten to get parameters
from command line. It generates test data, sql commands and automatize
process of postgres crashing :-) I attach this new version to my post.
Regards,
Oleg
PS.
Tom (Lane), sometimes I got an old behaivour of postgres on big joins -
all memory (ram+swap) exhausted. I remember a week ago that was fixed
and I certainly did the same tests without any problem.
drop table t0;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.
Backtrace:
mira:/usr/local/pgsql/data/base/test# gdb /usr/local/pgsql/bin/postmaster core
GDB is free software and you are welcome to distribute copies of it
under certain conditions; type "show copying" to see the conditions.
There is absolutely no warranty for GDB; type "show warranty" for details.
GDB 4.16 (i486-slackware-linux),
Copyright 1996 Free Software Foundation, Inc...
Core was generated by /usr/local/pgsql/bin/postgres localhost megera test DROP
'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libdl.so.1...done.
Reading symbols from /lib/libm.so.5...done.
Reading symbols from /usr/lib/libreadline.so...done.
Reading symbols from /usr/lib/libhistory.so...done.
Reading symbols from /lib/libtermcap.so.2...done.
Reading symbols from /lib/libncurses.so.3.0...done.
Reading symbols from /usr/lib/libc.so.5...done.
Reading symbols from /lib/ld-linux.so.1...done.
#0 0x806aa2b in heapgettup ()
(gdb) bt
#0 0x806aa2b in heapgettup ()
#1 0x806b7d1 in heap_getnext ()
#2 0x807ca56 in DeleteTypeTuple ()
#3 0x807cbb5 in heap_destroy_with_catalog ()
#4 0x8083128 in RemoveRelation ()
#5 0x80e41ef in ProcessUtility ()
#6 0x80e2486 in pg_exec_query_dest ()
#7 0x80e23cc in pg_exec_query ()
#8 0x80e3518 in PostgresMain ()
#9 0x80cc72c in DoBackend ()
#10 0x80cc26b in BackendStartup ()
#11 0x80cb9e7 in ServerLoop ()
#12 0x80cb573 in PostmasterMain ()
#13 0x80a2999 in main ()
#14 0x806131e in _start ()
(gdb)
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
Attachment | Content-Type | Size |
---|---|---|
mkjoindata.pl | text/plain | 3.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 1999-05-25 10:21:22 | Re: [HACKERS] 6.5 cvs: can't drop table |
Previous Message | Jan Wieck | 1999-05-25 09:08:13 | Re: [HACKERS] Partial fix for INSERT...SELECT problems |