The combination of Lambda, RDS Proxy, and Aurora in the application architecture often led to the Lambda concurrency limit of 1000 being exceeded.
Connection pinning, caused by statements with a text size greater than 16 KB, led to excessive database connections in RDS Proxy.
To address the issue, a new RDS Proxy was created specifically for the problematic API, and the affected repository was redirected to use this proxy.
By routing queries triggering connection pinning to the new proxy, the Lambda concurrency was stabilized, and the Aurora connection limits were not exceeded.