6.5 cvs: can't drop table

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

Responses

Browse pgsql-hackers by date

  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