[Bucardo-general] bucardo VAC errors
Paul Theodoropoulos
paul at anastrophe.com
Mon Feb 4 23:43:43 UTC 2019
Was running Bucardo 5.4.1. Recently upgraded servers from Debian Jessie
to Debian Stretch. This upgraded postgresql from 9.4 to 9.6, and
upgraded perl from 5.20.1 to 5.24.1. I reinstalled all required perl
modules (including Bucardo).
Since then, I get errors such as these:
(27541) [Mon Feb 4 15:37:53 2019] VAC Warning! VAC was killed at line
7868: DBD::Pg::st pg_result failed: ERROR: relation
"bucardo.delta_pg_toast_pg_toast_21502_index" does not exist
LINE 1: DELETE FROM bucardo.delta_pg_toast_pg_toast_21502_index USIN...
^
QUERY: DELETE FROM bucardo.delta_pg_toast_pg_toast_21502_index USING
(SELECT txntime AS tt FROM bucardo.track_pg_toast_pg_toast_21502_index
GROUP BY 1 HAVING COUNT(*) = 1) AS foo WHERE txntime = tt AND txntime <
now() - interval '45 seconds'
CONTEXT: PL/pgSQL function bucardo.bucardo_purge_delta_oid(text,oid)
line 49 at EXECUTE
SQL statement "SELECT bucardo.bucardo_purge_delta_oid($1, myrec.tablename)"
PL/pgSQL function bucardo_purge_delta(text) line 12 at SQL statement at
/usr/local/share/perl/5.24.1/Bucardo.pm line 7868.
Just to be thorough, I upgraded to Bucardo 5.5.0 (followed all upgrade
steps), but no joy, the errors remain.
Thoughts?
By the way, really like the improvements to 'bucardo status', with more
details of what bucardo is doing 'right now'.
--
Paul Theodoropoulos
www.anastrophe.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20190204/f546167b/attachment.html>
More information about the Bucardo-general
mailing list