PostgeSQL problem (server crashed?)

From: Edwin Pauli <edwin(at)epauli(dot)dyndns(dot)org>
To: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: PostgeSQL problem (server crashed?)
Date: 2004-03-14 00:34:53
Message-ID: 4053A8AD.5030306@epauli.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My PostgreSQL server is not reachable at this moment. It look likes a
crash from the postmaster proces.

Since saturday 13-03-2004 at 20.09 (Dutch Time / UTC+1) the server is
not working correctly. Before 20.09, the server was running perfectly.

I can't query the database. On the Postgres powered websites i see the
folowing errors.

Warning: pg_query(): Query failed: ERROR: syntax error at or near
"'5a55385afe83062516f465d5dbb23e96'" at character 64 . in
/home/epauli/WWW/qst-new/_inc/main.inc.php on line 9

Warning: pg_query(): Query failed: ERROR: syntax error at or near
"hoofdid" at character 8 . in
/home/epauli/WWW/qst-new/_inc/main.inc.php on line 81

Warning: pg_fetch_object(): supplied argument is not a valid
PostgreSQL result resource in
/home/epauli/WWW/qst-new/_inc/main.inc.php on line 89

On all of the pages where PostgreSQL is used, this error occured.
When i see this problem the first time, i've stopped the postmaster
proces directly.
After that, i trying to start the postmaster proces with pg_ctl.
Normaly, this start proces is done in about 1 or 2 seconds, but now
there is a timeout after 60 seconds.

With the -l option, i've tried to log the server output to
/var/log/pgsql, but i see nothing in that file after giving the pg_ctl
command and waiting for 60 seconds.

The permission from /var/log/pgsql is correct (owner:pgsql,
group:pgsql, perm:700)

There is only one message logged. That is in /var/log/messages

Mar 14 00:09:40 epauli postgres[27088]: [1-1] FATAL: the database
system is starting up
Mar 14 00:09:42 epauli postgres[27093]: [1-1] ERROR: syntax error at
or near "d" at character 8
Mar 14 00:09:43 epauli postgres[27097]: [1-1] ERROR: syntax error at
or near "d" at character 8
Mar 14 00:09:44 epauli postgres[27101]: [1-1] ERROR: syntax error at
or near "d" at character 8

This lines are repeated 60 times (1 minute)

The server is running PostgreSQL 7.4.1 on FreeBSD 4.9-RELEASE-p3

Does anybody know what's wrong?

--
E-mail : edwin(at)quicksteps(dot)nl
: e(dot)pauli(at)student(dot)hhs(dot)nl
Website : http://www.quicksteps.nl/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-14 00:52:13 Re: PostgeSQL problem (server crashed?)
Previous Message Eric B.Ridge 2004-03-13 06:27:38 Re: How reliable are the stats collector stats?