使用官方文档进行tpcc测试时加载数据报数据超长out of range value for column

[小唐Eden]

【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】根据https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000508050文档进行tpcc测试，在执行./runLoader.sh props.ob这一步时报错out of range value for column

【复现路径】根据上面文档步骤进行
【附件及日志】

[皇甫侯]

看报错是字段长度不够，看下 bmsql_warehouse 和 bmsql_item 的定义吧。。

[小唐Eden]

都是按文档标准化的操作，表结构也是文档中提供的
cat sql.common/tableCreates_parts.sql
create table bmsql_config (
cfg_name varchar(30) primary key,
cfg_value varchar(50)
);

– drop tablegroup tpcc_group;
create tablegroup tpcc_group binding true partition by hash partitions 9;

create table bmsql_warehouse (
w_id integer not null,
w_ytd decimal(12,2),
w_tax decimal(4,4),
w_name varchar(10),
w_street_1 varchar(20),
w_street_2 varchar(20),
w_city varchar(20),
w_state char(2),
w_zip char(9),
primary key(w_id)
)tablegroup=‘tpcc_group’ partition by hash(w_id) partitions 9;

create table bmsql_district (
d_w_id integer not null,
d_id integer not null,
d_ytd decimal(12,2),
d_tax decimal(4,4),
d_next_o_id integer,
d_name varchar(10),
d_street_1 varchar(20),
d_street_2 varchar(20),
d_city varchar(20),
d_state char(2),
d_zip char(9),
PRIMARY KEY (d_w_id, d_id)
)tablegroup=‘tpcc_group’ partition by hash(d_w_id) partitions 9;

create table bmsql_customer (
c_w_id integer not null,
c_d_id integer not null,
c_id integer not null,
c_discount decimal(4,4),
c_credit char(2),
c_last varchar(16),
c_first varchar(16),
c_credit_lim decimal(12,2),
c_balance decimal(12,2),
c_ytd_payment decimal(12,2),
c_payment_cnt integer,
c_delivery_cnt integer,
c_street_1 varchar(20),
c_street_2 varchar(20),
c_city varchar(20),
c_state char(2),
c_zip char(9),
c_phone char(16),
c_since timestamp,
c_middle char(2),
c_data varchar(500),
PRIMARY KEY (c_w_id, c_d_id, c_id)
)tablegroup=‘tpcc_group’ partition by hash(c_w_id) partitions 9;

create table bmsql_history (
hist_id integer,
h_c_id integer,
h_c_d_id integer,
h_c_w_id integer,
h_d_id integer,
h_w_id integer,
h_date timestamp,
h_amount decimal(6,2),
h_data varchar(24)
)tablegroup=‘tpcc_group’ partition by hash(h_w_id) partitions 9;

create table bmsql_new_order (
no_w_id integer not null ,
no_d_id integer not null,
no_o_id integer not null,
PRIMARY KEY (no_w_id, no_d_id, no_o_id)
)tablegroup=‘tpcc_group’ partition by hash(no_w_id) partitions 9;

create table bmsql_oorder (
o_w_id integer not null,
o_d_id integer not null,
o_id integer not null,
o_c_id integer,
o_carrier_id integer,
o_ol_cnt integer,
o_all_local integer,
o_entry_d timestamp,
PRIMARY KEY (o_w_id, o_d_id, o_id)
)tablegroup=‘tpcc_group’ partition by hash(o_w_id) partitions 9;

create table bmsql_order_line (
ol_w_id integer not null,
ol_d_id integer not null,
ol_o_id integer not null,
ol_number integer not null,
ol_i_id integer not null,
ol_delivery_d timestamp,
ol_amount decimal(6,2),
ol_supply_w_id integer,
ol_quantity integer,
ol_dist_info char(24),
PRIMARY KEY (ol_w_id, ol_d_id, ol_o_id, ol_number)
)tablegroup=‘tpcc_group’ partition by hash(ol_w_id) partitions 9;

create table bmsql_item (
i_id integer not null,
i_name varchar(24),
i_price decimal(5,2),
i_data varchar(50),
i_im_id integer,
PRIMARY KEY (i_id)
);

create table bmsql_stock (
s_w_id integer not null,
s_i_id integer not null,
s_quantity integer,
s_ytd integer,
s_order_cnt integer,
s_remote_cnt integer,
s_data varchar(50),
s_dist_01 char(24),
s_dist_02 char(24),
s_dist_03 char(24),
s_dist_04 char(24),
s_dist_05 char(24),
s_dist_06 char(24),
s_dist_07 char(24),
s_dist_08 char(24),
s_dist_09 char(24),
s_dist_10 char(24),
PRIMARY KEY (s_w_id, s_i_id)
)tablegroup=‘tpcc_group’ use_bloom_filter=true partition by hash(s_w_id) partitions 9;

[皇甫侯]

最简单的办法应该是扩下字段长度，想要排查的话可以在sql_audit中捞一下报错的语句估计是一个insert，看下脚本生成的值到底是多少

[小唐Eden]

Emmm这才真看不懂了

[小唐Eden]

该问题出现在4.2.1.5版本，目测是bug，使用4.2.2.1的observer没有该问题

[皇甫侯]

有点离谱。。你用的啥版本的OB