Fatal error: Allowed memory size of 8388608 bytes exhausted
If I try to insert I got the following error as
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 79 bytes)
Where to set that.
Regards,
Sreedhar Bhaskararaju
"shreedhar" <shreedhar@lucidindia.net> writes:
If I try to insert I got the following error as
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 79 bytes)
There is not, and never has been, any error message of that wording in
the PG backend. You must be looking at some client-side failure. But
since you didn't tell us what client-side code you're using, it's hard
to say more than that...
regards, tom lane
I am using PHP4 as client side.
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "shreedhar" <shreedhar@lucidindia.net>
Cc: "Postgre General" <pgsql-general@postgresql.org>; "Postgre Admin"
<pgsql-admin@postgresql.org>
Sent: Wednesday, September 24, 2003 10:44 AM
Subject: Re: [ADMIN] Fatal error: Allowed memory size of 8388608 bytes
exhausted
Show quoted text
"shreedhar" <shreedhar@lucidindia.net> writes:
If I try to insert I got the following error as
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 79 bytes)There is not, and never has been, any error message of that wording in
the PG backend. You must be looking at some client-side failure. But
since you didn't tell us what client-side code you're using, it's hard
to say more than that...regards, tom lane
On Wed, 24 Sep 2003, shreedhar wrote:
I am using PHP4 as client side.
In that case what about this setting in php.ini:
memory_limit = 8M ; Maximum amount of memory a script may consume (8MB)
Show quoted text
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "shreedhar" <shreedhar@lucidindia.net>
Cc: "Postgre General" <pgsql-general@postgresql.org>; "Postgre Admin"
<pgsql-admin@postgresql.org>
Sent: Wednesday, September 24, 2003 10:44 AM
Subject: Re: [ADMIN] Fatal error: Allowed memory size of 8388608 bytes
exhausted"shreedhar" <shreedhar@lucidindia.net> writes:
If I try to insert I got the following error as
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 79 bytes)There is not, and never has been, any error message of that wording in
the PG backend. You must be looking at some client-side failure. But
since you didn't tell us what client-side code you're using, it's hard
to say more than that...
shreedhar wrote:
I am using PHP4 as client side.
[snip]
Subject: Re: [ADMIN] Fatal error: Allowed memory size of 8388608 bytes
exhausted
this is a php appache message. either
A) you have a phpscript that allocates memory in a infinate loop
B) your php script has become so big, or its data has become so big to
exceed the default 8 meg provided by apache
php.ini, or apache php.ini
php_value memory_limit 16M
on apache 2.x I wasn't able to use the M, I had to use 16000000
I usualy try google searchs on error message before I assume they are
one pice of software or another, you are currently using 3 apache, php,
postgresql
--
Arno Karner aka Behind the Muffs
West 7th St., St. Paul aka smell, Minn
http://tnss.com/noise_stink
Nigel J. Andrews wrote:
On Wed, 24 Sep 2003, shreedhar wrote:
I am using PHP4 as client side.
In that case what about this setting in php.ini:
memory_limit = 8M ; Maximum amount of memory a script
may consume (8MB)
But before you change that, you may want to dive into the code that
consumes so much memory. Perhaps you just don't reuse/free enough memory
or have a bug in your code that causes it to loop too often.
But as said, it has nothing to do with postgres and is a pure php error
and you may want to continue your quest on the php mailing lists or
their pretty decent manual.
Regards,
Arjen
Show quoted text
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "shreedhar" <shreedhar@lucidindia.net>
Cc: "Postgre General" <pgsql-general@postgresql.org>;"Postgre Admin"
<pgsql-admin@postgresql.org>
Sent: Wednesday, September 24, 2003 10:44 AM
Subject: Re: [ADMIN] Fatal error: Allowed memory size of8388608 bytes
exhausted
"shreedhar" <shreedhar@lucidindia.net> writes:
If I try to insert I got the following error as
Fatal error: Allowed memory size of 8388608 bytesexhausted (tried
to allocate 79 bytes)
There is not, and never has been, any error message of
that wording
in the PG backend. You must be looking at some
client-side failure.
But since you didn't tell us what client-side code you're using,
it's hard to say more than that...---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Look for the limit in the php.ini file
On Wed, 24 Sep 2003, shreedhar wrote:
Show quoted text
I am using PHP4 as client side.
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "shreedhar" <shreedhar@lucidindia.net>
Cc: "Postgre General" <pgsql-general@postgresql.org>; "Postgre Admin"
<pgsql-admin@postgresql.org>
Sent: Wednesday, September 24, 2003 10:44 AM
Subject: Re: [ADMIN] Fatal error: Allowed memory size of 8388608 bytes
exhausted"shreedhar" <shreedhar@lucidindia.net> writes:
If I try to insert I got the following error as
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 79 bytes)There is not, and never has been, any error message of that wording in
the PG backend. You must be looking at some client-side failure. But
since you didn't tell us what client-side code you're using, it's hard
to say more than that...regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org