Обсуждение: BUG #2489: Metadata dosen't match tables
The following bug has been logged online: Bug reference: 2489 Logged by: James A Cole Email address: jacole@acm.org PostgreSQL version: 7.4.13 Operating system: Red Hat Enterprise Linux 4 Description: Metadata dosen't match tables Details: PostgreSQL 7.4.13 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-2) mkeB_reports=# \d arrivals Did not find any relation named "arrivals". mkeB_reports=# select * from arrivals where ontime>'2006-6-21'; ontime | flightid | airline | runway | upline | downline | acty pe | sta | beacon | icao24 | tail | term | gate | etatype | cetatime ------------------------+----------+---------+--------+--------+----------+- ---- ---+------------------------+--------+----------+----------+----------+----- ---- -+---------+------------------------------- 2006-06-21 00:16:52-04 | ACT301 | ACT | 01L | MDW | MKE | PA31 | | | | | | | 8 | 2006-06-21 00:18:29.538826-04 2006-06-21 01:04:08-04 | USC361 | USC | 01L | MDW | MKE | C208 | | | | | | | 8 | 2006-06-21 01:05:53.170079-04 There are many other databases on this server. Most do not have this problem. Jim Cole
James A Cole wrote: > mkeB_reports=# \d arrivals > Did not find any relation named "arrivals". > > mkeB_reports=# select * from arrivals where ontime>'2006-6-21'; > [data] > There are many other databases on this server. Most > do not have this problem. Ah, so this is the only one that has suffered transaction id wraparound. If you don't want to restore from backup, you may want to search the archives for old threads. Use keywords "transaction id wraparound" or maybe "xid wraparound". Next time you really want to make sure you vacuum the whole database, often. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
"James A Cole" <jacole@acm.org> writes: > mkeB_reports=# \d arrivals > Did not find any relation named "arrivals". > mkeB_reports=# select * from arrivals where ontime>'2006-6-21'; > [ works ] Looks like XID wraparound in the system catalogs. You can probably get out of it with a database-wide VACUUM, but there is some risk that you've lost data. Please read the administrator's guide part of the manual concerning routine vacuuming requirements. regards, tom lane