[Bucardo-general] PG async issue
chris.keane at zoomius.com
Mon Mar 24 23:20:23 UTC 2014
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 Keane* * Track Intelligence Inc * +1 (650) 703 5523 (cell)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general