注册

mysql迁移到达梦分析表时报错

lxxxxx 2024/03/06 603 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:windows
【CPU】:
【问题描述】*:我在进行mysql(5.5.53版本)迁移到达梦时在分析表时报错,报错信息如下:
[INFO] 2024-03-06 15:07:24.016> [TASK]@ANALYZE_TABLE:start
[ERROR] 2024-03-06 15:07:24.167> [TASK]@ANALYZE_TABLE🏃ad_sync_logs
com.dameng.common.service.ServiceException
at com.dameng.dts.plugin.support.service.MysqlTransformService.getColumns(MysqlTransformService.java:284)
at com.dameng.dts.core.service.BaseTransformService.fillTableInfo(BaseTransformService.java:338)
at com.dameng.dts.plugin.support.service.MysqlTransformService.fillTableInfo(MysqlTransformService.java:1217)
at com.dameng.dts.plugin.support.task.BaseAnalyzeTableTask.fillTransformItem(BaseAnalyzeTableTask.java:308)
at com.dameng.dts.plugin.support.task.BaseAnalyzeTableTask.access$1(BaseAnalyzeTableTask.java:278)
at com.dameng.dts.plugin.support.task.BaseAnalyzeTableTask$2.consume(BaseAnalyzeTableTask.java:185)
at com.dameng.dts.core.mutithread.Producer$ConsumerThread.run(Producer.java:120)
Caused by: com.dameng.dts.core.service.TransformServiceException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DATETIME_PRECISION' in 'field list'
at com.dameng.dts.core.service.BaseTransformService.select(BaseTransformService.java:989)
at com.dameng.dts.plugin.support.service.MysqlTransformService.doGetColumns(MysqlTransformService.java:445)
at com.dameng.dts.plugin.support.service.MysqlTransformService.getColumns(MysqlTransformService.java:279)
... 6 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DATETIME_PRECISION' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at com.dameng.common.persistence.jdbc.SQLQuery.execute(SQLQuery.java:112)
at com.dameng.common.persistence.jdbc.JdbcSupport.select(JdbcSupport.java:253)
at com.dameng.common.persistence.jdbc.JdbcSupport.select(JdbcSupport.java:240)
at com.dameng.dts.core.service.BaseTransformService.select(BaseTransformService.java:985)
... 8 more

[ERROR] 2024-03-06 15:07:24.171> [TASK]@ANALYZE_TABLE:fail
java.lang.Exception: 分析表失败!

回答 0
暂无回答
扫一扫
联系客服