Postgres Pro
Downloads
Home   >   mailing lists

pg_repack failure - Mailing list pgsql-hackers

From Nagaraj Raj
Subject pg_repack failure
Date
Msg-id 1328678121.7709881.1578377709154@mail.yahoo.com
Whole thread Raw
Responses Re: pg_repack failure  (Michael Paquier <michael@paquier.xyz>)
Re: pg_repack failure  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: bitmaps and correlation
Next
From: Amit Kapila
Date:
Subject: Re: pgsql: Add basic TAP tests for psql's tab-completion logic.