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

feat(MTR): Trace unstable MTR on github #1826

Open
RingsC opened this issue May 25, 2023 · 0 comments
Open

feat(MTR): Trace unstable MTR on github #1826

RingsC opened this issue May 25, 2023 · 0 comments
Labels
A-feature feature with good idea

Comments

@RingsC
Copy link
Contributor

RingsC commented May 25, 2023

Is your feature request related to a problem? Please describe.

On github action, all PRs should be passed all MTR tests, but, now, there are some tests failed randomly. Such as, issue848, and tianmu.init_auto_increment_value, etc.

  • issue1532
  • issue848
    the error message: MySQL error: "1030 - Got error -1 from storage engine" , this article say that it runs out of disk space.
    "
    **This usually means you've ran out of disk space. Check using df -h and delete any large log files or other files taking up a lot of space.

Failing that, check your memory usage.**
"

The the alter operation may lead to run of disk. same as issue #752 .

ref: https://stackoverflow.com/questions/26591708/mysql-error-1030-got-error-1-from-storage-engine

  • init_auto_increment_value
  • issue1637

Taking PR#1790 as an example, issue1637 and init_auto_increment_value failed, but in other PR, the failed cases are different. The unstable failed cases will make PR delivery very very HARD.

  • tianmu.alter_table1
[ 57%] tianmu.alter_table1                      w1 [ fail ]
        Test ended at 2023-05-26 02:20:30
CURRENT_TEST: tianmu.alter_table1
mysqltest: At line 117: query 'alter table st6 rename to st7,add name1 varchar(10)' failed: 1030: Got error 1 from storage engine
The result from queries just before the failure was:
< snip >
alter table st4  change column name1 name varchar(25);
alter table st4 change name name2 varchar(20) after salary;
CREATE TABLE st5
(id INT(11),
name VARCHAR(25),
deptId INT(11),
salary FLOAT,
PRIMARY KEY(id)
);
alter table st5 modify name varchar(20);
alter table st5 modify column name varchar(24);
alter table st5 modify column name varchar(15) after salary;
ALTER TABLE st5 modify id varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE st6
(id INT(11),
name VARCHAR(25),
deptId INT(11),
salary FLOAT,
PRIMARY KEY(id)
);
safe_process[79574]: Child process: 79575, exit: 1

This unstable cases should be fixed as soon as possible.

Describe the solution you'd like

Describe alternatives you've considered

Additional context

@RingsC RingsC added the A-feature feature with good idea label May 25, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-feature feature with good idea
Projects
None yet
Development

No branches or pull requests

1 participant