Re: [GENERAL] invalid memory alloc request size

[Gabriel Sánchez Martínez]

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










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