| From: | Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_repack failure |
| Date: | 2020-01-07 06:15:09 |
| Message-ID: | 1328678121.7709881.1578377709154@mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-01-07 06:46:12 | Re: pg_repack failure |
| Previous Message | Justin | 2020-01-07 02:28:08 | Re: UPDATE many records |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2020-01-07 06:18:10 | Re: pgsql: Add basic TAP tests for psql's tab-completion logic. |
| Previous Message | Justin Pryzby | 2020-01-07 05:26:06 | Re: bitmaps and correlation |