Обсуждение: pg_repack failure

Поиск
Список
Период
Сортировка

pg_repack failure

От
Nagaraj Raj
Дата:
Hello,

When I tried to repack my bloated table an error occurred:

FATAL: terminating connection due to idle-in-transaction timeout
ERROR: query failed: SSL connection has been closed unexpectedly
DETAIL: query was: SAVEPOINT repack_sp1

and this error is occurring in large tables only, and current table size which is running about 700GB

/pg_repack --version
pg_repack 1.4.3

DB version: PostgreSQL 9.6.11 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit




Appreciate the assistance.

Regards,
Nagaraj

Re: pg_repack failure

От
Michael Paquier
Дата:
On Tue, Jan 07, 2020 at 06:15:09AM +0000, Nagaraj Raj wrote:
> and this error is occurring in large tables only, and current table
> size which is running about 700GB
>
> /pg_repack --version
> pg_repack 1.4.3
>
> DB version: PostgreSQL 9.6.11 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit

I think that you had better report that directly to the maintainers of
the tool here:
https://github.com/reorg/pg_repack/
--
Michael
Вложения

Re: pg_repack failure

От
Michael Paquier
Дата:
On Tue, Jan 07, 2020 at 06:15:09AM +0000, Nagaraj Raj wrote:
> and this error is occurring in large tables only, and current table
> size which is running about 700GB
>
> /pg_repack --version
> pg_repack 1.4.3
>
> DB version: PostgreSQL 9.6.11 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit

I think that you had better report that directly to the maintainers of
the tool here:
https://github.com/reorg/pg_repack/
--
Michael