> Hmm, all the crashes you show us below sound like resource exhaustion
> issues. That's a nice way to say your feeding silly SQL to the server,
> and it's _trying_ to do what you ask... How are you driving the server?
> psql? some sort of CGI? We need more info to help you debug what's
> happening.
The server is being queried mainly from Perl CGI scripts (just plain
perl, not mod_perl or FastCGI, etc...)
> In particular, the 'parser: parse error' problems are exactly that:
> the parser was handed something that it can't grok. Admitedly, the error
> message is not particularly useful, bug that's being worked on. It would
> help if you turned on some debugging, so you could see what the backend
> is trying to do when it crashes. I find -d3 useful for this sort of
> thing; warning though: it _will_ generate large log files.
The -d3 helped and as such I was able to get rid of those parse errors.
thanks!
> What do you mean by a crash, btw? a backend dies, or the postmaster dies,
> or the kernel goes down?
When I say crash, I mean the postmaster dies - no process is left, no
dust, no bones.. ;) The linux box itself seems to be OK.
> > ERROR: parser: parse error at or near ""
> > ERROR: parser: parse error at or near ""
> > FATAL 1: ReleaseLruFile: No opened files - no one can be closed
>
> Looks like a resource leak on the parser error path , specifically
> file handles.
I believe this may be caused by severe server load (because qmail
complains sometimes "Too many open files in system").
> Hmm, what do you mean by high load? Do you really have 128 simultanious
> backends running?
Well, I would sometimes get the error 'Sorry, too many clients running',
so I increased the backends to 128.
> These last few sound like you've damaged your DB installation, perhaps
> from the resource exhaustion problem from earlier.
The DB seems to be OK though, absolutely no problems AFTER i manage to
get Postgres up and running again.
Alas, I need a more powerful machine, but in the meantime if there are
any other tips you guys can give me, I'd greatly appreciate it!
--
Garry Dolley
Webmaster/Technical Contact
LinuxStart.Com
