lstewart at superb
Sep 26, 2009, 9:26 PM
Post #1 of 1
(548 views)
Permalink
|
|
Upgraded to RT 3.8.5 and RTIR 2.4.1 and now get hanging when clicking "Lookup IP" in a make clicky
|
|
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).
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:
http://ir.hopone.net/RTIR/Tools/Lookup.html?ticket=10177&type=ip&q=209.160.34.162
The rwhois server is working fine after I kill off the stalled MySQL
processes.
And it results in a super long query being executed that never seems to
finish like this:
| 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 = main.id ) JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_4 ON ( ObjectCustomFieldValues_4.Disabled = '0' )
AND ( ObjectCustomFieldValues_4.ObjectType = 'RT::Ticket' ) AND (
ObjectCustomFieldValues_4.CustomField = '13' ) AND (
ObjectCustomFieldValues_4.ObjectId = main.id ) JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_1 ON ( ObjectCustomFieldValues_1.CustomField = '13'
) AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND (
ObjectCustomFieldValues_1.Disabled = '0' ) AND (
ObjectCustomFieldValues_1.ObjectId = main.id ) JOIN Transactions
Transactions_5 ON ( Transactions_5.ObjectId = main.id ) JOIN
ObjectCustomFieldValues ObjectCustomFieldValues_2 ON (
ObjectCustomFieldValues_2.Disabled = '0' ) AND (
ObjectCustomFieldValues_2.ObjectId = main.id ) 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 = main.id) |
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:
| 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 = main.id ) JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_4 ON ( ObjectCustomFieldValues_4.Disabled = '0' )
AND ( ObjectCustomFieldValues_4.ObjectType = 'RT::Ticket' ) AND (
ObjectCustomFieldValues_4.CustomField = '13' ) AND (
ObjectCustomFieldValues_4.ObjectId = main.id ) JOIN ObjectCustomFieldValues
ObjectCustomFieldValues_1 ON ( ObjectCustomFieldValues_1.CustomField = '13'
) AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND (
ObjectCustomFieldValues_1.Disabled = '0' ) AND (
ObjectCustomFieldValues_1.ObjectId = main.id ) JOIN Transactions
Transactions_5 ON ( Transactions_5.ObjectId = main.id ) JOIN
ObjectCustomFieldValues ObjectCustomFieldValues_2 ON (
ObjectCustomFieldValues_2.Disabled = '0' ) AND (
ObjectCustomFieldValues_2.ObjectId = main.id ) 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 = main.id) |
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.
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.
--
Landon Stewart <LStewart [at] SUPERB>
SuperbHosting.Net by Superb Internet Corp.
Toll Free: 888-354-6128 x 4199 (US/Canada)
Web hosting and more "Ahead of the Rest": http://www.superbhosting.net
|
