Out of Memory Errors

From: Jeffrey <seesej(at)uswest(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Out of Memory Errors
Date: 2000-04-11 23:21:29
Message-ID: B5190189.2C05%seesej@uswest.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All,

I am having a problem with out of memory errors and I am wondering if it is
something going on with the postgres.

I review my error log and find the following.

Out of memory!
[Tue Apr 11 14:54:08 2000] [error] [client 209.208.191.31] Premature end of
script headers: /home/cycle/cgi-bin/bidreq.cgi
DBD::Pg::st execute failed: pqReadData() -- backend closed the channel
unexpectedly.
This probably means the backend terminated abnormally before or while
processing the request.

There are also a few errors like this

1) disconnect(DBI::db=HASH(0x825f738)) invalidates 1 active statement.
Either destroy statement handles or call finish on them before
disconnecting. at /home/cycle/cgi-bin/dealer.cgi line 102, <confHandle>
chunk 128.

2) DBD::Pg::db selectrow_array failed: ERROR: parser: parse error at or
near "null"

I understand the cause of error 1 & 2,
- somewhere one of my scripts does not terminate the statement handle before
exiting
- I must be doing a search on a null variable causing error 2.

Is it possible that these two errors are causing my problem? If I exit a
script with out properly terminating the db handle or statement handle does
that take up resources on postgres, or is it not something to worry about.

Thank you in advance
Jeff Seese

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2000-04-12 00:08:17 Re: foriegn key...
Previous Message The Hermit Hacker 2000-04-11 23:16:34 SearchEngine ...