2023-07-31 17:08:24.518 [main] INFO MessageSource - JVM TimeZone: GMT+08:00, Locale: zh_CN 2023-07-31 17:08:24.523 [main] INFO MessageSource - use Locale: zh_CN timeZone: sun.util.calendar.ZoneInfo[id="GMT+08:00",offset=28800000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null] 2023-07-31 17:08:24.606 [main] INFO VMInfo - VMInfo# operatingSystem class => sun.management.OperatingSystemImpl 2023-07-31 17:08:24.620 [main] INFO Engine - the machine info => osInfo: Linux amd64 3.10.0-957.el7.x86_64 jvmInfo: Red Hat, Inc. 1.8 25.372-b07 cpu num: 24 totalPhysicalMemory: -0.00G freePhysicalMemory: -0.00G maxFileDescriptorCount: -1 currentOpenFileDescriptorCount: -1 GC Names [PS MarkSweep, PS Scavenge] MEMORY_NAME | allocation_size | init_size PS Eden Space | 256.00MB | 256.00MB Code Cache | 240.00MB | 2.44MB Compressed Class Space | 1,024.00MB | 0.00MB PS Survivor Space | 42.50MB | 42.50MB PS Old Gen | 683.00MB | 683.00MB Metaspace | -0.00MB | 0.00MB 2023-07-31 17:08:24.685 [main] INFO Engine - { "setting":{ "speed":{ "channel":4 }, "errorLimit":{ "record":0, "percentage":0.1 } }, "content":[ { "reader":{ "name":"mysqlreader", "parameter":{ "username":"root", "password":"*******************", "column":[ "*" ], "connection":[ { "table":[ "config" ], "jdbcUrl":[ "jdbc:mysql://10.192.45.36:3306/nova?useUnicode=true&characterEncoding=utf8" ] } ] } }, "writer":{ "name":"oceanbasev10writer", "parameter":{ "obWriteMode":"insert", "column":[ "*" ], "preSql":[ "truncate table config" ], "connection":[ { "jdbcUrl":"||_dsc_ob10_dsc_||obce-3zones:tenant1||_dsc_ob10_dsc_||jdbc:oceanbase://172.118.81.156:2883/nova?useLocalSessionState=true&allowBatch=true&allowMultiQueries=true&rewriteBatchedStatements=true", "table":[ "config" ] } ], "username":"root", "password":"**********", "writerThreadCount":10, "batchSize":1000, "memstoreThreshold":"0.9" } } } ] } 2023-07-31 17:08:24.757 [main] INFO PerfTrace - PerfTrace traceId=job_-1, isEnable=false 2023-07-31 17:08:24.758 [main] INFO JobContainer - DataX jobContainer starts job. 2023-07-31 17:08:24.761 [main] INFO JobContainer - Set jobId = 0 2023-07-31 17:08:25.608 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://10.192.45.36:3306/nova?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true. 2023-07-31 17:08:25.610 [job-0] WARN OriginalConfPretreatmentUtil - 您的配置文件中的列配置存在一定的风险. 因为您未配置读取数据库表的列，当您的表字段个数、类型有变动时，可能影响任务正确性甚至会运行出错。请检查您的配置并作出修改. 2023-07-31 17:08:25.644 [job-0] INFO DBUtil - this is ob1_0 jdbc url. 2023-07-31 17:08:25.645 [job-0] INFO DBUtil - this is ob1_0 jdbc url. user=obce-3zones:tenant1:root :url=jdbc:oceanbase://172.118.81.156:2883/nova?useLocalSessionState=true&allowBatch=true&allowMultiQueries=true&rewriteBatchedStatements=true 2023-07-31 17:08:25.662 [job-0] ERROR RetryUtil - Exception when calling callable, 异常Msg:Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为：java.lang.ClassNotFoundException: com.alipay.oceanbase.jdbc.Driver com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为：java.lang.ClassNotFoundException: com.alipay.oceanbase.jdbc.Driver at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:30) ~[datax-common-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asConnException(RdbmsException.java:36) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.DBUtil.connect(DBUtil.java:397) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.DBUtil.connect(DBUtil.java:387) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.DBUtil.access$000(DBUtil.java:22) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.DBUtil$3.call(DBUtil.java:322) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.DBUtil$3.call(DBUtil.java:319) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.common.util.RetryUtil$Retry.call(RetryUtil.java:164) ~[datax-common-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.common.util.RetryUtil$Retry.doRetry(RetryUtil.java:111) ~[datax-common-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.common.util.RetryUtil.executeWithRetry(RetryUtil.java:30) [datax-common-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getConnection(DBUtil.java:319) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getConnection(DBUtil.java:303) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.writer.oceanbasev10writer.util.DbUtils.fetchSingleValueWithRetry(DbUtils.java:49) [oceanbasev10writer-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Job.checkCompatibleMode(OceanBaseV10Writer.java:198) [oceanbasev10writer-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Job.init(OceanBaseV10Writer.java:61) [oceanbasev10writer-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.job.JobContainer.initJobWriter(JobContainer.java:704) [datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:304) [datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:113) [datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.Engine.start(Engine.java:86) [datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.Engine.entry(Engine.java:168) [datax-core-0.0.1-SNAPSHOT.jar:na] at com.alibaba.datax.core.Engine.main(Engine.java:201) [datax-core-0.0.1-SNAPSHOT.jar:na] 2023-07-31 17:08:26.664 [job-0] ERROR RetryUtil - Exception when calling callable, 即将尝试执行第1次重试.本次重试计划等待[1000]ms,实际等待[1000]ms, 异常Msg:[Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为：java.lang.ClassNotFoundException: com.alipay.oceanbase.jdbc.Driver] 2023-07-31 17:08:26.665 [job-0] INFO DBUtil - this is ob1_0 jdbc url. 2023-07-31 17:08:26.666 [job-0] INFO DBUtil - this is ob1_0 jdbc url. user=obce-3zones:tenant1:root :url=jdbc:oceanbase://172.118.81.156:2883/nova?useLocalSessionState=true&allowBatch=true&allowMultiQueries=true&rewriteBatchedStatements=true 2023-07-31 17:08:28.668 [job-0] ERROR RetryUtil - Exception when calling callable, 即将尝试执行第2次重试.本次重试计划等待[2000]ms,实际等待[2000]ms, 异常Msg:[Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为：java.lang.ClassNotFoundException: com.alipay.oceanbase.jdbc.Driver] 2023-07-31 17:08:28.669 [job-0] INFO DBUtil - this is ob1_0 jdbc url. 2023-07-31 17:08:28.680 [job-0] INFO DBUtil - this is ob1_0 jdbc url. user=obce-3zones:tenant1:root :url=jdbc:oceanbase://172.118.81.156:2883/nova?useLocalSessionState=true&allowBatch=true&allowMultiQueries=true&rewriteBatchedStatements=true 2023-07-31 17:08:32.682 [job-0] ERROR RetryUtil - Exception when calling callable, 即将尝试执行第3次重试.本次重试计划等待[4000]ms,实际等待[4000]ms, 异常Msg:[Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).]. - 具体错误信息为：java.lang.ClassNotFoundException: com.alipay.oceanbase.jdbc.Driver] 2023-07-31 17:08:32.683 [job-0] INFO DBUtil - this is ob1_0 jdbc url. 2023-07-31 17:08:32.684 [job-0] INFO DBUtil - this is ob1_0 jdbc url. user=obce-3zones:tenant1:root :url=jdbc:oceanbase://172.118.81.156:2883/nova?useLocalSessionState=true&allowBatch=true&allowMultiQueries=true&rewriteBatchedStatements=true