./obloader -h 10.5.8.102 -P 2881 -u root@sys -p ******--sys-user root --sys-password ******-D hf_sjgc --csv --table 'DWS_ZDZC_ZFCG' -f /data/obd/obdumper/mysql/data/data/mysql/TABLE/DWS_ZDZC_ZFCG.csv 2025-11-28 15:34:24 [INFO] Parsed args: [--csv] true [--file-path] /data/obd/obdumper/mysql/data/data/mysql/TABLE/DWS_ZDZC_ZFCG.csv [--host] 10.5.8.102 [--port] 2881 [--user] root@sys [--password] ****** [--database] hf_sjgc [--sys-user] root [--sys-password] ****** [--table] [DWS_ZDZC_ZFCG] 2025-11-28 15:34:24 [WARN] The Java version (1.8.0_181) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0) 2025-11-28 15:34:24 [INFO] Log files will be written to /data/obd/obdumper/mysql/data/data/mysql/TABLE/logs 2025-11-28 15:34:24 [INFO] Trying to establish JDBC connection to `root@sys`... 2025-11-28 15:34:25 [INFO] Server Mode: OBMYSQL-4.3.5.4 2025-11-28 15:34:25 [INFO] Version: 4.3.4.1 2025-11-28 15:34:25 [INFO] Querying table column metadata, this might take a while... 2025-11-28 15:34:25 [WARN] Table: "dws_zdzc_zfcg" doesn't exist, skip it 2025-11-28 15:34:25 [INFO] Splitting data files into 64 MB logical chunks... 2025-11-28 15:34:25 [INFO] Split 1 data files to 1 logical chunks success. Elapsed: 17.37 ms 2025-11-28 15:34:25 [INFO] Querying primary/unique constraints metadata for data replacing... 2025-11-28 15:34:25 [INFO] Querying primary key for table "DWS_ZDZC_ZFCG"... 2025-11-28 15:34:25 [INFO] Partition calculation flag is true 2025-11-28 15:34:25 [INFO] Query entry for table: "DWS_ZDZC_ZFCG" finished. Remain: [0/1] 2025-11-28 15:34:25 [INFO] Query leader location of table: "DWS_ZDZC_ZFCG" finished. Remain: [0/1] 2025-11-28 15:34:25 [INFO] Waiting to calculate leader for 1 sub-files.... 2025-11-28 15:34:25 [INFO] Create 1024 slots for ring buffer and leader server [127.0.0.1:2881] succeed. 2025-11-28 15:34:25 [INFO] Start 16 writers for 16 threads and leader server [127.0.0.1:2881] succeed. 2025-11-28 15:34:25 [INFO] Start 1 readers for 16 threads succeed. 2025-11-28 15:34:25 [INFO] --------------------------------------------------------------------------------------------------------- OBServerLoadThrottle: Server: 127.0.0.1:2881 Merge Status: false Mem Used Ratio: 17% Load Mode: FAST --------------------------------------------------------------------------------------------------------- DummyGCThrottle: Name: ParNew GC Count: 1 GC Cost: 00:00:00.032 Name: ConcurrentMarkSweep GC Count: 0 GC Cost: 00:00:00.000 --------------------------------------------------------------------------------------------------------- RingBufferThrottle: Blocking: false --------------------------------------------------------------------------------------------------------- MemoryThrottle: [HEAP_MEM: 99.5 MB/3.9 GB], [NON_HEAP_MEM: 47.5 MB/488 MB], Block Possible: 0 % --------------------------------------------------------------------------------------------------------- TpsThrottle: [Tps: 2147483647], Blocking: false --------------------------------------------------------------------------------------------------------- 2025-11-28 15:34:25 [INFO] Reset batch size [0->800] for table "DWS_ZDZC_ZFCG". 2025-11-28 15:34:25 [INFO] Block Threads: 0 --------------------------------------------------------------------------------------------------------- ThreadSubmitTpsThrottle: [Tps: 1.0000], Blocking: false --------------------------------------------------------------------------------------------------------- ThreadSubmitMemThrottle: [HEAP_MEM: 99.5 MB/3.9 GB], [NON_HEAP_MEM: 47.7 MB/488 MB], Block Possible: 0 % --------------------------------------------------------------------------------------------------------- 2025-11-28 15:34:25 [INFO] File: "/data/obd/obdumper/mysql/data/data/mysql/TABLE/DWS_ZDZC_ZFCG.csv" has been read finished. 2025-11-28 15:34:25 [ERROR] Other Error: java.sql.SQLException: java.sql.SQLTransientConnectionException: (conn=3221691680) Incorrect decimal value for column 'bdgamt' at row 1 at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter$RetryCallback.executeUpdate(JdbcClientWriter.java:406) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter$RetryCallback.doCall(JdbcClientWriter.java:274) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter$RetryCallback.call(JdbcClientWriter.java:210) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter$RetryCallback.call(JdbcClientWriter.java:193) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] at com.github.rholder.retry.AttemptTimeLimiters$NoAttemptTimeLimit.call(AttemptTimeLimiters.java:78) ~[guava-retrying-2.0.0.jar:?] at com.github.rholder.retry.Retryer.call(Retryer.java:160) ~[guava-retrying-2.0.0.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter.onEvent(JdbcClientWriter.java:131) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter.onEvent(JdbcClientWriter.java:61) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] at com.lmax.disruptor.WorkProcessor.run(WorkProcessor.java:143) ~[disruptor-3.4.4.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_181] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_181] at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_181] Caused by: java.sql.SQLTransientConnectionException: (conn=3221691680) Incorrect decimal value for column 'bdgamt' at row 1 at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:329) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1103) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.execute(JDBC4ServerPreparedStatement.java:1059) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeUpdate(JDBC4ServerPreparedStatement.java:1040) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter$RetryCallback.executeUpdate(JdbcClientWriter.java:401) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] ... 11 more Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Incorrect decimal value for column 'bdgamt' at row 1 at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:207) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:188) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:547) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1085) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.execute(JDBC4ServerPreparedStatement.java:1059) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeUpdate(JDBC4ServerPreparedStatement.java:1040) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter$RetryCallback.executeUpdate(JdbcClientWriter.java:401) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] ... 11 more Caused by: java.sql.SQLException: Incorrect decimal value for column 'bdgamt' at row 1 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2378) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2241) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2129) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:544) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:1085) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.execute(JDBC4ServerPreparedStatement.java:1059) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeUpdate(JDBC4ServerPreparedStatement.java:1040) ~[oceanbase-client-2.4.14.jar:?] at com.oceanbase.tools.loaddump.loader.writer.JdbcClientWriter$RetryCallback.executeUpdate(JdbcClientWriter.java:401) ~[ob-loader-dumper-4.3.4.1-RELEASE.jar:?] ... 11 more 2025-11-28 15:34:25 [ERROR] Fatal error occurred while loading data from "/data/obd/obdumper/mysql/data/data/mysql/TABLE/DWS_ZDZC_ZFCG.csv" into table `hf_sjgc`.`DWS_ZDZC_ZFCG`. Reason: Load data into "hf_sjgc"."DWS_ZDZC_ZFCG" failed! Incorrect decimal value for column 'bdgamt' at row 1 2025-11-28 15:34:26 [ERROR] Error: Load data into "hf_sjgc"."DWS_ZDZC_ZFCG" failed! Incorrect decimal value for column 'bdgamt' at row 1 2025-11-28 15:34:26 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ---------- 2025-11-28 15:34:26 [INFO] All Load Tasks Finished: ---------------------------------------------------------------------------------------------------------------------------- No.# | Type | Name | Count | Status ---------------------------------------------------------------------------------------------------------------------------- 1 | TABLE | DWS_ZDZC_ZFCG | 22 -> 0 | FAILURE ---------------------------------------------------------------------------------------------------------------------------- Total Count: 0 End Time: 2025-11-28 15:34:26 2025-11-28 15:34:26 [INFO] Load record finished. Total Elapsed: 1.379 s 2025-11-28 15:34:26 [ERROR] System exit 1