Project

General

Profile

Bug #6731

Out-of-control queries on production server

Added by Boone Gorges over 2 years ago. Updated 2 months ago.

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

83%

Estimated time:
(Total: 0.00 h)

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

Bug #6710: GES resulting in infinite loopResolvedRaymond Hoh

Bug #6734: PressForward RSS fetching requires very large number of queriesRejectedBoone Gorges

Bug #6740: LayerSlider plugin runs table-sniffing routine across entire network on activationResolvedBoone Gorges

Bug #6743: etivite_bp_group_adminmod_member_before_save seems to have a bug that causes an infinite loopResolvedRaymond Hoh

Bug #6746: bp-multiple-forum-post activity "backfilling" is sometimes causing infinite query loopResolvedDaniel Jones

Bug #6749: BPEO iCal request can trigger very large number of DB queriesNewRaymond Hoh


Related issues

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

History

#1 Updated by Boone Gorges over 2 years ago

  • Target version set to 1.11

The immediate problem seems to be solved. Let's continue to chip away at items during this dev cycle.

#2 Updated by Boone Gorges about 2 years ago

  • Target version changed from 1.11 to 1.12

#3 Updated by Boone Gorges over 1 year ago

  • Status changed from New to Resolved

I think we've done all the work it's worthwhile to do on this ticket, especially as we're no longer seeing performance issues.

#4 Updated by Boone Gorges over 1 year ago

  • Related to Bug #8930: Throttle Jetpack batch routines added

Also available in: Atom PDF