Skip site navigation (1) Skip section navigation (2)

delete from ..;vacuum crashes

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: delete from ..;vacuum crashes
Date: 1998-10-02 03:44:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Here is a report regarding the backend-crash from a user in Japan.
Included shell script should reproduce the phenomenon.
Note that
	select * from getting; vacuum;
does cause a crash, while
	select * from getting;
Tatsuo Ishii



destroydb $DBNAME
createdb $DBNAME
psql -e $DBNAME <<EOF
create table header
	host	text	not null,
	port	int	not null,
	path	text	not null,
	file	text	not null,
	extra	text	not null,
	name	text	not null,
	value	text	not null
create index header_url_idx on header (host, port, path, file, extra);
create unique index header_uniq_idx on header (host, port, path, file, extra, name);

create table reference
	f_url	text	not null,
	t_url	text	not null
create index reference_from_idx on reference (f_url);
create index reference_to_idx on reference (t_url);
create unique index reference_uniq_idx on reference (f_url, t_url);

create table extension
	ext	text	not null,
	note	text
create unique index extension_ext_idx on extension (ext);

create table getting
	host	text	not null,
	port	int	not null,
	ip	text	not null,
	when	datetime	not null
create unique index getting_ip_idx on getting (ip);
#psql -c "delete from getting; vacuum;" $DBNAME
psql -c "select * from getting; vacuum;" $DBNAME
#psql -c "delete from getting;" $DBNAME
#psql -c "select * from getting;" $DBNAME
#psql -c "vacuum;" $DBNAME
#psql -c "vacuum; vacuum;" $DBNAME

pgsql-hackers by date

Next:From: Thomas G. LockhartDate: 1998-10-02 05:00:04
Subject: Re: [HACKERS] pg_dump
Previous:From: Bruce MomjianDate: 1998-10-02 02:25:23
Subject: Re: [HACKERS] Proper cleanup at backend exit

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group