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

Lists: pgsql-bugs
From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: fakramone58(at)gmail(dot)com
Subject: BUG #16359: Server error message: ERROR: memory exhausted
Date: 2020-04-13 16:00:36
Message-ID: 16359-9c0c605db2c68b61@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16359
Logged by: Fak Ramone
Email address: fakramone58(at)gmail(dot)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


From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: fakramone58(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16359: Server error message: ERROR: memory exhausted
Date: 2020-04-13 16:48:11
Message-ID: 20200413164811.2urj2mrs4udnqp7d@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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(at)gmail(dot)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