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