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

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

    XMLWordPrintable

Details

    Description

      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 
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: