ERROR 1064 (HY000): intolerable failure in opening node channels

MySQL [ods_banggood_work]> show create table dm_affiliate_info_extend \G
*************************** 1. row ***************************
Table: dm_affiliate_info_extend
Create Table: CREATE TABLE dm_affiliate_info_extend (
id bigint(20) NOT NULL COMMENT “id”,
affiliate_id bigint(20) NOT NULL DEFAULT “0” COMMENT “Affiliate ID”,
influencer_id bigint(20) NOT NULL DEFAULT “0” COMMENT “红人ID”,
admin_id bigint(20) NOT NULL DEFAULT “0” COMMENT “管理员id”,
label_id varchar(300) NOT NULL DEFAULT “” COMMENT “标签”,
trade_model varchar(150) NOT NULL DEFAULT “” COMMENT “交易模式”,
pay_model varchar(150) NOT NULL DEFAULT “” COMMENT “支付方式”,
pay_bank varchar(150) NOT NULL DEFAULT “” COMMENT “支付账号”,
uc_code varchar(765) NOT NULL DEFAULT “” COMMENT “uc code”,
image varchar(300) NOT NULL DEFAULT “” COMMENT “附件”,
customers_type smallint(6) NOT NULL DEFAULT “1” COMMENT “用户类型”
) ENGINE=OLAP
PRIMARY KEY(id)
COMMENT “aff扩展表”
DISTRIBUTED BY HASH(id) BUCKETS 3
PROPERTIES (
“replication_num” = “2”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);
1 row in set (0.00 sec)

MySQL [ods_banggood_work]> show create table link_dm_affiliate_info_extend \G
*************************** 1. row ***************************
Table: link_dm_affiliate_info_extend
Create Table: CREATE EXTERNAL TABLE link_dm_affiliate_info_extend (
id bigint(20) NOT NULL COMMENT “id”,
affiliate_id bigint(20) NOT NULL DEFAULT “0” COMMENT “Affiliate ID”,
influencer_id bigint(20) NOT NULL DEFAULT “0” COMMENT “红人ID”,
admin_id bigint(20) NOT NULL DEFAULT “0” COMMENT “管理员id”,
label_id varchar(300) NOT NULL DEFAULT “” COMMENT “标签”,
trade_model varchar(150) NOT NULL DEFAULT “” COMMENT “交易模式”,
pay_model varchar(150) NOT NULL DEFAULT “” COMMENT “支付方式”,
pay_bank varchar(150) NOT NULL DEFAULT “” COMMENT “支付账号”,
uc_code varchar(765) NOT NULL DEFAULT “” COMMENT “uc code”,
image varchar(300) NOT NULL DEFAULT “” COMMENT “附件”,
customers_type smallint(6) NOT NULL DEFAULT “1” COMMENT “用户类型”
) ENGINE=MYSQL
COMMENT “MYSQL”
PROPERTIES (
“host” = “10.177.13.172”,
“port” = “3306”,
“user” = “etl”,
“password” = “”,
“database” = “banggood_work”,
“table” = “dm_affiliate_info_extend”
);
1 row in set (0.00 sec)

MySQL [ods_banggood_work]> insert into dm_affiliate_info_extend select * from link_dm_affiliate_info_extend limit 10;
ERROR 1064 (HY000): intolerable failure in opening node channels

在所有be日志下下面执行下 grep “too many tablet versions” ./*,看下信息。

我也遇到了这个问题,请问您这边怎么解决的?

应该是磁盘空间不足造成的;

我磁盘空间够的,我再看看。

我也是再导入数据streamload的时候经常遇到这个错误信息

找到原因啦! 两个be的9020端口没有放开 :grinning: