Thread: Fatal error: Allowed memory size of 8388608 bytes exhausted

Fatal error: Allowed memory size of 8388608 bytes exhausted

From
"shreedhar"
Date:
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


Re: Fatal error: Allowed memory size of 8388608 bytes exhausted

From
Tom Lane
Date:
"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

Re: Fatal error: Allowed memory size of 8388608 bytes exhausted

From
"shreedhar"
Date:
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
>


Re: Fatal error: Allowed memory size of 8388608 bytes exhausted

From
maillist
Date:
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

Re: [GENERAL] Fatal error: Allowed memory size of 8388608

From
"Nigel J. Andrews"
Date:
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...


Re: [GENERAL] Fatal error: Allowed memory size of 8388608

From
"scott.marlowe"
Date:
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
>