Re: Various serverlog messages

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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