Bug #6731

Out-of-control queries on production server

Added by Boone Gorges over 3 years ago. Updated about 1 year ago.

Priority name:
Category name:
Target version:
Start date:
Due date:
% Done:


Estimated time:
(Total: 0.00 h)


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.


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


#1 Updated by Boone Gorges over 3 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 3 years ago

  • Target version changed from 1.11 to 1.12

#3 Updated by Boone Gorges over 2 years 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 2 years ago

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

Also available in: Atom PDF