matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.77k stars 275 forks source link

[Bug]: cluster table restore #15954

Closed Ariznawlll closed 5 months ago

Ariznawlll commented 5 months ago

Is there an existing issue for the same bug?

Branch Name

main

Commit ID

44a4d5e

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image image

Expected Behavior

No response

Steps to Reproduce

场景1:
use mo_catalog;
create cluster table clu01(col1 int, col2 decimal);
insert into clu01 values(1,2,0);

drop snapshot if exists sp01;
create snapshot sp01 for account sys;
insert into clu01 values(2,3,0);

restore account sys from snapshot sp01;

select * from clu01;  -->结果不对

场景2:
create table clu01(col1 int, col2 decimal);
insert into clu01 values(1,2);

drop snapshot if exists sp01;
create snapshot sp01 for account sys;
insert into clu01 values(2,3);

restore account sys from snapshot sp01;

select * from clu01;  -->结果不对
 select count(*) from clu01;   -->结果不对

Additional information

No response

YANGGMM commented 5 months ago

现在集群表的恢复还没有结论

YANGGMM commented 5 months ago

场景2 跟之前几个issue场景重复https://github.com/matrixorigin/matrixone/issues/15953

YANGGMM commented 5 months ago

场景2:fixed by https://github.com/matrixorigin/matrixone/pull/15937

YANGGMM commented 5 months ago

重新提一个集群表的issue

Ariznawlll commented 5 months ago

commit:7922426e3effea12dbe900af0daf02a308d9f031

image

verified