innodb.alter_crash 'innodb'              w4 [ fail ]

        Test ended at 2020-12-01 11:29:01

CURRENT_TEST: innodb.alter_crash

The process cannot access the file because it is being used by another process.

mysqltest: In included file "./include/start_mysqld.inc": 

included from D:/win32-debug/build/src/mysql-test/suite/innodb/t/alter_crash.test at line 186:

At line 10: exec of 'D:\win32-debug\build\client\Debug\echo.exe "restart" > D:/win32-debug/build/mysql-test/var/4/tmp/mysqld.1.expect' failed, error: 1, status: 1, errno: 2

Output from before failure:

# Restart mysqld after the crash and reconnect.

The result from queries just before the failure was:

< snip >

) ENGINE=InnoDB DEFAULT CHARSET=latin1

DROP TABLE t2;

CREATE TABLE t2 (f1 INT NOT NULL, f2 INT NOT NULL) ENGINE=InnoDB;

ALTER TABLE t2 ADD PRIMARY KEY (f2, f1);

DROP TABLE t2;

db.opt

# -------------------------

# End of Testing Scenario 2

# -------------------------

#

# Bug#19330255 WL#7142 - CRASH DURING ALTER TABLE LEADS TO

# DATA DICTIONARY INCONSISTENCY

#

CREATE TABLE t1(a int PRIMARY KEY, b varchar(255), c int NOT NULL)

ENGINE=InnoDB;

INSERT INTO t1 SET a=1,c=2;

SET DEBUG_DBUG='+d,innodb_alter_commit_crash_after_commit';

ALTER TABLE t1 ADD INDEX (b), CHANGE c d int, ALGORITHM=INPLACE;

ERROR HY000: Lost connection to MySQL server during query

# Restart mysqld after the crash and reconnect.

More results from queries before failure can be found in D:\win32-debug\build\mysql-test\var\4\log\alter_crash.log

 - saving 'D:/win32-debug/build/mysql-test/var/4/log/innodb.alter_crash-innodb/' to 'D:/win32-debug/build/mysql-test/var/log/innodb.alter_crash-innodb/'

Retrying test innodb.alter_crash, attempt(2/3)...

***Warnings generated in error logs during shutdown after running tests: innodb.alter_crash

2020-12-01 11:28:55 7032 [ERROR] InnoDB: Flagged corruption of `c2` in table `test`.`t1` in dict_set_index_corrupted

2020-12-01 11:28:55 7032 [ERROR] InnoDB: Flagged corruption of `c3` in table `test`.`t1` in dict_set_index_corrupted

2020-12-01 11:28:58 6780 [ERROR] InnoDB: Index `c2` of table `test`.`t1` is corrupted

2020-12-01 11:28:58 6780 [ERROR] InnoDB: Index `c3` of table `test`.`t1` is corrupted

innodb.alter_crash 'innodb'              w2 [ fail ]

        Test ended at 2023-09-13 20:33:02

CURRENT_TEST: innodb.alter_crash

The process cannot access the file because it is being used by another process.

mysqltest: In included file "./include/start_mysqld.inc": 

included from D:/winx64-debug/build/src/mysql-test/suite/innodb/t/alter_crash.test at line 160:

At line 37: exec of 'D:\winx64-debug\build\client\\Debug\echo.exe "restart" > D:/winx64-debug/build/mysql-test/var/2/tmp/mysqld.1.expect' failed, error: 1, status: 1, errno: 2

Output from before failure:

# Restart mysqld after the crash and reconnect.