Re: Various serverlog messages - Mailing list 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