Re: backend crash on DELETE, reproducible locally

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: backend crash on DELETE, reproducible locally
Дата
Msg-id 20181101144257.GD2954@hermes.hilbert.loc
обсуждение исходный текст
Ответы Re: backend crash on DELETE, reproducible locally  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
> I am running this delete statement via psql
> 
>     DELETE FROM ref.auto_hint WHERE title = 'Kontraindikation: ACE/Sartan <-> Schwangerschaft';
> 
> and it crashes the backend it is running on.

For what it is worth I have identified the physical file

    gnumed_v21=# select pg_relation_filepath('ref.auto_hint');
     pg_relation_filepath
    ----------------------
     base/139580/111088
    (1 Zeile)

and phyically copied that to another place (so there's no
read error on the disk - but the DELETE would perhaps ask for
a physical write test ?).

Attached the output of pg_filedump which, to me, doesn't seem
to show anything out of the ordinary either.

Corrupt index should not be the case because the databse is
REINDEXed during the upgrade process before the failing
statement.

Will attempt to get a stack trace ...

Thanks,
Karsten
-- 
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: backend crash on DELETE, reproducible locally
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: backend crash on DELETE, reproducible locally