<br><div class="gmail_extra">Well this is frustrating. So I was successful in replicating a smaller data set without issue. Once I try to replicate large amounts of data , it seems to fail and restart, at what it feels the end of the biggest table of each set.<br>
<br>2012-11-29 19:54:06 PST CONFIG remoteWorkerThread_1: 16341.883 seconds to copy table "tracking"."spotimpressions"<br>2012-11-29 19:54:06 PST CONFIG remoteWorkerThread_1: copy table "tracking"."impressions"<br>
2012-11-29 19:54:06 PST CONFIG remoteWorkerThread_1: Begin COPY of table "tracking"."impressions"<br>2012-11-29 19:54:06 PST ERROR remoteWorkerThread_1: "select "_admissioncls".copyFields(19);" <br>
2012-11-29 19:54:06 PST WARN remoteWorkerThread_1: data copy for set 2 failed 1 times - sleep 15 seconds<br><br>This large table ran for 4+ hours and the minute it starts with the very next table, it "fails", Identical behavior when doing set 1 which has a large table<br>
<br><br>
1235574-2012-11-29 12:22:12 PST CONFIG remoteWorkerThread_1: Begin COPY of table "cls"."customers"<br>1235665-2012-11-29 12:22:12 PST ERROR remoteWorkerThread_1: "select "_admissioncls".copyFields(8);" <br>
<div>
1235759:2012-11-29 12:22:12 PST WARN remoteWorkerThread_1: data copy for set 1 failed 1 times - sleep 15 seconds<br>Followed sometime later by this<br>2012-11-29 12:22:28 PST DEBUG2 remoteWorkerThread_2: forward confirm 3,5001168772 received by 4<br>
2012-11-29 12:22:28 PST INFO copy_set 1 - omit=f - bool=0<br>2012-11-29 12:22:28 PST INFO omit is FALSE<br><br></div><br>So what's going on, it appears to have made it through the heavy lifting, but it immediately goes to fail as it starts a much smaller table. Why does it wait to make it through the largest table in the set, before it says "bahh just kidding".<br>
<br>AHHH interesting, yet again at the moment of "fail" a log switchover is starting, this is identical to each and every failure. Why is a log switch appearing right before every failure?!<br><br>Can I disable this for a test? , disable logswitch<br>
<br>2012-11-29 19:54:11 PST admissionclsdb postgres [local] NOTICE: Slony-I: Logswitch to sl_log_2 initiated<br>2012-11-29 19:54:11 PST admissionclsdb postgres [local] CONTEXT: SQL statement "SELECT "_admissioncls".logswitch_start()"<br>
PL/pgSQL function "cleanupevent" line 96 at PERFORM<br><br>2012-11-29 12:22:13 PST admissionclsdb postgres [local] NOTICE: Slony-I: Logswitch to sl_log_2 initiated<br>2012-11-29 12:22:13 PST admissionclsdb postgres [local] CONTEXT: SQL statement "SELECT "_admissioncls".logswitch_start()"<br>
<div> PL/pgSQL function "cleanupevent" line 96 at PERFORM</div><br><blockquote class="gmail_quote">"</blockquote>Thanks<br>Tory<br>
</div>