delete from ..;vacuum crashes

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема delete from ..;vacuum crashes
Дата
Msg-id 199810020344.MAA17792@srapc451.sra.co.jp
обсуждение исходный текст
Ответы Re: [HACKERS] delete from ..;vacuum crashes
select * from ..;vacuum crashes
Список 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@sra.co.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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Proper cleanup at backend exit
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] SQL92