908443 - DBD::mysql::db selectcol_arrayref failed: Lost connection to MySQL server during query of multiple "contains any of the strings" for comment fields

Status: NEW

(Bugzilla :: Query/Bug List, defect)

Description

[Mardeg]

STR
1. Click the link in the URL field
2. Wait a few minutes

Expected results:
Buglist search results

Actual results:
The following text on the lower half while the upper half still said "Please wait while your bugs are retrieved.":



Bugzilla has suffered an internal error:

DBD::mysql::db selectcol_arrayref failed: Lost connection to MySQL server during query [for Statement "SELECT bugs.bug_id AS bug_id, bugs.bug_status AS bug_status, bugs.priority AS priority, map_assigned_to.login_name AS assigned_to FROM bugs LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id AND NOT ( security_map.group_id IN (19,10,9,119,69) ) LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 200920 INNER JOIN profiles AS map_assigned_to ON bugs.assigned_to = map_assigned_to.userid INNER JOIN bug_status AS map_bug_status ON bugs.bug_status = map_bug_status.value INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value LEFT JOIN longdescs AS longdescs_1 ON bugs.bug_id = longdescs_1.bug_id AND ((INSTR(longdescs_1.thetext, 'upload') > 0 OR INSTR(longdescs_1.thetext, 'progress') > 0 OR INSTR(longdescs_1.thetext, 'event') > 0) AND longdescs_1.isprivate = 0) LEFT JOIN longdescs AS longdescs_2 ON bugs.bug_id = longdescs_2.bug_id AND ((INSTR(longdescs_2.thetext, 'xhr') > 0 OR INSTR(longdescs_2.thetext, 'xmlhttprequest') > 0 OR INSTR(longdescs_2.thetext, 'cors') > 0) AND longdescs_2.isprivate = 0) LEFT JOIN longdescs AS longdescs_3 ON bugs.bug_id = longdescs_3.bug_id AND ((INSTR(longdescs_3.thetext, 'ssl') > 0 OR INSTR(longdescs_3.thetext, 'https') > 0 OR INSTR(longdescs_3.thetext, 'secure') > 0 OR INSTR(longdescs_3.thetext, 'tls') > 0) AND longdescs_3.isprivate = 0) WHERE bugs.creation_ts IS NOT NULL AND (security_map.group_id IS NULL OR (bugs.reporter_accessible = 1 AND bugs.reporter = 200920) OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL) OR bugs.assigned_to = 200920 OR bugs.qa_contact = 200920) AND ( ( (INSTR(bugs.short_desc, 'upload') > 0 OR INSTR(bugs.short_desc, 'progress') > 0 OR INSTR(bugs.short_desc, 'event') > 0) ) AND longdescs_1.comment_id IS NOT NULL ) AND longdescs_2.comment_id IS NOT NULL AND longdescs_3.comment_id IS NOT NULL GROUP BY bugs.bug_id ORDER BY map_bug_status.sortkey, map_bug_status.value, map_priority.sortkey, map_priority.value, assigned_to, bug_id LIMIT 500 "]

Comment 1

[Andre Klapper]

I can confirm this.