Re: PQgetCopyData() failed - corruption?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: François Beausoleil <francois(at)teksol(dot)info>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: PQgetCopyData() failed - corruption?
Date: 2013-04-18 20:02:53
Message-ID: 9658.1366315373@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= <francois(at)teksol(dot)info> writes:
> I received the following error while backing up my database:

> pg_dump: Dumping the contents of table "summary_show_unique_personas_2012_10_15" failed: PQgetCopyData() failed.
> pg_dump: Error message from server: pg_dump: The command was: COPY public.summary_show_unique_personas_2012_10_15 (market_id, period, show_id, service_id, service_name, gender, followers_count, interactions_count) TO stdout;

Hmm, what libpq version is pg_dump depending on? The lack of any "error
message from server" (which in this case really means "from libpq") is
odd. AFAICS, it is impossible in the current code for PQgetCopyData to
return a failure indication without setting up an appropriate textual
message too --- but it sure looks like it did for you, so I'm wondering
if this is an old version with some bug in the error handling code paths.

> Does that error indicate a database corruption? Or just a network interruption?

I'd guess it's just a lost connection. You could look at the
postmaster's log to see what happened according to that end.
If it logged "unexpected EOF on client connection" or some such, then
it was indeed just a dropped connection.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vitalii Tymchyshyn 2013-04-18 21:17:39 Re: [PERFORM] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
Previous Message Stefan Kaltenbrunner 2013-04-18 19:59:09 Re: What's wrong with postgresql.org domain?