Beta2 Vacuum and pg_dump failures and mangled databases

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Beta2 Vacuum and pg_dump failures and mangled databases
Date: 2001-01-12 17:05:09
Message-ID: 3A5F3945.DC213B19@joerdens.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

First I tried to dump out a database like:

frank(at)limedes:~ > pg_dump mpi > dump.mpi
getTables(): relation 'institute': 6 Triggers were expected, but got 0

The database mpi does contain a table 'institute' and a few foreign key constraints. Then
I tried to dump another database, as in:

postgres(at)limedes:~ > pg_dump intranet > dumptest
getTables(): relation 'institute': 6 Triggers were expected, but got 0

The database intranet has _no_ table 'institute' and no foreign key constraints.

Then I had a look via psql at intranet and it turns out that it shows up as the database
mpi mangled into the database intranet, contentwise; i.e. it doesn't only show the tables
that are in intranet but also those that belong to mpi?! Then I look at _any_ of the
databases in this Postgres installation, they show up as mangled together with mpi?! When
I try to vacuum any of those databases, I always get:

[ . . . stuff that looks normal . . . ]
Index pg_class_oid_index: Pages 2; Tuples 138: Deleted 45. CPU 0.00s/0.00u sec.
NOTICE: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (138) IS NOT THE SAME AS HEAP'
(205).
Recreate the index.
NOTICE: Index pg_class_relname_index: Pages 4; Tuples 138: Deleted 44. CPU 0.00s/0.00u
sec.
NOTICE: Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (138) IS NOT THE SAME AS
HEAP' (205).
Recreate the index.
ERROR: Cannot insert a duplicate key into unique index pg_class_relname_index

However, if I use another client, i.e. not psql, but a web app, then I do still have
access to the contents of, for instance, the intranet database.

Restarting the server didn't make a difference.

Does this make any sense to anyone?

Regards, Frank

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2001-01-12 17:11:27 Re: Bruce Momjian's interview in LWN.
Previous Message The Hermit Hacker 2001-01-12 16:57:29 Re: Beta4 for GiST? (Was: Re: AW: Re: GiST for 7.1 !! )