<div dir="ltr">Good morning, hope you can help.<div><br></div><div>I use the perlscripts provided in the installation. I wanted to create and subscribe a new set with one table</div><div><br></div><div>Here is the set info from the slon_tools file:</div><div><br></div><div><div># "set20" => { </div><div># "set_id" => 20,</div><div># "table_id" => 416,</div><div># "sequence_id" => 340,</div><div># "pkeyedtables" => [</div><div>#"public.dba_food_preferences",</div><div># ],</div><div># "sequences" =></div><div># [</div><div>#"public.dba_food_preferences_dbafood_pkey_seq",</div><div>#]</div><div>#},</div><div><br></div><div>I issued a ./slonik_create_set for set 20 - no problem</div><div>I issued a ./slonik_subscribe set for set 20 node2 and got this error:</div><div><br></div><div><div> remoteWorkerThread_1: provider node -1 for set 20not found in runtime configuration</div></div><div><br></div><div>I issued unsubscribe_set , drop_set, stopped and restarted the slon daemon and still get this error.</div><div>In fact slony is not working at all. It looks like it continues to add the previous active sets then errors out:</div><div><br></div><div><br></div><div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: update provider configuration</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 1 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 2 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 3 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 4 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 5 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 6 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 7 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 8 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 9 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 10 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 11 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 12 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 13 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 14 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 15 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 16 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 17 to provider 1</div><div>2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 18 to provider 1</div><div>
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 19 to provider 1</span>
<br></div><div>2018-02-14 12:17:20 EST CONFIG cleanupThread: bias = 60</div><div>2018-02-14 12:17:20 EST CONFIG version for "host=10.93.156.52 dbname=mavmail user=slony port=5432" is 90408</div><div>2018-02-14 12:17:20 EST INFO copy_set 20 - omit=f - bool=0</div><div>2018-02-14 12:17:20 EST INFO omit is FALSE</div><div>2018-02-14 12:17:20 EST ERROR remoteWorkerThread_1: provider node -1 for set 20not found in runtime configuration</div><div>2018-02-14 12:17:20 EST CONFIG slon: child terminated signal: 9; pid: 24519, current worker pid: 24519</div><div>2018-02-14 12:17:20 EST CONFIG slon: restart of worker in 10 seconds</div></div><div><br></div><div><br></div><div>Any ideas short of uninstalling the entire package, that might get me around this?</div><div><br></div><div>Thank you</div><div><br></div><div><br></div>-- <br><div class="gmail_signature"><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br><a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br> <span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br><a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br><br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br></span></span></font></span></p><font color="#888888"></font></div>
</div></div>
<br>
<a href="https://www.drivedominion.com/transform-your-vue/" target="_blank"><img src="https://drive.google.com/uc?export=download&id=0B1pDjtKLadwBOWcyaGpTaE1YLUJaYTZmTDNOOXYwcGI2ZmRJ"></a>