Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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

Environment

None

Smart Checklist

Activity

Show:

Oleksandr Kachan September 15, 2020 at 1:16 PM

The maximum allowed value for innodb_encryption_threads is changed to 255.

Done

Details

Assignee

Reporter

Labels

Time tracking

2d 2h 40m logged

Fix versions

Affects versions

Priority

Smart Checklist

Created September 4, 2020 at 7:57 AM
Updated March 6, 2024 at 10:56 AM
Resolved September 15, 2020 at 1:16 PM