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

Debezium UI SQL Server tests randomly fail due to slow agent start-up

XMLWordPrintable

      See:

      2023-02-23T12:44:57.8015955Z 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
      2023-02-23T12:44:57.8017999Z 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.
      2023-02-23T12:44:57.8019045Z 
      

            ccranfor@redhat.com Chris Cranford
            ccranfor@redhat.com Chris Cranford
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: