From: | "Ian Cass" <ian(dot)cass(at)mblox(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | select failure |
Date: | 2002-06-07 13:44:45 |
Message-ID: | 083e01c20e29$7c99fdf0$6602a8c0@salamander |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Ideas where I should look for the answer to this problem & how I should fix
it?
observer=# select host, current_route, count(current_route)
observer-# from messages_200205
observer-# group by host, current_route;
FATAL 2: open of /var/lib/postgres/data/pg_clog/0534 failed: No such file
or directory
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.
--
Ian Cass
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Syjuco | 2002-06-07 14:08:50 | Re: arrays as pgsql function parameters |
Previous Message | Achilleus Mantzios | 2002-06-07 13:33:02 | Re: arrays as pgsql function parameters |