Thread: pg_dump fails pg_rewrite entry not found
Hello, our database suddenly went broken somehow. We still dont know if it is becouse of hw failure etc., anyway, when I try to make dump using pg_dump or pg_dumpall I have got error message like this: pg_dump: failed sanity check, parent table OID 1001834 of pg_rewrite entry OID 1001837 not found pg_dumpall: pg_dump failed on database "eb3_nz", exiting I have tried to search for such an error and have found a lot of solution suggestions, but nothing worked for me, because I did not found any record in pg_class, or pg_rewrite, etc. referencing to those OIDs 1001834 or 1001837 . The version of postgres is 9.2.2 Please is there any other place, where to look for the error? Thank you in advance, Jakub.
On 03/14/2014 06:56 AM, Jakub Can wrote: > Hello, our database suddenly went broken somehow. We still dont know if > it is becouse of hw failure etc., anyway, when I try to make dump using > pg_dump or pg_dumpall I have got error message like this: > > pg_dump: failed sanity check, parent table OID 1001834 of pg_rewrite > entry OID 1001837 not found > pg_dumpall: pg_dump failed on database "eb3_nz", exiting > > I have tried to search for such an error and have found a lot of > solution suggestions, but nothing worked for me, because I did not found > any record in pg_class, or pg_rewrite, etc. referencing to those OIDs > 1001834 or 1001837 . The version of postgres is 9.2.2 > > Please is there any other place, where to look for the error? So 'select * from pg_rewrite where oid = 1001837' finds nothing? > > Thank you in advance, > Jakub. > > -- Adrian Klaver adrian.klaver@aklaver.com
I am terribly sorry. I was sinked in this for about 2 days and just a few minutes after i posted this a was told by a 3rd person that I am using datbase postgres instead of eb3_nz to searched for pending OID in pg_rewrite. So the common delete from pg_rewrite where oid = 1001837 worked. Thanks a lot. On 03/14/2014 03:11 PM, Adrian Klaver wrote: > On 03/14/2014 06:56 AM, Jakub Can wrote: >> Hello, our database suddenly went broken somehow. We still dont know if >> it is becouse of hw failure etc., anyway, when I try to make dump using >> pg_dump or pg_dumpall I have got error message like this: >> >> pg_dump: failed sanity check, parent table OID 1001834 of pg_rewrite >> entry OID 1001837 not found >> pg_dumpall: pg_dump failed on database "eb3_nz", exiting >> >> I have tried to search for such an error and have found a lot of >> solution suggestions, but nothing worked for me, because I did not found >> any record in pg_class, or pg_rewrite, etc. referencing to those OIDs >> 1001834 or 1001837 . The version of postgres is 9.2.2 >> >> Please is there any other place, where to look for the error? > > So 'select * from pg_rewrite where oid = 1001837' finds nothing? > >> >> Thank you in advance, >> Jakub. >> >> > >