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._______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
