Bingchen1512 opened a new issue, #17737: URL: https://github.com/apache/doris/issues/17737
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Doirs 1.2.2 Mysql 8.0.30 ### What's Wrong? [2023-03-13 16:01:50] [HY000][1105] errCode = 2, detailMessage = NoClassDefFoundError: com/mysql/cj/protocol/a/result/BinaryBufferRow [2023-03-13 16:01:50] CAUSED BY: ClassNotFoundException: com.mysql.cj.protocol.a.result.BinaryBufferRow. But when I retry multiple times, it inserts successfully. ### What You Expected? #### mysql-catalog CREATE CATALOG jdbc_mysql PROPERTIES ( "type"="jdbc", "user"="root", "password"="root", "jdbc_url" = "jdbc:mysql://hadoop000105:3306/test_db?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&useCursorFetch=true", "driver_url" = "mysql-connector-java-8.0.30.jar", "driver_class" = "com.mysql.cj.jdbc.Driver" ); #### create doris table CREATE TABLE `ods_so_saleorder` ( `CSALEORDERID` varchar(60) NOT NULL COMMENT '销售订单主实体', `APPROVER` varchar(60) NULL COMMENT '审批人', `BADVFEEFLAG` varchar(3) NULL COMMENT '代垫运费', `BARSETTLEFLAG` varchar(3) NULL COMMENT '收入结算关闭', `BCOOPTOPOFLAG` varchar(3) NULL COMMENT '已协同生成采购订单', `BCOSTSETTLEFLAG` varchar(3) NULL COMMENT '成本结算关闭', `BFREECUSTFLAG` varchar(3) NULL COMMENT '是否散户', `BILLMAKER` varchar(60) NULL COMMENT '制单人', `BINVOICENDFLAG` varchar(3) NULL COMMENT '开票关闭', `BOFFSETFLAG` varchar(3) NULL COMMENT '是否冲抵', `BOUTENDFLAG` varchar(3) NULL COMMENT '出库关闭', `BPOCOOPTOMEFLAG` varchar(3) NULL COMMENT '由采购订单协同生成', `BPRECEIVEFLAG` varchar(3) NULL COMMENT '收款限额控制预售', `BSENDENDFLAG` varchar(3) NULL COMMENT '发货关闭', `CARSUBTYPEID` varchar(60) NULL COMMENT '赠品兑付类型', `CBALANCETYPEID` varchar(60) NULL COMMENT '结算方式', `CBILLSRCID` varchar(60) NULL COMMENT '整单来源单据ID', `CBIZTYPEID` varchar(60) NULL COMMENT '业务流程', `CCHANNELTYPEID` varchar(60) NULL COMMENT '销售渠道类型', `CCUSTBANKACCID` varchar(60) NULL COMMENT '开户银行账户', `CCUSTBANKID` varchar(60) NULL COMMENT '开户银行', `CCUSTOMERID` varchar(60) NULL COMMENT '客户', `CDEPTID` varchar(60) NULL COMMENT '部门最新版本', `CDEPTVID` varchar(60) NULL COMMENT '部门', `CEMPLOYEEID` varchar(60) NULL COMMENT '业务员', `CFREECUSTID` varchar(60) NULL COMMENT '散货', `CHRECEIVEADDID` varchar(60) NULL COMMENT '收货地址', `CHRECEIVECUSTID` varchar(60) NULL COMMENT '收货客户', `CINVOICECUSTID` varchar(60) NULL COMMENT '开票客户', `CORIGCURRENCYID` varchar(60) NULL COMMENT '原币', `CPAYTERMID` varchar(60) NULL COMMENT '收款协议', `CREATIONTIME` varchar(57) NULL COMMENT '创建时间', `CREATOR` varchar(60) NULL COMMENT '创建人', `CREVISERID` varchar(60) NULL COMMENT '修订人', `CTRADEWORDID` varchar(60) NULL COMMENT '贸易术语', `CTRANSPORTTYPEID` varchar(60) NULL COMMENT '运输方式', `CTRANTYPEID` varchar(60) NULL COMMENT '订单类型', `DBILLDATE` varchar(57) NULL COMMENT '单据日期', `DMAKEDATE` varchar(57) NULL COMMENT '下游目的单据主组织', `DR` bigint(20) NULL COMMENT '制单日期', `FPFSTATUSFLAG` bigint(20) NULL COMMENT '审批流状态', `FSTATUSFLAG` bigint(20) NULL COMMENT '单据状态(1=自由，2=审批通过，3=冻结，4=关闭，7=审批中，8=审批不通过，5=失效)', `IPRINTCOUNT` bigint(20) NULL COMMENT '打印次数', `IVERSION` bigint(20) NULL COMMENT '修订版本号', `MODIFIEDTIME` varchar(57) NULL COMMENT '修改时间', `MODIFIER` varchar(60) NULL COMMENT '修改人', `NDISCOUNTRATE` decimal(18, 8) NULL COMMENT '整单折扣', `NLRGTOTALORIGMNY` decimal(18, 8) NULL COMMENT '赠品价税合计', `NPRECEIVEMNY` decimal(18, 8) NULL COMMENT '实际预收款金额', `NPRECEIVEQUOTA` decimal(18, 8) NULL COMMENT '订单收款限额', `NPRECEIVERATE` decimal(18, 8) NULL COMMENT '本次收款金额', `NRECEIVEDMNY` decimal(18, 8) NULL COMMENT '冲抵前金额', `NTOTALNUM` decimal(18, 8) NULL COMMENT '总重量', `NTOTALORIGMNY` decimal(18, 8) NULL COMMENT '价税合计', `NTOTALORIGSUBMNY` decimal(18, 8) NULL COMMENT '费用冲抵金额', `NTOTALPIECE` decimal(18, 8) NULL COMMENT '总件数', `NTOTALVOLUME` decimal(18, 8) NULL COMMENT '合计体积', `NTOTALWEIGHT` decimal(18, 8) NULL COMMENT '合计重量', `PK_GROUP` varchar(60) NULL COMMENT '集团', `PK_ORG` varchar(60) NULL COMMENT '销售组织', `PK_ORG_V` varchar(60) NULL COMMENT '销售组织版本', `TAUDITTIME` varchar(57) NULL COMMENT '审核日期', `TREVISETIME` varchar(57) NULL COMMENT '修订时间', `TS` varchar(57) NULL, `VBILLCODE` varchar(120) NULL COMMENT '单据号', `VBILLSRCTYPE` varchar(60) NULL COMMENT '整单来源单据类型', `VCOOPPOHCODE` varchar(120) NULL COMMENT '对方订单号', `VCREDITNUM` varchar(60) NULL COMMENT '信用证号', `VDEF1` varchar(600) NULL COMMENT '自定义项1', `VDEF10` varchar(303) NULL, `VDEF11` varchar(303) NULL, `VDEF12` varchar(303) NULL, `VDEF13` varchar(303) NULL, `VDEF14` varchar(303) NULL, `VDEF15` varchar(303) NULL, `VDEF16` varchar(303) NULL, `VDEF17` varchar(303) NULL, `VDEF18` varchar(303) NULL, `VDEF19` varchar(303) NULL, `VDEF2` varchar(303) NULL, `VDEF20` varchar(303) NULL, `VDEF3` varchar(303) NULL, `VDEF4` varchar(303) NULL, `VDEF5` varchar(303) NULL, `VDEF6` varchar(303) NULL, `VDEF7` varchar(303) NULL, `VDEF8` varchar(303) NULL, `VDEF9` varchar(303) NULL, `VNOTE` varchar(5433) NULL COMMENT '备注', `VREVISEREASON` varchar(543) NULL COMMENT '修订理由', `VTRANTYPECODE` varchar(60) NULL COMMENT '订单类型编码', `__op` boolean NULL ) ENGINE=OLAP UNIQUE KEY(`CSALEORDERID`) COMMENT 'OLAP' DISTRIBUTED BY HASH(`CSALEORDERID`) BUCKETS 4 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "in_memory" = "false", "storage_format" = "V2", "enable_unique_key_merge_on_write" = "true", "light_schema_change" = "true", "disable_auto_compaction" = "false" ); #### create mysql sql CREATE TABLE `ods_so_saleorder` ( `CSALEORDERID` varchar(60) NOT NULL COMMENT '销售订单主实体', `APPROVER` varchar(60) NULL COMMENT '审批人', `BADVFEEFLAG` varchar(3) NULL COMMENT '代垫运费', `BARSETTLEFLAG` varchar(3) NULL COMMENT '收入结算关闭', `BCOOPTOPOFLAG` varchar(3) NULL COMMENT '已协同生成采购订单', `BCOSTSETTLEFLAG` varchar(3) NULL COMMENT '成本结算关闭', `BFREECUSTFLAG` varchar(3) NULL COMMENT '是否散户', `BILLMAKER` varchar(60) NULL COMMENT '制单人', `BINVOICENDFLAG` varchar(3) NULL COMMENT '开票关闭', `BOFFSETFLAG` varchar(3) NULL COMMENT '是否冲抵', `BOUTENDFLAG` varchar(3) NULL COMMENT '出库关闭', `BPOCOOPTOMEFLAG` varchar(3) NULL COMMENT '由采购订单协同生成', `BPRECEIVEFLAG` varchar(3) NULL COMMENT '收款限额控制预售', `BSENDENDFLAG` varchar(3) NULL COMMENT '发货关闭', `CARSUBTYPEID` varchar(60) NULL COMMENT '赠品兑付类型', `CBALANCETYPEID` varchar(60) NULL COMMENT '结算方式', `CBILLSRCID` varchar(60) NULL COMMENT '整单来源单据ID', `CBIZTYPEID` varchar(60) NULL COMMENT '业务流程', `CCHANNELTYPEID` varchar(60) NULL COMMENT '销售渠道类型', `CCUSTBANKACCID` varchar(60) NULL COMMENT '开户银行账户', `CCUSTBANKID` varchar(60) NULL COMMENT '开户银行', `CCUSTOMERID` varchar(60) NULL COMMENT '客户', `CDEPTID` varchar(60) NULL COMMENT '部门最新版本', `CDEPTVID` varchar(60) NULL COMMENT '部门', `CEMPLOYEEID` varchar(60) NULL COMMENT '业务员', `CFREECUSTID` varchar(60) NULL COMMENT '散货', `CHRECEIVEADDID` varchar(60) NULL COMMENT '收货地址', `CHRECEIVECUSTID` varchar(60) NULL COMMENT '收货客户', `CINVOICECUSTID` varchar(60) NULL COMMENT '开票客户', `CORIGCURRENCYID` varchar(60) NULL COMMENT '原币', `CPAYTERMID` varchar(60) NULL COMMENT '收款协议', `CREATIONTIME` varchar(57) NULL COMMENT '创建时间', `CREATOR` varchar(60) NULL COMMENT '创建人', `CREVISERID` varchar(60) NULL COMMENT '修订人', `CTRADEWORDID` varchar(60) NULL COMMENT '贸易术语', `CTRANSPORTTYPEID` varchar(60) NULL COMMENT '运输方式', `CTRANTYPEID` varchar(60) NULL COMMENT '订单类型', `DBILLDATE` varchar(57) NULL COMMENT '单据日期', `DMAKEDATE` varchar(57) NULL COMMENT '下游目的单据主组织', `DR` bigint(20) NULL COMMENT '制单日期', `FPFSTATUSFLAG` bigint(20) NULL COMMENT '审批流状态', `FSTATUSFLAG` bigint(20) NULL COMMENT '单据状态(1=自由，2=审批通过，3=冻结，4=关闭，7=审批中，8=审批不通过，5=失效)', `IPRINTCOUNT` bigint(20) NULL COMMENT '打印次数', `IVERSION` bigint(20) NULL COMMENT '修订版本号', `MODIFIEDTIME` varchar(57) NULL COMMENT '修改时间', `MODIFIER` varchar(60) NULL COMMENT '修改人', `NDISCOUNTRATE` decimal(18, 8) NULL COMMENT '整单折扣', `NLRGTOTALORIGMNY` decimal(18, 8) NULL COMMENT '赠品价税合计', `NPRECEIVEMNY` decimal(18, 8) NULL COMMENT '实际预收款金额', `NPRECEIVEQUOTA` decimal(18, 8) NULL COMMENT '订单收款限额', `NPRECEIVERATE` decimal(18, 8) NULL COMMENT '本次收款金额', `NRECEIVEDMNY` decimal(18, 8) NULL COMMENT '冲抵前金额', `NTOTALNUM` decimal(18, 8) NULL COMMENT '总重量', `NTOTALORIGMNY` decimal(18, 8) NULL COMMENT '价税合计', `NTOTALORIGSUBMNY` decimal(18, 8) NULL COMMENT '费用冲抵金额', `NTOTALPIECE` decimal(18, 8) NULL COMMENT '总件数', `NTOTALVOLUME` decimal(18, 8) NULL COMMENT '合计体积', `NTOTALWEIGHT` decimal(18, 8) NULL COMMENT '合计重量', `PK_GROUP` varchar(60) NULL COMMENT '集团', `PK_ORG` varchar(60) NULL COMMENT '销售组织', `PK_ORG_V` varchar(60) NULL COMMENT '销售组织版本', `TAUDITTIME` varchar(57) NULL COMMENT '审核日期', `TREVISETIME` varchar(57) NULL COMMENT '修订时间', `TS` varchar(57) NULL, `VBILLCODE` varchar(120) NULL COMMENT '单据号', `VBILLSRCTYPE` varchar(60) NULL COMMENT '整单来源单据类型', `VCOOPPOHCODE` varchar(120) NULL COMMENT '对方订单号', `VCREDITNUM` varchar(60) NULL COMMENT '信用证号', `VDEF1` varchar(600) NULL COMMENT '自定义项1', `VDEF10` varchar(303) NULL, `VDEF11` varchar(303) NULL, `VDEF12` varchar(303) NULL, `VDEF13` varchar(303) NULL, `VDEF14` varchar(303) NULL, `VDEF15` varchar(303) NULL, `VDEF16` varchar(303) NULL, `VDEF17` varchar(303) NULL, `VDEF18` varchar(303) NULL, `VDEF19` varchar(303) NULL, `VDEF2` varchar(303) NULL, `VDEF20` varchar(303) NULL, `VDEF3` varchar(303) NULL, `VDEF4` varchar(303) NULL, `VDEF5` varchar(303) NULL, `VDEF6` varchar(303) NULL, `VDEF7` varchar(303) NULL, `VDEF8` varchar(303) NULL, `VDEF9` varchar(303) NULL, `VNOTE` varchar(5433) NULL COMMENT '备注', `VREVISEREASON` varchar(543) NULL COMMENT '修订理由', `VTRANTYPECODE` varchar(60) NULL COMMENT '订单类型编码', `__op` boolean NULL ) ENGINE=OLAP UNIQUE KEY(`CSALEORDERID`) COMMENT 'OLAP' DISTRIBUTED BY HASH(`CSALEORDERID`) BUCKETS 4 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "in_memory" = "false", "storage_format" = "V2", "enable_unique_key_merge_on_write" = "true", "light_schema_change" = "true", "disable_auto_compaction" = "false" ); #### insert into insert into ods_so_saleorder(APPROVER,BADVFEEFLAG,BARSETTLEFLAG,BCOOPTOPOFLAG,BCOSTSETTLEFLAG,BFREECUSTFLAG,BILLMAKER,BINVOICENDFLAG,BOFFSETFLAG,BOUTENDFLAG,BPOCOOPTOMEFLAG,BPRECEIVEFLAG,BSENDENDFLAG,CARSUBTYPEID,CBALANCETYPEID,CBILLSRCID,CBIZTYPEID,CCHANNELTYPEID,CCUSTBANKACCID,CCUSTBANKID,CCUSTOMERID,CDEPTID,CDEPTVID,CEMPLOYEEID,CFREECUSTID,CHRECEIVEADDID,CHRECEIVECUSTID,CINVOICECUSTID,CORIGCURRENCYID,CPAYTERMID,CREATIONTIME,CREATOR,CREVISERID,CSALEORDERID,CTRADEWORDID,CTRANSPORTTYPEID,CTRANTYPEID,DBILLDATE,DMAKEDATE,DR,FPFSTATUSFLAG,FSTATUSFLAG,IPRINTCOUNT,IVERSION,MODIFIEDTIME,MODIFIER,NDISCOUNTRATE,NLRGTOTALORIGMNY,NPRECEIVEMNY,NPRECEIVEQUOTA,NPRECEIVERATE,NRECEIVEDMNY,NTOTALNUM,NTOTALORIGMNY,NTOTALORIGSUBMNY,NTOTALPIECE,NTOTALVOLUME,NTOTALWEIGHT,PK_GROUP,PK_ORG,PK_ORG_V,TAUDITTIME,TREVISETIME,TS,VBILLCODE,VBILLSRCTYPE,VCOOPPOHCODE,VCREDITNUM,VDEF1,VDEF10,VDEF11,VDEF12,VDEF13,VDEF14,VDEF15,VDEF16,VDEF17,VDEF18,VDEF19,VDEF2,VDEF20,VDEF3,VDEF4,VDEF5,VDEF6,VDEF7,VDEF8,VDEF9,VNOT E,VREVISEREASON,VTRANTYPECODE,__OP) select *,0 from jdbc_mysql.test_db.so_saleorder; ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
