Adriaan Joubert wrote:
> Something in my pg_proc table got corrupted and when trying to
> vacuum it, vacuum would create thousands of index files in the database
> directory. It would just go into an endless loop and all it seems to do
> is create files. Anybody else seen this before? I've tried everything
> and am now in the process of dumping all the data out table by table and
> rebuilding the database from scratch. Any ideas what I can do to avoid
> this or any idea how this could have happened? I'm running 6.5.2 on
> Digital Unix 4.0F.
OK, I've got the same problem again. I upgraded to 6.5.3 just in case there
was something different, and
it makes no difference. Thousands of pg_proc_prosrc_index..<id> files and
vacuum just seems to be in and endless loop. I really need to get this
pinned down. Any ideas where I could start looking?
In the logs I only get this
NOTICE: --Relation pg_proc--
NOTICE: Pages 30: Changed 0, Reapped 5, Empty 0, New 0; Tup 1074: Vac 25,
Keep/VTL 0/0, Crash 0, UnUsed 2, MinLen 145, MaxLen 3013; Re-using:
Free/Avail. Space 30108/30108; EndEmpty/Avail. Pages 0/5. Elapsed 0/0 sec.
so the relation pg_proc did not even change!
I'd really appreciate any help on this one -- I'm getting an awful lot of
stick for this.
Adriaan