Re: unexpected message type 0x58 during COPY from stdin

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unexpected message type 0x58 during COPY from stdin
Date: 2010-08-25 19:01:46
Message-ID: 23491.1282762906@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

bricklen <bricklen(at)gmail(dot)com> writes:
> I'm getting a strange error during reload of one of our databases.

This appears to indicate that the server's first idea that there was
trouble came when the client side disconnected partway through a COPY:

> 2010-08-25 04:16:46 PDT [2401]: [1-1] (user=postgres) ERROR: unexpected
> message type 0x58 during COPY from stdin

(0x58 = 'X' = Terminate message, implying client called PQfinish)

So it would be useful to look at what pg_restore thinks happened.
I rather suspect your cron setup sends pg_restore's output to
/dev/null ... or at least you failed to show it.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Papathanasiou 2010-08-25 19:05:34 Re: Differences between to_tsquery() and plainto_tsquery() when it comes to applying an index?
Previous Message Selena Deckelmann 2010-08-25 19:01:00 Re: recovery fail