pg_repack failure

Nagaraj Raj <[email protected]> Tue, 7 Jan 2020 06:15:09 +0000 (UTC)

Newsgroups	gmane.comp.db.postgresql.devel.general,gmane.comp.db.postgresql.general
Message-ID	<[email protected]>

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