High CPU Usage Observed After Updating APIM 3.2.1 to a Later U2 Level

[JanithaSampathBandara]

Description

The issue is observed while redeploying an existing API. During the redeployment flow, we identified that the following query is taking a considerable amount of time to complete.

SELECT grp.CONDITION_GROUP_ID, AUM.HTTP_METHOD, AUM.AUTH_SCHEME,
       pol.APPLICABLE_LEVEL, AUM.URL_PATTERN,
       AUM.THROTTLING_TIER, AUM.MEDIATION_SCRIPT,
       AUM.URL_MAPPING_ID, pol.DEFAULT_QUOTA_TYPE
FROM AM_API_URL_MAPPING AUM
INNER JOIN AM_API API ON AUM.API_ID = API.API_ID
LEFT OUTER JOIN AM_API_THROTTLE_POLICY pol
       ON AUM.THROTTLING_TIER = pol.NAME
LEFT OUTER JOIN AM_CONDITION_GROUP grp
       ON pol.POLICY_ID = grp.POLICY_ID
WHERE API.CONTEXT = ?
  AND API.API_VERSION = ?
  AND pol.TENANT_ID = ?
ORDER BY AUM.URL_MAPPING_ID;

From the thread dumps, we could see multiple deployment threads spending a significant amount of time waiting on the execution of this query.

Steps to Reproduce

1. Updated the APIM 3.2.1 to U2 level 96.
2. Redeploy an API

Version

APIM 3.2.1.96

Environment Details (with versions)

No response