[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