Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7883

Server crashes with ALTER query when --rocksdb_write_disable_wal is enabled

Details

    • 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
      
      

       

      Attachments

        Activity

          People

            marcelo.altmann Marcelo Altmann
            mohit.joshi Mohit Joshi
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Time Spent - 3 days, 7 hours, 4 minutes Remaining Estimate - 42 minutes
                42m
                Logged:
                Time Spent - 3 days, 7 hours, 4 minutes Remaining Estimate - 42 minutes
                3d 7h 4m

                Smart Checklist