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@quicksteps.nl
: e.pauli@student.hhs.nl
Website : http://www.quicksteps.nl/