[Bucardo-general] any way to know what bucardo is doing while state is "WAIT"?

[Yan Chunlu]

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:

bucardo_ctl 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)
Type: swap
Source herd/database: adamsherd / diggcontent
Target database: bjdiggcontent
Tables in sync: 59
Last good: unknown
Ins/Upd/Del:
Last bad: unknown
PID file: /var/run/bucardo/bucardo.ctl.sync.adambjsync.pid
PID file created: Sun Dec 11 21:26:24 2011
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: no
Onetimecopy: 0


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
sync=adambjsync,source=diggcontent,target=bjdiggcontent,count=1.
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;"
count
---------
4421304
(1 row)

"select count(*) from bucardo_track;"
count
-------
0
(1 row)

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: