Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-7541

SQLServer tests taking long time due to database bad state

XMLWordPrintable

    • False
    • None
    • False

      Sometimes the SQLServer test take long time and the killed due to this errorĀ 

      2024-02-21 09:50:27,650 ERROR  SQL_Server|server1|0|streaming|testDB2  Producer failure   [io.debezium.pipeline.ErrorHandler]
      35770com.microsoft.sqlserver.jdbc.SQLServerException: Database 'testDB2' is in transition. Try the statement later.
      35771	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
      35772	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695)
      35773	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920)
      35774	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814)
      35775	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7675)
      35776	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4137)
      35777	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272)
      35778	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246)
      35779	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:736)
      35780	at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:642)
      35781	at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:511)
      35782	at io.debezium.connector.sqlserver.SqlServerConnection.getMaxTransactionLsn(SqlServerConnection.java:314)
      35783	at io.debezium.connector.sqlserver.SqlServerStreamingChangeEventSource.getToLsn(SqlServerStreamingChangeEventSource.java:496)
      35784	at io.debezium.connector.sqlserver.SqlServerStreamingChangeEventSource.executeIteration(SqlServerStreamingChangeEventSource.java:174)
      35785	at io.debezium.connector.sqlserver.SqlServerStreamingChangeEventSource.executeIteration(SqlServerStreamingChangeEventSource.java:66)
      35786	at io.debezium.connector.sqlserver.SqlServerChangeEventSourceCoordinator.executeChangeEventSources(SqlServerChangeEventSourceCoordinator.java:117)
      35787	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:140)
      35788	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
      35789	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      35790	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
      35791	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
      35792	at java.base/java.lang.Thread.run(Thread.java:840 

              rh-ee-mvitale Mario Fiore Vitale
              rh-ee-mvitale Mario Fiore Vitale
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: