Re: Various serverlog messages
От | CSN |
---|---|
Тема | Re: Various serverlog messages |
Дата | |
Msg-id | 20030704043649.49413.qmail@web40613.mail.yahoo.com обсуждение исходный текст |
Ответ на | Re: Various serverlog messages (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Various serverlog messages
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-general |
--- Tom Lane <tgl@sss.pgh.pa.us> wrote: > > ERROR: _mdfd_getrelnfd: cannot open relation > > pg_toast_16384_index: No such file or directory > > This is definitely not routine. Assuming you're > running 7.3, > this seems to indicate that you've lost the toast > index for > pg_attrdef. Which would be a bad thing, although we > can hope > that maybe you didn't have any default expressions > long enough > to need to be toasted. > > Could we see the output of > select oid,* from pg_class where relname = > 'pg_toast_16384_index'; > (you should repeat this in each of your databases to > make sure > they all give the same answers). > > Are you able to do a pg_dump? Yes, pg_dump and pg_dumpall appear to work fine. The output for all of the dbs (except one) for the select above is: oid | relname | relnamespace | reltype | relowner | relam | relfilenode | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules | relhassubclass | relacl -------+----------------------+--------------+---------+----------+-------+-------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+-------- 16656 | pg_toast_16384_index | 99 | 0 | 1 | 403 | 16656 | 1 | 0 | 0 | 0 | f | f | i | 2 | 0 | 0 | 0 | 0 | 0 | f | f | f | f | (1 row) Here's the exception: oid | relname | relnamespace | reltype | relowner | relam | relfilenode | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules | relhassubclass | relacl -------+----------------------+--------------+---------+----------+-------+-------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+-------- 16656 | pg_toast_16384_index | 99 | 0 | 1 | 403 | 3682590432 | 1 | 0 | 0 | 0 | f | f | i | 2 | 0 | 0 | 0 | 0 | 0 | f | f | f | f | (1 row) The 3682590432 value. BTW, what is toast (for big fields?) and (toasted) default expressions? TIA, CSN __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
В списке pgsql-general по дате отправления: