yes , add sync failed 2017-06-06 20:00 GMT+08:00 <[email protected]>:
> Send Bucardo-general mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://mail.endcrypt.com/mailman/listinfo/bucardo-general > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Bucardo-general digest..." > > > Today's Topics: > > 1. Bucardo add sync failed (??) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 6 Jun 2017 10:23:58 +0800 > From: ?? <[email protected]> > To: [email protected] > Subject: [Bucardo-general] Bucardo add sync failed > Message-ID: <[email protected]> > Content-Type: text/plain; charset="gb2312" > > Hello: > 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=127.0.0.1;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-0001.html> > > ------------------------------ > > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general > > > End of Bucardo-general Digest, Vol 115, Issue 3 > *********************************************** >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
