[Bucardo-general] CTL Creating Too Many syncrun Rows

David E. Wheeler david at justatheory.com
Thu Jul 25 13:29:40 UTC 2013


On Jul 25, 2013, at 2:47 PM, David E. Wheeler <david at justatheory.com> wrote:

> * The bar_sync CTL gets them all, and, for each, duly creates
>  a syncrun for each and sends a NOTIFY to the bar_sync KID
> * The KID gets the first NOTIFY and starts work
> * When the KID finishes its work, the CTL has by now created
>  multiple syncrun records

Scratch that. Just reviewed the code again, and it’s the KID that creates the syncrun record. However, it should be the only KID running, and running synchronously, so I cannot figure out how the duplicate records are getting in there.

> * So the KID gets confused, and leaves errors in the log such
>  as this:
> 
>        (11068) [Wed Jul 24 17:08:33 2013] KID Expected one row from end_syncrun, but got 8

This definitely happens, though. And FWIW, the status for all of those rows with no ended column is always "Finished (KID 11063)". Same damn KID.

Is KID doing something async?

Best,

Davi



More information about the Bucardo-general mailing list