LinkMenuExpand(external link)DocumentSearchCopyCopied

MySqlConnection.Open Freezes with Amazon Aurora

When using Amazon Aurora RDS, you may experience a hang when calling MySqlConnection.Open(). The immediate prior log statement will be:

[TRACE]  ServerSession  Session0.0 ServerVersion=5.7.12 supports reset connection and pipelining; sending pipelined reset connection request

The cause of this problem is Amazon Aurora not correctly supporting pipelining in the MySQL protocol. This is known to be a problem with 2.x versions of Aurora (that implement MySQL 5.7), but not with 3.x versions (that implement MySQL 8.0).

To work around it, add Pipelining = False; to your connection string to disable the pipelining feature.