Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8409

Changing file-key-management-encryption-algorithm causes crash and no real info why

Details

    • 10.1.6-2, 10.1.7-1

    Description

      Create database with file-key-management-encryption-algorithm=aes_cbs, shutdown, and change file-key-management-encryption-algorithm=aes_ctr and you will see following:

      BROKEN: block: 3400 checkpoint: 6 414980c0 a801facf
      BROKEN: block: 3400 checkpoint: 6 414980c0 a801facf
      InnoDB: Log block no 3400 at lsn 1740288 has
      InnoDB: ok header, but checksum field contains 2818702031, should be 1095336128
      InnoDB: Set innodb_force_recovery to ignore this error.
      2015-07-02 09:52:18 7fa13b6ce780  InnoDB: Assertion failure in thread 140330463455104 in file log0recv.cc line 2833
      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/5.6/en/forcing-innodb-recovery.html
      InnoDB: about forcing recovery.
      150702  9:52:18 [ERROR] mysqld got signal 6 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
       
      To report this bug, see http://kb.askmonty.org/en/reporting-bugs
       
      We will try our best to scrape up some info that will hopefully help
      diagnose the problem, but since we have already crashed, 
      something is definitely wrong and this may fail.
       
      Server version: 10.1.6-MariaDB-debug
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=0
      max_threads=153
      thread_count=0
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467186 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x0x0
      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 = 0x0 thread_stack 0x48000
      addr2line: 'sql/mysqld': No such file
      sql/mysqld(my_print_stacktrace+0x38)[0x7fa13c4355be]
      sql/mysqld(handle_fatal_signal+0x34c)[0x7fa13be1d603]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7fa139bf2340]
      /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39)[0x7fa139249cc9]
      /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fa13924d0d8]
      sql/mysqld(+0xa92add)[0x7fa13c19dadd]
      sql/mysqld(+0xa93045)[0x7fa13c19e045]
      sql/mysqld(+0xa93839)[0x7fa13c19e839]
      sql/mysqld(+0xb74289)[0x7fa13c27f289]
      sql/mysqld(+0xa0c21f)[0x7fa13c11721f]
      sql/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0xf3)[0x7fa13be1f55a]
      sql/mysqld(+0x4fec05)[0x7fa13bc09c05]
      sql/mysqld(_Z11plugin_initPiPPci+0x8e5)[0x7fa13bc0a7c8]
      sql/mysqld(+0x3e37ba)[0x7fa13baee7ba]
      sql/mysqld(_Z11mysqld_mainiPPc+0x5f3)[0x7fa13baef750]
      sql/mysqld(main+0x20)[0x7fa13bae51d5]
      /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5)[0x7fa139234ec5]
      sql/mysqld(+0x3da0c8)[0x7fa13bae50c8]
      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.

      Attachments

        Issue Links

          Activity

            jplindst Jan Lindström (Inactive) created issue -
            jplindst Jan Lindström (Inactive) made changes -
            Field Original Value New Value
            Description {noformat}
            BROKEN: block: 3400 checkpoint: 6 414980c0 a801facf
            BROKEN: block: 3400 checkpoint: 6 414980c0 a801facf
            InnoDB: Log block no 3400 at lsn 1740288 has
            InnoDB: ok header, but checksum field contains 2818702031, should be 1095336128
            InnoDB: Set innodb_force_recovery to ignore this error.
            2015-07-02 09:52:18 7fa13b6ce780 InnoDB: Assertion failure in thread 140330463455104 in file log0recv.cc line 2833
            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/5.6/en/forcing-innodb-recovery.html
            InnoDB: about forcing recovery.
            150702 9:52:18 [ERROR] mysqld got signal 6 ;
            This could be because you hit a bug. It is also possible that this binary
            or one of the libraries it was linked against is corrupt, improperly built,
            or misconfigured. This error can also be caused by malfunctioning hardware.

            To report this bug, see http://kb.askmonty.org/en/reporting-bugs

            We will try our best to scrape up some info that will hopefully help
            diagnose the problem, but since we have already crashed,
            something is definitely wrong and this may fail.

            Server version: 10.1.6-MariaDB-debug
            key_buffer_size=134217728
            read_buffer_size=131072
            max_used_connections=0
            max_threads=153
            thread_count=0
            It is possible that mysqld could use up to
            key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467186 K bytes of memory
            Hope that's ok; if not, decrease some variables in the equation.

            Thread pointer: 0x0x0
            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 = 0x0 thread_stack 0x48000
            addr2line: 'sql/mysqld': No such file
            sql/mysqld(my_print_stacktrace+0x38)[0x7fa13c4355be]
            sql/mysqld(handle_fatal_signal+0x34c)[0x7fa13be1d603]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7fa139bf2340]
            /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39)[0x7fa139249cc9]
            /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fa13924d0d8]
            sql/mysqld(+0xa92add)[0x7fa13c19dadd]
            sql/mysqld(+0xa93045)[0x7fa13c19e045]
            sql/mysqld(+0xa93839)[0x7fa13c19e839]
            sql/mysqld(+0xb74289)[0x7fa13c27f289]
            sql/mysqld(+0xa0c21f)[0x7fa13c11721f]
            sql/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0xf3)[0x7fa13be1f55a]
            sql/mysqld(+0x4fec05)[0x7fa13bc09c05]
            sql/mysqld(_Z11plugin_initPiPPci+0x8e5)[0x7fa13bc0a7c8]
            sql/mysqld(+0x3e37ba)[0x7fa13baee7ba]
            sql/mysqld(_Z11mysqld_mainiPPc+0x5f3)[0x7fa13baef750]
            sql/mysqld(main+0x20)[0x7fa13bae51d5]
            /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5)[0x7fa139234ec5]
            sql/mysqld(+0x3da0c8)[0x7fa13bae50c8]
            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.
            {noformat}
            Create database with file-key-management-encryption-algorithm=aes_cbs, shutdown, and change file-key-management-encryption-algorithm=aes_ctr and you will see following:

            {noformat}
            BROKEN: block: 3400 checkpoint: 6 414980c0 a801facf
            BROKEN: block: 3400 checkpoint: 6 414980c0 a801facf
            InnoDB: Log block no 3400 at lsn 1740288 has
            InnoDB: ok header, but checksum field contains 2818702031, should be 1095336128
            InnoDB: Set innodb_force_recovery to ignore this error.
            2015-07-02 09:52:18 7fa13b6ce780 InnoDB: Assertion failure in thread 140330463455104 in file log0recv.cc line 2833
            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/5.6/en/forcing-innodb-recovery.html
            InnoDB: about forcing recovery.
            150702 9:52:18 [ERROR] mysqld got signal 6 ;
            This could be because you hit a bug. It is also possible that this binary
            or one of the libraries it was linked against is corrupt, improperly built,
            or misconfigured. This error can also be caused by malfunctioning hardware.

            To report this bug, see http://kb.askmonty.org/en/reporting-bugs

            We will try our best to scrape up some info that will hopefully help
            diagnose the problem, but since we have already crashed,
            something is definitely wrong and this may fail.

            Server version: 10.1.6-MariaDB-debug
            key_buffer_size=134217728
            read_buffer_size=131072
            max_used_connections=0
            max_threads=153
            thread_count=0
            It is possible that mysqld could use up to
            key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467186 K bytes of memory
            Hope that's ok; if not, decrease some variables in the equation.

            Thread pointer: 0x0x0
            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 = 0x0 thread_stack 0x48000
            addr2line: 'sql/mysqld': No such file
            sql/mysqld(my_print_stacktrace+0x38)[0x7fa13c4355be]
            sql/mysqld(handle_fatal_signal+0x34c)[0x7fa13be1d603]
            /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7fa139bf2340]
            /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39)[0x7fa139249cc9]
            /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fa13924d0d8]
            sql/mysqld(+0xa92add)[0x7fa13c19dadd]
            sql/mysqld(+0xa93045)[0x7fa13c19e045]
            sql/mysqld(+0xa93839)[0x7fa13c19e839]
            sql/mysqld(+0xb74289)[0x7fa13c27f289]
            sql/mysqld(+0xa0c21f)[0x7fa13c11721f]
            sql/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0xf3)[0x7fa13be1f55a]
            sql/mysqld(+0x4fec05)[0x7fa13bc09c05]
            sql/mysqld(_Z11plugin_initPiPPci+0x8e5)[0x7fa13bc0a7c8]
            sql/mysqld(+0x3e37ba)[0x7fa13baee7ba]
            sql/mysqld(_Z11mysqld_mainiPPc+0x5f3)[0x7fa13baef750]
            sql/mysqld(main+0x20)[0x7fa13bae51d5]
            /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5)[0x7fa139234ec5]
            sql/mysqld(+0x3da0c8)[0x7fa13bae50c8]
            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.
            {noformat}
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.6-2 [ 7 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.6-2 [ 7 ] 10.1.6-2, 10.0.21 [ 7, 8 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.6-2, 10.0.21 [ 7, 8 ] 10.1.6-2 [ 7 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            jplindst Jan Lindström (Inactive) made changes -
            Sprint 10.1.6-2 [ 7 ] 10.1.6-2, 10.1.7-1 [ 7, 10 ]
            jplindst Jan Lindström (Inactive) made changes -
            Rank Ranked higher
            jplindst Jan Lindström (Inactive) made changes -
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.1.7 [ 19604 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 70432 ] MariaDB v4 [ 149331 ]

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.