Re: ERROR: invalid memory alloc request size 18446744073709551613

[Flaris Roland Feller <flaris.feller@xxxxxxxxx>]

Hello Peter,

In this case, It was a COPY for a table to out of the database, but the error occurs with other commands like a SELECT.

Thanks in advance,

Flaris.

Flaris R. Feller

flaris.feller@xxxxxxxxx

http://linkedin.com/in/flarisfeller

Em 22 de jun de 2020, à(s) 12:33, Peter J. Holzer <hjp-pgsql@xxxxxx> escreveu:

On 2020-06-22 11:13:33 -0300, Flaris Feller wrote:

When using Postgres 9.6.15 on "CentOS Linux release 7.5.1804 (Core)" on Intel

x86_64 I noticed "invalid memory alloc request size" error at PostgreSQL logs.

This is the postgresq.log file's fragment of log where the error was found.

2020-06-22 00:29:18 BRT [16987]: [1-1] db=bxs,user=postgres ERRO:  invalid

memory alloc request size 18446744073709551613

That's 2**64 - 3. So probably the size of some object is (erroneously)
computed as -3 bytes.

2020-06-22 00:29:18 BRT [16987]: [2-1] db=bxs,user=postgres COMANDO:  COPY

public.cham_chamada....

Does this always happen in conjunction with a COPY command or sometimes
with other commands, too? If the former, are you copying into the
database or out of it?

       hp

--
  _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@xxxxxx         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"