Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-8136

500 Internal Server Error when using Account Find 3scale API endpoint

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Minor
    • None
    • SaaS
    • System
    • False
    • False
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Hide

      Request:

      curl -v  -X GET "https://<ADMIN-PORTAL>.3scale.net/admin/api/accounts/find.xml?access_token=<ACCESS_TOKEN>&email=<EMAIL>"
      Show
      Request: curl -v  -X GET "https://<ADMIN-PORTAL>.3scale.net/admin/api/accounts/find.xml?access_token=<ACCESS_TOKEN>&email=<EMAIL>"

    Description

      Issue
      Some queries to the Account Management API, for example Account Find endpoint, results in  500 Internal Server Error.

      Cause
      Due to the large number of queries during billing time and the System ProxyConfigs API endpoint used by APIcast (which produces mysql slow queries) there is a high increase of the CPU utilisation in mysql that produces an increase of latency in system. The number of requests that system can handle is impacted resulting in some HTTP 5XX errors. 

      Request
      Improve mysql performance.

      Attachments

        Activity

          People

            Unassigned Unassigned
            rhn-support-avilatus Anna Vila Tusell
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: