<div dir="ltr">Hello,<div><br></div><div>I thought I was out of the woods but apparently not. I changed the index name and the slonik_drop_table apparently worked</div><div>However I am still getting the following error in the slony log and it has suspended replication:</div><div><br></div><div> "<font color="#0000ff">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</font></div><div><font color="#0000ff"><br></font></div><div>CONTEXT: SQL statement "SELECT "_replication".alterTableDropTriggers(p_tab_id)"</div><div>PL/pgSQL function _replication.setdroptable_int(integer) line 52 at PERFORM</div><div>2016-06-23 16:27:02 EDT CONFIG slon: child terminated signal: 9; pid: 78119, current worker pid: 78119</div><div>2016-06-23 16:27:02 EDT CONFIG slon: restart of worker in 10 seconds</div><div><br></div><div>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.</div><div><br></div><div>Any ideas, comments welcome. Thank you</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 23, 2016 at 1:44 PM, Mark Steben <span dir="ltr"><<a href="mailto:mark.steben@drivedominion.com" target="_blank">mark.steben@drivedominion.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">In answer to my own question - yes the primary key index on the table itself <div>has to match with the entry in sl_table because the function <span style="font-size:12.8px">alterTableDropTriggers()</span></div><div><span style="font-size:12.8px">runs a join requiring a match for tables, indices and schema names. I had changed the</span></div><div><span style="font-size:12.8px">pk name a couple months back which did not change the name in sl_table, hence the </span></div><div><span style="font-size:12.8px">'NOT FOUND'</span></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 23, 2016 at 12:00 PM, Mark Steben <span dir="ltr"><<a href="mailto:mark.steben@drivedominion.com" target="_blank">mark.steben@drivedominion.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Yes it does - only one replica being used.<div>Question - do the index names on the master and replica have to match?</div></div><div class="gmail_extra"><div><div><br><div class="gmail_quote">On Thu, Jun 23, 2016 at 11:47 AM, Vick Khera <span dir="ltr"><<a href="mailto:vivek@khera.org" target="_blank">vivek@khera.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><span><br><div class="gmail_quote">On Thu, Jun 23, 2016 at 9:54 AM, Mark Steben <span dir="ltr"><<a href="mailto:mark.steben@drivedominion.com" target="_blank">mark.steben@drivedominion.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div><stdin>:8: Could not drop table 140 for replication!</div></div></div><div><br></div><div></div></blockquote></div><br></span>Does that exist on all replicas?</div></div>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span>-- <br><div data-smartmail="gmail_signature"><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br><a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br> <span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br><a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br><br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br></span></span></font></span></p><font color="#888888"></font></div>
</span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div data-smartmail="gmail_signature"><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br><a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br> <span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br><a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br><br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br></span></span></font></span></p><font color="#888888"></font></div>
</div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br><a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br> <span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br><a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br><br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br></span></span></font></span></p><font color="#888888"></font></div>
</div>