[INFO]-[2024-03-26 15:21:05]-[put_entinctax.sh]-[生成卸数文件开始] [INFO]-[2024-03-26 15:21:05]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_ZCJS_U_20210228.dat...] 2024-03-26 15:21:06 [INFO] Parsed args: [--cut] true [--file-path] /data/etl/cw_etl/out/enter_inc_tax/20210228 [--no-sys] true [--column-splitter]  [--null-string] [--empty-string] [--trail-delimiter] true [--host] 10.116.87.40 [--port] 2883 [--user] FMS_NCC@fms#sy_gold_obcl03 [--password] ****** [--database] FMS_NCC [--sys-user] root [--query-sql] select 'ZCJS'||seq_account.nextval, trim(both '0' from b.code) code, a.bill_code, a.bill_status, c.name, d.user_name, a.audittime, e.card_code, e.asset_code, e.asset_name, e.spec, e.card_model, e.begin_date, h.naturemonth, h.usedmonth, f.name, g.red_localoriginvalue, h.curryeardep, g.accudep, g.red_netrating, g.purgerevenue, case when g.def1 = '~' then 0 else to_number(g.def1) end def1, nvl(g.purgefee,0) as purgefee, 0 from fa_reduce a, org_orgs b, org_accountingbook c, sm_user d, fa_card e, org_dept f, fa_reduce_b g, fa_cardhistory h where a.pk_org = b.pk_org and a.pk_accbook = c.pk_accountingbook and a.billmaker = d.cuserid and a.pk_reduce = g.pk_reduce and g.pk_card = e.pk_card and e.pk_card= h.pk_card and substr(a.business_date,0,7)=h.accyear||'-'||h.period and h.pk_mandept = f.pk_dept and a.bill_status='3' and substr(a.business_date,0,7) = '2021-02'; [--file-name] FMS_ZCJS_U_20210228.dat [--skip-check-dir] true [--remove-newline] true [--retain-empty-files] true 2024-03-26 15:21:06 [INFO] Load jdbc driver class: "com.oceanbase.jdbc.Driver" finished 2024-03-26 15:21:17 [INFO] Generate 1 dump tasks finished. Total Elapsed: 11.07 ms 2024-03-26 15:21:17 [INFO] Start 16 record dump threads for 1 dump tasks finished 2024-03-26 15:21:21 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:21:22 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:21:26 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ---------- 2024-03-26 15:21:26 [INFO] All Dump Tasks Finished: ---------------------------------------------------------------------------------------------------------------------------- No.# | Type | Name | Count | Status ---------------------------------------------------------------------------------------------------------------------------- 1 | TABLE | CUSTOM_SQL | 0 | SUCCESS ---------------------------------------------------------------------------------------------------------------------------- Total Count: 0 End Time: 2024-03-26 15:21:26 2024-03-26 15:21:26 [INFO] Merge 1 data files into "/data/etl/cw_etl/out/enter_inc_tax/20210228/data/FMS_NCC/TABLE/FMS_ZCJS_U_20210228.dat" finished. Elapsed: 353.2 μs 2024-03-26 15:21:26 [INFO] Merge data files for 1 tables finished. Elapsed: 6.137 ms 2024-03-26 15:21:26 [INFO] Dump record finished. Total Elapsed: 9.289 s 2024-03-26 15:21:26 [INFO] System exit 0 [INFO]-[2024-03-26 15:21:26]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_ZCJS_U_20210228.dat成功] [INFO]-[2024-03-26 15:21:26]-[put_entinctax.sh]-[生成校验文件FMS_ZCJS_U_20210228.verf开始] [INFO]-[2024-03-26 15:21:26]-[put_entinctax.sh]-[生成校验文件FMS_ZCJS_U_20210228.verf结束] [INFO]-[2024-03-26 15:21:26]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_ZCKPTZ_U_20210228.dat...] 2024-03-26 15:21:27 [INFO] Parsed args: [--cut] true [--file-path] /data/etl/cw_etl/out/enter_inc_tax/20210228 [--no-sys] true [--column-splitter]  [--null-string] [--empty-string] [--trail-delimiter] true [--host] 10.116.87.40 [--port] 2883 [--user] FMS_NCC@fms#sy_gold_obcl03 [--password] ****** [--database] FMS_NCC [--sys-user] root [--query-sql] select 'KPTZ'||seq_account.nextval, trim(both '0' from c.code) code, d.name, b.accyear || '-' || b.period, a.card_code, a.asset_code, a.asset_name, a.spec, a.card_model, b.localoriginvalue, b.accudep, b.curryeardep, b.salvage, b.predevaluate, b.originvalue-b.accudep-b.predevaluate,--净额字段未找到暂定为0 t.cate_code, t1.status_name, e.name, f.code, g.code, a.position, b.dep_start_date, a.business_date, '', '', b.tax_input, b.salvagerate, b.naturemonth, b.depamount from fa_card a, fa_cardhistory b, org_orgs c, fa_category t, fa_usingstatus t1, org_accountingbook d, org_dept e, org_dept f, fa_deptscale i, bd_psndoc g where a.pk_card = b.pk_card and a.pk_org = c.pk_org and b.pk_mandept = e.pk_dept and b.pk_category = t.pk_category and b.pk_usingstatus = t1.pk_usingstatus and b.pk_accbook = d.pk_accountingbook and b.pk_usedept = i.link_key and i.pk_dept = f.pk_dept and a.pk_assetuser = g.pk_psndoc(+) and b.accyear || '-' || b.period='2021-02'; [--file-name] FMS_ZCKPTZ_U_20210228.dat [--skip-check-dir] true [--remove-newline] true [--retain-empty-files] true 2024-03-26 15:21:27 [INFO] Load jdbc driver class: "com.oceanbase.jdbc.Driver" finished 2024-03-26 15:21:32 [INFO] Generate 1 dump tasks finished. Total Elapsed: 10.96 ms 2024-03-26 15:21:32 [INFO] Start 16 record dump threads for 1 dump tasks finished 2024-03-26 15:21:36 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:21:37 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:21:42 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:21:42 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:21:47 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:21:47 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:21:52 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:21:52 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 4900.78 Records/sec | 1.26 MB/sec | 1 Slots 1.min.avg | 1567.13 Records/sec | 411.35 KB/sec | 1 Slots Total | 98058 Records | 25.14 MB | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:21:57 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ---------- 2024-03-26 15:21:57 [INFO] All Dump Tasks Finished: ---------------------------------------------------------------------------------------------------------------------------- No.# | Type | Name | Count | Status ---------------------------------------------------------------------------------------------------------------------------- 1 | TABLE | CUSTOM_SQL | 212977 | SUCCESS ---------------------------------------------------------------------------------------------------------------------------- Total Count: 212977 End Time: 2024-03-26 15:21:57 2024-03-26 15:21:57 [INFO] Merge 1 data files into "/data/etl/cw_etl/out/enter_inc_tax/20210228/data/FMS_NCC/TABLE/FMS_ZCKPTZ_U_20210228.dat" finished. Elapsed: 360.2 μs 2024-03-26 15:21:57 [INFO] Merge data files for 1 tables finished. Elapsed: 6.386 ms 2024-03-26 15:21:57 [INFO] Dump record finished. Total Elapsed: 24.29 s 2024-03-26 15:21:57 [INFO] System exit 0 [INFO]-[2024-03-26 15:21:57]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_ZCKPTZ_U_20210228.dat成功] [INFO]-[2024-03-26 15:21:57]-[put_entinctax.sh]-[生成校验文件FMS_ZCKPTZ_U_20210228.verf开始] [INFO]-[2024-03-26 15:21:57]-[put_entinctax.sh]-[生成校验文件FMS_ZCKPTZ_U_20210228.verf结束] [INFO]-[2024-03-26 15:21:57]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_YBYZTZ_U_20210228.dat...] 2024-03-26 15:21:58 [INFO] Parsed args: [--cut] true [--file-path] /data/etl/cw_etl/out/enter_inc_tax/20210228 [--no-sys] true [--column-splitter]  [--null-string] [--empty-string] [--trail-delimiter] true [--host] 10.116.87.40 [--port] 2883 [--user] FMS_NCC@fms#sy_gold_obcl03 [--password] ****** [--database] FMS_NCC [--sys-user] root [--query-sql] select 'YZTZ'||seq_account.nextval, trim(both '0' from b.code) code, a.bill_code, a.bill_status, a.business_date, d.user_name, a.audittime, e.card_code, e.asset_code, e.asset_name, e.spec, e.card_model, nvl(g.originvalue_cal_before, 0), nvl(i.differ, 0), 0, (nvl(g.originvalue_cal_before, 0) + nvl(i.differ, 0)), h.reason_name from fa_alter a, org_orgs b, sm_user d, fa_card e, fa_alter_b g, fa_altersheet i, fa_reason h where a.pk_org = b.pk_org and a.billmaker = d.cuserid and a.pk_alter = g.pk_alter and a.pk_alter = i.pk_alter and g.pk_alter_b = i.pk_alter_b and g.pk_card = e.pk_card and g.pk_reason = h.pk_reason and a.transi_type = 'HG-01' and i.altertype = '16' and b.isbusinessunit = 'Y' and a.dr = '0' and b.dr = '0' and g.dr = '0' and i.dr = '0' and e.dr = '0' and d.dr = '0' and h.dr = '0' and a.bill_status = '3' and substr(a.BUSINESS_DATE,1,7) = '2021-02'; [--file-name] FMS_YBYZTZ_U_20210228.dat [--skip-check-dir] true [--remove-newline] true [--retain-empty-files] true 2024-03-26 15:21:58 [INFO] Load jdbc driver class: "com.oceanbase.jdbc.Driver" finished 2024-03-26 15:22:07 [INFO] Generate 1 dump tasks finished. Total Elapsed: 13.12 ms 2024-03-26 15:22:07 [INFO] Start 16 record dump threads for 1 dump tasks finished 2024-03-26 15:22:11 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:22:12 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:22:17 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:22:17 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:22:19 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ---------- 2024-03-26 15:22:19 [INFO] All Dump Tasks Finished: ---------------------------------------------------------------------------------------------------------------------------- No.# | Type | Name | Count | Status ---------------------------------------------------------------------------------------------------------------------------- 1 | TABLE | CUSTOM_SQL | 8 | SUCCESS ---------------------------------------------------------------------------------------------------------------------------- Total Count: 8 End Time: 2024-03-26 15:22:19 2024-03-26 15:22:19 [INFO] Merge 1 data files into "/data/etl/cw_etl/out/enter_inc_tax/20210228/data/FMS_NCC/TABLE/FMS_YBYZTZ_U_20210228.dat" finished. Elapsed: 461.2 μs 2024-03-26 15:22:19 [INFO] Merge data files for 1 tables finished. Elapsed: 30.65 ms 2024-03-26 15:22:19 [INFO] Dump record finished. Total Elapsed: 11.35 s 2024-03-26 15:22:19 [INFO] System exit 0 [INFO]-[2024-03-26 15:22:19]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_YBYZTZ_U_20210228.dat成功] [INFO]-[2024-03-26 15:22:19]-[put_entinctax.sh]-[生成校验文件FMS_YBYZTZ_U_20210228.verf开始] [INFO]-[2024-03-26 15:22:19]-[put_entinctax.sh]-[生成校验文件FMS_YBYZTZ_U_20210228.verf结束] [INFO]-[2024-03-26 15:22:19]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_CWGLXTZZ_U_20210228.dat...] 2024-03-26 15:22:20 [INFO] Parsed args: [--cut] true [--file-path] /data/etl/cw_etl/out/enter_inc_tax/20210228 [--no-sys] true [--column-splitter]  [--null-string] [--empty-string] [--trail-delimiter] true [--host] 10.116.87.40 [--port] 2883 [--user] FMS_NCC@fms#sy_gold_obcl03 [--password] ****** [--database] FMS_NCC [--sys-user] root [--query-sql] select 'XTZZ'||seq_account.nextval, g.name, --'hx', trim(both '0' from e.code) code, --'hxmc', e.name, substr(b.prepareddate,1,10), b.num, a.explanation, substr(DISPNAME,1,instr(DISPNAME,'\')-1), substr(DISPNAME,instr(DISPNAME,'\')+1), a.localdebitamount-a.localcreditamount, a.localdebitamount, a.localcreditamount, f.user_code, substr(b.tallydate,1,10), 'FMS', b.year||'-'||b.period, j.name from gl_detail a, gl_voucher b, bd_accasoa c, bd_account d, org_orgs e, sm_user f, org_accountingbook g, fip_relation h, er_bxzb i, bd_inoutbusiclass j where a.pk_voucher = b.pk_voucher and a.pk_accasoa = c.pk_accasoa and a.pk_account = d.pk_account and a.pk_org = e.pk_org and b.pk_accountingbook = g.pk_accountingbook and b.pk_voucher = h.des_relationid(+) and substr(h.src_relationid,1,20) = i.pk_jkbx(+) and i.szxmid = j.pk_inoutbusiclass(+) and e.isbusinessunit='Y' and b.pk_prepared = f.cuserid and b.tallydate <> '~' and a.YEARV||'-'||PERIODV = '2021-02'; [--file-name] FMS_CWGLXTZZ_U_20210228.dat [--skip-check-dir] true [--remove-newline] true [--retain-empty-files] true 2024-03-26 15:22:20 [INFO] Load jdbc driver class: "com.oceanbase.jdbc.Driver" finished 2024-03-26 15:22:25 [INFO] Generate 1 dump tasks finished. Total Elapsed: 10.56 ms 2024-03-26 15:22:25 [INFO] Start 16 record dump threads for 1 dump tasks finished 2024-03-26 15:22:29 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:22:30 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:22:34 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:22:35 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 3332.5 Records/sec | 707.73 KB/sec | 1 Slots 1.min.avg | 531.0 Records/sec | 112.75 KB/sec | 1 Slots Total | 33354 Records | 6.92 MB | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:22:35 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ---------- 2024-03-26 15:22:35 [INFO] All Dump Tasks Finished: ---------------------------------------------------------------------------------------------------------------------------- No.# | Type | Name | Count | Status ---------------------------------------------------------------------------------------------------------------------------- 1 | TABLE | CUSTOM_SQL | 36971 | SUCCESS ---------------------------------------------------------------------------------------------------------------------------- Total Count: 36971 End Time: 2024-03-26 15:22:35 2024-03-26 15:22:35 [INFO] Merge 1 data files into "/data/etl/cw_etl/out/enter_inc_tax/20210228/data/FMS_NCC/TABLE/FMS_CWGLXTZZ_U_20210228.dat" finished. Elapsed: 356.3 μs 2024-03-26 15:22:35 [INFO] Merge data files for 1 tables finished. Elapsed: 6.807 ms 2024-03-26 15:22:35 [INFO] Dump record finished. Total Elapsed: 10.29 s 2024-03-26 15:22:35 [INFO] System exit 0 [INFO]-[2024-03-26 15:22:36]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_CWGLXTZZ_U_20210228.dat成功] [INFO]-[2024-03-26 15:22:36]-[put_entinctax.sh]-[生成校验文件FMS_CWGLXTZZ_U_20210228.verf开始] [INFO]-[2024-03-26 15:22:36]-[put_entinctax.sh]-[生成校验文件FMS_CWGLXTZZ_U_20210228.verf结束] [INFO]-[2024-03-26 15:22:36]-[put_entinctax.sh]-[连接数据库读取数据写入文件FMS_FPQD_U_20210228.dat...] 2024-03-26 15:22:37 [INFO] Parsed args: [--cut] true [--file-path] /data/etl/cw_etl/out/enter_inc_tax/20210228 [--no-sys] true [--column-splitter]  [--null-string] [--empty-string] [--trail-delimiter] true [--host] 10.116.87.40 [--port] 2883 [--user] FMS_NCC@fms#sy_gold_obcl03 [--password] ****** [--database] FMS_NCC [--sys-user] root [--query-sql] select 'FPQD'||seq_account.nextval, trim(both '0' from orgs.code) code, --报销机构号 orgs.name, --报销机构名称 invoice.salename, --销方名称 invoice.saletaxno, --销方税号 busitem.fplxpk, --发票类型 regexp_replace(coalesce(busitem.fpdm,translate(invoice.INVCODE USING CHAR_CS)),'\n',''), --发票代码 coalesce(invoice.invoiceno,busitem.fphm), --发票号码 busitem.tax_amount+busitem.tni_amount as total, --合计金额 busitem.tax_rate, --税率 busitem.tax_amount, --税额合计 busitem.tni_amount, --不含税金额 substr(busitem.defitem15,1,10), --开票日期 '已报销', --报销状态 bxzb.djbh, --报销单单号 busitem.defitem23, --货物或应税服务名称 substr(voucher.tallydate,1,10), --会计期间 voucher.num, --凭证编码 ACCO2.CODE AS ACCCODE, --科目编码 ACCO2.NAME AS ACCNAME --科目名称 from er_busitem busitem left join (select FIP.FACTORVALUE1,acco.code,acco.name from fip_docview_b FIP LEFT JOIN bd_accasoa ACC ON ACC.PK_ACCASOA=FIP.DESDOCVALUE AND acc.dr='0' AND FIP.pk_classview = '1001A910000000001753' --收支项目 AND fip.dr='0' LEFT JOIN BD_ACCOUNT ACCO ON ACC.PK_ACCOUNT=ACCO.PK_ACCOUNT AND acco.dr='0' where acco.code is not null) acco2 ON acco2.FACTORVALUE1=BUSITEM.SZXMID left join er_bxzb bxzb on bxzb.pk_jkbx = busitem.pk_jkbx left join fip_relation relation on bxzb.pk_jkbx = substr(relation.src_relationid,1,20) inner join gl_voucher voucher on relation.des_relationid = voucher.pk_voucher left join erm_vtaxinvoice_h invoice on busitem.defitem17 = invoice.pk_bill_h left join bd_defdoc defdoc on invoice.vdef4 = defdoc.pk_defdoc left join org_orgs orgs on bxzb.pk_org = orgs.pk_org where substr(voucher.tallydate,1,7) = '2021-02' and coalesce(invoice.invoiceno,busitem.fphm) is not null; [--file-name] FMS_FPQD_U_20210228.dat [--skip-check-dir] true [--remove-newline] true [--retain-empty-files] true 2024-03-26 15:22:37 [INFO] Load jdbc driver class: "com.oceanbase.jdbc.Driver" finished 2024-03-26 15:22:45 [INFO] Generate 1 dump tasks finished. Total Elapsed: 11.11 ms 2024-03-26 15:22:45 [INFO] Start 16 record dump threads for 1 dump tasks finished 2024-03-26 15:22:49 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ---------- 2024-03-26 15:22:50 [ERROR] create connection SQLException, url: jdbc:oceanbase://10.116.87.40:2883/FMS_NCC?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&log=true&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&emulateUnsupportedPstmts=true&useServerPrepStmts=true&log=true, errorCode 0, state 08000 java.sql.SQLNonTransientConnectionException: Could not connect to 10.116.87.40:2883 : unexpected end of stream, read 0 bytes from 4 at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:122) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1644) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1427) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:306) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.Driver.connect(Driver.java:89) ~[oceanbase-client-2.4.3.jar:?] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1691) ~[druid-1.2.18.jar:?] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1789) ~[druid-1.2.18.jar:?] at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2942) ~[druid-1.2.18.jar:?] Caused by: java.sql.SQLNonTransientConnectionException: unexpected end of stream, read 0 bytes from 4 at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2559) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2041) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.additionalData(AbstractConnectProtocol.java:1274) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.postConnectionQueries(AbstractConnectProtocol.java:986) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:626) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1639) ~[oceanbase-client-2.4.3.jar:?] ... 6 more Caused by: java.io.EOFException: unexpected end of stream, read 0 bytes from 4 at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.readMysqlStream(StandardPacketInputStream.java:158) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:104) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:91) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2039) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.additionalData(AbstractConnectProtocol.java:1274) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.postConnectionQueries(AbstractConnectProtocol.java:986) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:626) ~[oceanbase-client-2.4.3.jar:?] at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1639) ~[oceanbase-client-2.4.3.jar:?] ... 6 more 2024-03-26 15:22:50 [INFO] Dump Performance Monitor: ------------------------------------------------------------------------------------------------------- Dimension \ Metric | Tps | Throughput | Buffer ------------------------------------------------------------------------------------------------------- 1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots 1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots Total | 0 Records | 0.0 B | 1 Slots ------------------------------------------------------------------------------------------------------- 2024-03-26 15:22:52 [ERROR] Error: unexpected end of stream, read 0 bytes from 4 2024-03-26 15:22:52 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ---------- 2024-03-26 15:22:52 [INFO] All Dump Tasks Finished: ---------------------------------------------------------------------------------------------------------------------------- No.# | Type | Name | Count | Status ---------------------------------------------------------------------------------------------------------------------------- 1 | TABLE | CUSTOM_SQL | 0 | FAILURE ---------------------------------------------------------------------------------------------------------------------------- Total Count: 0 End Time: 2024-03-26 15:22:52 2024-03-26 15:22:52 [INFO] Dump record finished. Total Elapsed: 6.282 s 2024-03-26 15:22:52 [ERROR] System exit 1 [INFO]-[2024-03-26 15:22:52]-[put_entinctax.sh]-[FMS_FPQD_U_20210228.dat数据文件生成失败]