PostgeSQL problem (server crashed?)
От | Edwin Pauli |
---|---|
Тема | PostgeSQL problem (server crashed?) |
Дата | |
Msg-id | 4053A8AD.5030306@epauli.dyndns.org обсуждение исходный текст |
Ответы |
Re: PostgeSQL problem (server crashed?)
Re: PostgeSQL problem (server crashed?) Re: PostgeSQL problem (server crashed?) |
Список | 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@quicksteps.nl : e.pauli@student.hhs.nl Website : http://www.quicksteps.nl/
В списке pgsql-general по дате отправления: