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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-10-02 05:00:04 | Re: [HACKERS] pg_dump |
Previous Message | Bruce Momjian | 1998-10-02 02:25:23 | Re: [HACKERS] Proper cleanup at backend exit |