| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Memory allocation error |
| Date: | 2023-07-14 07:13:23 |
| Message-ID: | CAFj8pRCr=Qvsys2FKYscjWw5VR7wOYMFsHRoUwLsTZjgRV5yjQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi
pá 14. 7. 2023 v 8:38 odesílatel Shaozhong SHI <shishaozhong(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2023-07-14 07:36:46 | Re: Memory allocation error |
| Previous Message | Shaozhong SHI | 2023-07-14 06:38:34 | Memory allocation error |