Hi list, We have attempted to use Bucardo to migrate from PG9.6 to PG11 in AWS Aurora[1], but unfortunately, after about an hour of running sync, locking queries start piling up like crazy until the DB becomes unreachable, a failover is triggered, and we are able to drop the bucardo schema, resolving the locking, which gets the DB healthy again.
Any tips on where to start trying to figure out the cause? Unfortunately, I do not have available backups of the database when the schema was created, and bucardo logs don't show anything meaningful. https://drive.google.com/file/d/1FEdmPfxE9rtaf39OAF8UDOl2_lclgu1J/view?usp=sharing https://drive.google.com/file/d/1GwtXPyJBxPCzoV9MaTR-v9ue1ViJya4b/view?usp=sharing Best, [1] bucardo add sync pg11migration relgroup=alpha dbs=aurora9:source,aurora11:target onetimecopy=2 conflict_strategy=bucardo_source _______________________________________________ Bucardo-general mailing list Bucardo-general@bucardo.org https://bucardo.org/mailman/listinfo/bucardo-general