From: | Maris Jansons <maris(at)lailio(dot)net> |
---|---|
To: | Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 |
Date: | 2017-01-26 09:44:21 |
Message-ID: | 1735117324.25930609.1485423861541.JavaMail.zimbra@lailio.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have identified the problematic column, in my case it is api_response, my version of script:
DO $f$
DECLARE
baddata TEXT;
badid INT;
BEGIN
FOR badid IN SELECT id FROM api_logs LOOP
BEGIN
SELECT api_response
INTO baddata
FROM api_logs where id = badid;
EXCEPTION
WHEN OTHERS THEN
RAISE NOTICE 'Data for ID % is corrupt', badid;
CONTINUE;
END;
END LOOP;
END;
$f$
However this script finishes without errors, but if I run simple
> select api_response from api_logs;
I get:
ERROR: missing chunk number 0 for toast value 413511 in pg_toast_25477
Maybe I have messed something up in the script?
Best Regards,
Maris
From: "Jorge Torralba" <jorge(dot)torralba(at)gmail(dot)com>
To: "Maris Jansons" <maris(at)lailio(dot)net>
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Sent: Wednesday, January 25, 2017 11:52:08 PM
Subject: Re: [ADMIN] Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477
I have run this with success several times. I modified it to be intuitive. There may be a typo or two but have a look at this:
DO $f$
DECLARE
baddata TEXT;
badid INT;
BEGIN
FOR badid IN SELECT id FROM badtable LOOP
BEGIN
SELECT badcolumn
INTO columndata
FROM badtable where id = badid;
EXCEPTION
WHEN OTHERS THEN
RAISE NOTICE 'Data for ID % is corrupt', badid;
CONTINUE;
END;
END LOOP;
END;
$f$
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-01-26 16:03:03 | Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 |
Previous Message | Jorge Torralba | 2017-01-25 21:52:08 | Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 |