Project

General

Profile

Actions
Copy link

Bug #6731

closed

Out-of-control queries on production server

Added by Boone Gorges over 7 years ago. Updated about 5 years ago.

Status:
Resolved
Priority name:
Low
Assignee:
Boone Gorges
Category name:
-
Target version:
1.12
Start date:
2016-11-14
Due date:
% Done:

83%

Estimated time:
(Total: 0.00 h)
Deployment actions:

Description

This is a master ticket to track potential causes of recent performance problems on the production server.

Symptom: Webserver RAM occasionally spikes, with no corresponding traffic increase. Spikes correspond to highly increased traffic between webserver and database server, suggesting a query loop that's out of control.

I've been collecting diagnostic data over the past 24 hours about the following:
- requests that trigger large numbers of database queries
- requests that take a very long time to complete

and I have some preliminary findings, which I'll spell out in specific tickets.

Subtasks 6 (1 open — 5 closed)

Bug #6710: GES resulting in infinite loopResolvedRaymond Hoh2016-11-14

Actions
Bug #6734: PressForward RSS fetching requires very large number of queriesRejectedBoone Gorges2016-11-15

Actions
Bug #6740: LayerSlider plugin runs table-sniffing routine across entire network on activationResolvedBoone Gorges2016-11-15

Actions
Bug #6743: etivite_bp_group_adminmod_member_before_save seems to have a bug that causes an infinite loopResolvedRaymond Hoh2016-11-15

Actions
Bug #6746: bp-multiple-forum-post activity "backfilling" is sometimes causing infinite query loopResolvedDaniel Jones2016-11-15

Actions
Bug #6749: BPEO iCal request can trigger very large number of DB queriesNewRaymond Hoh2016-11-15

Actions

Related issues

Related to CUNY Academic Commons - Bug #8930: Throttle Jetpack batch routinesResolvedBoone Gorges2017-11-22

Actions
Actions
Copy link

Also available in: Atom PDF