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

SQL Server tasks fail if the number of databases is smaller than maxTasks

XMLWordPrintable

      The connector will always create maxTasks number of tasks even when the number of databases defined in database.names is less than the number of maxTasks. This will cause an exception like the following:

      com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
      at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:299)
      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:132)
      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37)
      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:26)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:3897)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7730)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3786)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:3905)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:4271)
      at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:400)
      at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:349)
      at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:374)
      at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:561)
      at io.debezium.jdbc.JdbcConnection.readTableNames(JdbcConnection.java:1057)
      at io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource.getAllTableIds(SqlServerSnapshotChangeEventSource.java:105)
      at io.debezium.relational.RelationalSnapshotChangeEventSource.determineCapturedTables(RelationalSnapshotChangeEventSource.java:185)
      at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:104)
      at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76)
      ... 8 more

            Unassigned Unassigned
            sugarcrm-jgminder Jacob Gminder (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: