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: 199810020344.MAA17792@srapc451.sra.co.jp (view raw or flat)
Thread:
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;
	vacuum;
not.
--
Tatsuo Ishii
t-ishii(at)sra(dot)co(dot)jp

========================================================================
#!/bin/sh

DBNAME=ptest

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);
EOF
#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-2014 The PostgreSQL Global Development Group