Issue
Jitterbit Harmony Performance Degradation
Date
April 2, 2020
Location
NA (North America)
Duration of Issue
- Start: April 2, 2020 1:33 PDT (2020-04-02 20:33 UTC)
- Finish: April 2, 2020 1:59 PDT (2020-04-02 20:59 UTC)
- Duration: 26 minutes
Summary
An unbound query of the activity log caused system degradation while retrieving activity and status logs. This in turn caused delays in Jitterbit Harmony affecting the Management Console, API performance, and project deployment.
Mediation
After clearing the long-running query, service was restored at April 2, 2020 1:59 PM PDT (2020-04-02 20:59 UTC).
Actions
- Cleared errant query
- Captured additional data in logs
- Added additional indexes to handle this use case
- Added additional monitoring to handle this use case