[Bucardo-general] Another problem

Michelle Sullivan michelle at sorbs.net
Wed Oct 16 08:17:45 UTC 2013


Greg Sabino Mullane wrote:
> On Tue, Oct 15, 2013 at 11:40:52PM +0200, Michelle Sullivan wrote:
> ...
>   
>> (15164) [Mon Oct 14 11:46:18 2013] MCP Table public.networks is
>> referenced by public.dns, which is not part of this sync!
>>
>> Is that what is stopping it?
>>     
>
> No - that's informational only, and won't stop the sync from 
> running. Check the logs for something else. Try grepping 
> for the sync name.
>
>   
Well this is what I see:

(20829) [Tue Oct 15 14:46:30 2013] MCP Activating sync "sorbsrbls"
(20829) [Tue Oct 15 14:46:30 2013] MCP Running validate_sync on "sorbsrbls"
(21669) [Tue Oct 15 14:48:58 2013] CTL New controller for sync
"sorbsrbls". Relgroup is "sorbsdns", dbs is "sorbsslaves". PID=21669
(20829) [Tue Oct 15 14:48:58 2013] MCP Created controller 21669 for sync
"sorbsrbls". Kick is 0
(21738) [Tue Oct 15 14:49:05 2013] KID New kid, sync "sorbsrbls" alive=1
Parent=21669 PID=21738 kicked=0
(21669) [Tue Oct 15 14:49:05 2013] CTL Created new kid 21738 for sync
"sorbsrbls"
(20829) [Tue Oct 15 15:09:12 2013] MCP Deactivating sync "sorbsrbls"
(21669) [Tue Oct 15 15:09:12 2013] CTL Controller for "sorbsrbls" was
killed at line 1321: MCP request
(20829) [Tue Oct 15 15:09:14 2013] MCP Reactivating sync sorbsrbls
(20829) [Tue Oct 15 15:09:14 2013] MCP Running validate_sync on "sorbsrbls"
(21738) [Tue Oct 15 15:09:15 2013] KID Kid 21738 exiting at cleanup_kid.
Sync "sorbsrbls" public.timestamps Reason: CTL request Line: 4771
(24124) [Tue Oct 15 15:10:00 2013] CTL New controller for sync
"sorbsrbls". Relgroup is "sorbsdns", dbs is "sorbsslaves". PID=24124
(20829) [Tue Oct 15 15:10:00 2013] MCP Created controller 24124 for sync
"sorbsrbls". Kick is 0
(24133) [Tue Oct 15 15:10:07 2013] KID New kid, sync "sorbsrbls" alive=1
Parent=24124 PID=24133 kicked=0
(24124) [Tue Oct 15 15:10:07 2013] CTL Created new kid 24133 for sync
"sorbsrbls"
(20829) [Tue Oct 15 21:52:55 2013] MCP Attempting to signal PID from
file "bucardo.ctl.sync.sorbsrbls.pid"
(24124) [Tue Oct 15 21:52:55 2013] CTL Controller for "sorbsrbls" was
killed at line 1321: MCP request
(20829) [Tue Oct 15 21:52:55 2013] MCP Attempting to signal PID from
file "bucardo.kid.sync.sorbsrbls.pid"
(20829) [Tue Oct 15 21:58:48 2013] MCP Activating sync "sorbsrbls"
(20829) [Tue Oct 15 21:58:48 2013] MCP Running validate_sync on "sorbsrbls"
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_cheetah (target)
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_crossbow (target)
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_falken (target)
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_helix (source)
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_kraken (target)
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_predator (target)
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_ricochet (target)
(20829) [Tue Oct 15 21:59:34 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_stinger (target)
(18924) [Tue Oct 15 22:00:09 2013] CTL New controller for sync
"sorbsrbls". Relgroup is "sorbsdns", dbs is "sorbsslaves". PID=18924
(20829) [Tue Oct 15 22:00:09 2013] MCP Created controller 18924 for sync
"sorbsrbls". Kick is 0
(18979) [Tue Oct 15 22:00:16 2013] KID New kid, sync "sorbsrbls" alive=1
Parent=18924 PID=18979 kicked=0
(18979) [Tue Oct 15 22:00:16 2013] KID Overwriting
/sorbs/bucardo/bucardo.kid.sync.sorbsrbls.pid: old process was ?
(18924) [Tue Oct 15 22:00:16 2013] CTL Created new kid 18979 for sync
"sorbsrbls"
(20829) [Tue Oct 15 22:23:50 2013] MCP Deactivating sync "sorbsrbls"
(18924) [Tue Oct 15 22:23:50 2013] CTL Controller for "sorbsrbls" was
killed at line 1321: MCP request
(20829) [Tue Oct 15 22:23:54 2013] MCP Reactivating sync sorbsrbls
(20829) [Tue Oct 15 22:23:54 2013] MCP Running validate_sync on "sorbsrbls"
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_cheetah (target)
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_crossbow (target)
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_falken (target)
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_helix (source)
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_kraken (target)
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_predator (target)
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_ricochet (target)
(20829) [Tue Oct 15 22:24:38 2013] MCP Listen for kick_sync_sorbsrbls on
sorbs_stinger (target)
(20008) [Tue Oct 15 22:24:38 2013] CTL New controller for sync
"sorbsrbls". Relgroup is "sorbsdns", dbs is "sorbsslaves". PID=20008
(20829) [Tue Oct 15 22:24:38 2013] MCP Created controller 20008 for sync
"sorbsrbls". Kick is 0
(20014) [Tue Oct 15 22:24:44 2013] KID New kid, sync "sorbsrbls" alive=1
Parent=20008 PID=20014 kicked=0
(20014) [Tue Oct 15 22:24:44 2013] KID Overwriting
/sorbs/bucardo/bucardo.kid.sync.sorbsrbls.pid: old process was ?
(20008) [Tue Oct 15 22:24:45 2013] CTL Created new kid 20014 for sync
"sorbsrbls"

PID of Bucardo MCP: 20829
 Name         State                   Last good    Time     Last I/D   
Last bad                Time       
============+=======================+============+========+===========+=======================+=============
 dnsmm      | Good                  | 08:10:14   | 3m 48s | 0/0       |
none                  |            
 dnsrbls    | Good                  | 08:10:22   | 3m 39s | 0/0       |
Oct 15, 2013 14:11:39 | 18h 2m 22s 
 dnsseq     | Good                  | 08:10:16   | 3m 45s | 0/0       |
none                  |            
 sessions   | Good                  | 08:14:00   | 1s     | 0/3       |
Oct 15, 2013 11:47:43 | 20h 26m 18s
 sessionsdb | Good                  | 08:14:01   | 0s     | 6/12      |
Oct 15, 2013 14:11:39 | 18h 2m 22s 
 sorbsmm    | Begin txn (KID 6625)  | 08:14:00   | 1s     | 840/3903  |
08:04:56              | 9m 5s      
 sorbsmmseq | Begin txn (KID 20042) | none       |        |           |
Oct 15, 2013 22:25:52 | 9h 48m 9s  
 sorbsrbls  | Good                  | 08:14:01   | 1s     | 0/0       |
Oct 15, 2013 13:53:25 | 18h 20m 36s
 sorbsstats | Good                  | 08:13:14   | 48s    | 0/0       |
Oct 15, 2013 11:47:43 | 20h 26m 18s


But as far as I can see it isn't actually replicating anything...

Its configured as follows:

Sync: dnsmm       Relgroup: dns        [Active]
  DB group dnsmasters: dns_corkscrew (source) dns_galaxi (source)
dns_gemini (source) dns_helix (source)
Sync: dnsrbls     Relgroup: dns        [Active]
  DB group dnsslaves: dns_cheetah (target) dns_corkscrew (source)
dns_crossbow (target) dns_falken (target) dns_galaxi (source) dns_gemini
(source) dns_helix (source) dns_kraken (target) dns_predator (target)
dns_ricochet (target) dns_stinger (target)
Sync: dnsseq      Relgroup: dnsseq     [Active]
  DB group dnsmasters: dns_corkscrew (source) dns_galaxi (source)
dns_gemini (source) dns_helix (source)
Sync: sessions    Relgroup: sessions   [Active]
  DB group sorbsmasters: sorbs_corkscrew (source) sorbs_galaxi (source)
sorbs_gemini (source) sorbs_helix (source)
Sync: sessionsdb  Relgroup: sessionsdb [Active]
  DB group sessionsdb: sessions_corkscrew (source) sessions_galaxi
(source) sessions_gemini (source) sessions_helix (source)
--> Sync: sorbsmm     Relgroup: sorbs2     [Active]
-->   DB group sorbsmasters: sorbs_corkscrew (source) sorbs_galaxi
(source) sorbs_gemini (source) sorbs_helix (source)
Sync: sorbsmmseq  Relgroup: sorbsseq   [Active]
  DB group sorbsmasters: sorbs_corkscrew (source) sorbs_galaxi (source)
sorbs_gemini (source) sorbs_helix (source)
--> Sync: sorbsrbls   Relgroup: sorbsdns   [Active]
-->   DB group sorbsslaves: sorbs_cheetah (target) sorbs_crossbow
(target) sorbs_falken (target) sorbs_helix (source) sorbs_kraken
(target) sorbs_predator (target) sorbs_ricochet (target) sorbs_stinger
(target)
Sync: sorbsstats  Relgroup: sorbsstats [Active]
  DB group sorbsmasters: sorbs_corkscrew (source) sorbs_galaxi (source)
sorbs_gemini (source) sorbs_helix (source)

I have also tried it with:

DB group sorbsslaves: sorbs_cheetah (target) sorbs_crossbow (target)
sorbs_falken (target) sorbs_corkscrew (source) sorbs_galaxi (source)
sorbs_gemini (source) sorbs_helix (source) sorbs_kraken (target)
sorbs_predator (target) sorbs_ricochet (target) sorbs_stinger (target)

But that seems to make no difference...

Regards,

Michelle

-- 
Michelle Sullivan
http://www.mhix.org/



More information about the Bucardo-general mailing list