<div dir="ltr">Good morning I thought I would pass additional info from the slony tables to help add a bit of context to the picture :<div><br></div><div><div>mavmail=# select ev_origin, ev_seqno, ev_timestamp, ev_snapshot, ev_type, ev_data1, ev_data2, ev_data3, ev_data4 from _replicationtwo.sl_event where ev_type <> 'SYNC' order by ev_timestamp;</div><div> ev_origin | ev_seqno | ev_timestamp | ev_snapshot | ev_type | ev_data1 | ev_data2 | ev_data3 | ev_data4 </div><div>-----------+------------+-----<wbr>--------------------------+---<wbr>------------------------------<wbr>------------+-----------------<wbr>----+----------+----------+---<wbr>------------------------------<wbr>-------------+----------------<wbr>------------------------------<wbr>---------</div><div> 1 | 5000880660 | 2018-02-14 11:02:03.762749-05 | 3704200728:3704209595:<wbr>3704200728 | SUBSCRIBE_SET | 20 | 1 | 2 | t</div><div> 1 | 5000880661 | 2018-02-14 11:02:03.762749-05 | 3704200728:3704209595:<wbr>3704200728 | ENABLE_SUBSCRIPTION | 20 | 1 | 2 | t</div><div> 1 | 5000881066 | 2018-02-14 11:11:00.982413-05 | 3704200728:3704217695:<wbr>3704200728 | DROP_SET | 20 | | | </div><div> 1 | 5000881076 | 2018-02-14 11:11:28.673615-05 | 3704200728:3704217775:<wbr>3704200728 | STORE_SET | 20 | 1 | Set 20 (set20) for replicationtwo | </div><div> 1 | 5000881078 | 2018-02-14 11:11:28.795985-05 | 3704200728:3704217778:<wbr>3704200728 | SET_ADD_TABLE | 20 | 416 | public.dba_food_preferences | dbafood_pkey</div><div> 1 | 5000881081 | 2018-02-14 11:11:29.076247-05 | 3704200728:3704217783:<wbr>3704200728 | SET_ADD_SEQUENCE | 20 | 340 | public.dba_food_preferences_<wbr>dbafood_pkey_seq | Sequence public.dba_food_preferences_<wbr>dbafood_pkey_seq</div><div> 1 | 5000881236 | 2018-02-14 11:14:58.638468-05 | 3704200728:3704219464:<wbr>3704200728 | SUBSCRIBE_SET | 20 | 1 | 2 | t</div><div> 1 | 5000881237 | 2018-02-14 11:14:58.638468-05 | 3704200728:3704219464:<wbr>3704200728 | ENABLE_SUBSCRIPTION | 20 | 1 | 2 | t</div><div> 2 | 5000160982 | 2018-02-14 11:15:37.34594-05 | 154224842:154224842: | UNSUBSCRIBE_SET | 20 | 2 | | </div><div> 1 | 5000881411 | 2018-02-14 11:20:11.76759-05 | 3704200728:3704220797:<wbr>3704200728 | DROP_SET | 20 | | | </div><div> 1 | 5000881419 | 2018-02-14 11:20:27.813263-05 | 3704200728:3704220881:<wbr>3704200728,3704220866 | STORE_SET | 20 | 1 | Set 20 (set20) for replicationtwo | </div><div> 1 | 5000881421 | 2018-02-14 11:20:27.922722-05 | 3704200728:3704220886:<wbr>3704200728,3704220866 | SET_ADD_TABLE | 20 | 416 | public.dba_food_preferences | dbafood_pkey</div><div> 1 | 5000881423 | 2018-02-14 11:20:28.120457-05 | 3704200728:3704220888:<wbr>3704200728,3704220866 | SET_ADD_SEQUENCE | 20 | 340 | public.dba_food_preferences_<wbr>dbafood_pkey_seq | Sequence public.dba_food_preferences_<wbr>dbafood_pkey_seq</div><div> 2 | 5000160983 | 2018-02-14 11:21:33.455822-05 | 154225614:154225614: | UNSUBSCRIBE_SET | 20 | 2 | | </div><div> 1 | 5000881694 | 2018-02-14 11:28:43.306001-05 | 3704200728:3704226617:<wbr>3704200728 | DROP_SET | 20 | | | </div><div> 2 | 5000160984 | 2018-02-14 11:31:39.175163-05 | 154226919:154226919: | UNSUBSCRIBE_SET | 20 | 2 | | </div><div> 2 | 5000160985 | 2018-02-14 11:37:23.732968-05 | 154227660:154227660: | UNSUBSCRIBE_SET | 20 | 2 | | </div><div> 2 | 5000160986 | 2018-02-14 11:37:31.31214-05 | 154227677:154227677: | UNSUBSCRIBE_SET | 20 | 2 | | </div><div> 1 | 5000883198 | 2018-02-14 12:09:56.431871-05 | 3704247815:3704247815: | DROP_SET | 19 | | | </div><div> 2 | 5000160987 | 2018-02-14 12:11:25.380175-05 | 154232130:154232130: | UNSUBSCRIBE_SET | 19 | 2 | | </div><div>(20 rows)</div></div><div><br></div><div><div> <span style="font-size:12.8px">mavmail=# select * from _replicationtwo.sl_path;</span></div></div><div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;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"><div> pa_server | pa_client | pa_conninfo | pa_connretry </div><div>-----------+-----------+------<wbr>------------------------------<wbr>-------------------+----------<wbr>----</div><div> 2 | 1 | host=10.93.156.52 dbname=mavmail user=slony port=5432 | 10</div><div> 1 | 2 | host=10.93.156.47 dbname=mavmail user=slony port=5432 | 10</div><div>(2 rows)</div></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;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"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;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"><div> select * from _replicationtwo.sl_listen;</div><div> li_origin | li_provider | li_receiver </div><div>-----------+-------------+----<wbr>---------</div><div> 2 | 2 | 1</div><div> 1 | 1 | 2</div></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;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"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;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"><div> select * from _replicationtwo.sl_apply_<wbr>stats </div><div>;</div><div>-[ RECORD 1 ]--------+--------------------<wbr>----------</div><div>as_origin | 2</div><div>as_num_insert | 0</div><div>as_num_update | 0</div><div>as_num_delete | 0</div><div>as_num_truncate | 0</div><div>as_num_script | 0</div><div>as_num_total | 0</div><div>as_duration | 00:07:32.004</div><div>as_apply_first | 2018-01-26 19:13:43.434628-05</div><div>as_apply_last | 2018-02-14 11:13:51.191299-05</div><div>as_cache_prepare | 0</div><div>as_cache_hit | 0</div><div>as_cache_evict | 0</div><div>as_cache_prepare_max | 0</div><div><br></div><div>Thanks for your time.</div></div><br class="gmail-Apple-interchange-newline">
<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Feb 14, 2018 at 12:25 PM, Mark Steben <span dir="ltr"><<a href="mailto:mark.steben@drivedominion.com" target="_blank">mark.steben@drivedominion.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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"<wbr>,</div><div># ],</div><div># "sequences" =></div><div># [</div><div>#"public.dba_food_preferences_<wbr>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="m_7185512590016525573gmail_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/<wbr>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>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="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>
<br>
<a href="https://www.drivedominion.com/transform-your-vue/" target="_blank"><img src="https://drive.google.com/uc?export=download&id=0B1pDjtKLadwBOWcyaGpTaE1YLUJaYTZmTDNOOXYwcGI2ZmRJ"></a>