[BUGS] BUG #14516: misleading error from libpq on out-of-memory - Mailing list pgsql-bugs

From andrew@tao11.riddles.org.uk
Subject [BUGS] BUG #14516: misleading error from libpq on out-of-memory
Date
Msg-id 20170126050259.1434.30111@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14516: misleading error from libpq on out-of-memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14516
Logged by:          Andrew Gierth
Email address:      andrew@tao11.riddles.org.uk
PostgreSQL version: 9.4.8
Operating system:   any
Description:

This came up on IRC:

Running psql with a restricted memory ulimit to reproduce, one gets this
error message:

postgres=# \copy (select repeat('a',120000000)) to '/dev/null'
lost synchronization with server: got message type "d", length 120000001

Googling this finds some old bugs, but in the reported case, none of those
applied and the only problem was an actual lack of memory; the database
contained a large (60MB) bytea value, and pg_dump would fail with the "lost
synchronization" error.

So the failure is expected, but the fact that the error message doesn't even
hint at "out of memory" being the cause is a problem.


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14515: tsquery with only a negative term doesn't match empty tsvector
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14516: misleading error from libpq on out-of-memory