156628 - Software error running a preset query

Status: RESOLVED DUPLICATE of bug 151817

(Bugzilla :: Query/Bug List, defect)

Description

[Andrei Boros]

My bugzilla handle is [e-mail].

In the last 3 days while trying to run a preset query I saved some time ago, I
get the following error: 

I sent email to webmaster as suggested at the bottom of the text.
Since I get this repeatedly, I am also filing it as a bug report.

============= returned error =======================
Please stand by ...
Content-type: text/html
Software error:
SELECT DISTINCT bugs.bug_id, bugs.groupset, bugs.bug_severity, bugs.priority,
bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution,
bugs.short_desc FROM bugs, profiles map_assigned_to, profiles map_reporter LEFT
JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid,
longdescs longdescs_, profiles longdescnames_ LEFT JOIN cc cc_ ON bugs.bug_id =
cc_.bug_id LEFT JOIN profiles map_cc_ ON cc_.who = map_cc_.userid LEFT JOIN cc
selectVisible_cc ON bugs.bug_id = selectVisible_cc.bug_id AND
selectVisible_cc.who = 47002 WHERE ((bugs.groupset & 0) = bugs.groupset OR
(bugs.reporter_accessible = 1 AND bugs.reporter = 47002) OR
(bugs.cclist_accessible = 1 AND selectVisible_cc.who = 47002 AND not
isnull(selectVisible_cc.who)) OR (bugs.assigned_to = 47002) OR (bugs.qa_contact
= 47002)) AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter =
map_reporter.userid AND longdescs_.bug_id = bugs.bug_id AND longdescs_.who =
longdescnames_.userid AND bugs.reporter = map_reporter.userid AND (bugs.product
= 'Browser') AND (bugs.bug_status = 'UNCONFIRMED' OR bugs.bug_status = 'NEW' OR
bugs.bug_status = 'ASSIGNED' OR bugs.bug_status = 'REOPENED' OR bugs.bug_status
= 'RESOLVED' OR bugs.bug_status = 'VERIFIED' OR bugs.bug_status = 'CLOSED') AND
(bugs.op_sys = 'All') AND (INSTR(LOWER(map_reporter.login_name),
'[e-mail]') OR INSTR(LOWER(map_cc_.login_name),
'[e-mail]') OR INSTR(LOWER(longdescnames_.login_name),
'[e-mail]')) ORDER BY bugs.priority, bugs.bug_severity : Server
shutdown in progress at globals.pl line 276.

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

Comment 1

[Jouni Heikniemi]

There are several problems that are related to certain queries being run. For
this particular instance, the problem is the sort by importance combined with
substring email address searches. See bug 151817 for more information.

Comment 2

[Ralf Hauser]

I got a similar one when looking for bugs I reported/am CCed and bzbarsky QA/CCed:
http://bugzilla.mozilla.org/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&emailassigned_to1=1&emailcc1=1&emailtype1=exact&email1=hauser%40acm.org&emailqa_contact2=1&emailcc2=1&emailtype2=exact&email2=bzbarsky%40mit.edu&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0=

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

SELECT bugs.bug_id, bugs.creation_ts, bugs.bug_severity, bugs.priority,
bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution,
map_products.name, bugs.short_desc FROM bugs, profiles AS map_assigned_to,
products AS map_products LEFT JOIN cc cc_ ON bugs.bug_id = cc_.bug_id AND
cc_.who IN(56971) LEFT JOIN cc cc_ ON bugs.bug_id = cc_.bug_id AND cc_.who
IN(20209) LEFT JOIN profiles map_qa_contact ON bugs.qa_contact =
map_qa_contact.userid LEFT JOIN bug_group_map  ON bug_group_map.bug_id =
bugs.bug_id  WHERE bugs.assigned_to = map_assigned_to.userid AND bugs.product_id
= map_products.id AND bugs.assigned_to = map_assigned_to.userid AND
((map_assigned_to.login_name IN ('[e-mail]')) OR (cc_.who IS NOT NULL))
AND ((cc_.who IS NOT NULL) OR (map_qa_contact.login_name IN
('[e-mail]'))) AND ((bug_group_map.group_id IS NULL)) GROUP BY
bugs.bug_id ORDER BY bugs.bug_id : Not unique table/alias: 'cc_' 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. 
---------
When I also add bzbarsky as commenter, I get the following warning:
<<You are searching on a combination of email fields that will not return a
result due to a bug in Bugzilla's database software. When searching on the CC or
Added comment fields, do not search on other email fields at the same time.>>

Comment 3

[Robert Pollak]

I see a similar bug: The query
http://bugzilla.mozilla.org/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&emailtype1=substring&email1=&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&remaction=run&namedcmd=blocking1.3%2B&order=Reuse+same+sort+as+last+time&field0-0-0=flagtypes.name&type0-0-0=substring&value0-0-0=blocking1.4a%2B

(looking for bugs with a flag containing "blocking1.4a+")
failed several times during the last weeks.
An example of the received error:

----------------------
Software error:

SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.rep_platform,
map_assigned_to.login_name, map_reporter.login_name, bugs.bug_status,
bugs.resolution, map_products.name, bugs.short_desc FROM bugs, profiles AS
map_assigned_to, profiles AS map_reporter, products AS map_products LEFT JOIN
flags flags_0 ON bugs.bug_id = flags_0.bug_id LEFT JOIN flagtypes flagtypes_0 ON
flags_0.type_id = flagtypes_0.id LEFT JOIN bug_group_map  ON
bug_group_map.bug_id = bugs.bug_id  AND bug_group_map.group_id NOT IN (9,10) 
LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 25874  WHERE
bugs.assigned_to = map_assigned_to.userid AND bugs.reporter =
map_reporter.userid AND bugs.product_id = map_products.id AND
(INSTR(LOWER(CONCAT(flagtypes_0.name, flags_0.status)), 'blocking1.4a+')) AND
((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 25874)     OR (bugs.cclist_accessible = 1 AND cc.who IS NOT
NULL)     OR (bugs.assigned_to = 25874) OR (bugs.qa_contact = 25874) ) GROUP BY
bugs.bug_id ORDER BY bugs.bug_id : Server shutdown in progress at globals.pl
line 283.

Comment 4

[Dave Miller [:justdave]]

Robert, yours is different.

> : Server shutdown in progress at globals.pl line 283.

Your query took too long (>5 minutes) and was killed to preserve the server's
sanity.  Probably the server was under high load at the time or something.

Comment 5

[Robert Pollak]

I see. I made the mistake to think that the "Server shutdown in progress", which
also appears in the original description, is an essential property of this bug.
But now it's clear that this can be caused by any slow and expensive query.

Comment 6

[Joel Peshkin]

[e-mail] seems to care about these so they wont make 2.18.  If
someone adopts them, they can move them back. Retargetting to 2.20

Comment 7

[Max Kanat-Alexander]

Yeah, I think the original problem is what jouni describes in comment 1.

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