pg_repack failure
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.
FATAL: terminating connection due to idle-in-transaction timeout · Issue #222 · reorg/pg_repack
|
|
|
| | |
|
|
|
| |
FATAL: terminating connection due to idle-in-transaction timeout · Issu...
When I tried to repack my bloated table an error occurred: FATAL: terminating connection due to idle-in-transact...
|
|
|
Regards,Nagaraj
Import Notes
Reference msg id not found: 1328678121.7709881.1578377709154.ref@mail.yahoo.com
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.3DB 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