| 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: | Whole Thread | Raw Message | 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 |