Hello,
We have been using the slony for the past few months. We are still in dev/test
cycle and not yet gone to production. But recently we did a switchover
operation and we got this error in the slony logs. Can you help us out in this
?? Please let me know if you need any more information. We are using slony1
2.0.1.
This is the error we got:
<stdin>:5: PGRES_FATAL_ERROR select "_evslonycluster".lockSet(1); select
pg_catalog.txid_snapshot_xmax(pg_catalog.txid_current_snapshot()); - ERROR:
deadlock detected
DETAIL: Process 12169 waits for AccessExclusiveLock on relation 17591 of
database 16386; blocked by process 1987.
Process 1987 waits for AccessShareLock on relation 17480 of database 16386;
blocked by process 12169.
CONTEXT: SQL statement "create trigger "_evslonycluster_lockedset" before
insert or update or delete on "public"."domaincontrollerinfo" for each row
execute procedure
"_evslonycluster".lockedSet
('_evslonycluster');"
PL/pgSQL function "lockset" line 44 at EXECUTE statement
Thanks.
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
