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/
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? |