[
https://issues.apache.org/jira/browse/FLINK-40649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18115123#comment-18115123
]
Gyeongdeok Kim commented on FLINK-40649:
----------------------------------------
Hi, I’d like to work on this issue. I plan to make the SQL Server Agent status
check independent of the localized service name and add focused test coverage.
Could a committer please assign it to me?
> [sqlserver-cdc] Agent status validation fails on localized SQL Server
> instances where service name is not in English
> --------------------------------------------------------------------------------------------------------------------
>
> Key: FLINK-40649
> URL: https://issues.apache.org/jira/browse/FLINK-40649
> Project: Flink
> Issue Type: Bug
> Components: Flink CDC
> Reporter: dulele
> Priority: Major
>
> * Flink CDC version: 3.x （main）
> * SQL Server version: Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64)
> Enterprise Edition
> * OS: Windows Server 2016 Datacenter (Chinese Simplified)
> * {*}Bug Description：{*}org.apache.flink.table.api.ValidationException: SQL
> Server Agent is not running.
> Please start SQL Server Agent before creating the SQL Server pipeline.
> at
> org.apache.flink.cdc.connectors.sqlserver.utils.SqlServerSchemaUtils.validateSqlServerAgentRunning(SqlServerSchemaUtils.java:78)
>
> * *Root Cause Analysis*
> {{{}SELECT TOP(1) status_desc FROM
> sys.dm_server_services{}}}{{{}WHERE servicename LIKE 'SQL Server Agent (%'{}}}
> {{ bug my sqlserver (SQL Server 代理 (MSSQLSERVER)) not }}{{{}SQL Server
> Agent (%{}}}{{{}{}}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
