[Bucardo-general] Bucardo-general Digest, Vol 115, Issue 3

张远 zy20130729 at gmail.com
Wed Jun 7 02:12:24 UTC 2017


yes , add sync failed

2017-06-06 20:00 GMT+08:00 <bucardo-general-request at bucardo.org>:

> Send Bucardo-general mailing list submissions to
>         bucardo-general at bucardo.org
>
> 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
>         bucardo-general-request at bucardo.org
>
> You can reach the person managing the list at
>         bucardo-general-owner at bucardo.org
>
> 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: ?? <zy20130729 at gmail.com>
> To: bucardo-general at bucardo.org
> Subject: [Bucardo-general] Bucardo add sync failed
> Message-ID: <822A4089-8ACC-4CBA-AFD0-9170DD1EBBDF at gmail.com>
> 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
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>
> End of Bucardo-general Digest, Vol 115, Issue 3
> ***********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170607/f64d6e7b/attachment.html>


More information about the Bucardo-general mailing list