开发者社区 > 数据库 > 数据库管理工具 > 正文

数据传输DTS任务获取日志遇到了问题。如何解决?

【任务名称】:主数据同步prod-低温B2b
【所有报错信息】:
CODE:dts.retry.err.0238
错误概述:数据传输DTS任务获取日志遇到了问题。如何解决?
解决方案:请点击“一键复制”进入钉钉客户交流群咨询解决。
帮助文档:https://help.aliyun.com/document_detail/462133.html#DTS-RETRY-ERR-0238
详细报错信息:dts-k-src: DTS-52111: Increment Context Is Not Running..: mysql-reader: DTS-52210: fetch log failed
cause:
IOException: mysql-reader: DTS--0001: execute sql select UNIX_TIMESTAMP() failed, case by mysql-reader: DTS--0001: Can not create connection to source database, case by common: DTS-100047: retry 0 times, 10008 seconds, which exceed the supposed 43200 seconds
cause:
CriticalAnyAllException: mysql-reader: DTS--0001: Can not create connection to source database, case by common: DTS-100047: retry 0 times, 10008 seconds, which exceed the supposed 43200 seconds
FatalAnyAllException: common: DTS-100047: retry 0 times, 10008 seconds, which exceed the supposed 43200 seconds
SQLException: Reading bytes from a network handler fails. Socket errno: 110, Socket errmsg: Connection timed out.(ETIMEDOUT)
CriticalAnyAllException: mysql-reader: DTS--0001: execute sql select UNIX_TIMESTAMP() failed, case by mysql-reader: DTS--0001: Can not create connection to source database, case by common: DTS-100047: retry 0 times, 10008 seconds, which exceed the supposed 43200 seconds
CriticalAnyAllException: mysql-reader: DTS--0001: Can not create connection to source database, case by common: DTS-100047: retry 0 times, 10008 seconds, which exceed the supposed 43200 seconds
FatalAnyAllException: common: DTS-100047: retry 0 times, 10008 seconds, which exceed the supposed 43200 seconds
SQLException: Reading bytes from a network handler fails. Socket errno: 110, Socket errmsg: Connection timed out.(ETIMEDOUT)
cause:
CriticalAnyAllException: mysql-reader: DTS-52210: fetch log failed
IOException: mysql-reader: DTS--0001: execute sql select UNIX_TIMESTAMP() failed, case by mysql-reader: DTS--0001: Can not create connection to source database, case by common: DTS-100047: retry 0 times, 10008 seconds, which exceed the supposed 43200 seconds
cause:
CriticalAnyAllException: mysql-reader: DTS--0001: Can not create connection to source database, case by common: DTS-100047: retry 0 times, 1000
【URL】:https://dtsnew.console.aliyun.com/sync/detail/manager/sfeo3hrn26bd76r?serial=15
【当前时间】:2024-04-11 22:37:56
【Region】:cn-beijing

展开
收起
三分钟热度的鱼 2024-04-17 20:41:21 66 0
1 条回答
写回答
取消 提交回答
  • 辛苦检查一下源库连接是否正常。此回答整理自钉群“DTS客户交流群-2”

    2024-04-17 21:06:37
    赞同 展开评论 打赏

阿里云提供了一系列数据库管理工具,可以满足您在云上进行数据库管理的各种需求。包含数据传输服务DTS、数据库备份 DBS、数据库自治服务 DAS、数据管理 DMS。

相关电子书

更多
PostgresChina2018_赖思超_PostgreSQL10_hash索引的WAL日志修改版final 立即下载
Kubernetes下日志实时采集、存储与计算实践 立即下载
日志数据采集与分析对接 立即下载