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

Restrict innodb encryption threads to 255 and add min/max values

Details

    Description

      SET GLOBAL innodb_encryption_threads=99999999999999;

      Executing the above query crashes the server.

      stacktrace:

      Thread pointer: 0x7fa038000da0
      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 = 7fa0f8149d30 thread_stack 0x46000
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x43) [0x4697787]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(handle_fatal_signal+0x2cb) [0x35e2792]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7fa10fd33390]
      /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7fa10f98d438]
      /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fa10f98f03a]
      /usr/local/lib64/libstdc++.so.6(+0x993dc) [0x7fa1104f83dc]
      /usr/local/lib64/libstdc++.so.6(+0xa44c6) [0x7fa1105034c6]
      /usr/local/lib64/libstdc++.so.6(+0xa4531) [0x7fa110503531]
      /usr/local/lib64/libstdc++.so.6(+0xa47c4) [0x7fa1105037c4]
      /usr/local/lib64/libstdc++.so.6(std::__throw_system_error(int)+0x81) [0x7fa1104fb048]
      /usr/local/lib64/libstdc++.so.6(+0xcdac9) [0x7fa11052cac9]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(std::thread::thread<Runnable, void (&)(), void>(Runnable&&, void (&)())+0x73) [0x48f08b5]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(IB_thread create_detached_thread<void (&)()>(mysql_pfs_key_t, void (&)())+0x6c) [0x48efee0]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(fil_crypt_set_thread_cnt(unsigned int)+0x10e) [0x4cfd8ca]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld() [0x47d4419]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(sys_var_pluginvar::global_update(THD*, set_var*)+0x337) [0x3434fdf]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(sys_var::update(THD*, set_var*)+0xa2) [0x32bb1f2]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(set_var::update(THD*)+0x4b) [0x32bd9a9]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(sql_set_variables(THD*, List<set_var_base>*, bool)+0x206) [0x32bcb63]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(mysql_execute_command(THD*, bool)+0x2982) [0x33f6ffd]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x71b) [0x33fce19]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1410) [0x33f1b0e]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld(do_command(THD*)+0x503) [0x33f0086]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld() [0x35cc84a]
      /home/mohit.joshi/keyring_pr/percona-server/bld_27aug2020/install/bin/mysqld() [0x4e1e827]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba) [0x7fa10fd296ba]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7fa10fa5f4dd]Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (7fa03800c7b8): set global innodb_encryption_threads=99999
      Connection ID (thread ID): 8
      Status: NOT_KILLED

      Attachments

        Issue Links

          Activity

            People

              oleksandr.kachan Oleksandr Kachan
              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:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 days, 2 hours, 40 minutes
                  2d 2h 40m

                  Smart Checklist