[Bucardo-general] relation bucardo.delta_pg_toast_pg_toast_xxx does not exist

[ManuParra]

Hi Adrian, did you maintain one of the replicas up and running with 9.3 version?



> On 17 Oct 2021, at 11:24, Videanu Adrian <videanuadrian at yahoo.com> wrote:
> 
> 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 stopped
> 2. Export all the databases from old server (pg_dump -Fc ....)
> 3. Import all the databases to new server
> 4. 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 Videanu
> Skype: videanu.adrian
> Tel:+40723864025
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://bucardo.org/mailman/listinfo/bucardo-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211021/ee328644/attachment.htm>