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

ValidateSqlServerFiltersIT fails in CI

XMLWordPrintable

      Recently ValidateSqlServerFiltersIT fails on GitHub. The root cause is that the sql server is not fully started when we try to set CDC for the tables:

      2022-09-14T12:17:30.6519613Z Caused by: org.testcontainers.ext.ScriptUtils$ScriptStatementFailedException: Script execution failed (/initialize-sqlserver-database.sql:16): EXEC sys.sp_cdc_enable_table @source_schema = 'inventory', @source_name = 'products', @role_name = NULL, @supports_net_changes = 0
      2022-09-14T12:17:30.6521876Z Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Could not update the metadata that indicates table [inventory].[products] is enabled for Change Data Capture. The failure occurred when executing the command '[sys].[sp_cdc_add_job] @job_type = N'capture''. The error returned was 22836: 'Could not update the metadata for database testDB2 to indicate that a Change Data Capture job has been added. The failure occurred when executing the command 'sp_add_jobstep_internal'. The error returned was 14258: 'Cannot perform this operation while SQLServerAgent is starting. Try again later.'. Use the action and error to determine the cause of the failure and resubmit the request.'. Use the action and error to determine the cause of the failure and resubmit the request.
      

            vjuranek@redhat.com Vojtech Juranek
            vjuranek@redhat.com Vojtech Juranek
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: