Re: PostgeSQL problem (server crashed?)

On Sun, 14 Mar 2004 20:53:00 +0100 Edwin Pauli <edwin@epauli.dyndns.org> sat down, thought long and
then wrote:

> Richard Huxton wrote:
> > To follow up to Tom's message, you need to look at two things:
> > 1. What happened at 20:09 (and *something* must have)
>
> The only thing i can see is that at 20.19 (20.09 was a typo, but it
> doesn't matter) all of the query are result in a error. Before 20.19,
> there are no errors from PostgreSQL in /var/log/messages.
>
> Here is the message log (/var/log/messages)
>
> Mar 13 20:18:31 epauli dhcpd: Dynamic and static leases present for
> 192.168.1.4.
> Mar 13 20:18:31 epauli dhcpd: Remove host declaration Dennis or remove
> 192.168.1.4
> Mar 13 20:18:31 epauli dhcpd: from the dynamic address pool for
> 192.168.1.0/24
> Mar 13 20:19:29 epauli postgres[23313]: [1-1] ERROR:  syntax error at
> or near "'d41261f4c273da146b119b225df7849a'" at character 64
> Mar 13 20:19:29 epauli postgres[23313]: [2-1] ERROR:  syntax error at
> or near "hoofdid" at character 8
> Mar 13 20:19:29 epauli postgres[23313]: [3-1] ERROR:  syntax error at
> or near "TO_CHAR" at character 17
> Mar 13 20:19:29 epauli postgres[23313]: [4-1] ERROR:  syntax error at
> or near "TO_CHAR" at character 17
> Mar 13 20:19:29 epauli postgres[23313]: [5-1] ERROR:  syntax error at
> or near "klasse_id" at character 17
>
>  > 2. Does pg_ctl start up the server and can you access it from psql?
>
> No, it doesn't startup
> A big problem is that pg_ctl don't log the error, also when
> de log facility in the postgres conf is enabled.
>
> When i copy a backup from 3 weeks ago to /usr/local/pgsql, the server
> can startup and working correctly.
> Maybe the database is corrupt?

The error messages above have nothing in common with a corrupt database. These are faulty queries. I
recommend to shut down the webserver and (re)start the database engine with statement logging
enabled (not to messages but to a sparate logfile), and afterwards start the webserver again, to
see, what query causes these errors. Did you check your script
home/epauli/WWW/qst-new/_inc/main.inc.php very carefully?

Maybe, if you show us the queries and, if possible, the corresponding table structure, we can find
out more.

Regards, Frank.