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 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: digitech_slonik_nodes.sh
Type: application/x-shellscript
Size: 8682 bytes
Desc: 353016560-digitech_slonik_nodes.sh
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060321/3e22d6e3/digitech_slonik_nodes.bin