<br><br><div class="gmail_quote">On Mon, Dec 10, 2012 at 3:59 PM, Jan Wieck <span dir="ltr"><<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 12/10/2012 6:26 PM, Tory M Blue wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
On Mon, Dec 10, 2012 at 2:55 PM, Jan Wieck <<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a><br>
<mailto:<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a>>> wrote:<br>
<br>
On 12/10/2012 5:28 PM, Tory M Blue wrote:<br>
<br>
<br>
I'm back to it with debug of 4 on the source and the destination<br>
nodes.<br>
<br>
Still failing<br>
<br>
Destination:<br>
<br>
Slon log:<br>
<br>
2012-12-10 12:04:49 PST CONFIG remoteWorkerThread_1: 6525.754<br>
seconds to<br>
copy table "cls"."listings"<br>
2012-12-10 12:04:49 PST CONFIG remoteWorkerThread_1: copy table<br>
"cls"."customers"<br>
2012-12-10 12:04:49 PST CONFIG remoteWorkerThread_1: Begin COPY<br>
of table<br>
"cls"."customers"<br>
2012-12-10 12:04:49 PST ERROR remoteWorkerThread_1: "select<br>
"_admissioncls".copyFields(8);<u></u>__"<br>
</blockquote>
<br>
This is the bit that I don't understand.<br>
<br>
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.<br>
<br>
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().<br>
<br>
I wonder what PQresStatus(PQresultStatus(<u></u>res3)) as well as PQerrorMessage(pro_dbconn) at this point have to tell.<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thanks for not giving up on me<br>
Tory<br>
</blockquote>
<br>
What version of Slony are you running this on?<br></blockquote><div><br>-bash-4.1$ slon -v<br>slon version 2.1.1<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Can you run a custom patched slon on the new subscriber so that we can see that information in the log?<span class="HOEnZb"><font color="#888888"><br></font></span></blockquote><div><br>Absolutely! <br><br>Thanks!<br>Tory<br>
</div></div>