Thread: BUG #16359: Server error message: ERROR: memory exhausted

BUG #16359: Server error message: ERROR: memory exhausted

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      16359
Logged by:          Fak Ramone
Email address:      fakramone58@gmail.com
PostgreSQL version: 12.1
Operating system:   Ubuntu Server 18.04
Description:

I need help for this problem
pg_dump: error: Extraction of table content "a_3" failed: PQgetResult ()
failed.
pg_dump: error: Server error message: ERROR: memory exhausted
DETAIL: Unable to enlarge string buffer that already has 1073741822 bytes by
1 additional bytes.
pg_dump: error: The command was: COPY public.a_3

When I use select * from a_3;
give me the data.

What to refer the error


Re: BUG #16359: Server error message: ERROR: memory exhausted

From
Tomas Vondra
Date:
On Mon, Apr 13, 2020 at 04:00:36PM +0000, PG Bug reporting form wrote:
>The following bug has been logged on the website:
>
>Bug reference:      16359
>Logged by:          Fak Ramone
>Email address:      fakramone58@gmail.com
>PostgreSQL version: 12.1
>Operating system:   Ubuntu Server 18.04
>Description:
>
>I need help for this problem
>pg_dump: error: Extraction of table content "a_3" failed: PQgetResult ()
>failed.
>pg_dump: error: Server error message: ERROR: memory exhausted
>DETAIL: Unable to enlarge string buffer that already has 1073741822 bytes by
>1 additional bytes.
>pg_dump: error: The command was: COPY public.a_3
>

There don't seem to be any such error messges in 12.1. Are you sure
you're using this pg_dump version? Or maybe you translated the error
messages to english?

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services