[Bucardo-general] This doesn't look right...
Michelle Sullivan
michelle at sorbs.net
Sun Jun 27 22:51:21 UTC 2010
# bucardo_ctl status sorbs2_delta
Days back: 3 User: bucardo Database: bucardo
======================================================================
Sync name: sorbs2_delta
Current state: idle (PID = 1071)
Type: pushdelta
Source herd/database: sorbs2slave / usmaster
Target database: backup_server
Tables in sync: 58
Last good: 10m 45s (time to run: 20m 18s)
Last good time: Jun 27, 2010 17:37:29 Target: backup_server
Ins/Upd/Del: 568676 / 0 / 2262
Last bad: 32m 5s (time to run: 4m 30s)
Last bad time: Jun 27, 2010 17:16:08 Target: backup_server
Latest bad reason: MCP removing stale q entry
PID file: /var/run/bucardo.ctl.sync.sorbs2_delta.pid
PID file created: Sun Jun 27 17:17:10 2010
Status: active
Limitdbs: 0
Priority: 0
Checktime: none
Overdue time: 00:00:00
Expired time: 00:00:00
Stayalive: yes Kidsalive: yes
Rebuild index: 0 Do_listen: no
Ping: yes Makedelta: inherits/inherits
Onetimecopy: 0
# bucardo_ctl status sorbs2_swap
Days back: 3 User: bucardo Database: bucardo
======================================================================
Sync name: sorbs2_swap
Current state: WAIT:31m 7s (PID = 1072)
Type: swap
Source herd/database: sorbs2master / aumaster
Target database: usmaster
Tables in sync: 58
Last good: 1h 15m 43s (time to run: 29m 17s)
Last good time: Jun 27, 2010 16:32:39 Target: usmaster
Ins/Upd/Del: 33183 / 171 / 0
Last bad: 32m 13s (time to run: 4m 27s)
Last bad time: Jun 27, 2010 17:16:08 Target: usmaster
Latest bad reason: MCP removing stale q entry
PID file: /var/run/bucardo.ctl.sync.sorbs2_swap.pid
PID file created: Sun Jun 27 17:17:10 2010
Status: active
Limitdbs: 0
Priority: 0
Checktime: none
Overdue time: 00:00:00
Expired time: 00:00:00
Stayalive: yes Kidsalive: yes
Rebuild index: 0 Do_listen: no
Ping: yes Makedelta: inherits/on
Onetimecopy: 0
Note the insert counts... how can the delta be more than the swap for
inserts... it's all supposed to be in sync....
Thanks,
Michelle
More information about the Bucardo-general
mailing list