How to identify transient errors in NET Standard 2.1 with MySql.Data.MySqlClient.MySqlException?

Question

I'm writing my app with NET Standard 2.1 and MySql (NuGet pack MySql.Data). The MySqlException doesn't have the property IsTransient so I can't recognize if the exception is temporary. How can I manage this? Is there a list of error code that are transient? I can't find it.

Thanks

Bradley Grainger · Accepted Answer · 2022-07-23 05:08:22Z

0

If switching NuGet packages is an option for you, the MySqlConnector package (disclaimer: I'm the lead author) implements this property: https://github.com/mysql-net/MySqlConnector/issues/849

Otherwise, you could borrow its logic:

public static bool IsTransient(MySqlException ex) => (MySqlErrorCode) ex.Code
    is MySqlErrorCode.ConnectionCountError
    or MySqlErrorCode.LockDeadlock
    or MySqlErrorCode.LockWaitTimeout
    or MySqlErrorCode.UnableToConnectToHost
    or MySqlErrorCode.XARBDeadlock

answered Jul 23, 2022 at 5:08

Bradley Grainger

28.3k4 gold badges95 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to identify transient errors in NET Standard 2.1 with MySql.Data.MySqlClient.MySqlException?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related