ODC导入数据到mysql发生异常

OceanBase
#1

2024-03-14 16:31:34 [INFO] Data transfer task starts, working directory:C:\Users\Administrator\AppData\Roaming\odc\data\data_transfer\129
2024-03-14 16:31:49 [INFO] Unzip file to working dir, from=C:\Users\Administrator\Downloads\export_34\export_35\export_65\export_98\export_98_export_file.zip, dest=C:\Users\Administrator\AppData\Roaming\odc\data\data_transfer\129\data
2024-03-14 16:31:49 [INFO] Found 130 schema jobs for database rkjkpt.
2024-03-14 16:31:49 [WARN] Failed to run data transfer task.
java.lang.RuntimeException: Failed to init transfer jobs.
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.initTransferJobs(MySQLDataTransferJob.java:204) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.call(MySQLDataTransferJob.java:135) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.call(MySQLDataTransferJob.java:75) ~[?:?]
at com.oceanbase.odc.service.datatransfer.task.DataTransferTask.call(DataTransferTask.java:135) ~[odc-service-4.2.3-20231225.jar!/:?]
at com.oceanbase.odc.service.datatransfer.task.DataTransferTask.call(DataTransferTask.java:100) ~[odc-service-4.2.3-20231225.jar!/:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_292]
at com.oceanbase.odc.common.trace.TraceDecorator.lambda$decorate$0(TraceDecorator.java:40) ~[odc-common-4.2.3-20231225.jar!/:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [show index from base_bacterialcultureheader from rkjkpt]; nested exception is java.sql.SQLSyntaxErrorException: Table ‘rkjkpt.base_bacterialcultureheader’ doesn’t exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at com.oceanbase.tools.dbbrowser.schema.mysql.MySQLNoGreaterThan5740SchemaAccessor.listTableIndexes(MySQLNoGreaterThan5740SchemaAccessor.java:932) ~[db-browser-1.0.4.jar!/:?]
at com.oceanbase.odc.plugin.schema.mysql.MySQLTableExtension.getDetail(MySQLTableExtension.java:55) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.job.TransferJobFactory.generateDataTransferJobs(TransferJobFactory.java:139) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.initTransferJobs(MySQLDataTransferJob.java:196) ~[?:?]
… 9 more
Caused by: java.sql.SQLSyntaxErrorException: Table ‘rkjkpt.base_bacterialcultureheader’ doesn’t exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110) ~[HikariCP-4.0.3.jar!/:?]
at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar!/:?]
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at com.oceanbase.tools.dbbrowser.schema.mysql.MySQLNoGreaterThan5740SchemaAccessor.listTableIndexes(MySQLNoGreaterThan5740SchemaAccessor.java:932) ~[db-browser-1.0.4.jar!/:?]
at com.oceanbase.odc.plugin.schema.mysql.MySQLTableExtension.getDetail(MySQLTableExtension.java:55) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.job.TransferJobFactory.generateDataTransferJobs(TransferJobFactory.java:139) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.initTransferJobs(MySQLDataTransferJob.java:196) ~[?:?]
… 9 more
2024-03-14 16:31:49 [WARN] Failed to run data transfer task.
java.lang.RuntimeException: Failed to init transfer jobs.
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.initTransferJobs(MySQLDataTransferJob.java:204) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.call(MySQLDataTransferJob.java:135) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.call(MySQLDataTransferJob.java:75) ~[?:?]
at com.oceanbase.odc.service.datatransfer.task.DataTransferTask.call(DataTransferTask.java:135) ~[odc-service-4.2.3-20231225.jar!/:?]
at com.oceanbase.odc.service.datatransfer.task.DataTransferTask.call(DataTransferTask.java:100) ~[odc-service-4.2.3-20231225.jar!/:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_292]
at com.oceanbase.odc.common.trace.TraceDecorator.lambda$decorate$0(TraceDecorator.java:40) ~[odc-common-4.2.3-20231225.jar!/:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [show index from base_bacterialcultureheader from rkjkpt]; nested exception is java.sql.SQLSyntaxErrorException: Table ‘rkjkpt.base_bacterialcultureheader’ doesn’t exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at com.oceanbase.tools.dbbrowser.schema.mysql.MySQLNoGreaterThan5740SchemaAccessor.listTableIndexes(MySQLNoGreaterThan5740SchemaAccessor.java:932) ~[db-browser-1.0.4.jar!/:?]
at com.oceanbase.odc.plugin.schema.mysql.MySQLTableExtension.getDetail(MySQLTableExtension.java:55) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.job.TransferJobFactory.generateDataTransferJobs(TransferJobFactory.java:139) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.initTransferJobs(MySQLDataTransferJob.java:196) ~[?:?]
… 9 more
Caused by: java.sql.SQLSyntaxErrorException: Table ‘rkjkpt.base_bacterialcultureheader’ doesn’t exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110) ~[HikariCP-4.0.3.jar!/:?]
at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar!/:?]
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) ~[spring-jdbc-5.3.26.jar!/:5.3.26]
at com.oceanbase.tools.dbbrowser.schema.mysql.MySQLNoGreaterThan5740SchemaAccessor.listTableIndexes(MySQLNoGreaterThan5740SchemaAccessor.java:932) ~[db-browser-1.0.4.jar!/:?]
at com.oceanbase.odc.plugin.schema.mysql.MySQLTableExtension.getDetail(MySQLTableExtension.java:55) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.job.TransferJobFactory.generateDataTransferJobs(TransferJobFactory.java:139) ~[?:?]
at com.oceanbase.odc.plugin.task.mysql.datatransfer.MySQLDataTransferJob.initTransferJobs(MySQLDataTransferJob.java:196) ~[?:?]
… 9 more
2024-03-14 16:31:50 [INFO] Delete data directory, dir=C:\Users\Administrator\AppData\Roaming\odc\data\data_transfer\129\data, result=true

#3

OB版本 4214 ODC版本423

#4

您好，麻烦确认您的数据源类型选择的是 OceanBase MySQL 而不是 mysql
image