Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.x
-
Yes
Description
The server crashes with the attached MTR testcase. The server is started with --loose-rocksdb_write_disable_wal=ON
Before the server crashes, the error log reports:
2021-09-03T04:19:33.654829Z 8 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'Failed to write to WAL (non kIOError), Status Code: 4, Status: Invalid argument: Sync writes has to enable WAL.' 2021-09-03T04:19:33.654891Z 8 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'aborting on WAL write error.'
Stacktrace:
Thread pointer: 0x7f0b18001040 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 = 7f0bf8076be8 thread_stack 0x46000 /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x59) [0x559eab061b3b] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(handle_fatal_signal+0x2e4) [0x559ea9ba717e] /lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7f0c065b83c0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb) [0x7f0c063f718b] /lib/x86_64-linux-gnu/libc.so.6(abort+0x12b) [0x7f0c063d6859] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/lib/plugin/ha_rocksdb.so(myrocks::rdb_handle_io_error(rocksdb::Status, myrocks::RDB_IO_ERROR_TYPE)+0x474) [0x7f0b7f914587] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/lib/plugin/ha_rocksdb.so(myrocks::Rdb_transaction_impl::commit_no_binlog()+0x230) [0x7f0b7f9271cc] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/lib/plugin/ha_rocksdb.so(myrocks::Rdb_transaction::commit()+0x9c) [0x7f0b7f924400] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/lib/plugin/ha_rocksdb.so(+0x14be538) [0x7f0b7f8ec538] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(ha_commit_low(THD*, bool, bool)+0x2d1) [0x559ea94c448c] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(MYSQL_BIN_LOG::commit(THD*, bool)+0xeaf) [0x559eaabbb0a3] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(ha_commit_trans(THD*, bool, bool)+0x88e) [0x559ea94c3dce] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(trans_commit_implicit(THD*, bool)+0x17d) [0x559ea9b37517] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(ha_enable_transaction(THD*, bool)+0xd7) [0x559ea94d0079] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(mysql_trans_commit_alter_copy_data(THD*)+0x6c) [0x559ea9a6c8c9] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(+0x3f02adf) [0x559ea9a6dadf] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*)+0x4c87) [0x559ea9a69dd6] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x5e5) [0x559ea986745d] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(mysql_execute_command(THD*, bool)+0x5b68) [0x559ea997238c] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(dispatch_sql_command(THD*, Parser_state*, bool)+0x794) [0x559ea997452a] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x14f0) [0x559ea9969a86] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(do_command(THD*)+0x561) [0x559ea9967df8] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(+0x4023654) [0x559ea9b8e654] /home/mohit.joshi/mysql-8.0/bld_8.0.26-16/install/bin/mysqld(+0x5d895a2) [0x559eab8f45a2] /lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7f0c065ac609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7f0c064d3293] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f0b182187d8): ALTER TABLE tt_12 MODIFY COLUMN ipkey INT(14), LOCK=DEFAULT, ALGORITHM=DEFAULT Connection ID (thread ID): 7 Status: NOT_KILLED