1589726 - bugzilla-dev runs out of memory for certain queries

Status: RESOLVED WONTFIX

(bugzilla.mozilla.org :: Infrastructure, defect)

Description

[David Lawrence [:dkl]]

[Bugzilla.App] DBD::mysql::db selectcol_arrayref failed: Out of sort memory, consider increasing server sort buffer size [for Statement "SELECT bugs.bug_id AS bug_id, map_component.name AS component, bugs.short_desc AS short_desc, bugs.bug_status AS bug_status, bugs.priority AS priority, CASE WHEN INSTR(CAST(map_assigned_to.login_name AS BINARY), CAST('@' AS BINARY)) != 0 THEN SUBSTR(map_assigned_to.login_name, 1, INSTR(CAST(map_assigned_to.login_name AS BINARY), CAST('@' AS BINARY)) - 1) ELSE map_assigned_to.login_name END AS assigned_to
FROM bugs
LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id
INNER JOIN components AS map_component ON bugs.component_id = map_component.id
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
WHERE bugs.creation_ts IS NOT NULL
AND secu

Comment 1

[Chris Kolosiwsky [:ckolos] (ckolos has left the building)]

Attachment: Swap util from 2019/10/1 to 2019/10/21

Comment 2

[Chris Kolosiwsky [:ckolos] (ckolos has left the building)]

Attachment: Freeable memory from 2019/10/01 to 2019/10/21

Comment 3

[Chris Kolosiwsky [:ckolos] (ckolos has left the building)]

Looking at the AWS metrics for the -dev DB instance, I'm really not seeing an RDS memory issue.

Looking at the swap utilization graph for the month of october to date, I see that there's one spike in memory pressure corresponding with a drop in freeable memory, but this only occurs once during the month.

Does this code run frequently on -dev or was this a one time incident?

Comment 4

[Chris Kolosiwsky [:ckolos] (ckolos has left the building)]

Closing this due to age. If this is still an issue, feel free to reopen.