pg_class could not be found

Started by zhicheng wangalmost 22 years ago7 messagesgeneral

wang_zc@yahoo.co.uk

almost 22 years ago

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

Martijn van Oosterhout

kleptog@svana.org

almost 22 years ago

In reply to: zhicheng wang (#1)

Re: pg_class could not be found

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/

Show quoted text

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.

zhicheng wang

wang_zc@yahoo.co.uk

almost 22 years ago

In reply to: Martijn van Oosterhout (#2)

Re: pg_class could not be found

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

Tom Lane

tgl@sss.pgh.pa.us

almost 22 years ago

In reply to: Martijn van Oosterhout (#2)

Re: pg_class could not be found

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

zhicheng wang

wang_zc@yahoo.co.uk

almost 22 years ago

In reply to: Martijn van Oosterhout (#2)

Re: pg_class could not be found

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

Martijn van Oosterhout

kleptog@svana.org

almost 22 years ago

In reply to: zhicheng wang (#5)

Re: pg_class could not be found

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/

Show quoted text

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.

zhicheng wang

wang_zc@yahoo.co.uk

almost 22 years ago

In reply to: Martijn van Oosterhout (#6)

Re: pg_class could not be found

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