stonedb icon indicating copy to clipboard operation
stonedb copied to clipboard

feat(MTR): Trace unstable MTR on github

Open RingsC opened this issue 1 year ago • 0 comments

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 avatar May 25 '23 10:05 RingsC