matrixorigin / matrixone

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

[Bug]: pitr+fulltext index, restore pitr failed #20064

Open tom-csf opened 6 days ago

tom-csf commented 6 days ago

Is there an existing issue for the same bug?

Branch Name

2.0-dev

Commit ID

bd0368f0c140dc9eccc232adb28470467cd680e8

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

企业微信截图_7d8a8d36-6129-4054-9de1-7a66365d3fd0

Expected Behavior

No response

Steps to Reproduce

1、create  database test;
2、use test;
3、create pitr pitr01 for database test range 1 'y';
4、mysql> CREATE TABLE articles (
    -> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    -> title VARCHAR(200),
    -> body TEXT,
    -> FULLTEXT (title,body));
5、insert into articles values (0,'hello world','Bill Gates');
6、select now()//time1
7、restore database test from pitr pitr01 'time1';

Additional information

https://shanghai.idc.matrixorigin.cn:30001/explore?panes=%7B%22O2c%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-chaos-bd0368f-202411141029%5C%22%7D%20%7C%3D%20%60unclassified%20statement%20appears%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221731552613000%22,%22to%22:%221731552913000%22%7D%7D%7D&schemaVersion=1&orgId=1

YANGGMM commented 6 days ago
drop database if exists test;
create  database test;
use test;
drop pitr if exists pitr01;
create pitr pitr01 for database test range 1 'y';
drop table if exists articles;
CREATE TABLE articles ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), body TEXT, FULLTEXT (title,body));
insert into articles values (0,'hello world','Bill Gates');
select now();
restore database test from pitr pitr01 'time1';
YANGGMM commented 6 days ago

related to #20036