[Bucardo-general] Bugs...

[Michelle Sullivan]

Seems a 'bucardo status' does not show a stalled status...

Note: 'dnsrbls'...

root at boomerang:~ # bucardo status
PID of Bucardo MCP: 34313
  Name              State                             Last 
good               Time           Last I/D    Last bad                Time
=================+=================================+=======================+==============+===========+=======================+================
  dnsmm           | Good                            | 
12:32:17              | 2m 7s        | 0/0       | Oct 19, 2018 23:34:30 
| 10356h 59m 54s
  dnsrbls         | Good                            | Dec 21, 2019 
07:05:35 | 101h 28m 49s | 0/0       | Dec 10, 2019 19:10:15 | 353h 24m 9s
  dnsseq          | Good                            | 
12:32:16              | 2m 8s        | 0/0       | Oct 16, 2018 15:49:18 
| 10436h 45m 6s
  rt4db           | Begin txn (KID 40699)           | 
12:32:15              | 2m 9s        | 6/169     | 08:44:58              
| 3h 49m 26s
  rt4seq          | Good                            | 
12:34:21              | 3s           | 0/0       | Dec 16, 2019 02:49:34 
| 225h 44m 50s
  rt4sequences    | Good                            | 
08:52:19              | 3h 42m 5s    | 0/0       | none                  |
  s2evidence      | Good                            | 
12:34:16              | 8s           | 0/12      | Dec 19, 2019 11:26:33 
| 145h 7m 51s
  s2users         | Good                            | 
12:34:23              | 1s           | 0/0       | 07:06:44              
| 5h 27m 40s
  sessions        | Good                            | 
12:34:21              | 3s           | 0/2       | 07:06:44              
| 5h 27m 40s
  sessionsdb      | Good                            | 
12:34:20              | 4s           | 2/5       | 07:15:56              
| 5h 18m 28s
  shelsmm         | Good                            | 
08:52:18              | 3h 42m 6s    | 0/6       | Oct 16, 2018 15:49:27 
| 10436h 44m 57s
  sorbs2sequences | Good                            | 
08:52:19              | 3h 42m 5s    | 0/0       | none                  |
  sorbsmm         | Good                            | 
12:34:23              | 0s           | 0/0       | 07:06:44              
| 5h 27m 40s
  sorbsqs         | Good                            | 
12:22:18              | 12m 5s       | 123/123   | Oct 08, 2018 06:36:40 
| 10637h 57m 44s
  sorbsstats      | Sync public.reportq (KID 40696) | Dec 24, 2019 
01:23:26 | 35h 10m 58s  | 0/147704  | 08:44:58              | 3h 49m 26s


bucardo=# select name,herd,dbs,status from sync where name = 'dnsrbls';
   name   | herd |    dbs    | status
---------+------+-----------+---------
  dnsrbls | dns  | dnsslaves | stalled
(1 row)


Obviously the 'last good' and 'last bad' are a give away, but the 
problem is you might not notice for several hours.

Next related problem...

root at boomerang:~ # bucardo activate dnsrbls
Activating sync dnsrbls
root at boomerang:~ # bucardo kick dnsrbls
Cannot kick inactive sync "dnsrbls"
root at boomerang:~ #

bucardo=# select name,herd,dbs,status from sync where name = 'dnsrbls';
   name   | herd |    dbs    | status
---------+------+-----------+---------
  dnsrbls | dns  | dnsslaves | stalled
(1 row)

Can't seem to 'un-stall' it..  I can however issue a "update sync set 
status = 'active' where name = 'dnsrbls';" and a restart will kick it 
all off... (haven't tried kicking it when just updating the DB).. worse...

... when restarting bucardo all stalled syncs stay 'stalled' without 
reporting such ... was lucky I was monitoring the replication via my 
nagios plugin and saw the various datasets were staying 'lagged'...

root at boomerang:~ # bucardo --version
bucardo version 5.4.1

Regards,

Michelle

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