473,692 Members | 3,013 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ERROR: fixrdesc: no pg_class entry for pg_class


yes i know, this question has already been asked and i found it in the
archives, but i didnt find an answer for this problem, so maybe one of
you can help me?

My PostgreSQL Database has been up and running exactly for one year, but
last week after rebooting the error message "fixrdesc: no pg_class entry
for pg_class" appeared on the screen. So is there any way to solve this
problem or to recover the data at least?

Info: PGSQL 7.2 on Midori Linux, booting from CF with database data
stored on the harddisk.

Thx in advance

Thomas Bamesberger <ba***@bms-austria.com>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #1
1 2032
Thomas Bamesberger <ba***@bms-austria.com> writes:
My PostgreSQL Database has been up and running exactly for one year, but
last week after rebooting the error message "fixrdesc: no pg_class entry
for pg_class" appeared on the screen. So is there any way to solve this
problem or to recover the data at least?

Ouch. You have a problem :-(

Are you seeing this failure when you connect to any database in the
cluster, or just one? If the former, I'd guess that you've been
ignoring messages about needing a cluster-wide VACUUM for a little too
long, and you're now hosed due to transaction wraparound. If the
latter, it's probably localized data corruption in that database's
system catalog. Which is not necessarily any better news, but there
are a couple of desperation measures you can try:

1. Remove the "pg_internal.in it" file in the broken database, then see
if you can start a backend.

2. Try to start a standalone backend and reindex the system catalogs.
(See the REINDEX man page for details on this rather arcane procedure.)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Nov 11 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Andrei Ivanov | last post by:
This happend again, but now, postgresql tells me where it happens: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: did not find '}' at end of input node pg_dump: The command was: select (select usename from pg_user where usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath from pg_database where datname = 'dc' pg_dumpall: pg_dump failed on database "dc", exiting
by: Kragen Sitaker | last post by:
ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index We've been getting this error in our application every once in a while --- typically once an hour to once a day, although it varies over time. The daemon that gets the error exits and restarts a few seconds later. Usually it's fine then, but sometimes the error happens three or more times in a row. Occasionally, instead, we get "ERROR: Cannot insert a...
by: Dave Smith | last post by:
I am running 7.2 and when doing a vacuum I am getting the following error.... ERROR: Cannot insert a duplicate key into unique index pg_statistic_relid_att_index Where do I start to fix this? --
by: muteki muteki | last post by:
Hi, I am currently having the corrupted tables issues described in the following link (possibly caused by power failure, which happens pretty often) http://archives.postgresql.org/pgsql-admin/2003-04/msg00012.php. Since we have our systems being deployed to numerous remote systems (psql 7.2.3), upgrading the entire database (with data migration) will be the least preferable solution. I am thinking of creating a script that
by: Sally Sally | last post by:
Very strange things are happening when I am reindexing a table. I did this with postmaster running as a standalone. The index for the table prior to reindexing is on a separate disk and I created a sym link (due to lack of space). When the reindexing is done I see new files created under /data/base/dbnumber/ but when I look at pg_class table it is pointing still to the old index because the oid I get is the older one. What does this mean?...
by: zhicheng wang | last post by:
hi, has any one used Martijn van Oosterhout's PostgreSQL table checker and dumper (pgfsck, at http://svana.org/kleptog/pgsql/pgfsck.html)? i ran this again my database and it gives this error: Couldn't find relation pg_class(1259)
by: borajetta | last post by:
ERROR: duplicate key violates unique constraint "pg_class_oid_index" I found a post earlier but wanted to post up my info as the other persons did not look like the same type of error: I tried to cluster the isbn_table cluster isbn_index_code on isbn_table; ERROR: duplicate key violates unique constraint "pg_class_oid_index" The table looks like this
by: Ed L. | last post by:
While dealing with filesystem bloat issues, I found a large file named 43710738, recently updated and sitting in one of my database directories, $ ls -lh ../../../data/base/11259315/43710738 -rw------- 1 dba dba 1016M Nov 3 17:05 ../../../data/base/11259315/43710738 .... with no corresponding entry that I can find in pg_class with that oid (I thought they were all in there). I tried dumping the database, knowing the...
by: frbn | last post by:
hi all, we currently experience an original problem on a production server with a postgresql 7.1.3 ( a bit old, I know :\ ) We just want to know if somebody experienced this problem: the error message : "ERROR: Unable to locate type oid 0 in catalog"
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.