Hi, I am using slony1.1.5 on postgresql 8.0.3 to set up replication between an origin and a subscriber. I am getting some failures when setting up the set (I have only one) on the origin:
<stdin>:36: PGRES_FATAL_ERROR select "_digitech_cluster".setAddTable(1, 17, 'public.dt_event', 'dt_event_pkey', ''); - ERROR: deadlock detected DETAIL: Process 6071 waits for AccessExclusiveLock on relation 29880264 of database 29880093; blocked by process 6057. Process 6057 waits for AccessShareLock on relation 29880184 of database 29880093; blocked by process 6071. CONTEXT: SQL statement "lock table "public"."dt_event" in access exclusive mode" PL/pgSQL function "altertableforreplication" line 51 at execute statement SQL statement "SELECT "_digitech_cluster".alterTableForReplication( $1 )" PL/pgSQL function "setaddtable_int" line 80 at perform SQL statement "SELECT "_digitech_cluster".setAddTable_int( $1 , $2 , $3 , $4 , $5 )" PL/pgSQL function "setaddtable" line 37 at perform <stdin>:66: ERROR: SLONIK FAILED ADDIN TABLES I have a script that sets this up. This script used to work just fine on 1.1.1 that I was using until recently. I am attaching the script for reference. Can anyone help? I really need to get this replication going. Thanks, Ujwal __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
digitech_slonik_nodes.sh
Description: 353016560-digitech_slonik_nodes.sh
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
