Project

General

Profile

Actions

Bug #6731

closed

Out-of-control queries on production server

Added by Boone Gorges about 6 years ago. Updated almost 4 years 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)
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 open5 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 #1

Updated by Boone Gorges about 6 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.

Actions #2

Updated by Boone Gorges almost 6 years ago

  • Target version changed from 1.11 to 1.12
Actions #3

Updated by Boone Gorges over 5 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.

Actions #4

Updated by Boone Gorges about 5 years ago

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

Also available in: Atom PDF