SET AUTOCOMMIT = 1 causes session pinning with RDS Proxy #2004
Description
Describe the bug
I ran into an issue with connections getting pinned while utilizing Pomelo for connecting with RDS Proxy and Aurora MySQL. I suspect it was the set autocommit being preprended to each update statement.
To Reproduce
Setup Aurora MySQL database with RDS Proxy. Run an update command with Pomelo. Look at CloudWatch logs will show session pinning. If no logs, RDS Proxy enhanced logging may need to be enabled.
Expected behavior
Someway to opt-out of auto commit so we can specify it as part of RDS proxy if necessary.
Technical details:
- Database server version: Aurora MySQL 3.09.0(compatible with MySQL 8.0.40)
- Pomelo.EntityFrameworkCore.MySql version: 9.0.0-preview.3.efcore.9.0.0
- Other technical details: ASP.NET Core