On 12/10/2012 6:26 PM, Tory M Blue wrote:
>
>
> On Mon, Dec 10, 2012 at 2:55 PM, Jan Wieck <JanWieck at yahoo.com
> <mailto:JanWieck at yahoo.com>> wrote:
>
>     On 12/10/2012 5:28 PM, Tory M Blue wrote:
>
>
>         I'm back to it with debug of 4 on the source and the destination
>         nodes.
>
>         Still failing
>
>         Destination:
>
>         Slon log:
>
>         2012-12-10 12:04:49 PST CONFIG remoteWorkerThread_1: 6525.754
>         seconds to
>         copy table "cls"."listings"
>         2012-12-10 12:04:49 PST CONFIG remoteWorkerThread_1: copy table
>         "cls"."customers"
>         2012-12-10 12:04:49 PST CONFIG remoteWorkerThread_1: Begin COPY
>         of table
>         "cls"."customers"
>         2012-12-10 12:04:49 PST ERROR  remoteWorkerThread_1: "select
>         "_admissioncls".copyFields(8);__"

This is the bit that I don't understand.

Looking at the remote_worker.c code, this error message comes from line 
3032 in 2.1 STABLE. The same code is in line 2911 in HEAD.

That select of copyFields() has apparently failed, because the result 
status code is not PGRES_TUPLES_OK, yet there seems to be nothing 
returned from PQresultErrorMessage().

I wonder what PQresStatus(PQresultStatus(res3)) as well as 
PQerrorMessage(pro_dbconn) at this point have to tell.


> Thanks for not giving up on me
> Tory

What version of Slony are you running this on?

Can you run a custom patched slon on the new subscriber so that we can 
see that information in the log?


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin