Re: ERROR: invalid memory alloc request size 18446744073709551613

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Flaris Feller <flaris(dot)feller(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: ERROR: invalid memory alloc request size 18446744073709551613
Date: 2020-06-22 14:28:08
Message-ID: D078FFA1-C66B-4B76-9AA1-5E6F404447C0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jun 22, 2020, at 8:13 AM, Flaris Feller <flaris(dot)feller(at)gmail(dot)com> wrote:
>
> Hello all,
>
> 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
> 2020-06-22 00:29:18 BRT [16987]: [2-1] db=bxs,user=postgres COMANDO: COPY public.cham_chamada....
>
> PostgreSQL was installed using official PGDG repository through yum.
> This is the list of postgresql.conf settings used in the cluster.
>
> listen_addresses = '*'
> log_destination = 'stderr'
> logging_collector = on
> log_directory = 'pg_log'
> log_filename = 'postgresql-%a.log'
> log_truncate_on_rotation = on
> log_rotation_age = 1d
> log_rotation_size = 0
> autovacuum = off
> datestyle = 'iso, mdy'
> lc_messages = 'pt_BR'
> lc_monetary = 'pt_BR'
> lc_numeric = 'pt_BR'
> lc_time = 'pt_BR'
> default_text_search_config = 'pg_catalog.portuguese'
> max_connections=150
> shared_buffers=2GB
> effective_cache_size=4GB
> work_mem=13981kB
> maintenance_work_mem=256MB
> log_min_duration_statement = 300000
> log_line_prefix = '%t [%p]: [%l-1] db=%d,user=%u '
> log_lock_waits = on
> timezone='America/Sao_paulo'
> log_timezone = 'Brazil/East'
> min_wal_size = 1GB
> max_wal_size = 2GB
>
> Looking at previous list's messages I've found this could be a data corruption issue and I've followed the recommended procedures.
> But even removing the corrupted records, doing a vacuum full and re-indexing the table the problem keep going recurrently.
> So I would like some guidance to find the root cause of the table corruption on the database.
> Any help would be appreciated.
>
> Thanks in advance,
> Flaris Feller.

I there an application generating this value perhaps?
1111111111111111111111111111111111111111111111111111111111111101
Looks a little like a signed/un-signed mismatch

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2020-06-22 15:33:15 Re: ERROR: invalid memory alloc request size 18446744073709551613
Previous Message Flaris Feller 2020-06-22 14:13:33 ERROR: invalid memory alloc request size 18446744073709551613