[Bucardo-general] relation bucardo.delta_pg_toast_pg_toast_xxx does not exist
Videanu Adrian
videanuadrian at yahoo.com
Sun Oct 17 09:24:11 UTC 2021
Hi All,
I have a master-master postgresql bucardo (version 5.4.1) cluster.
This morning I replaced one of the servers that were running PostgreSQL 9.3 with one the is running PostgreSQL 13. The procedure was the following:
1. Bucardo was stopped2. Export all the databases from old server (pg_dump -Fc ....)
3. Import all the databases to new server4. switch the old server IP to new server (so that for bucardo we would have the same connection info)
5. start bucardo
it seems that aonce started I got errors like:
(6266) [Sun Oct 17 12:13:39 2021] VAC Warning! VAC was killed at line 7737: DBD::Pg::st pg_result failed: ERROR: relation "bucardo.delta_pg_toast_pg_toast_50507" does not exist
LINE 1: DELETE FROM bucardo.delta_pg_toast_pg_toast_50507 USING (SEL...
^
QUERY: DELETE FROM bucardo.delta_pg_toast_pg_toast_50507 USING (SELECT txntime AS tt FROM bucardo.track_pg_toast_pg_toast_50507 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/lib64/perl5/5.20.2/Bucardo.pm line 7737.
Any idea how should I proceed?
Regards, Adrian VideanuSkype: videanu.adrianTel:+40723864025
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211017/ce93ee94/attachment.htm>
More information about the Bucardo-general
mailing list