Re: invalid memory alloc request size

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?

Also how did the Postgres server get installed?


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


--
Adrian Klaver
adrian.klaver@aklaver.com