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.ste...@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.ste...@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 <vi...@khera.org> wrote:
>>
>>>
>>> On Thu, Jun 23, 2016 at 9:54 AM, Mark Steben <
>>> mark.ste...@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>
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
