Never mind. I had my application running on the origin. Stopping the application fixed the problem.
Thanks, Ujwal --- "Ujwal S. Setlur" <[EMAIL PROTECTED]> wrote: > 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 > _______________________________________________ > Slony1-general mailing list > [email protected] > http://gborg.postgresql.org/mailman/listinfo/slony1-general > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
