| | | 1 | | namespace Elsa.Persistence.EFCore; |
| | | 2 | | |
| | | 3 | | internal static class DbExceptionClassifier |
| | | 4 | | { |
| | 0 | 5 | | private static readonly HashSet<int> SqlServerTransientErrorNumbers = |
| | 0 | 6 | | [ |
| | 0 | 7 | | -2, |
| | 0 | 8 | | 64, |
| | 0 | 9 | | 233, |
| | 0 | 10 | | 1205, |
| | 0 | 11 | | 4060, |
| | 0 | 12 | | 10928, |
| | 0 | 13 | | 10929, |
| | 0 | 14 | | 40197, |
| | 0 | 15 | | 40501, |
| | 0 | 16 | | 40613, |
| | 0 | 17 | | 49918, |
| | 0 | 18 | | 49919, |
| | 0 | 19 | | 49920, |
| | 0 | 20 | | ]; |
| | | 21 | | |
| | | 22 | | public static bool IsSqlServerTransient(string providerName, Exception exception) |
| | | 23 | | { |
| | 0 | 24 | | if (!providerName.Contains("SqlServer", StringComparison.OrdinalIgnoreCase)) |
| | 0 | 25 | | return false; |
| | | 26 | | |
| | 0 | 27 | | return EnumerateExceptions(exception).Any(IsSqlServerTransientException); |
| | | 28 | | } |
| | | 29 | | |
| | | 30 | | public static bool IsDuplicateKey(Exception exception) |
| | | 31 | | { |
| | 0 | 32 | | return EnumerateExceptions(exception).Any(IsDuplicateKeyException); |
| | | 33 | | } |
| | | 34 | | |
| | | 35 | | private static bool IsSqlServerTransientException(Exception exception) |
| | | 36 | | { |
| | 0 | 37 | | if (!IsSqlClientException(exception)) |
| | 0 | 38 | | return false; |
| | | 39 | | |
| | 0 | 40 | | return GetErrorNumbers(exception).Any(SqlServerTransientErrorNumbers.Contains) |
| | 0 | 41 | | || exception.Message.Contains("deadlock", StringComparison.OrdinalIgnoreCase); |
| | | 42 | | } |
| | | 43 | | |
| | | 44 | | private static bool IsDuplicateKeyException(Exception exception) |
| | | 45 | | { |
| | 0 | 46 | | var type = exception.GetType(); |
| | 0 | 47 | | var typeName = type.Name; |
| | 0 | 48 | | var typeNamespace = type.Namespace ?? string.Empty; |
| | 0 | 49 | | var errorNumbers = GetErrorNumbers(exception).ToList(); |
| | | 50 | | |
| | 0 | 51 | | if (IsSqlClientException(exception) && errorNumbers.Any(number => number is 2601 or 2627)) |
| | 0 | 52 | | return true; |
| | | 53 | | |
| | 0 | 54 | | if (typeName.Contains("MySql", StringComparison.OrdinalIgnoreCase) && errorNumbers.Contains(1062)) |
| | 0 | 55 | | return true; |
| | | 56 | | |
| | 0 | 57 | | if (typeName.Contains("Sqlite", StringComparison.OrdinalIgnoreCase) && errorNumbers.Any(number => number is 19 o |
| | 0 | 58 | | return true; |
| | | 59 | | |
| | 0 | 60 | | if (typeName.Contains("Oracle", StringComparison.OrdinalIgnoreCase) && errorNumbers.Contains(1)) |
| | 0 | 61 | | return true; |
| | | 62 | | |
| | 0 | 63 | | if (GetStringProperty(exception, "SqlState") == "23505") |
| | 0 | 64 | | return true; |
| | | 65 | | |
| | 0 | 66 | | return typeNamespace.Contains("Data", StringComparison.OrdinalIgnoreCase) |
| | 0 | 67 | | && (exception.Message.Contains("duplicate key", StringComparison.OrdinalIgnoreCase) |
| | 0 | 68 | | || exception.Message.Contains("unique constraint", StringComparison.OrdinalIgnoreCase) |
| | 0 | 69 | | || exception.Message.Contains("UNIQUE constraint failed", StringComparison.OrdinalIgnoreCase) |
| | 0 | 70 | | || exception.Message.Contains("ORA-00001", StringComparison.OrdinalIgnoreCase)); |
| | | 71 | | } |
| | | 72 | | |
| | | 73 | | private static bool IsSqlClientException(Exception exception) |
| | | 74 | | { |
| | 0 | 75 | | var type = exception.GetType(); |
| | 0 | 76 | | return type.Name.Equals("SqlException", StringComparison.OrdinalIgnoreCase) |
| | 0 | 77 | | && type.Namespace?.Contains("SqlClient", StringComparison.OrdinalIgnoreCase) == true; |
| | | 78 | | } |
| | | 79 | | |
| | | 80 | | private static IEnumerable<int> GetErrorNumbers(object source) |
| | | 81 | | { |
| | 0 | 82 | | if (GetIntProperty(source, "Number") is { } number) |
| | 0 | 83 | | yield return number; |
| | | 84 | | |
| | 0 | 85 | | if (GetIntProperty(source, "SqliteErrorCode") is { } sqliteErrorCode) |
| | 0 | 86 | | yield return sqliteErrorCode; |
| | | 87 | | |
| | 0 | 88 | | if (GetIntProperty(source, "SqliteExtendedErrorCode") is { } sqliteExtendedErrorCode) |
| | 0 | 89 | | yield return sqliteExtendedErrorCode; |
| | | 90 | | |
| | 0 | 91 | | var errors = source.GetType().GetProperty("Errors")?.GetValue(source); |
| | 0 | 92 | | if (errors is not System.Collections.IEnumerable errorCollection) |
| | 0 | 93 | | yield break; |
| | | 94 | | |
| | 0 | 95 | | foreach (var error in errorCollection) |
| | | 96 | | { |
| | 0 | 97 | | if (error is null) |
| | | 98 | | continue; |
| | | 99 | | |
| | 0 | 100 | | if (GetIntProperty(error, "Number") is { } errorNumber) |
| | 0 | 101 | | yield return errorNumber; |
| | | 102 | | } |
| | 0 | 103 | | } |
| | | 104 | | |
| | | 105 | | private static int? GetIntProperty(object source, string name) |
| | | 106 | | { |
| | 0 | 107 | | var value = source.GetType().GetProperty(name)?.GetValue(source); |
| | 0 | 108 | | return value switch |
| | 0 | 109 | | { |
| | 0 | 110 | | int number => number, |
| | 0 | 111 | | short number => number, |
| | 0 | 112 | | long number when number is >= int.MinValue and <= int.MaxValue => (int)number, |
| | 0 | 113 | | _ => null |
| | 0 | 114 | | }; |
| | | 115 | | } |
| | | 116 | | |
| | | 117 | | private static string? GetStringProperty(object source, string name) |
| | | 118 | | { |
| | 0 | 119 | | return source.GetType().GetProperty(name)?.GetValue(source) as string; |
| | | 120 | | } |
| | | 121 | | |
| | | 122 | | private static IEnumerable<Exception> EnumerateExceptions(Exception exception) |
| | | 123 | | { |
| | 0 | 124 | | var stack = new Stack<Exception>(); |
| | 0 | 125 | | stack.Push(exception); |
| | | 126 | | |
| | 0 | 127 | | while (stack.Count > 0) |
| | | 128 | | { |
| | 0 | 129 | | var current = stack.Pop(); |
| | 0 | 130 | | yield return current; |
| | | 131 | | |
| | 0 | 132 | | if (current is AggregateException aggregateException) |
| | | 133 | | { |
| | 0 | 134 | | foreach (var inner in aggregateException.InnerExceptions) |
| | 0 | 135 | | stack.Push(inner); |
| | | 136 | | } |
| | 0 | 137 | | else if (current.InnerException is not null) |
| | | 138 | | { |
| | 0 | 139 | | stack.Push(current.InnerException); |
| | | 140 | | } |
| | 0 | 141 | | } |
| | 0 | 142 | | } |
| | | 143 | | } |