[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