181115 - search took too long

Status: RESOLVED DUPLICATE of bug 157952

(Bugzilla :: Query/Bug List, defect)

Description

[timeless]

Please stand by ...
Content-type: text/html
Software error:

SELECT bugs.bug_id, bugs.bug_severity, map_assigned_to.login_name,
bugs.bug_status, bugs.resolution, map_products.name, map_components.name,
map_qa_contact.login_name, bugs.short_desc FROM bugs, profiles AS
map_assigned_to LEFT JOIN profiles map_qa_contact ON bugs.qa_contact =
map_qa_contact.userid, products AS map_products, components AS map_components,
longdescs longdescs_ LEFT JOIN bug_group_map  ON bug_group_map.bug_id =
bugs.bug_id  AND bug_group_map.group_id NOT IN (2,4,7,9,10,12)  LEFT JOIN cc ON
cc.bug_id = bugs.bug_id AND cc.who = 15223  WHERE bugs.assigned_to =
map_assigned_to.userid AND bugs.product_id = map_products.id AND
bugs.component_id = map_components.id AND longdescs_.bug_id = bugs.bug_id AND
(bugs.product_id IN (1)) AND (INSTR(LOWER(longdescs_.thetext), 'dependent') AND
INSTR(LOWER(longdescs_.thetext), 'window') AND INSTR(LOWER(longdescs_.thetext),
'created') AND INSTR(LOWER(longdescs_.thetext), 'without') AND
INSTR(LOWER(longdescs_.thetext), 'a') AND INSTR(LOWER(longdescs_.thetext),
'parent')) AND ((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible
= 1 AND bugs.reporter = 15223)     OR (bugs.cclist_accessible = 1 AND cc.who IS
NOT NULL)     OR (bugs.assigned_to = 15223) OR (bugs.qa_contact = 15223) ) GROUP
BY bugs.bug_id ORDER BY bugs.bug_id : Server shutdown in progress at globals.pl
line 283.

For help, please send mail to the webmaster ([e-mail]), giving this
error message and the time and date of the error.

Comment 1

[Bradley Baetz (:bbaetz)]

You're searching through the text of every single comment ever made 6 times.
Yes, this will take a while.

mysql may even be doing the TOLOWER 6 times, although I'd hope not.

I'm tempted to INVALID this. Theres nothing bugzilla can do, really. Since mysql
does case insensitive compares, I guess we could drop the TOLOWER, although I'm
not convinved that that would buy us much

Comment 2

[Dave Miller [:justdave]]

*** This bug has been marked as a duplicate of 157952 ***