ADS 实例同步常见异常问题
-
ADS 主键字段值校验异常
异常信息:
DTS-077500: Target Instance error in table {db_name.tb_name}, Please contact ADS support, cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: InvalidStatementException: [USER ERROR] all primary key columns value are NULL: (0, NULL, NULL).
解决方案:
重建目的ADS表,并调整ADS主键符合源库数据值 -
ADS 磁盘空间不足或者ADS磁盘写入失败
DTS-077500: Record Replicator error in table {db_name.tb_name}, cause by java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Error Code:20015, RealtimeDataFailedException:Insert failed with 1 data records: [partition=14] Unknown error in QueueStorage
解决方案:
去ADS控制台扩容ADS实例磁盘空间,然后重启DTS同步任务 -
ADS 计算节点挂了
DTS-077500: Target Instance error in table {db_name.tb_name}, Please contact ADS support, cause by java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Error Code:20015, RealtimeDataFailedException:Insert failed with 1 data records: [partition=60] connect to <10.154.184.97:43894> failed
解决方案:
联系ADS值班恢复计算节,然后重启DTS任务 ADS 写入列校验失败
DTS-077500:
Target Instance error in table anta_analytic.ads_test, Please contact ADS support. cause by [com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: InvalidStatementException:[USER ERROR] null value is not allowed for NOT NULL column: column=name7, value=java.lang.Object@4904e6c8]
解决方案:修改ADS对应表结构定义,重启任务