Hello,

I thought I was out of the woods but apparently not.  I changed the index
name and the slonik_drop_table apparently worked
However I am still getting the following error in the slony log and it has
suspended replication:

  "lock table "_replication".sl_config_lock;select
"_replication".setDropTable_int(140);insert into "_replication".sl_event
  (ev_origin, ev_seqno, ev_timestamp,      ev_snapshot, ev_type , ev_data1
   ) values ('1', '5021650374', '2016-06-23 12:25:10.772052-04',
'3309223886:3309223886:', 'SET_DROP_TABLE', '140'); insert into
"_replication".sl_confirm    (con_origin, con_received, con_seqno,
con_timestamp)    values (1, 3, '5021650374', now()); commit transaction;"
PGRES_FATAL_ERROR ERROR:  Slony-I: alterTableDropTriggers(): Table with id
140 not found

CONTEXT:  SQL statement "SELECT
"_replication".alterTableDropTriggers(p_tab_id)"
PL/pgSQL function _replication.setdroptable_int(integer) line 52 at PERFORM
2016-06-23 16:27:02 EDT CONFIG slon: child terminated signal: 9; pid:
78119, current worker pid: 78119
2016-06-23 16:27:02 EDT CONFIG slon: restart of worker in 10 seconds

At this point all I want to do is for this process to stop. It apparently
is trying to correct my previous screw-up and I already 'corrected' it.

Any ideas, comments welcome. Thank you


On Thu, Jun 23, 2016 at 1:44 PM, Mark Steben <mark.steben at drivedominion.com>
wrote:

> In answer to my own question - yes the primary key index on the table
> itself
> has to match with the entry in sl_table because the function
> alterTableDropTriggers()
> runs a join requiring a match for tables, indices and schema names.  I had
> changed the
> pk name a couple months back which did not change the name in sl_table,
> hence the
> 'NOT FOUND'
>
> On Thu, Jun 23, 2016 at 12:00 PM, Mark Steben <
> mark.steben at drivedominion.com> wrote:
>
>> Yes it does - only one replica being used.
>> Question - do the index names on the master and replica have to match?
>>
>> On Thu, Jun 23, 2016 at 11:47 AM, Vick Khera <vivek at khera.org> wrote:
>>
>>>
>>> On Thu, Jun 23, 2016 at 9:54 AM, Mark Steben <
>>> mark.steben at drivedominion.com> wrote:
>>>
>>>> <stdin>:8: Could not drop table 140 for replication!
>>>>
>>>>
>>> Does that exist on all replicas?
>>>
>>
>>
>>
>> --
>> *Mark Steben*
>>  Database Administrator
>> @utoRevenue <http://www.autorevenue.com/> | Autobase
>> <http://www.autobase.net/>
>>   CRM division of Dominion Dealer Solutions
>> 95D Ashley Ave.
>> West Springfield, MA 01089
>> t: 413.327-3045
>> f: 413.383-9567
>>
>> www.fb.com/DominionDealerSolutions
>> www.twitter.com/DominionDealer
>>  www.drivedominion.com <http://www.autorevenue.com/>
>>
>> <http://autobasedigital.net/marketing/DD12_sig.jpg>
>>
>>
>>
>>
>
>
> --
> *Mark Steben*
>  Database Administrator
> @utoRevenue <http://www.autorevenue.com/> | Autobase
> <http://www.autobase.net/>
>   CRM division of Dominion Dealer Solutions
> 95D Ashley Ave.
> West Springfield, MA 01089
> t: 413.327-3045
> f: 413.383-9567
>
> www.fb.com/DominionDealerSolutions
> www.twitter.com/DominionDealer
>  www.drivedominion.com <http://www.autorevenue.com/>
>
> <http://autobasedigital.net/marketing/DD12_sig.jpg>
>
>
>
>


-- 
*Mark Steben*
 Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
  CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20160623/1970e11b/attachment.htm