(camel-quarkus) 03/05: Increase debezium-sqlserver init script wait time to 30 seconds

[ja...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

jamesnetherton pushed a commit to branch 3.27.x
in repository https://gitbox.apache.org/repos/asf/camel-quarkus.git

commit 764232080063ed89507336cacca6897e3ec78898
Author: James Netherton <ja...@gmail.com>
AuthorDate: Fri Nov 14 07:48:10 2025 +0000

    Increase debezium-sqlserver init script wait time to 30 seconds
---
 .../debezium/mssql/src/test/resources/initSqlserver.sql      | 12 +++++++-----
 1 file changed, 7 insertions(+), 5 deletions(-)

diff --git a/integration-test-groups/debezium/mssql/src/test/resources/initSqlserver.sql b/integration-test-groups/debezium/mssql/src/test/resources/initSqlserver.sql
index 8120a878c4..31f2e94705 100644
--- a/integration-test-groups/debezium/mssql/src/test/resources/initSqlserver.sql
+++ b/integration-test-groups/debezium/mssql/src/test/resources/initSqlserver.sql
@@ -19,6 +19,13 @@
 CREATE DATABASE testDB;
 
 USE testDB;
+
+-- sql agent is started by providing of the system property, but it could happen that it is still starting during this
+-- execution. In that case, this script fails during setting of cdc for table. In case of failure because of:
+-- 'The error returned was 14258: Cannot perform this operation while SQLServerAgent is starting.'
+-- please increase following delay accordingly
+WAITFOR DELAY '00:00:30'
+
 EXEC sys.sp_cdc_enable_db;
 
 CREATE SCHEMA Test;
@@ -28,11 +35,6 @@ CREATE TABLE Test.COMPANY(
     CITY  varchar(255),
     PRIMARY KEY (NAME)
 );
--- sql agent is started by providing of the system property, but it could happen that it is still starting during this
--- execution. In that case, this script fails during setting of cdc for table. In case of failure because of:
--- 'The error returned was 14258: Cannot perform this operation while SQLServerAgent is starting.'
--- please increase following delay accordingly
-WAITFOR DELAY '00:00:10'
 
 EXEC sys.sp_cdc_enable_table @source_schema=N'Test', @source_name=N'COMPANY', @role_name = NULL,@filegroup_name=N'PRIMARY', @supports_net_changes=0;
 INSERT INTO Test.COMPANY (name, city) VALUES ('init', 'init');