Urgent... access to table failed!

Поиск
Список
Период
Сортировка
От Wim
Тема Urgent... access to table failed!
Дата
Msg-id 3D187CDF.1060705@belbone.be
обсуждение исходный текст
Ответы Re: Urgent... access to table failed!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello people!

When I try to get data from a table, I get the following message:

FATAL 2:  open of /pgdata/pg_clog/0090 failed: No such file or directory
FATAL 2:  open of /pgdata/pg_clog/0090 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: DEBUG:  server
process (pid 23748) exited with exit code 2
DEBUG:  terminating any other active server processes
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.
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.
!# DEBUG:  all server processes terminated; reinitializing shared memory
and semaphores
DEBUG:  database system was interrupted at 2002-06-25 16:17:45 CEST
DEBUG:  checkpoint record is at 0/36C22998
DEBUG:  redo record is at 0/36C22998; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 1802441; next oid: 1886045
DEBUG:  database system was not properly shut down; automatic recovery
in progress
DEBUG:  ReadRecord: record with zero length at 0/36C229D8
DEBUG:  redo is not required
DEBUG:  database system is ready

How do I solve this problem?

Thanx!

Wim




В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Urgent: Tuning strategies?
Следующее
От: Robert Treat
Дата:
Сообщение: Re: login issue..