[Bug]: 任务日志显示不准确

[weihebu]

1️⃣ 问题描述 | Problem Description

任务日志里只显示读取的等待时间，写入的等待时间一直为0，这是否是软件上的Bug？

2️⃣ 当前使用的 Addax 版本 | Addax Version

5.1.1

3️⃣ 操作系统类型 | Operating System

Linux (Default)

4️⃣ 使用的 Java JDK 版本 | Java JDK Version

Oracle JDK 1.8.0

5️⃣ 相关日志/输出结果 | Relevant Log Output

2025-08-31 02:05:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:07.767 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:19 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:19.769 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:31 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:31.771 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:43 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:43.774 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:55 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:55.776 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:06:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:07.778 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:06:19 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:19.781 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:06:31 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:31.783 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%

[weihebu]

还有一个问题就是当oracle表中有blob字段存在，并且是update的模式情况下，会导致写入等待，任务的持续时间明显增长，下面附上两个日志的持续时间。第一个是带blob字段的任务，第二个是去掉blob字段后的。表是相同的，就是blob字段存不存在的差异。

[weihebu]

2025-08-31 02:05:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:07.767 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:19 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:19.769 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:31 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:31.771 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:43 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:43.774 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:05:55 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:05:55.776 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:06:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:07.778 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:06:19 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:19.781 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:06:31 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:31.783 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 0.00%
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:36.845 [  writer-0-0] WARN  BasicDataSource      - An internal object pool swallowed an Exception.
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] java.sql.SQLRecoverableException: IO Error: Socket read timed out
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:1922)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:2746)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.dbcp2.DelegatingConnection.closeInternal(DelegatingConnection.java:187)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.dbcp2.PoolableConnection.reallyClose(PoolableConnection.java:371)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.dbcp2.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:154)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.pool2.impl.GenericObjectPool.destroy(GenericObjectPool.java:610)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.pool2.impl.GenericObjectPool.returnObject(GenericObjectPool.java:1082)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.dbcp2.PoolableConnection.close(PoolableConnection.java:225)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.dbcp2.DelegatingConnection.closeInternal(DelegatingConnection.java:187)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.dbcp2.DelegatingConnection.close(DelegatingConnection.java:166)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at org.apache.commons.dbcp2.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:58)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at com.wgzhao.addax.rdbms.util.DBUtil.closeDBResources(DBUtil.java:314)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at com.wgzhao.addax.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:336)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at com.wgzhao.addax.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:344)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at com.wgzhao.addax.plugin.writer.oraclewriter.OracleWriter$Task.startWrite(OracleWriter.java:147)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at com.wgzhao.addax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:74)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at java.lang.Thread.run(Thread.java:745)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: oracle.net.nt.TimeoutInterruptHandler$IOReadTimeoutException: Socket read timed out
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.nt.TimeoutSocketChannel.handleInterrupt(TimeoutSocketChannel.java:544)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:420)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1119)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:267)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:199)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:141)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:114)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:98)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:834)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:487)
2025-08-31 02:06:36 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:622)
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:74)
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 	at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:1912)
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 	... 16 common frames omitted
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:37.785 [       job-0] INFO  AbstractScheduler    - The scheduler has completed all tasks.
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:37.785 [       job-0] INFO  JobContainer         - The Writer.Job [oraclewriter] perform post work.
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:37.786 [       job-0] INFO  JobContainer         - The Reader.Job [postgresqlreader] perform post work.
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:37.787 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 812431 records, 367794170 bytes | Speed 16.46KB/s, 37 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 1,805.102s | Percentage 100.00%
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 2025-08-31 02:06:37.789 [       job-0] INFO  JobContainer         - 
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] Job start  at             : 2025-08-30 20:03:00
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] Job end    at             : 2025-08-31 02:06:37
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] Job took secs             :              21816s
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] Average   bps             :           16.46KB/s
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] Average   rps             :             37rec/s
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] Number of rec             :              812431
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] Failed record             :                   0
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] 
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] ==================== DEPRECATED WARNING ========================
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] addax.py is deprecated, It's going to be removed in future release.
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] As a replacement, you can use addax.sh to run job
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53] ==================== DEPRECATED WARNING ========================
2025-08-31 02:06:37 [AnalysisStatistics.analysisStatisticsLog-53]

[weihebu]

2025-09-02 10:40:52 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:40:52.060 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 121344 records, 53319280 bytes | Speed 152.46KB/s, 341 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 386.662s | Percentage 0.00%
2025-09-02 10:41:04 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:41:04.064 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 127488 records, 56147569 bytes | Speed 230.17KB/s, 512 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 398.009s | Percentage 0.00%
2025-09-02 10:41:16 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:41:16.069 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 133632 records, 58974755 bytes | Speed 230.08KB/s, 512 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 409.298s | Percentage 0.00%
2025-09-02 10:41:28 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:41:28.074 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 141824 records, 62745314 bytes | Speed 306.85KB/s, 682 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 426.537s | Percentage 0.00%
2025-09-02 10:41:40 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:41:40.087 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 147968 records, 65547218 bytes | Speed 228.02KB/s, 512 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 438.867s | Percentage 0.00%
2025-09-02 10:41:52 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:41:52.091 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 154112 records, 68308883 bytes | Speed 224.74KB/s, 512 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 449.783s | Percentage 0.00%
2025-09-02 10:42:04 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:42:04.095 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 158208 records, 70124846 bytes | Speed 147.78KB/s, 341 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 457.014s | Percentage 0.00%
2025-09-02 10:42:16 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:42:16.100 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 164352 records, 72807828 bytes | Speed 218.34KB/s, 512 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 467.440s | Percentage 0.00%
2025-09-02 10:42:28 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:42:28.104 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 178688 records, 79142963 bytes | Speed 515.55KB/s, 1194 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 489.589s | Percentage 0.00%
2025-09-02 10:42:40 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:42:40.108 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 184832 records, 81908944 bytes | Speed 225.10KB/s, 512 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 499.374s | Percentage 0.00%
2025-09-02 10:42:52 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:42:52.113 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 190976 records, 84694340 bytes | Speed 226.68KB/s, 512 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 508.374s | Percentage 0.00%
2025-09-02 10:43:03 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:43:03.713 [  reader-0-0] INFO  CommonRdbmsReader$Task - Finished reading records by executing SQL query: [SELECT "nt_pay_voucher_id","fiscal_year","mof_div_code","mof_div_name","exec_agency_code","exec_agency_name","non_tax_pay_code","non_tax_pay_no","author","bill_date","payer_name","payer_acc_no","payer_open_bank","act_payer_name","act_payer_acc_no","act_payer_open_bank","total_pay_amt","due_amt","delay_amt","paid_amt","rec_acct_type","payee_acct_name","payee_acct_no","payee_acct_bank_name","payee_bank_code","payee_bank_name","paid_date","pay_way_code","pay_way_name","belong_org_code","belong_org_name","record_date","pay_in_met_code","pay_in_met_name","bus_type","einvoice_name","einvoice_code","random_number","checker","bill_time","payer_party_type_code","payer_party_type_name","payer_party_code","biz_code","remark","supervisor_remark","related_invoice_code","related_invoice_number","einvoice_specimen_code","supervisor_area_code","is_last_inst","update_time","is_deleted","create_time","eff_date","send_date" FROM public.nt_pay_voucher_v25 WHERE (update_time >= CURRENT_DATE - 1)].
2025-09-02 10:43:04 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:43:04.117 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 199168 records, 88423465 bytes | Speed 303.48KB/s, 682 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 520.020s | Percentage 0.00%
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:43:07.119 [       job-0] INFO  AbstractScheduler    - The scheduler has completed all tasks.
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:43:07.120 [       job-0] INFO  JobContainer         - The Writer.Job [oraclewriter] perform post work.
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:43:07.121 [       job-0] INFO  JobContainer         - The Reader.Job [postgresqlreader] perform post work.
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:43:07.123 [       job-0] INFO  StandAloneJobContainerCommunicator - Total 203647 records, 90439092 bytes | Speed 166.33KB/s, 383 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 526.660s | Percentage 100.00%
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] 2025-09-02 10:43:07.125 [       job-0] INFO  JobContainer         - 
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] Job start  at             : 2025-09-02 10:34:14
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] Job end    at             : 2025-09-02 10:43:07
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] Job took secs             :                532s
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] Average   bps             :          166.33KB/s
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] Average   rps             :            383rec/s
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] Number of rec             :              203647
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] Failed record             :                   0
2025-09-02 10:43:07 [AnalysisStatistics.analysisStatisticsLog-53] 

[weihebu]

我查询全表后发现这个blob字段长度都为0，也就是说没有实际数据存在。但是就是因为有blob字段存在，就会让任务卡住很长时间。这个字段是postgresql中的bytea类型，写入为oralce中的blob类型。