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

Bhushan Verma wrote:
> 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
> ...
> Is there any limitations or some database configuration problem.
> Can anyone please help me in this regards.

A segmentation fault is certainly not normal, but it's hard to tell if
it's caused by a bug, misconfigured or buggy 3rd party modules, or
faulty hardware without some more information. Like:

- What version of PostgreSQL you are using?
- What does "UrlRecord_$1" table look like?
- What is your operating system?

A backtrace would help a lot to pinpoint the problem. Please run "ulimit
-c unlimited" or similar to enable core dumps, and then do:

gdb <path to postgres binary>/postgres $PGDATA/core
> bt

and post the output.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com