Обсуждение: Out of Memory Errors

Поиск
Список
Период
Сортировка

Out of Memory Errors

От
Jeffrey
Дата:
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


Re: Out of Memory Errors

От
Ed Loehr
Дата:
Jeffrey wrote:
>
> Out of memory!

Looks like you might possibly be using Apache?

http://perl.apache.org/guide/troubleshooting.html#Out_of_memory_