MIME-Version: 1.0
References: 
 <CA+i5JwYtVS9z2E71PcNKAVPbOn4R2wuj-LqbJsYr_XOz73q7dQ@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwYtVS9z2E71PcNKAVPbOn4R2wuj-LqbJsYr_XOz73q7dQ@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Fri, 14 Jul 2023 09:13:23 +0200
Message-ID: 
 <CAFj8pRCr=Qvsys2FKYscjWw5VR7wOYMFsHRoUwLsTZjgRV5yjQ@mail.gmail.com>
Subject: Re: Memory allocation error
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005f4f6f06006d316c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFj8pRCr%3DQvsys2FKYscjWw5VR7wOYMFsHRoUwLsTZjgRV5yjQ%40mail.gmail.com>
Precedence: bulk

--0000000000005f4f6f06006d316c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

p=C3=A1 14. 7. 2023 v 8:38 odes=C3=ADlatel Shaozhong SHI <shishaozhong@gmai=
l.com>
napsal:

> A function is being called in a loop.  Sometime, there is an error.
>
> sqlstate: XX000
> NOTICE:  message: invalid memory alloc request size 1073741824
>
> What to do to resolve the issue?
>

It depends what you do. Postgres doesn't allow to allocate bigger blocks
than 1GB. Maybe you create too big string or too big value of some other
type. But it can be signal of some cache bloating.

Can you show source code? Can you use gdb, attach to Postgres, place
breakpoint to this error message, and when you get this error, send stack
trace?

Regards

Pavel


>
> Regards,
>
> David
>

--0000000000005f4f6f06006d316c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi<br></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">p=C3=A1 14. 7. 2023 v=C2=A08:38 odes=C3=ADlat=
el Shaozhong SHI &lt;<a href=3D"mailto:shishaozhong@gmail.com">shishaozhong=
@gmail.com</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">A function is being called in =
a loop.=C2=A0 Sometime, there is an error.<div><br></div><div><div>sqlstate=
: XX000</div><div>NOTICE:=C2=A0 message: invalid memory alloc request size =
1073741824</div></div><div><br></div><div>What to do to resolve the issue?<=
/div></div></div></blockquote><div><br></div>It depends what you do. Postgr=
es doesn&#39;t allow to allocate bigger blocks than 1GB. Maybe you create t=
oo big string or too big value of some other type. But it can be signal of =
some cache bloating. <br></div><div class=3D"gmail_quote"><br></div><div cl=
ass=3D"gmail_quote">Can you show source code? Can you use gdb, attach to Po=
stgres, place breakpoint to this error message, and when you get this error=
, send stack trace?</div><div class=3D"gmail_quote"><br></div><div class=3D=
"gmail_quote">Regards</div><div class=3D"gmail_quote"><br></div><div class=
=3D"gmail_quote">Pavel<br></div><div class=3D"gmail_quote"><br></div><div c=
lass=3D"gmail_quote">=C2=A0<br><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><div>Regards,</div><=
div><br></div><div>David</div></div></div>
</blockquote></div></div>

--0000000000005f4f6f06006d316c--