注册

使用达梦DTS迁移mysql8数据时,提示`set identity status on/off error`

¢-口_口- 2025/10/26 296 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:

  • DM Database Server x64 V8, DB Version: 0x7000d, BUILD_VERSION: 03134284368-20250430-272000-20149
  • DM数据迁移工具 V8 (Build 2023.06.30)

【操作系统】:

  • DTS跑在windows7专业版sp1
  • mysql和DMSERVER跑在Kylin Linux Advanced Server V10 (Sword)

【CPU】: x86_64
【问题描述】*:
迁移完成了,但日志中有两个成对出现的set identity status on/off的warning,这是为啥啊?有什么影响吗?

  • set identity status on error日志
[INFO] 2025-10-26 11:22:14.347> [TASK]{table-"XXXX":"SYSDBA.XXXX"}@COPY_DATA:START:COPIED=0
[WARN] 2025-10-26 11:22:14.419> set identity status on error!
dm.jdbc.driver.DMException: 第1 行附近出现错误:
表[XXXX]不存在IDENTITY列
	at dm.jdbc.driver.DBError.throwException(SourceFile:738)
	at dm.jdbc.a.a.y.r(SourceFile:623)
	at dm.jdbc.a.a.f.r(SourceFile:138)
	at dm.jdbc.a.a.y.z(SourceFile:555)
	at dm.jdbc.a.a.y.L(SourceFile:536)
	at dm.jdbc.a.a.a(SourceFile:269)
	at dm.jdbc.a.a.a(SourceFile:803)
	at dm.jdbc.driver.DmdbStatement.executeInner(SourceFile:771)
	at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:248)
	at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:239)
	at dm.jdbc.driver.DmdbStatement.executeUpdate(SourceFile:1143)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.setIdentityStatus(BaseCopyDataTask.java:657)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.lambda$0(BaseCopyDataTask.java:428)
	at com.dameng.dts.plugin.support.task.BaseTask.executeWithReconn(BaseTask.java:382)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.borrowDestSession(BaseCopyDataTask.java:426)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.beforeImport(BaseCopyDataTask.java:409)
	at com.dameng.dts.plugin.support.task.BaseDm7CopyDataTask.beforeImport(BaseDm7CopyDataTask.java:80)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.internalImp(BaseCopyDataTask.java:1178)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.imp(BaseCopyDataTask.java:339)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doRun(BaseCopyDataTask.java:316)
	at com.dameng.common.task.Task.run(SourceFile:127)
	at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:256)
	at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:1)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
  • set identity status off error日志
[WARN] 2025-10-26 11:22:18.119> set identity status off error!
dm.jdbc.driver.DMException: 第1 行附近出现错误:
表[XXXX]不存在IDENTITY列
	at dm.jdbc.driver.DBError.throwException(SourceFile:738)
	at dm.jdbc.a.a.y.r(SourceFile:623)
	at dm.jdbc.a.a.f.r(SourceFile:138)
	at dm.jdbc.a.a.y.z(SourceFile:555)
	at dm.jdbc.a.a.y.L(SourceFile:536)
	at dm.jdbc.a.a.a(SourceFile:269)
	at dm.jdbc.a.a.a(SourceFile:803)
	at dm.jdbc.driver.DmdbStatement.executeInner(SourceFile:771)
	at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:248)
	at dm.jdbc.driver.DmdbStatement.do_executeUpdate(SourceFile:239)
	at dm.jdbc.driver.DmdbStatement.executeUpdate(SourceFile:1143)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.setIdentityStatus(BaseCopyDataTask.java:657)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.afterImport(BaseCopyDataTask.java:448)
	at com.dameng.dts.plugin.support.task.BaseDm7CopyDataTask.afterImport(BaseDm7CopyDataTask.java:104)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.internalImp(BaseCopyDataTask.java:1209)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.imp(BaseCopyDataTask.java:339)
	at com.dameng.dts.plugin.support.task.BaseCopyDataTask.doRun(BaseCopyDataTask.java:316)
	at com.dameng.common.task.Task.run(SourceFile:127)
	at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:256)
	at com.dameng.common.task.TaskRunner$TaskAdapter.call(SourceFile:1)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
回答 0
暂无回答
扫一扫
联系客服