Home >> pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 43712886 in pg_toast_16418

pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 43712886 in pg_toast_16418     10/19/2012 12:40:44 PM

0 Person had this question Me Too

After

$ pg_dumpall -U postgres -f /tmp/pgall.sql

I see following:

pg_dump: SQL command failed pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 43712886 in pg_toast_16418 pg_dump: The command was: COPY public.page_parts (id, name, filter_id, content, page_id) TO stdout; pg_dumpall: pg_dump failed on database "radiant", exiting

I haven't earlier backups. How can I fix it?

Thanks in advance.

All Replies
  • Magnus Hagander replied on 10/19/2012 12:40:44 PM

    This means that your database is basically corrupt, for some reason.

    What you need to do is try to access the table page_parts piece by piece (one row at a time), to determine which row is corrupt, and then delete the row. The probably easiest way to do this is to do a SELECT * FROM page_parts LIMIT , and do that as a binary search over the rows in the table (start at the middle, cutting each piece in half etc). Once you've identified the row, delete it, and you should be able to dump the rest of the database. Once you have the row you can also identify which individual column it is, of course, if the data is high value.

    Was this helpful?
    Yes
    0
  • 1

Tell me

*
*

Related Threads

  • Message:
    Description: I have a laptop and my adapter/charger could not be used anymore as the cable was cut. So I bought a new adapter but it was slightly different than the original. My original had (Toshiba's original): Input: 100-240V ~ 1 ...
  • Message:
    Description: My Sparc box which is running Solaris 10 stopped working due (I think) to a power outage. Now I can't get it to boot up. I'm not interested in trying to recover the contents of the hard-disk. I just want to make the mac ...
  • Message:
    Description: I just bought a firewall that is very loud. The biggest problem is the two fans in the back (2 x Sunon 40mm fans) running at full speed. The firewall is 1RU with pfSense installed on it.The CPU is a Pentium 4 2.8 GHZ wi ...
  • Message:
    Description: I'm working in an academic lab on a project that has high CPU requirements, and we're thinking about purchasing servers that would help us enhance performance time. The project is written in Python, and we're currently ...
  • Message:
    Description: Background: We have a third party service from which we download files over explicit FTPS. Currently we're having trouble downloading files from our live environment, but not our dev environment. In the live environment ...