Wed Feb 14 10:20:53 PST 2018
- Previous message: [Slony1-general] running slony1 2.2.5
- Next message: [Slony1-general] slony1 drop node failure
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Good morning I thought I would pass additional info from the slony tables to help add a bit of context to the picture : 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; ev_origin | ev_seqno | ev_timestamp | ev_snapshot | ev_type | ev_data1 | ev_data2 | ev_data3 | ev_data4 -----------+------------+-------------------------------+--- ------------------------------------------+----------------- ----+----------+----------+--------------------------------- -------------+------------------------------------------------------- 1 | 5000880660 | 2018-02-14 11:02:03.762749-05 | 3704200728:3704209595:3704200728 | SUBSCRIBE_SET | 20 | 1 | 2 | t 1 | 5000880661 | 2018-02-14 11:02:03.762749-05 | 3704200728:3704209595:3704200728 | ENABLE_SUBSCRIPTION | 20 | 1 | 2 | t 1 | 5000881066 | 2018-02-14 11:11:00.982413-05 | 3704200728:3704217695:3704200728 | DROP_SET | 20 | | | 1 | 5000881076 | 2018-02-14 11:11:28.673615-05 | 3704200728:3704217775:3704200728 | STORE_SET | 20 | 1 | Set 20 (set20) for replicationtwo | 1 | 5000881078 | 2018-02-14 11:11:28.795985-05 | 3704200728:3704217778:3704200728 | SET_ADD_TABLE | 20 | 416 | public.dba_food_preferences | dbafood_pkey 1 | 5000881081 | 2018-02-14 11:11:29.076247-05 | 3704200728:3704217783:3704200728 | SET_ADD_SEQUENCE | 20 | 340 | public.dba_food_preferences_dbafood_pkey_seq | Sequence public.dba_food_preferences_dbafood_pkey_seq 1 | 5000881236 | 2018-02-14 11:14:58.638468-05 | 3704200728:3704219464:3704200728 | SUBSCRIBE_SET | 20 | 1 | 2 | t 1 | 5000881237 | 2018-02-14 11:14:58.638468-05 | 3704200728:3704219464:3704200728 | ENABLE_SUBSCRIPTION | 20 | 1 | 2 | t 2 | 5000160982 | 2018-02-14 11:15:37.34594-05 | 154224842:154224842: | UNSUBSCRIBE_SET | 20 | 2 | | 1 | 5000881411 | 2018-02-14 11:20:11.76759-05 | 3704200728:3704220797:3704200728 | DROP_SET | 20 | | | 1 | 5000881419 | 2018-02-14 11:20:27.813263-05 | 3704200728:3704220881:3704200728,3704220866 | STORE_SET | 20 | 1 | Set 20 (set20) for replicationtwo | 1 | 5000881421 | 2018-02-14 11:20:27.922722-05 | 3704200728:3704220886:3704200728,3704220866 | SET_ADD_TABLE | 20 | 416 | public.dba_food_preferences | dbafood_pkey 1 | 5000881423 | 2018-02-14 11:20:28.120457-05 | 3704200728:3704220888:3704200728,3704220866 | SET_ADD_SEQUENCE | 20 | 340 | public.dba_food_preferences_dbafood_pkey_seq | Sequence public.dba_food_preferences_dbafood_pkey_seq 2 | 5000160983 | 2018-02-14 11:21:33.455822-05 | 154225614:154225614: | UNSUBSCRIBE_SET | 20 | 2 | | 1 | 5000881694 | 2018-02-14 11:28:43.306001-05 | 3704200728:3704226617:3704200728 | DROP_SET | 20 | | | 2 | 5000160984 | 2018-02-14 11:31:39.175163-05 | 154226919:154226919: | UNSUBSCRIBE_SET | 20 | 2 | | 2 | 5000160985 | 2018-02-14 11:37:23.732968-05 | 154227660:154227660: | UNSUBSCRIBE_SET | 20 | 2 | | 2 | 5000160986 | 2018-02-14 11:37:31.31214-05 | 154227677:154227677: | UNSUBSCRIBE_SET | 20 | 2 | | 1 | 5000883198 | 2018-02-14 12:09:56.431871-05 | 3704247815:3704247815: | DROP_SET | 19 | | | 2 | 5000160987 | 2018-02-14 12:11:25.380175-05 | 154232130:154232130: | UNSUBSCRIBE_SET | 19 | 2 | | (20 rows) mavmail=# select * from _replicationtwo.sl_path; pa_server | pa_client | pa_conninfo | pa_connretry -----------+-----------+------------------------------------ -------------------+-------------- 2 | 1 | host=10.93.156.52 dbname=mavmail user=slony port=5432 | 10 1 | 2 | host=10.93.156.47 dbname=mavmail user=slony port=5432 | 10 (2 rows) select * from _replicationtwo.sl_listen; li_origin | li_provider | li_receiver -----------+-------------+------------- 2 | 2 | 1 1 | 1 | 2 select * from _replicationtwo.sl_apply_stats ; -[ RECORD 1 ]--------+------------------------------ as_origin | 2 as_num_insert | 0 as_num_update | 0 as_num_delete | 0 as_num_truncate | 0 as_num_script | 0 as_num_total | 0 as_duration | 00:07:32.004 as_apply_first | 2018-01-26 19:13:43.434628-05 as_apply_last | 2018-02-14 11:13:51.191299-05 as_cache_prepare | 0 as_cache_hit | 0 as_cache_evict | 0 as_cache_prepare_max | 0 Thanks for your time. On Wed, Feb 14, 2018 at 12:25 PM, Mark Steben <mark.steben at drivedominion.com > wrote: > Good morning, hope you can help. > > I use the perlscripts provided in the installation. I wanted to create > and subscribe a new set with one table > > Here is the set info from the slon_tools file: > > # "set20" => { > # "set_id" => 20, > # "table_id" => 416, > # "sequence_id" => 340, > # "pkeyedtables" => [ > #"public.dba_food_preferences", > # ], > # "sequences" => > # [ > #"public.dba_food_preferences_dbafood_pkey_seq", > #] > #}, > > I issued a ./slonik_create_set for set 20 - no problem > I issued a ./slonik_subscribe set for set 20 node2 and got this error: > > remoteWorkerThread_1: provider node -1 for set 20not found in runtime > configuration > > I issued unsubscribe_set , drop_set, stopped and restarted the slon daemon > and still get this error. > In fact slony is not working at all. It looks like it continues to add > the previous active sets then errors out: > > > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: update provider > configuration > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 1 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 2 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 3 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 4 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 5 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 6 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 7 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 8 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 9 to > provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 10 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 11 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 12 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 13 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 14 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 15 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 16 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 17 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 18 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG remoteWorkerThread_1: added active set 19 > to provider 1 > 2018-02-14 12:17:20 EST CONFIG cleanupThread: bias = 60 > 2018-02-14 12:17:20 EST CONFIG version for "host=10.93.156.52 > dbname=mavmail user=slony port=5432" is 90408 > 2018-02-14 12:17:20 EST INFO copy_set 20 - omit=f - bool=0 > 2018-02-14 12:17:20 EST INFO omit is FALSE > 2018-02-14 12:17:20 EST ERROR remoteWorkerThread_1: provider node -1 for > set 20not found in runtime configuration > 2018-02-14 12:17:20 EST CONFIG slon: child terminated signal: 9; pid: > 24519, current worker pid: 24519 > 2018-02-14 12:17:20 EST CONFIG slon: restart of worker in 10 seconds > > > Any ideas short of uninstalling the entire package, that might get me > around this? > > Thank you > > > -- > *Mark Steben* > Database Administrator > @utoRevenue <http://www.autorevenue.com/> | Autobase > <http://www.autobase.net/> > CRM division of Dominion Dealer Solutions > 95D Ashley Ave. > West Springfield, MA 01089 > t: 413.327-3045 > f: 413.383-9567 > > www.fb.com/DominionDealerSolutions > www.twitter.com/DominionDealer > www.drivedominion.com <http://www.autorevenue.com/> > > <http://autobasedigital.net/marketing/DD12_sig.jpg> > > > > -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com <http://www.autorevenue.com/> <http://autobasedigital.net/marketing/DD12_sig.jpg> -- <https://www.drivedominion.com/transform-your-vue/> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20180214/5ad1dd31/attachment-0001.htm
- Previous message: [Slony1-general] running slony1 2.2.5
- Next message: [Slony1-general] slony1 drop node failure
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list