root@idrc-110:/data/mysql-8.0.21-test/mysql-test# ./mtr 1 Logging: ./mtr 1 MySQL Version 8.0.21 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/data/mysql-8.0.21-test/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped [ 33%] innodb_gis.1 [ pass ] 7463 [ 66%] main.1 [ fail ] Test ended at 2022-06-16 10:31:12 CURRENT_TEST: main.1 mysqltest: At line 31: Query 'alter table t1 add PARTITION(PARTITION p2 VALUES LESS THAN(200))' failed with wrong error 2013: 'Lost connection to MySQL server during query', should have failed with error '1146'. safe_process[4295]: Child process: 4296, exit: 1 Server [mysqld.1 - pid: 4239, winpid: 4239, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2022-06-16T02:31:10.633234Z 13 [ERROR] [MY-013183] [InnoDB] Assertion failure: dict0dict.cc:1888:table->get_ref_count() == 0 thread 139849914128128 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 02:31:10 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f30a80125c0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f3158740d18 thread_stack 0x46000 /data/mysql-8.0.21-test/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x55) [0x5611db1ac571] /data/mysql-8.0.21-test/bin/mysqld(handle_fatal_signal+0x2a8) [0x5611d9d1215f] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12980) [0x7f3169235980] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7) [0x7f31672b7e87] /lib/x86_64-linux-gnu/libc.so.6(abort+0x141) [0x7f31672b97f1] /data/mysql-8.0.21-test/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x1c1) [0x5611db668239] /data/mysql-8.0.21-test/bin/mysqld(+0x4f75ccd) [0x5611db7c2ccd] /data/mysql-8.0.21-test/bin/mysqld(dict_table_remove_from_cache(dict_table_t*)+0x1d) [0x5611db7c3471] /data/mysql-8.0.21-test/bin/mysqld(Ha_innopart_share::open_one_table_part(dd::cache::Dictionary_client*, THD*, TABLE const*, dd::Partition const*, char const*, dict_table_t**)+0x9e) [0x5611db34ac7c] /data/mysql-8.0.21-test/bin/mysqld(Ha_innopart_share::open_table_parts(THD*, TABLE const*, dd::Table const*, partition_info*, char const*)+0x335) [0x5611db34b545] /data/mysql-8.0.21-test/bin/mysqld(ha_innopart::open(char const*, int, unsigned int, dd::Table const*)+0x2c9) [0x5611db34c6f9] /data/mysql-8.0.21-test/bin/mysqld(handler::ha_open(TABLE*, char const*, int, int, dd::Table const*)+0x1e7) [0x5611d9ec437d] /data/mysql-8.0.21-test/bin/mysqld(open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, dd::Table const*)+0x1452) [0x5611d9c9905c] /data/mysql-8.0.21-test/bin/mysqld(open_table(THD*, TABLE_LIST*, Open_table_context*)+0x17ee) [0x5611d9a2fae6] /data/mysql-8.0.21-test/bin/mysqld(+0x31e6864) [0x5611d9a33864] /data/mysql-8.0.21-test/bin/mysqld(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)+0x3bc) [0x5611d9a34eb7] /data/mysql-8.0.21-test/bin/mysqld(mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*)+0x753) [0x5611d9bf87a6] /data/mysql-8.0.21-test/bin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x5e9) [0x5611da1af983] /data/mysql-8.0.21-test/bin/mysqld(mysql_execute_command(THD*, bool)+0x5f78) [0x5611d9b1ae70] /data/mysql-8.0.21-test/bin/mysqld(mysql_parse(THD*, Parser_state*)+0x6db) [0x5611d9b1da6a] /data/mysql-8.0.21-test/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x14d0) [0x5611d9b124cf] /data/mysql-8.0.21-test/bin/mysqld(do_command(THD*)+0x4c4) [0x5611d9b10979] /data/mysql-8.0.21-test/bin/mysqld(+0x34aead6) [0x5611d9cfbad6] /data/mysql-8.0.21-test/bin/mysqld(+0x5212eb8) [0x5611dba5feb8] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db) [0x7f316922a6db] /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f316739a61f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f30a9054d68): alter table t1 add PARTITION(PARTITION p2 VALUES LESS THAN(200)) Connection ID (thread ID): 13 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file safe_process[4239]: Child process: 4240, killed by signal: 6 ----------SERVER LOG END------------- Mysqltest client output from logfile ----------- MYSQLTEST OUTPUT START ----------- CREATE DATABASE corrupted; use corrupted; CREATE TABLE t1 ( a INT NOT NULL PRIMARY KEY, b INT, c CHAR(10), v VARCHAR(100), t TEXT) PARTITION BY RANGE(a)( PARTITION p1 VALUES LESS THAN(100) ); CREATE TABLE t2 LIKE t1; CREATE INDEX idx_v ON t2(v); INSERT INTO t1 VALUES (1, 2, 'aaa', 'abcdefghij', 'This is a'),(2, 4, 'bb', 'qwerty', 'test case'),(3, 6, 'ccccc', 'poiuy', 'for corrupted index'); INSERT INTO t2 SELECT * FROM t1; SELECT count(*) FROM t1; count(*) 3 SELECT count(*) FROM t2; count(*) 3 # Marking clustered index as corrupted results in ER_NO_SUCH_TABLE set debug = "+d, dict_set_clust_index_corrupted"; CHECK TABLE t1; Table Op Msg_type Msg_text corrupted.t1 check error Partition p1 returned error corrupted.t1 check Warning InnoDB: The B-tree of index PRIMARY is corrupted. corrupted.t1 check error Corrupt set debug = "-d, dict_set_clust_index_corrupted"; ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/data/mysql-8.0.21-test/mysql-test/var/log/main.1/1.log' [100%] shutdown_report [ pass ] ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 7.463 of 34 seconds executing testcases Completed: Failed 1/3 tests, 66.67% were successful. Failing test(s): main.1 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases