I upgraded from RT 3.7.26 but I do not recall what version of RTIR was in there before. I installed RT 3.7.26 at the same time as RTIR so it would have been the release of RTIR that was available when RT 3.7.26 was available. Sorry. I checked through as many files as I could find but I don't see the old RTIR version in any of the old installation (in a backup).<br>
<br>The issue I'm having is a super long delay while a query runs but never seems to complete when clicking on a "Lookup IP" link for an IP address sending me to a URL like this:<br><a href="http://ir.hopone.net/RTIR/Tools/Lookup.html?ticket=10177&type=ip&q=209.160.34.162">http://ir.hopone.net/RTIR/Tools/Lookup.html?ticket=10177&type=ip&q=209.160.34.162</a><br>
<br>The rwhois server is working fine after I kill off the stalled MySQL processes. <br><br>And it results in a super long query being executed that never seems to finish like this:<br>| 4 | xusername | localhost | rt3 | Query | 5 | Copying to tmp table | SELECT DISTINCT main.* FROM Tickets main JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3 ON ( ObjectCustomFieldValues_3.CustomField = '13' ) AND ( ObjectCustomFieldValues_3.Disabled = '0' ) AND ( ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_3.ObjectId = <a href="http://main.id">main.id</a> ) JOIN ObjectCustomFieldValues ObjectCustomFieldValues_4 ON ( ObjectCustomFieldValues_4.Disabled = '0' ) AND ( ObjectCustomFieldValues_4.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_4.CustomField = '13' ) AND ( ObjectCustomFieldValues_4.ObjectId = <a href="http://main.id">main.id</a> ) JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( ObjectCustomFieldValues_1.CustomField = '13' ) AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_1.Disabled = '0' ) AND ( ObjectCustomFieldValues_1.ObjectId = <a href="http://main.id">main.id</a> ) JOIN Transactions Transactions_5 ON ( Transactions_5.ObjectId = <a href="http://main.id">main.id</a> ) JOIN ObjectCustomFieldValues ObjectCustomFieldValues_2 ON ( ObjectCustomFieldValues_2.Disabled = '0' ) AND ( ObjectCustomFieldValues_2.ObjectId = <a href="http://main.id">main.id</a> ) AND ( ObjectCustomFieldValues_2.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_2.CustomField = '13' ) WHERE (main.Status != 'deleted') AND (Transactions_5.ObjectType = 'RT::Ticket') AND ( ( ( ( ( ( ObjectCustomFieldValues_1.Content <= '209.160.034.162' OR ( ( ObjectCustomFieldValues_1.Content = '' OR ObjectCustomFieldValues_1.Content IS NULL ) AND ObjectCustomFieldValues_1.LargeContent <= '209.160.034.162' ) ) ) ) AND ( ( ( ObjectCustomFieldValues_2.LargeContent >= '209.160.034.162' ) ) ) AND ( ( ( ObjectCustomFieldValues_3.Content >= '000.000.000.000' OR ( ( ObjectCustomFieldValues_3.Content = '' OR ObjectCustomFieldValues_3.Content IS NULL ) AND ObjectCustomFieldValues_3.LargeContent >= '000.000.000.000' ) ) ) ) AND ( ( ( ObjectCustomFieldValues_4.LargeContent <= '255.255.255.255' ) ) ) ) ) AND ( Transactions_5.Created > '2009-07-29 11:09:47' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = <a href="http://main.id">main.id</a>) |<br>
<br><br>After waiting I'll kill that process ("mysqladmin -u root -p kill 4") and I'll get another long query that never completes like this:<br>| 25 | root | localhost | rt3 | Query | 2 | Copying to tmp table | SELECT DISTINCT main.* FROM Tickets main JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3 ON ( ObjectCustomFieldValues_3.CustomField = '13' ) AND ( ObjectCustomFieldValues_3.Disabled = '0' ) AND ( ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_3.ObjectId = <a href="http://main.id">main.id</a> ) JOIN ObjectCustomFieldValues ObjectCustomFieldValues_4 ON ( ObjectCustomFieldValues_4.Disabled = '0' ) AND ( ObjectCustomFieldValues_4.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_4.CustomField = '13' ) AND ( ObjectCustomFieldValues_4.ObjectId = <a href="http://main.id">main.id</a> ) JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( ObjectCustomFieldValues_1.CustomField = '13' ) AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_1.Disabled = '0' ) AND ( ObjectCustomFieldValues_1.ObjectId = <a href="http://main.id">main.id</a> ) JOIN Transactions Transactions_5 ON ( Transactions_5.ObjectId = <a href="http://main.id">main.id</a> ) JOIN ObjectCustomFieldValues ObjectCustomFieldValues_2 ON ( ObjectCustomFieldValues_2.Disabled = '0' ) AND ( ObjectCustomFieldValues_2.ObjectId = <a href="http://main.id">main.id</a> ) AND ( ObjectCustomFieldValues_2.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_2.CustomField = '13' ) WHERE (main.Status != 'deleted') AND (Transactions_5.ObjectType = 'RT::Ticket') AND ( ( ( ( ( ( ObjectCustomFieldValues_1.Content <= '209.160.034.162' OR ( ( ObjectCustomFieldValues_1.Content = '' OR ObjectCustomFieldValues_1.Content IS NULL ) AND ObjectCustomFieldValues_1.LargeContent <= '209.160.034.162' ) ) ) ) AND ( ( ( ObjectCustomFieldValues_2.LargeContent >= '209.160.034.162' ) ) ) AND ( ( ( ObjectCustomFieldValues_3.Content >= '000.000.000.000' OR ( ( ObjectCustomFieldValues_3.Content = '' OR ObjectCustomFieldValues_3.Content IS NULL ) AND ObjectCustomFieldValues_3.LargeContent >= '000.000.000.000' ) ) ) ) AND ( ( ( ObjectCustomFieldValues_4.LargeContent <= '255.255.255.255' ) ) ) ) ) AND ( Transactions_5.Created > '2009-07-29 11:09:47' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = <a href="http://main.id">main.id</a>) |<br>
<br>And I'll get a third one too after killing off the second one although this time I didn't but nothing good in the resulting page. It displays empty fields even though I know there are other incidents and at least one investigation for that IP address.<br>
<br>I have numerous indexes on numerous tables but they are all as per the SQL patches during the upgrade. Perhaps I'm missing some indexes or skipped something in an upgrade path (upgrade to XYZ before ABC for example). If I can provide other information that might help troubleshoot this please let me know. This is really slowing down the processing of abuse related incidents reported to us.<br clear="all">
<br>-- <br>Landon Stewart <<a href="mailto:LStewart@SUPERB.NET">LStewart@SUPERB.NET</a>><br>SuperbHosting.Net by Superb Internet Corp.<br>Toll Free: 888-354-6128 x 4199 (US/Canada)<br>Web hosting and more "Ahead of the Rest": <a href="http://www.superbhosting.net">http://www.superbhosting.net</a><br>