Thu Sep 3 03:20:34 PDT 2009
- Previous message: [Slony1-general] where to find data transaction log?
- Next message: [Slony1-general] Replicating 1 table from various sources
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] where to find data transaction log?
- Next message: [Slony1-general] Replicating 1 table from various sources
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list