[Bucardo-general] couple of questions

[Greg Sabino Mullane]

> In the bc status display my "last good" column always seems 
> to be a question mark (see sample below). 
> Days back: 3  User: bucardo  Database: bucardo  PID of Bucardo MCP: 12887
> Name                           Type  State      PID   Last_good Time  I/U/D   Last_bad  Time
> ==============================+=====+==========+=====+=========+=====+=======+=========+====
> dictionary                    | P   |idle      |12896|?        |0s   |0/0/0  |17h59m21s|0s  

Could they be over 3 days old? It polls the bucardo.q and 
freezer.master_q table to get this information, so you 
might want to check there manually to see what's going 
on. For example:

SELECT * FROM bucardo.q
WHERE sync = 'dictionary'
AND aborted IS NULL
AND ended IS NOT NULL
ORDER BY ended DESC LIMIT 1;

SELECT * FROM freezer.master_q
WHERE sync = 'dictionary'
AND aborted IS NULL
AND ended IS NOT NULL
ORDER BY ended DESC LIMIT 1;

> in the "bc status mailaddresses_t1db2 " display snip below it gives a 
> date in the future. Is it using some time zone perhaps
> 
> Last good time:       Feb 25, 2010 03:33:28  Target: messagestore

That's pulled directly from the q table's ended field, so it's whatever 
psql is set to.

> note that bc is a link to bucardo_ctl so my keyboard does not wear out :)

I've aliases it to 'b': who needs two letters (plus, I use the 'bc' unix 
utility often)

> In the following snip of bc status what does "WAIT:6m44s" mean
> 
> tblmails_t1                   | P   |WAIT:6m44s|12899|?        |4s   |0/0/0    |?       |0s  
> tblmails_t2                   | P   |WAIT:6m39s|12891|?        |3s   |0/0/0    |?       |0s 

It means as far as the program can tell, the sync is actively running and started 
6 minutes ago.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100225/7e323150/attachment.bin