Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Date: 2017-06-12 12:56:26
Message-ID: 51e3c18c-ecc3-e98f-6a88-7574c38b5e11@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/06/2017 10:46, Harry Ambrose wrote:
> Hi,
>
> > Their suggestion is to upload to Google Drive. That or use a third party site, like Dropbox.
>
> I have uploaded the jar to dropbox, link below (please let me know if you have any issues downloading):
>
> https://www.dropbox.com/s/96vm465i7rwhcf8/toast-corrupter-aio.jar?dl=0
>
After 2 full attempts, (and after bringing my poor - old workstation to its knees) it still does not produce the supposed ERROR :
........
update 160000
update 180000
Updated all
Attempting vacuum
Vacuum completed
Dropping the table
=========================================
New attempt - number 3
Creating the table if it does not exist
Inserting the rows
Executing 0
Executing 40000
^C

PostgreSQL version : 9.3.4

> Best wishes,
> Harry

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harry Ambrose 2017-06-12 12:57:05 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Previous Message Alex Kliukin 2017-06-12 12:25:44 Re: Why restore_command is called for existing files in pg_xlog?