From: | ruben <ruben20(at)superguai(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | open of /usr/lib/pgsql/data/pg_clog/0F3E failed |
Date: | 2004-07-27 07:08:04 |
Message-ID: | 4105FF54.1080600@superguai.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
I'm running a large database on PostgreSQL 7.1.3. 20 days ago the
database failed with a threatening and not too descriptive error like:
pg_exec() query failed: server closed the connection unexpectedlyThis
probably means the server terminated abnormally before or while
processing the request.
I lost some data and had to recreate a table, without knowing the reason
for the error, now I got this error:
FATAL 2: open of /usr/lib/pgsql/data/pg_clog/0F3E failed: No existe el
fichero o el directorio
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
When I VACUUM the affected table I get:
FATAL 2: open of /usr/lib/pgsql/data/pg_clog/0F5C failed: No existe el
fichero o el directorio
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: NOTICE:
Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
Failed.
I guess I have lost again some data in one table.
Someone can help with the origin of these errors? How can I avoid them?
Thanks in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | John Sidney-Woollett | 2004-07-27 07:35:11 | Data model for Postfix v2 |
Previous Message | Pierre-Frédéric Caillaud | 2004-07-27 06:52:20 | Sequences & rules |