[Bucardo-general] Bucardo add sync failed

张远 zy20130729 at gmail.com
Tue Jun 6 02:23:58 UTC 2017

       I add a sync on production db failed , the error logs as follows
       WARNING:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=liyan;host=;port=5436 at line 29.
Failed to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::db do failed: ERROR:  deadlock detected
DETAIL:  Process 33477 waits for AccessExclusiveLock on relation 6680077 of database 1270703; blocked by process 78287.
Process 78287 waits for AccessShareLock on relation 1270891 of database 1270703; blocked by process 33477.
HINT:  See server log for query details. at line 126. at line 30.
CONTEXT:  PL/Perl function "validate_sync" at /usr/bin/bucardo line 4612.

       In my postgresql log I can see “CREATE TRIGGER "bucardo_note_trunc_liyan" 
                  AFTER TRUNCATE ON "public"."bookmark"
                  FOR EACH STATEMENT EXECUTE PROCEDURE bucardo.bucardo_note_truncation('liyan’)”  this sql is blocked by a select sql.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170606/1f728a2f/attachment.html>

More information about the Bucardo-general mailing list