Thread: pg_class could not be found
hi, has any one used Martijn van Oosterhout's PostgreSQL table checker and dumper (pgfsck, at http://svana.org/kleptog/pgsql/pgfsck.html)? i ran this again my database and it gives this error: Couldn't find relation pg_class(1259) does any one know what this is about cheng ===== Best wishes Z C Wang ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html
Sigh. Sorry, that tool really needs some TLC to get it working across all the versions of PostgreSQL I don't have access to. It's looking for pg_class and is assuming it's OID 1259 and trying to open that file. Evidently it's failing. You'd need to indicate the version of the database, maybe strace it to see where it's going wrong. Hope this helps, On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng wang wrote: > hi, > > has any one used Martijn van Oosterhout's PostgreSQL > table checker and dumper (pgfsck, at > http://svana.org/kleptog/pgsql/pgfsck.html)? > > i ran this again my database and it gives this error: > > Couldn't find relation pg_class(1259) > > does any one know what this is about > > cheng > > > ===== > Best wishes > Z C Wang > > > > > > ____________________________________________________________ > Yahoo! Messenger - Communicate instantly..."Ping" > your friends today! Download Messenger Now > http://uk.messenger.yahoo.com/download/index.html > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment
Thanks Martijn if i dump the db (pg_dumpall), the delete the pgsql dir, start a new pgsql dir, the import with template1, this error gone and the db can be checked by your excelent tool. also what is --Table arraytype.. Unknown type thanks --- Martijn van Oosterhout <kleptog@svana.org> wrote: > Sigh. Sorry, that tool really needs some TLC to get > it working across > all the versions of PostgreSQL I don't have access > to. It's looking for > pg_class and is assuming it's OID 1259 and trying to > open that file. > Evidently it's failing. > > You'd need to indicate the version of the database, > maybe strace it to > see where it's going wrong. > > Hope this helps, > > On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng > wang wrote: > > hi, > > > > has any one used Martijn van Oosterhout's > PostgreSQL > > table checker and dumper (pgfsck, at > > http://svana.org/kleptog/pgsql/pgfsck.html)? > > > > i ran this again my database and it gives this > error: > > > > Couldn't find relation pg_class(1259) > > > > does any one know what this is about > > > > cheng > > > > > > ===== > > Best wishes > > Z C Wang > > > > > > > > > > > > > ____________________________________________________________ > > Yahoo! Messenger - Communicate instantly..."Ping" > > your friends today! Download Messenger Now > > http://uk.messenger.yahoo.com/download/index.html > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please > send an appropriate > > subscribe-nomail command to > majordomo@postgresql.org so that your > > message can get through to the mailing list > cleanly > > -- > Martijn van Oosterhout <kleptog@svana.org> > http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% > perspiration. A patent is a > > tool for doing 5% of the work and then sitting > around waiting for someone > > else to do the other 95% so you can sue them. > > ATTACHMENT part 2 application/pgp-signature ===== Best wishes Z C Wang ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html
Martijn van Oosterhout <kleptog@svana.org> writes:
> Sigh. Sorry, that tool really needs some TLC to get it working across
> all the versions of PostgreSQL I don't have access to. It's looking for
> pg_class and is assuming it's OID 1259 and trying to open that file.
> Evidently it's failing.
I don't think it's a version issue; pg_class has always been OID 1259
(and relfilenode 1259, too). You might have version issues once you
started looking inside pg_class, but not before that.
Remember this is the guy whose disk drive seems to have committed major
sins of omission on his last shutdown. I think the file's probably just
plain gone :-(
regards, tom lane
hi, i can see the file 1259 is there and the db apparently working normal and can be started/stopped OK. if your tool cannot work on this set of db, does it mean that the db is problematic? i am realy worried. thanks in advance for advice. cheng --- Martijn van Oosterhout <kleptog@svana.org> wrote: > Sigh. Sorry, that tool really needs some TLC to get > it working across > all the versions of PostgreSQL I don't have access > to. It's looking for > pg_class and is assuming it's OID 1259 and trying to > open that file. > Evidently it's failing. > > You'd need to indicate the version of the database, > maybe strace it to > see where it's going wrong. > > Hope this helps, > > On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng > wang wrote: > > hi, > > > > has any one used Martijn van Oosterhout's > PostgreSQL > > table checker and dumper (pgfsck, at > > http://svana.org/kleptog/pgsql/pgfsck.html)? > > > > i ran this again my database and it gives this > error: > > > > Couldn't find relation pg_class(1259) > > > > does any one know what this is about > > > > cheng > > > > > > ===== > > Best wishes > > Z C Wang > > > > > > > > > > > > > ____________________________________________________________ > > Yahoo! Messenger - Communicate instantly..."Ping" > > your friends today! Download Messenger Now > > http://uk.messenger.yahoo.com/download/index.html > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please > send an appropriate > > subscribe-nomail command to > majordomo@postgresql.org so that your > > message can get through to the mailing list > cleanly > > -- > Martijn van Oosterhout <kleptog@svana.org> > http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% > perspiration. A patent is a > > tool for doing 5% of the work and then sitting > around waiting for someone > > else to do the other 95% so you can sue them. > > ATTACHMENT part 2 application/pgp-signature ===== Best wishes Z C Wang ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html
Maybe, but it doesn't work in some common cases apparently, I just don't have anything setup on my machine to test everything out. I don't even know which version you're running. Like I said, it's needs a lot of TLC. On Sat, Jun 05, 2004 at 06:37:55PM +0100, zhicheng wang wrote: > hi, > i can see the file 1259 is there and the db apparently > working normal and can be started/stopped OK. > > if your tool cannot work on this set of db, does it > mean that the db is problematic? i am realy worried. > > thanks in advance for advice. > > cheng -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment
we are running redhat version 7.3.6-1 for EL AS3. most of our db can be analyised by your tool. bot only one is not. if we dump this one, init a db, then import with template1, things are ok and your tool can be used against this new db. any suggestions? please cheng --- Martijn van Oosterhout <kleptog@svana.org> wrote: > Maybe, but it doesn't work in some common cases > apparently, I just > don't have anything setup on my machine to test > everything out. I don't > even know which version you're running. > > Like I said, it's needs a lot of TLC. > > On Sat, Jun 05, 2004 at 06:37:55PM +0100, zhicheng > wang wrote: > > hi, > > i can see the file 1259 is there and the db > apparently > > working normal and can be started/stopped OK. > > > > if your tool cannot work on this set of db, does > it > > mean that the db is problematic? i am realy > worried. > > > > thanks in advance for advice. > > > > cheng > -- > Martijn van Oosterhout <kleptog@svana.org> > http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% > perspiration. A patent is a > > tool for doing 5% of the work and then sitting > around waiting for someone > > else to do the other 95% so you can sue them. > > ATTACHMENT part 2 application/pgp-signature ===== Best wishes Z C Wang ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html