# Upload service degradation.

- Provider: [Uploadcare](https://down.guide/uploadcare)
- Level: confirmed
- Impact: Partial outage
- lasted 9h 29m
- started 2018-12-12 23:34 UTC
- Upload API
- id: DWN-0a599fdaa2
- Official page: http://stspg.io/68e480f3a

## Updates from Uploadcare
### 2018-12-12 23:34 UTC: investigating
We're experiencing issues with out Upload API.

### 2018-12-12 23:44 UTC: investigating
We are continuing to investigate this issue.

### 2018-12-13 01:27 UTC: identified
The issue has been identified and a fix is being implemented.

### 2018-12-13 01:54 UTC: monitoring
A fix has been implemented and we are monitoring the results.

### 2018-12-13 09:03 UTC: resolved
This incident has been resolved.

### 2018-12-17 16:43 UTC: postmortem
On December 12, we had a degradation of our Upload API. Most users were unable to upload files for 3 hours 11 minutes between Dec 12, 22:39 GMT and Dec 13, 01:50 GMT.
## What happened
Requests to Upload API were either handled extremely slowly or \\(most of them\\) rejected by our web workers. Scaling up our Upload API fleet didn't help.
## What really happened
Further investigation revealed that: 
— Slow requests were consuming all available web workers and without available workers requests were rejected by nginx. 
— Handled requests were slow due to constant database locks on one database table. 
— Database locks were caused by dramatical change of tracked usage statistics \\(change of project settings by one of our largest customers\\).
We've spent most of the time during incident on investigation and figuring our what is happening. Actual DB load was average, and DB was wrongly dismissed as source of issues at first. Once we've the root cause, the fix was trivial and took minutes to implement and deploy.
## What we have done
We turned off usage tracking for particular customer.
## What we will do
— Refactor statistic tracking, so it does not affect our core service. 
— Add more specific monitors to our DB, so we could identify problems of similar nature much faster.

---
down.guide reads providers' official status pages every minute and adds its own evidence, always labeled. Free, no account. Agents: MCP at https://down.guide/mcp, REST at https://down.guide/api/v1, feeds at https://down.guide/feed. Built by Sazabi (https://sazabi.com/?utm_source=down-guide&utm_medium=markdown).