Re: invalid memory alloc request size - Mailing list pgsql-general

On 12/10/2014 11:49 AM, Adrian Klaver wrote:
> On 12/10/2014 08:31 AM, Gabriel Sánchez Martínez wrote:
>>
>> On 12/10/2014 11:16 AM, Adrian Klaver wrote:
>>> On 12/10/2014 08:07 AM, Gabriel Sánchez Martínez wrote:
>>>> Hi all,
>>>>
>>>> I am running PostgreSQL 9.3.5 on Ubuntu Server 14.04 64 bit with 64 GB
>>>> of RAM.  When running pg_dump on a specific table, I get the following
>>>> error:
>>>>
>>>> pg_dump: Dumping the contents of table "x_20131111" failed:
>>>> PQgetResult() failed.
>>>> pg_dump: Error message from server: ERROR:  invalid memory alloc
>>>> request
>>>> size 18446744073709551613
>>>> pg_dump: The command was: COPY public.x_20131111 (...) TO stdout;
>>>> pg_dump: [parallel archiver] a worker process died unexpectedly
>>>>
>>>> If I run a COPY TO file from psql I get the same error.
>>>>
>>>> Is this an indication of corrupted data?  What steps should I take?
>>>
>>>
>>> What is the data that is being dumped, for example is there binary
>>> data in there?
>>
>> The data types are bigserial, integer, and character varying.
>>
>>>
>>> What is the table definition?
>>
>> The data is confidential so I have obfuscated the names:
>>
>> CREATE TABLE x
>> (
>>    c01 bigserial NOT NULL,
>>    c02 integer NOT NULL,
>>    c03 integer NOT NULL,
>>    c04 integer NOT NULL,
>>    c05 integer,
>>    c06 integer,
>>    c07 integer,
>>    c08 integer,
>>    c09 integer,
>>    c10 integer,
>>    c11 integer,
>>    c12 integer,
>>    c13 character varying(8),
>>    c14 integer,
>>    c15 integer,
>>    c16 character varying(8),
>>    c17 integer,
>>    c18 character varying(8),
>>    c19 integer,
>>    c20 integer,
>>    c21 integer,
>>    c22 integer,
>>    c23 integer,
>>    c24 integer,
>>    c25 integer,
>>    c26 integer,
>>    c27 integer,
>>    c28 integer,
>>    c29 integer,
>>    c30 integer,
>>    c31 integer,
>>    c32 integer,
>>    c33 integer,
>>    CONSTRAINT "PK_x" PRIMARY KEY (c01)
>> )
>>
>>>
>>> Would it be possible to show the header and some sample data from the
>>> COPY?
>>
>> Here is the first row using SELECT * LIMIT 1:
>>
>> 776696816;12368;47728024;3959;0;256;765;645;309;336;36;102;"";;;"";;"";;-1;0;0;0;0;-1;-1;0;0;5;28;;0;37
>>
>
> How did the database get to this machine?
>
> Was it created from scratch or did it come from somewhere else?

The database was created from a pg_dump backup using pg_restore. The
table has not changed since the backup date, so I could try re-creating
it the same way, but that doesn't solve the mystery.

>
> Also how did the Postgres server get installed?

apt-get install

>
>
>>
>>
>>>
>>>>
>>>> Thanks in advance,
>>>> Gabriel
>>>>
>>>>
>>>
>>>
>>
>
>