[Bucardo-general] Kindly help on Bucardo Error: VAC Warning! VAC was killed at line 7727: DBD::Pg::st pg_result failed: ERROR: relation "bucardo.xyz*" does not exist

[Ravi Chaubey]

Hi Bucardo Team,



I am trying to do the replication using Bucardo[Master-Slave, Postgres 9.4
to 10.6, bucardo version-5.4.1], but facing below error during Ontimecopy.

It would be very helpful for us if you could please suggest us or provide
work around on this issue as we are struck to proceed further.



Please also provide high level performance improvements for synching
process using Bucardo[Master-Slave] replication.


Bucardo error at full copy stage:
[image: image.png]



(28995) [Sat Apr 13 04:02:44 2019] VAC Warning! VAC was killed at line
7727: DBD::Pg::st pg_result failed: ERROR:  relation
"bucardo.delta_0e07cnfmq9s6_perf_wsserviceclassstatstable_p!58cd07e17b"
does not exist

LINE 1: DELETE FROM
bucardo."delta_0e07cnfmq9s6_perf_wsserviceclasss...                ^

QUERY:  DELETE FROM
bucardo."delta_0e07cnfmq9s6_perf_wsserviceclassstatstable_p!58cd07e17b"
USING (SELECT txntime AS tt FROM
bucardo."track_0e07cnfmq9s6_perf_wsserviceclassstatstable_p!58cd07e17b"
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 statement

SQL statement "SELECT                  bucardo.bucardo_purge_delta_oid($1,
myrec.tablename)"

PL/pgSQL function bucardo.bucardo_purge_delta(text) line 12 at SQL
statement at /usr/share/perl5/Bucardo.pm line 7727.

(23941) [Sat Apr 13 04:02:44 2019] MCP Created VAC 28995





Thanks in advance.



Regards,

Ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20190413/1351cc15/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 693141 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20190413/1351cc15/attachment-0001.png>