On 12/10/2014 12:47 PM, Adrian Klaver wrote:
On 12/10/2014 09:25 AM, Gabriel Sánchez Martínez wrote:
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.
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.
So where did the data get dumped from?
An instance of the same version of Postgres or something different?
Which version(s) of pg_dump/pg_restore where used?
Also how did the Postgres server get installed?
apt-get install
Install from what repo?
The default Ubuntu repository.
What was the exact package installed?
I don't recall, but it was probably "postgresql". The database was
upgraded to 9.3 when Ubuntu was upgraded to 14.04. But I ran it for a
while without issues. This issue is recent.
Was there another instance of Postgres already(or currently) installed
on this machine?
No. There has always been only one instance.
Thanks in advance,
Gabriel
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general