(camel-quarkus) branch main updated: Increase debezium-sqlserver init script wait time to 30 seconds

[jamesnetherton]

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

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


The following commit(s) were added to refs/heads/main by this push:
     new 11523043c6 Increase debezium-sqlserver init script wait time to 30 
seconds
11523043c6 is described below

commit 11523043c63fac24d0efb05d15b1c371646fcd3e
Author: James Netherton <jamesnether...@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');