psql: FATAL: the database system is in recovery mode

Поиск
Список
Период
Сортировка
От Bhushan Verma
Тема psql: FATAL: the database system is in recovery mode
Дата
Msg-id 50a295ab0908310727xed4b26u45777ee6d220a007@mail.gmail.com
обсуждение исходный текст
Ответы Re: [BUGS] psql: FATAL: the database system is in recovery mode
Список pgsql-novice
Hi All,

  I am trying to run as follows queries
----------
SELECT PageIndex,
       (SUM(ConnectDoneTime - StartTime) * 100) / SUM(EndTime - StartTime) AS "ConnectTimePct",
       (SUM(WriteCompleTime - ConnectDoneTime) * 100) / SUM(EndTime - StartTime) AS "RequestSentTimePct",
       (SUM(FirstByteRcdTime - WriteCompleTime) * 100) / SUM(EndTime - StartTime) AS "FirstByteTimePct",
       (SUM(EndTime - FirstByteRcdTime) * 100) / SUM(EndTime - StartTime) AS "DownloadTimePct"
FROM UrlRecord_$1
WHERE EndTime <> 0
      AND ConnectDoneTime <> 0
      AND WriteCompleTime <> 0
      AND FirstByteRcdTime <> 0
GROUP By PageIndex
ORDER By PageIndex;

-----------
after running this query, I am getting as follows error
-----------
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

connection to server was lost

psql: FATAL:  the database system is in recovery mode
-----------

when I analyze the log file this is showing as follows:

LOG:  database system is ready to accept connections
LOG:  server process (PID 11736) was terminated by signal 11: Segmentation fault
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up at 2009-08-31 19:23:34 IST
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 1/64AF7AE0
LOG:  redo is not required
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started


Is there any limitations or some database configuration problem.
Can anyone please help me in this regards.


Regards


--
With Regards,
Bhushan

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How to update an entire table by getting the values from another table?
Следующее
От: Dante torio
Дата:
Сообщение: postgis/ posgresql trigger