Getting below errors while load testing(Two nodes).
Please share your inputs on UserSwitchedRoutingDataSource. I think ComboPooledDataSource is related to max connection limit is reached(i.e. connection per nodes=max connections in MySQL)
Env information: Gateway 9.2 version, OTK 4.1 version, external single MySQL DB is being used. Two nodes
Can you please clarify the way the load test is being conducted and provide the full context of the errors? I ask because the two items you mentioned are not specifically in the form of an error, so I'm unsure of the context behind it. Without that context, I can't really assist too effectively.
Some information that may be helpful:
Thank you Dauncey for valuable inputs,
Agree, these are not may be directly related to error as I don't see in Gateway logs. But Response time increase because of this bhavior as you can see below screenshots for guest token services.
curl -X POST \ https://<gateway_host>/auth/oauth/v2/token \ -H 'authorization: Basic credential' \ -H 'content-type: application/x-www-form-urlencoded' -d grant_type=client_credentials
Please let me know if you need any additional information.
From this and your other posts, it seems you are deep into performance testing and tuning. This type of testing is usually best done and observed with the proper tools, such as CA API Performance Monitor. Then again, this concern seems to be more to do with your database.
I know that AWS sets max connections to the database based on it's instance size, so depending on how much load you're throwing at the Gateway, you may be running into MySQL connection issues that Amazon has enforced at the AWS level. You should be able to view if you've reached your max connections on the database side from the AWS console.
Is any further information needed on this one, or has the data been determined in the meantime since the last update? I think the original question should be modified too to reflect a proper error as opposed to the way it is currently written. It may be confusing to some viewers of this thread. It's a bit hard to follow what exactly is needed or being asked, so any clarification would be appreciated.