On 4/21/2010 2:35 AM, Jaime Casanova wrote:
> Hi,
> 
> A customer of mine has the tendency of not follow instructions :(
> Recently i found that a table that is audited with table_log was
> modified without considering the log table (so the log table wasn't
> writing and neither the audited one), to fix that i drop the log table
> from the replication, renamed it and create a new one with the missing
> column...
> 
> then i tried to readd it to the replication i tried with the same id
> number it had before but when i subscribe the set get an error on the
> receiver that that tab_id exists so i tried it with a new number

This is suspicious. Is it possible that the original SET DROP TABLE 
failed on the subscriber and that the event was manually deleted from 
sl_event? This would be the only way I could envision how to force that 
existing tab_id on subscribe.


Jan

> """
> 2010-04-21 00:28:59 ECT DEBUG3 remoteWorkerThread_1: table
> "audit_log"."tcom_control_actividad_fecha" does not require Slony-I
> serial key
> 2010-04-21 00:28:59 ECT ERROR  remoteWorkerThread_1: "select
> "_sncp_incop_cluster".setAddTable_int(999, 259,
> '"audit_log"."tcom_control_actividad_fecha"',
> 'tcom_control_actividad_fecha_pkey', ''); " PGRES_FATAL_ERROR ERROR:
> Slony-I: setAddTable_int: table id 259 has already been assigned!
> """
> 
> so i unsubscribe the set, drop the table from the replica, and re add
> it again with a new tab_id... but when i try  to subscribe it doesn't
> get subscribed and the table doesn't copy and i get this error on the
> receiver
> """
> 2010-04-21 01:01:55 ECT DEBUG2 remoteListenThread_1: queue event
> 1,819616 SUBSCRIBE_SET
> 2010-04-21 01:01:55 ECT DEBUG2 remoteListenThread_1: queue event
> 1,819617 ENABLE_SUBSCRIPTION
> 2010-04-21 01:01:59 ECT DEBUG1 copy_set 999
> 2010-04-21 01:01:59 ECT ERROR  remoteWorkerThread_1: node -1 not found
> in runtime configuration
> 2010-04-21 01:01:59 ECT WARN   remoteWorkerThread_1: data copy for set
> 999 failed 539 times - sleep 60 seconds
> """
> 
> now, i'm getting this message every often... ideas?
> 


-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin