UNSOLVED 全量+增量同步mysql到starrock 失败
-
Console task execute with error. Context is {“resources”:[],“tryTimes”:null,“paramType”:null,“consoleJobId”:0,“dataJobId”:1}.
Exception stack is java.util.concurrent.ExecutionException: “远程执行SQL失败,请联系管理员。错误信息为:invoke rcontroller method failed.Request id:c2d5c343-e64a-11ec-969c-71b2fe922707msg:SQLSyntaxErrorException: Key columns should be a ordered prefix of the schema… Target sidecar is 172.31.238.4, route name is startrocks_rdbApplyScript”
at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:357)
at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1928)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.structmigration.UnifiedRdbMigrationHandler.twoLevelExecute(UnifiedRdbMigrationHandler.java:416)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.structmigration.UnifiedRdbMigrationHandler.migration(UnifiedRdbMigrationHandler.java:120)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.AbstractStructMigrationHandler.execute(AbstractStructMigrationHandler.java:148)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.AbstractStructMigrationHandler.execute(AbstractStructMigrationHandler.java:61)
at com.clougence.cloudcanal.console.component.consoletask.service.ConsoleJobManagerImpl.doExecuteJob(ConsoleJobManagerImpl.java:220)
at com.clougence.cloudcanal.console.component.consoletask.service.ConsoleJobManagerImpl.lambda$doExecuteJobAsync$1(ConsoleJobManagerImpl.java:174)
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:748)
Caused by: “远程执行SQL失败,请联系管理员。错误信息为:invoke rcontroller method failed.Request id:c2d5c343-e64a-11ec-969c-71b2fe922707msg:SQLSyntaxErrorException: Key columns should be a ordered prefix of the schema… Target sidecar is 172.31.238.4, route name is startrocks_rdbApplyScript”
at com.clougence.cloudcanal.console.component.rsocket.service.base.AbstractRdbMetaRService.applyScript(AbstractRdbMetaRService.java:443)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.structmigration.ds.RdbDialectSqlExecutor.applyCreateTableScripts(RdbDialectSqlExecutor.java:150)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.structmigration.ds.RdbDialectSqlExecutor.executeCreateTableSql(RdbDialectSqlExecutor.java:181)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.structmigration.thread.TableMigrationThread.get(TableMigrationThread.java:33)
at com.clougence.cloudcanal.console.component.consoletask.handler.createdatajob.structmigration.thread.TableMigrationThread.get(TableMigrationThread.java:17)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
… 3 more -
有不支持迁移的表结构,SR要求key的定义在表结构中必须排在前面,这些不支持的表现在可以先手动创建下