Thread: 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 > "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 >
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
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) > > ----- 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...
Look for the limit in the php.ini file On Wed, 24 Sep 2003, shreedhar wrote: > 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 >