How to match on MySQL deadlock?

[waynerobinson]

I don't seem to be able to work out how to match on a deadlock error.

When a MySQL query fails on deadlock it returns Database(MySqlDatabaseError { code: Some("40001"), number: 1213, message: "Deadlock found when trying to get lock; try restarting transaction" }) however, I don't seem to be able to create a matcher for that as it seems it's private.

Is there some example of matching on this deadlock error or potentially some automated retry logic for dealing with temporary deadlocks in contentious environments?

[Sandelinos]

Maybe there is some other cleaner way of doing it but this worked for me:

match sqlx::query("SQL QUERY")
    .execute(&pool)
    .await
{
    Ok => (),
    Err(sqlx::Error::Database(e)) if e.code().as_deref() == Some("40001") => {
        // Deadlock error
    },
    Err(e) => {
        // Some other error
        debug!("Database error: {:?}", e);
    }
};

(I'm just learning and spent many hours trying to figure this out.)