After go-sql-driver/mysql is upgraded to >= 1.7.0, error message pattern should also be aligned

[lance6716]

What did you do?

Because after 1.7.0, go-sql-driver/mysql will add SQLState in error message, like Error 8004: Transaction is too large -> Error 8004 (HY000): Transaction is too large. Our hard-coded error pattern should also be updated

The problem is in release-6.5 go-sql-driver/mysql is updated https://github.com/pingcap/tiflow/blob/release-6.5/go.mod#L34 but UnsupportedDMLMsgs does not contain SQLState
https://github.com/pingcap/tiflow/blob/release-6.5/dm/pkg/retry/errors.go#L47

Maybe pick c46cd35 is enough

What did you expect to see?

No response

What did you see instead?

No response

Versions of the cluster

see below

current status of DM cluster (execute query-status <task-name> in dmctl)

DM v6.5.10, v6.5.11