- Newest
- Most votes
- Most comments
Thank you for reaching out. I understand you are unable to see any data for the below metrics : DatabaseConnectionsCurrentlySessionPinned, DatabaseConnectionsCurrentlyInTransaction, DatabaseConnectionsCurrentlyBorrowed.
The above 3 metrics is a direct result of Dimension set 1, Dimension set 3, Dimension set 4 with the statistic as SUM.
Dimension set 1: ProxyName Dimension set 3: ProxyName, TargetGroup, Target Dimension set 4: ProxyName, TargetGroup, TargetRole
Additionally, Pinning is a situation when RDS Proxy cannot be sure that it is safe to reuse a database connection outside the current session. This usually occurs when the client mutates the session state (variables and configuration parameters that you can change through SET or SELECT statements). In such a case, it keeps the session on the same connection until the session ends.
Typically pinning occurs in the following conditions :
- session parameters are changed
- temp tables are created
- locking functions are called
- prepared statements are used
- user-defined variables are declared
I understand you are running query and if the block of code satisfies the above then that session will get pinned.
The above information will provide you with details to triage the issue. Please note this is general guidance only. In order to understand the issue fully, we require details that are non-public information. Please open a support case with AWS using the following link.
As always, Happy Cloud Computing.
@electric_al I have the same issue with the following metrics not showing in the RDS proxy details page metrics list: DatabaseConnectionsCurrentlyInTransaction DatabaseConnectionsCurrentlySessionPinned DatabaseConnectionsCurrentlyBorrowed ClientConnectionsSetupFailedAuth DatabaseConnectionsSetupFailed QueryDatabaseResponseLatency
I am able to add all of these metrics other than ClientConnectionsSetupFailedAuth to a cloudwatch graph directly using the metrics selection list.
The source of the issue is that the RDS proxy details page - metrics graphs configuration for these 6 metrics are filtered on the target-group and target. I have a case open with AWS support to have the metrics reconfigured for the RDS proxy details page with the filters removed.
Relevant content
- asked a year ago
- asked 3 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 4 years ago
Thanks!
Yes I can find the metrics if I go and find them in cloudwatch metrics, and I can see the values are > 0.
However my initial question was about the 'metrics' tab in the actual RDS proxy AWS section, that still shows 'no data'. From the above that a) the data is there in cloudwatch metrics and b) its not showing on the RDS proxy page, I suggest this is a bug?