DBZ-2625 Retry on transaction deadlock

When CDC is reconfigured while connector is running it is possbile to end up in tx deadlock. Such situation is only temporary and connector could recover from it upon restart.
seeekr · Nov 10, 2020 · 3b1f3e7 · 3b1f3e7
1 parent c41aa0e
commit 3b1f3e7
Showing 1 changed file with 3 additions and 1 deletion.
diff --git a/...nector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerErrorHandler.java b/...nector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerErrorHandler.java
@@ -30,6 +30,8 @@ protected boolean isRetriable(Throwable throwable) {
                         || throwable.getMessage().contains("Connection reset")
                         || throwable.getMessage().contains("SHUTDOWN is in progress")
                         || throwable.getMessage()
-                                .startsWith("An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_"));
+                                .startsWith("An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_")
+                        || throwable.getMessage()
+                                .endsWith("was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."));
     }
 }