Re: BUG #15723: Export fails 'worker process died unexpectedly' but no error in pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15723: Export fails 'worker process died unexpectedly' but no error in pg_dump
Дата
Msg-id 21913.1553868884@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15723: Export fails 'worker process died unexpectedly' but no error in pg_dump  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Bug reference:      15723
> Logged by:          Anna Muravieva
> Email address:      ana-mur21s@yandex.ru
> PostgreSQL version: 9.6.1
> Operating system:   linux
> Description:        

> Hello

> We have currently that issue. "worker process died unexpectedly" was caused
> by the lock on the table, which was generated because of the truncate we
> use. This seems to cause the Postgres pg_dump worker process to exit
> abnormally. Why this is not an Error or Warning in Postgres or pg_dump, What
> we see is that pg_dump exits at this point and has not exported part of the
> database. Again this feels like a Bug with Postgres or pg_dump. Could you
> please help to understand

9.6.1 is pretty old, and since then we've fixed a number of bugs in
pg_dump and/or pg_restore that could cause problems in parallel restores.
Please update to current (9.6.12) and see if the problem still occurs.

If it is still there, you'd need to provide more details, like what SQL
command fails exactly.

            regards, tom lane



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #15724: Can't create foreign table as partition
Следующее
От: Stepan Yankevych
Дата:
Сообщение: Re[2]: BUG #15724: Can't create foreign table as partition