55 lines
2.2 KiB
Plaintext
55 lines
2.2 KiB
Plaintext
#owner: jiahua.cjh
|
|
#group: storage
|
|
|
|
--disable_warnings
|
|
drop table if exists msdt_lob;
|
|
drop table if exists msdt_normal;
|
|
--enable_warnings
|
|
|
|
create table msdt_lob(c1 text, c2 int);
|
|
|
|
alter table msdt_lob drop c2;
|
|
|
|
create table msdt_normal(a int, b int);
|
|
|
|
# msdt_lob
|
|
let $tenant_id1 = query_get_value(select tenant_id from oceanbase.__all_virtual_table where table_name = 'msdt_lob', tenant_id, 1);
|
|
let $tablet_id1 = query_get_value(select tablet_id from oceanbase.__all_virtual_table where table_name = 'msdt_lob', tablet_id, 1);
|
|
let $ls_id1 = query_get_value(select ls_id from oceanbase.DBA_OB_TABLET_TO_LS where tablet_id = $tablet_id1, ls_id, 1);
|
|
|
|
let $report_cnt1 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_tablet_meta_table where tenant_id = $tenant_id1 and ls_id = $ls_id1 and tablet_id = $tablet_id1, cnt, 1);
|
|
let $unit_cnt1 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_unit where tenant_id = $tenant_id1, cnt, 1);
|
|
|
|
--disable_query_log
|
|
|
|
let $__i__= 120;
|
|
while($__i__ > 0)
|
|
{
|
|
sleep 1;
|
|
dec $__i__;
|
|
let $report_cnt1 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_tablet_meta_table where tenant_id = $tenant_id1 and ls_id = $ls_id1 and tablet_id = $tablet_id1, cnt, 1);
|
|
if($report_cnt1 == $unit_cnt1)
|
|
{
|
|
let $__i__ = -1;
|
|
}
|
|
}
|
|
|
|
|
|
eval select $report_cnt1 = $unit_cnt1 as result;
|
|
--enable_query_log
|
|
|
|
# msdt_normal
|
|
let $tenant_id2 = query_get_value(select tenant_id from oceanbase.__all_virtual_table where table_name = 'msdt_normal', tenant_id, 1);
|
|
let $tablet_id2 = query_get_value(select tablet_id from oceanbase.__all_virtual_table where table_name = 'msdt_normal', tablet_id, 1);
|
|
let $ls_id2 = query_get_value(select ls_id from oceanbase.DBA_OB_TABLET_TO_LS where tablet_id = $tablet_id2, ls_id, 1);
|
|
|
|
let $report_cnt2 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_tablet_meta_table where tenant_id = $tenant_id2 and ls_id = $ls_id2 and tablet_id = $tablet_id2, cnt, 1);
|
|
let $unit_cnt2 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_unit where tenant_id = $tenant_id2, cnt, 1);
|
|
|
|
--disable_query_log
|
|
eval select $report_cnt2 = $unit_cnt2 as result;
|
|
--enable_query_log
|
|
|
|
drop table msdt_lob;
|
|
drop table msdt_normal;
|