Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
1 task done
tom-csf opened this issue Nov 14, 2024 · 2 comments
Open
1 task done

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

tom-csf opened this issue Nov 14, 2024 · 2 comments
Assignees
Labels
kind/bug Something isn't working severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Milestone

Comments

@tom-csf
Copy link

tom-csf commented Nov 14, 2024

Is there an existing issue for the same bug?

  • I have checked the existing issues.

Branch Name

2.0-dev

Commit ID

bd0368f

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

@tom-csf tom-csf added kind/bug Something isn't working needs-triage severity/s0 Extreme impact: Cause the application to break down and seriously affect the use labels Nov 14, 2024
@tom-csf tom-csf added this to the 2.0.1 milestone Nov 14, 2024
@YANGGMM
Copy link
Contributor

YANGGMM commented Nov 14, 2024

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
Copy link
Contributor

YANGGMM commented Nov 14, 2024

related to #20036

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug Something isn't working severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Projects
None yet
Development

No branches or pull requests

3 participants