<br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 29, 2012 at 10:15 AM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 12-11-29 11:53 AM, Tory M Blue wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
<br>
<br>
On Thu, Nov 29, 2012 at 12:57 AM, Glyn Astill <<a href="mailto:glynastill@yahoo.co.uk" target="_blank">glynastill@yahoo.co.uk</a><br>
<mailto:<a href="mailto:glynastill@yahoo.co.uk" target="_blank">glynastill@yahoo.co.uk</a><u></u>>> wrote:<br>
<br>
Hi Tory<br>
<br>
> From: Tory M Blue <<a href="mailto:tmblue@gmail.com" target="_blank">tmblue@gmail.com</a> <mailto:<a href="mailto:tmblue@gmail.com" target="_blank">tmblue@gmail.com</a>>><br>
<br>
>To: slony1-general <<a href="mailto:slony1-general@lists.slony.info" target="_blank">slony1-general@lists.slony.<u></u>info</a><br>
<mailto:<a href="mailto:slony1-general@lists.slony.info" target="_blank">slony1-general@lists.<u></u>slony.info</a>>><br>
>Sent: Wednesday, 28 November 2012, 18:35<br>
>Subject: [Slony1-general] data copy for set 1 failed 3 times -<br>
sleep 60 seconds<br>
><br>
><br>
>Greetings<br>
><br>
>I've just brought up a replication node across the state, we have<br>
gig circuits, but still going over the net over a vpn tunnel. So<br>
there is some delay,<br>
><br>
>I'm getting these errors and can't get the initial replication to<br>
finish<br>
><br>
>4273435:2012-11-27 16:45:17 PST WARN remoteWorkerThread_1: data<br>
copy for set 1 failed 3 times - sleep 60 seconds<br>
><br>
<br>
Is that the only line you get in your logs? If so use a higher<br>
setting for log_level (like log_level=4).<br>
<br>
Also is there anything in the postgresql log to indicate the problem?<br>
<br>
<br>
I get the following<br>
<br>
2012-11-29 08:34:38 PST CONFIG remoteWorkerThread_1: 3858.988 seconds to<br>
copy table "cls"."listings"<br>
2012-11-29 08:34:38 PST CONFIG remoteWorkerThread_1: copy table<br>
"cls"."customers"<br>
2012-11-29 08:34:38 PST CONFIG remoteWorkerThread_1: Begin COPY of table<br>
"cls"."customers"<br>
2012-11-29 08:34:38 PST ERROR remoteWorkerThread_1: "select<br>
"_admissioncls".copyFields(8);<u></u>"<br>
<br>
</blockquote>
<br>
What is the structure of the table with table_id=8 (ie set add table(id=8, fully qualified name=?????)<br>
<br>
If you do<br>
manually run<br>
select _admissioncls".copyFields(8);<br>
from psql, what does it come back with?<br>
<br>
<br></blockquote><div>So ran it again with debug = 4, same failure same spot. Should be be dying due to the logswitch, but I guess it could be? <br><br>Failed again, this time with heavier debug, but not showing me much (level 4)<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>
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>And it starts all over again.<br><br>Postgres logs<br><br>2012-11-29 12:19:40 PST HINT: Consider increasing the configuration paramete<br>
r "checkpoint_segments".<br>2012-11-29 12:22:13 PST admissionclsdb postgres [local] NOTICE: Slony-I: Logswi<br>tch to sl_log_2 initiated<br>2012-11-29 12:22:13 PST admissionclsdb postgres [local] CONTEXT: SQL statement <br>
"SELECT "_admissioncls".logswitch_start()"<br> PL/pgSQL function "cleanupevent" line 96 at PERFORM<br><br>Nothing in /var/log/messages or dmesg, this is not a system thing it doesn't appear. Slony configurations sync rate, or something is putting the kabosh on this.<br>
<br><br>admissionclsdb=# select "_admissioncls".copyFields(8);<br> copyfields <br>------------<br> )<br>(1 row) <br><br>Any ideas? <br><br>Thanks<br>Tory<br></div></div></div>