Due to a specific API call over the 3scale API, some long running query's has been generated in the Administration Portal Database, which, was blocking a table thus blocking some of the further requests, causing intermittent issues in our 3scale APIS, Developer Portal UI and Admin portal.
The affected components were:
Preventative Measures:
We have identified the affected tables and applied the needed corrections on the queries to mitigate such degradations in the future.
Summary: