【 使用环境 】生产环境
【 OB or 其他组件 】
【 4.2.1.3】
【问题描述】
对ob的数据进行导出导入，导出od上的small_oa169数据库，包含ddl以及数据，命令如下:
./ob/bin/obdumper -h 127.0.0.1 -P 2883 -u root@neo_169 -p DevOps00@+ -D small_oa_169 --ddl --csv --no-sys --skip-check-dir --all -f ./output
执行正确，在output目录下 ddl csv正确生成
把导出的数据，导入到small_oa_999中，表结构全部导入成功，但是导出csv数据的时候，部分表失败，数据导入不进去，提示表连接不上，
导入命令：./ob/bin/obloader -h 127.0.0.1 -P 2883 -u root@neo_169 -p DevOps00@+ -D small_oa_360 --ddl --csv --no-sys --skip-check-dir --all -f ./output
错误： Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_member_card_config.0.csv” into table small_oa_999.t_member_card_config. Reason: Load data into “small_oa_999”.“t_member_card_config” failed! ConnectException: 拒绝连接 (Connection refused)
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：
连接正常的，是一部分表成功了，一部分表失败
-u root@neo_169 参数写法不对 。 需要拆分开 -u root -t neo_169
还是报同样的错误，提示：
Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_product_stock_detail_snapshot.1.csv” into table small_oa_101.t_product_stock_detail_snapshot. Reason: Load data into “small_oa_101”.“t_product_stock_detail_snapshot” failed! ConnectException: 拒绝连接 (Connection refused)
有这种提示的表，数据导入就是失败的
执行失败后打印日志会提示失败的日志路径，提供下日志文件看看。
我重新再来一次，稍等下。
我有个想法， 是不导入数据的时候 开了多个连接，oceanbase限制了，所以部分连接表失败了。
是不是导入一个表，开启一个连接，我这里700多张表导入
执行的导入命令
./ob/bin/obloader -h 127.0.0.1 -P 2883 -u root@neo_169 -p DevOps00@+ -D small_oa_123 --ddl --csv --no-sys --all -f ./output
错误日志
ailed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_pay_gateway_pay_config_log.0.csv” into table small_oa_123.t_pay_gateway_pay_config_log. Reason: Load data into “small_oa_123”.“t_pay_gateway_pay_config_log” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_imei_change_record.0.csv” into table small_oa_123.t_imei_change_record. Reason: Load data into “small_oa_123”.“t_imei_change_record” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_diy_info.0.csv” into table small_oa_123.t_diy_info. Reason: Load data into “small_oa_123”.“t_diy_info” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_depart_integral_record.0.csv” into table small_oa_123.t_depart_integral_record. Reason: Load data into “small_oa_123”.“t_depart_integral_record” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_pay_gateway_pay_config_area_rel.0.csv” into table small_oa_123.t_pay_gateway_pay_config_area_rel. Reason: Load data into “small_oa_123”.“t_pay_gateway_pay_config_area_rel” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_sys_config.0.csv” into table small_oa_123.t_sys_config. Reason: Load data into “small_oa_123”.“t_sys_config” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_product_stock_transfer_check_record.0.csv” into table small_oa_123.t_product_stock_transfer_check_record. Reason: Load data into “small_oa_123”.“t_product_stock_transfer_check_record” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_special_user_log.0.csv” into table small_oa_123.t_special_user_log. Reason: Load data into “small_oa_123”.“t_special_user_log” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_diy_product_conf.0.csv” into table small_oa_123.t_diy_product_conf. Reason: Load data into “small_oa_123”.“t_diy_product_conf” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_employment_experience.0.csv” into table small_oa_123.t_employment_experience. Reason: Load data into “small_oa_123”.“t_employment_experience” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_area_info_log.0.csv” into table small_oa_123.t_area_info_log. Reason: Load data into “small_oa_123”.“t_area_info_log” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_member_pay_card_gift.0.csv” into table small_oa_123.t_member_pay_card_gift. Reason: Load data into “small_oa_123”.“t_member_pay_card_gift” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_special_user.0.csv” into table small_oa_123.t_special_user. Reason: Load data into “small_oa_123”.“t_special_user” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_business_specific_group_condition.0.csv” into table small_oa_123.t_business_specific_group_condition. Reason: Load data into “small_oa_123”.“t_business_specific_group_condition” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_staff_integral_label_relation.0.csv” into table small_oa_123.t_staff_integral_label_relation. Reason: Load data into “small_oa_123”.“t_staff_integral_label_relation” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_pjt_opt_record.0.csv” into table small_oa_123.t_pjt_opt_record. Reason: Load data into “small_oa_123”.“t_pjt_opt_record” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_user_account_day.0.csv” into table small_oa_123.t_user_account_day. Reason: Load data into “small_oa_123”.“t_user_account_day” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_category_diy.0.csv” into table small_oa_123.t_category_diy. Reason: Load data into “small_oa_123”.“t_category_diy” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_merchant_visit_record_log.0.csv” into table small_oa_123.t_merchant_visit_record_log. Reason: Load data into “small_oa_123”.“t_merchant_visit_record_log” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/aa_account_code.0.csv” into table small_oa_123.aa_account_code. Reason: Load data into “small_oa_123”.“aa_account_code” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] Error: Fatal error occurred while loading data from “/opt/jiujicloud/mysql_agent/./output/data/small_oa_169/TABLE/t_product_join.0.csv” into table small_oa_123.t_product_join. Reason: Load data into “small_oa_123”.“t_product_join” failed! ConnectException: 拒绝连接 (Connection refused)
2024-03-11 15:16:29 [ERROR] System exit 1
大量的拒绝连接，看看observer的日志，看看报错信息？
WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246737][T1004_ApplySrv7][T1004][YB420A01FA9D-00061282E0B26304-0-0] [lt=51][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124844, v:0}, lsn:{lsn:46089903870}, submit_ts:1710143281951939}, this:0x7f941fd2f7c0, is_inited_:true, trans_id:{txid:3552032}, ls_id:{id:1001}, ctx:0x7f9803cd7950, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=99172, ctx_lock_wait_time=5555)
[2024-03-11 15:48:02.056759] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246657][T1004_ApplySrv0][T1004][YB420A01FA9D-00061282E1227C1A-0-0] [lt=48][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124835, v:0}, lsn:{lsn:46089610734}, submit_ts:1710143281948659}, this:0x7f942f8a5c30, is_inited_:true, trans_id:{txid:3552035}, ls_id:{id:1001}, ctx:0x7f9803473250, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=108098, ctx_lock_wait_time=0)
[2024-03-11 15:48:02.056947] WDIAG [PALF] inner_append_log (palf_handle_impl.cpp:2132) [246553][T1004_IOWorker][T1004][Y0-0000000000000000-0-0] [lt=27][errcode=-4389] write log cost too much time(ret=-4389, this={palf_id:1001, self:“10.1.250.157:2882”, has_set_deleted:false}, lsn_array=[{lsn:46096802158}], scn_array=[{val:1710143282020876354, v:0}], curr_size=36532, accum_size=37731330, time_cost=20278)
[2024-03-11 15:48:02.059296] WDIAG [RPC] create (ob_poc_rpc_server.cpp:113) [167655][pnio1][T0][YB420A01FA9D-00061288152AAD10-0-0] [lt=72][errcode=0] PNIO packet wait too much time between proxy and server_cb(pcode=5387, fly_ts=411575, send_timestamp=1710143281647719, peer=“10.1.250.161:24330”, sz=446)
[2024-03-11 15:48:02.062729] WDIAG [RPC] create (ob_poc_rpc_server.cpp:113) [167673][pnio1][T0][YB420A01FAA1-00061282C41F606A-0-0] [lt=14][errcode=0] PNIO packet wait too much time between proxy and server_cb(pcode=1815, fly_ts=405829, send_timestamp=1710143281656897, peer=“10.1.250.161:24368”, sz=232)
[2024-03-11 15:48:02.063740] WDIAG [RPC] create (ob_poc_rpc_server.cpp:113) [167677][pnio1][T0][YB420A01FA9D-00061288152AAD13-0-0] [lt=28][errcode=0] PNIO packet wait too much time between proxy and server_cb(pcode=5387, fly_ts=405788, send_timestamp=1710143281657951, peer=“10.1.250.161:24310”, sz=445)
[2024-03-11 15:48:02.065754] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246731][T1004_ApplySrv1][T1004][YB420A01FA9D-00061282E0626CD6-0-0] [lt=94][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124871, v:0}, lsn:{lsn:46091483943}, submit_ts:1710143281965713}, this:0x7f90427fb230, is_inited_:true, trans_id:{txid:3552020}, ls_id:{id:1001}, ctx:0x7f9802b66450, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=100036, ctx_lock_wait_time=2)
[2024-03-11 15:48:02.065911] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246732][T1004_ApplySrv2][T1004][YB420A01FA9D-00061282E3C29945-0-0] [lt=27][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124865, v:0}, lsn:{lsn:46090651161}, submit_ts:1710143281963075}, this:0x7f97be3fba60, is_inited_:true, trans_id:{txid:3552025}, ls_id:{id:1001}, ctx:0x7f98040db650, tx_data_guard:{tx_data:NULL}, is_callbacked_:false, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=102833, ctx_lock_wait_time=1)
[2024-03-11 15:48:02.066527] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246737][T1004_ApplySrv7][T1004][YB420A01FA9D-00061282E0B26304-0-0] [lt=70][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124873, v:0}, lsn:{lsn:46091607377}, submit_ts:1710143281966319}, this:0x7f9803475d40, is_inited_:true, trans_id:{txid:3552035}, ls_id:{id:1001}, ctx:0x7f9803473250, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:false, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=100207, ctx_lock_wait_time=0)
[2024-03-11 15:48:02.067666] WDIAG [STORAGE.TRANS] get_log_cb_ (ob_trans_part_ctx.cpp:4114) [246855][T1004_L0_G0][T1004][YB420A01FA9D-00061282E1325DB7-0-0] [lt=23][errcode=-6268] REACH SYSLOG RATE LIMIT [bandwidth]
[2024-03-11 15:48:02.068699] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246736][T1004_ApplySrv6][T1004][YB420A01FA9D-00061282E322A5F4-0-0] [lt=205][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124869, v:0}, lsn:{lsn:46090974732}, submit_ts:1710143281964499}, this:0x7f9877977970, is_inited_:true, trans_id:{txid:3552038}, ls_id:{id:1001}, ctx:0x7f9804379b50, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=100079, ctx_lock_wait_time=4118)
[2024-03-11 15:48:02.073583] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246657][T1004_ApplySrv0][T1004][YB420A01FA9D-00061282E1227C1A-0-0] [lt=44][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124887, v:0}, lsn:{lsn:46092145536}, submit_ts:1710143281972666}, this:0x7f96e2d90f90, is_inited_:true, trans_id:{txid:3552034}, ls_id:{id:1001}, ctx:0x7f9803da2650, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=99702, ctx_lock_wait_time=1211)
[2024-03-11 15:48:02.075772] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246733][T1004_ApplySrv3][T1004][YB420A01FA9D-00061282E0E254EC-0-0] [lt=63][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124891, v:0}, lsn:{lsn:46092453955}, submit_ts:1710143281975000}, this:0x7f9650beec30, is_inited_:true, trans_id:{txid:3552039}, ls_id:{id:1001}, ctx:0x7f9803c39750, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=100770, ctx_lock_wait_time=1)
[2024-03-11 15:48:02.076021] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246732][T1004_ApplySrv2][T1004][YB420A01FA9D-00061282E3C29945-0-0] [lt=42][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124893, v:0}, lsn:{lsn:46092526091}, submit_ts:1710143281975311}, this:0x7f97b6dc5a50, is_inited_:true, trans_id:{txid:3552028}, ls_id:{id:1001}, ctx:0x7f9803019650, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=100709, ctx_lock_wait_time=0)
[2024-03-11 15:48:02.076918] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246732][T1004_ApplySrv2][T1004][YB420A01FA9D-00061282E3C29945-0-0] [lt=98][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124895, v:0}, lsn:{lsn:46092592616}, submit_ts:1710143281975817}, this:0x7f957034eee0, is_inited_:true, trans_id:{txid:3552022}, ls_id:{id:1001}, ctx:0x7f9802a61050, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=101100, ctx_lock_wait_time=1)
[2024-03-11 15:48:02.076972] WDIAG [STORAGE.TRANS] test_lock (ob_trans_ctx.cpp:235) [246735][T1004_ApplySrv5][T1004][YB420A01FA9D-00061282DEA2A2EF-0-0] [lt=22][errcode=-4389] transaction log sync use too much time(log_cb={ObTxBaseLogCb:{base_ts:{val:0, v:0}, log_ts:{val:1710143281918124894, v:0}, lsn:{lsn:46092562668}, submit_ts:1710143281975424}, this:0x7f97b85fb9e0, is_inited_:true, trans_id:{txid:3552038}, ls_id:{id:1001}, ctx:0x7f9804379b50, tx_data_guard:{tx_data:NULL}, is_callbacked_:true, is_dynamic_:true, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[{log_type:0x1, arg:null}], first_part_scn_:{val:18446744073709551615, v:3}}, log_sync_used_time=100736, ctx_lock_wait_time=811)
[2024-03-11 15:48:02.077148] INFO [STORAGE.TRANS] get_number (ob_id_service.cpp:389) [247030][T1003_TenantWea][T1003][Y0-0000000000000000-0-0] [lt=14] get number(ret=0, service_type_=0, range=1, base_id=1710143282077144700, start_id=1710143282077144700, end_id=1710143282077144701)
先用 obclient 证明一下 这个用户 密码 能连接到这个租户下读取这个表。
注意 如果连接的是 2883 端口，表示连的是 obproxy，那么 用户信息就要写全。
obloader 提供了 三个参数 分别输入 集群名(-c) 租户名(-t) 用户名(-u）。连接 obproxy的时候这三个参数都不要少。 如果你放到 -u 里一起的话，也是可以，那就是 root@租户名#集群名 。
bin/obloader --help
e.g: ./obloader -h 192.168.0.0 -P 2883 -u xxx -t tenantA -c ClusterA -p xxx --sys-password xxx -D USERA --ddl --all -f /Users/admin/DUMP-1/
还是提示连接不上，一部分表成功，一部分表失败，失败的表提示，连接拒绝
对失败的表，单独导入，能成功
全部导入的时候，aa_account_code 这表提示连接拒绝，单独导入
/ob/bin/obloader -h 127.0.0.1 -P 2883 -u root@neo_169 -p DevOps00@+ -D small_oa_123 --csv --no-sys --table 'aa_account_code' -f ./output
执行成功
是不是工具导入的时候并发数比较高，导致连接不够用，是不是需要在哪里设置连接
看日志，没有与拒绝连接相关的错误信息。OB的日志量比较大，关键信息很可能被刷走了。
按照楼主的描述，怀疑是一次性连接量太大（或者并发量太大），导致有些连接被拒绝。
那这个问题，应该怎么去解决呢，有什么方案没
是有可能的，先说一下租户的资源配置。
另外设置 obloader 的 参数 --thread 看看。
thread 设置为1，依然出险拒绝链接的情况
会不会和表的权限有关系
单独对一张表导入，是不会出现这个问题的，我怀疑是 工具使用连接池，是不是没有关闭