[Bucardo-general] any way to know what bucardo is doing while state is "WAIT"?
springrider at gmail.com
Mon Dec 12 05:18:12 UTC 2011
sorry not sure why the email has been truncated.
I am trying master-master replication with sync type "swap".
bucardo_ctl status shows that the sync is in WAIT status:
Days back: 3 User: bucardo Database: bucardo PID of Bucardo MCP: 23422
Name Type State PID Last_good Time I/U/D Last_bad Time
adambjsync| S |WAIT:1h39m46s|25108|unknown | | |unknown |
the details as below:
bucardo_ctl status adambjsync
Days back: 3 User: bucardo Database: bucardo
Sync name: adambjsync
Current state: WAIT:1h 42m 16s (PID = 25108)
Source herd/database: adamsherd / diggcontent
Target database: bjdiggcontent
Tables in sync: 59
Last good: unknown
Last bad: unknown
PID file: /var/run/bucardo/bucardo.ctl.sync.adambjsync.pid
PID file created: Sun Dec 11 21:26:24 2011
Overdue time: 00:00:00
Expired time: 00:00:00
Stayalive: yes Kidsalive: yes
Rebuild index: 0 Do_listen: no
Ping: yes Makedelta: no
I have large amount data need to be synced, more than 4 millions
records in bucardo_delta table. not sure if bucardo can do this. for
now the table bucardo_track is empty. maybe means that the sync have
not started yet.
so what is bucardo is doing? I have
" CTL Could not add to q
Sending manual notification" in the log.bucardo file.
this is a production environment. while testing it, it also took
awhile with "WAIT" status. but the bucardo_delta table is
small(thousands of records), it back to normal minutes later.
I know there is a lot of data and may take a very long time to
proceed. but is there any way to find out what stage it is in? or what
it is doing? is there any problem blocking it? thanks!
"select count(*) from bucardo_delta;"
"select count(*) from bucardo_track;"
On Mon, Dec 12, 2011 at 1:15 PM, Yan Chunlu <springrider at gmail.com> wrote:
> I am trying master-master replication with sync type "swap". bucardo_ctl status shows that the sync is in WAIT status:
More information about the Bucardo-general