[Bucardo-general] PG async issue

[Chris Keane]

Bucardo 4.99.11 -- just pulled all fresh.

Error was DBD::Pg::db do failed: Cannot execute until previous async query
has finished at /usr/local/share/perl/5.14.2/Bucardo.pm line 8539

Happens when there is a particular large update to be made to database that
has been offline for a while, especially if there is a laggy connection.

At line 8528 Bucardo.pm sets
my $async = PG_ASYNC;
Would there be any harm in adding PG_OLDQUERY_WAIT?
my $async = PG_ASYNC + PG_OLDQUERY_WAIT;

I admit I don't know all the details of how pg async works, so I don't know
if that's good, bad or indifferent. It does make the error go away but I'm
not sure what price I'm paying.

Chris.




-- 
*Chris Keane* * Track Intelligence Inc *  +1 (650) 703 5523 (cell)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140324/20a0a32b/attachment.html>