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>
--
<https://www.drivedominion.com/transform-your-vue/>
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
