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

Sig 6 Assertion failure: fsp0fsp.cc:914:space_id == page_get_space_id(buf_block_get_frame(block))

Details

    Description

      While testing default_table_encryption, concurrency testing was performed. Following crash is encountered which may not be reproducible in single thread, hence an MTR testcase is hard to be written.

      Stack:
      2019-08-07T11:18:10.494941Z 33 [ERROR] [MY-013183] [InnoDB] Assertion failure: fsp0fsp.cc:914:space_id == page_get_space_id(buf_block_get_frame(block)) thread 139669585528576
      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.
      11:18: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: 0x7f068813a8c0
      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 = 7f075c07fd18 thread_stack 0x46000
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x55) [0x48088b8]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(handle_fatal_signal+0x2c6) [0x363a1a1]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f07750de390]
      /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f07733b6428]
      /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f07733b802a]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x1aa) [0x4db560b]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(fsp_header_write_encryption(unsigned int, unsigned long, unsigned char*, bool, bool, mtr_t*)+0xf7) [0x4fb5d71]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(fsp_header_rotate_encryption(fil_space_t*, unsigned char*, mtr_t*)+0xf5) [0x4fb601d]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4f77e30]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Fil_system::encryption_rotate_in_a_shard(Fil_shard*)+0x236) [0x4f781d0]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Fil_system::encryption_rotate_all()+0x80) [0x4f782e4]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(fil_encryption_rotate()+0x13) [0x4f78335]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(innobase_encryption_key_rotation()+0x136) [0x4a5b42a]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Rotate_innodb_master_key::execute()+0x228) [0x335ba0e]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Sql_cmd_alter_instance::execute(THD*)+0x172) [0x3350ac6]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(mysql_execute_command(THD*, bool)+0x61fe) [0x34483a8]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x6cd) [0x344ae79]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1571) [0x343f3a2]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(do_command(THD*)+0x50b) [0x343d7bb]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x36239bf]
      /home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4902764]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba) [0x7f07750d46ba]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f077348841d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (7f06881f6308): ALTER INSTANCE ROTATE INNODB MASTER KEY
      Connection ID (thread ID): 33
      Status: NOT_KILLED

      Attachments

        Activity

          People

            satya.bodapati Satya Bodapati
            mohit.joshi Mohit Joshi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 3 days, 1 hour
                3d 1h

                Smart Checklist