2.0.9版本，重置be和fe后，建表出现存储介质识别报错

Viewed 93
2.0

操作步骤描述:

  1. 关闭fe并清空fe的doris-meta目录
  2. 启动master后扩展两个observer
  3. 关闭3个be, 并格式化3块hdd的数据盘然后重新挂载(避免测试的时候等它慢慢删数据库浪费时间)
  4. 启动be将3个be注册进来组成3fe+3be的集群
  5. 创建数据库xxx
  6. 创建base表
  • 第6步很可能会报错:
    image.png
  • 因为能看到上面endIndex的输出, 看不到下面base表创建成功的输出
    image.png
  • 但不是必现
    image.png

be配置:

image.png

在创建过程中, 其中某个进程突然收到此报错, 其他的都是正常运行!image.png

base表ddl

image.png

fe日志

2024-05-06 14:14:00,203 WARN (Thread-57|100)
fe.log: https://web.qingtui.com/drive/preview/1239516720629157888

yadao23
2 Answers
-- base表ddl:
drop table if exists web_sales force;
CREATE TABLE IF NOT EXISTS web_sales (
                                         ws_item_sk bigint not null,
                                         ws_order_number bigint not null,
                                         ws_sold_date_sk bigint,
                                         ws_sold_time_sk bigint,
                                         ws_ship_date_sk bigint,
                                         ws_bill_customer_sk bigint,
                                         ws_bill_cdemo_sk bigint,
                                         ws_bill_hdemo_sk bigint,
                                         ws_bill_addr_sk bigint,
                                         ws_ship_customer_sk bigint,
                                         ws_ship_cdemo_sk bigint,
                                         ws_ship_hdemo_sk bigint,
                                         ws_ship_addr_sk bigint,
                                         ws_web_page_sk bigint,
                                         ws_web_site_sk bigint,
                                         ws_ship_mode_sk bigint,
                                         ws_warehouse_sk bigint,
                                         ws_promo_sk bigint,
                                         ws_quantity integer,
                                         ws_wholesale_cost decimalv3(7,2),
                                         ws_list_price decimalv3(7,2),
                                         ws_sales_price decimalv3(7,2),
                                         ws_ext_discount_amt decimalv3(7,2),
                                         ws_ext_sales_price decimalv3(7,2),
                                         ws_ext_wholesale_cost decimalv3(7,2),
                                         ws_ext_list_price decimalv3(7,2),
                                         ws_ext_tax decimalv3(7,2),
                                         ws_coupon_amt decimalv3(7,2),
                                         ws_ext_ship_cost decimalv3(7,2),
                                         ws_net_paid decimalv3(7,2),
                                         ws_net_paid_inc_tax decimalv3(7,2),
                                         ws_net_paid_inc_ship decimalv3(7,2),
                                         ws_net_paid_inc_ship_tax decimalv3(7,2),
                                         ws_net_profit decimalv3(7,2)
)
    DUPLICATE KEY(ws_item_sk, ws_order_number)
PARTITION BY RANGE(ws_sold_date_sk)
(
PARTITION `p1` VALUES LESS THAN ("2450846"),
PARTITION `p2` VALUES LESS THAN ("2450874"),
PARTITION `p3` VALUES LESS THAN ("2450905"),
PARTITION `p4` VALUES LESS THAN ("2450935"),
PARTITION `p5` VALUES LESS THAN ("2450966"),
PARTITION `p6` VALUES LESS THAN ("2450996"),
PARTITION `p7` VALUES LESS THAN ("2451027"),
PARTITION `p8` VALUES LESS THAN ("2451058"),
PARTITION `p9` VALUES LESS THAN ("2451088"),
PARTITION `p10` VALUES LESS THAN (MAXVALUE)
)
DISTRIBUTED BY HASH(ws_item_sk, ws_order_number) BUCKETS 64
PROPERTIES (
  "replication_num" = "3",
  "colocate_with" = "web-3"
);
yadao23

辛苦贴下fe.log具体对应的错误，或者加微信（Faith_xzc）具体看下，后续结果会同步到论坛供更多小伙伴参考。

更新

show backends 结果截图看下 be 是否已经添加成功；

然后看看 alive 的状态是否是 true：

  • 如果是true的话，把 fe.conf 中的参数调整下 allow_replica_on_same_host = true，然后重启
  • 不是true的话，得先重启 be 然后再看
徐振超@SelectDB4101