Cassandra timeout and connection issues for OAuth gateways - ( OTK Token NoSQL Revocation )

Products

• CA API Gateway

Issue/Introduction

After applying the patch OAuthSolutionKit-4.6.x-Patch-2024_08.sskar, the token store flow changed, and now it runs this other batch query which fails:

4 OTK Token NoSQL Revocation - line 191

BEGIN BATCH 
DELETE FROM oauth_access_token WHERE otk_token=${token};
DELETE FROM oauth_access_token_view_client_key WHERE client_key = ${selectQuery.client_key} AND resource_owner = ${selectQuery.resource_owner} AND otk_token = ${token};
DELETE FROM oauth_access_token_view_resource_owner WHERE resource_owner = ${selectQuery.resource_owner} AND client_key = ${selectQuery.client_key} AND otk_token = ${token};
DELETE FROM oauth_access_token_pagination WHERE client_name_otk_token = ${paginationKey};
DELETE FROM oauth_access_token_view_client_ident WHERE client_ident=${selectQuery.client_ident} AND resource_owner=${selectQuery.resource_owner} AND created=${selectQuery.created} AND otk_token=${token};

DELETE FROM oauth_access_token_by_resource_owner_pagination WHERE client_name_otk_token = ${paginationKey} AND resource_owner = ${selectQuery.resource_owner};
DELETE FROM oauth_access_token_by_resource_owner WHERE resource_owner = ${selectQuery.resource_owner} AND client_key = ${selectQuery.client_key} AND otk_token = ${token};
APPLY BATCH;

Environment

CA API Gateway 11.0

Cassandra 5.1.4

Cause

Cassandra Defect

Resolution

The IBM/Datastax Cassandra DSE team have identified a bug and has a fix coming very soon. (9/9/2024)
 
########################

IBM/Datastax confirmed, The bug was already found and patched.

The fix will be applied in the next DSE release and it will be available on the below date.

5.1.46 - RC September 4 - GA September 9, 2024
########################