Bug #81649 [ERROR] Can't create interrupt-thread (error 11, errno: 12)

• Submitted: 30 May 2016 23:33
• Modified: 31 May 2016 11:54
• Reporter: Roel Van de Paar
• Status: Verified
• Category: MySQL Server: Options
• Severity: S2 (Serious)
• Version: 5.7.12
• OS: Any
• CPU Architecture: Any

[30 May 2016 23:33] Roel Van de Paar

Description:
2016-05-30T23:17:42.822380Z 0 [ERROR] Can't create interrupt-thread (error 11, errno: 12)

How to repeat:
rm -Rf /dev/shm/772251/13
mkdir -p /dev/shm/772251/13/data /dev/shm/772251/13/tmp /dev/shm/772251/13/log
/sda/MS180516-mysql-5.7.12-linux-x86_64-debug/bin/mysqld --no-defaults --initialize-insecure --basedir=/sda/MS180516-mysql-5.7.12-linux-x86_64-debug --datadir=/dev/shm/772251/13/data --tmpdir=/dev/shm/772251/13/tmp --core-file --port=55037 --pid_file=/dev/shm/772251/13/pid.pid --socket=/dev/shm/772251/13/socket.sock --log-error=/dev/shm/772251/13/log/master.err
/sda/MS180516-mysql-5.7.12-linux-x86_64-debug/bin/mysqld --no-defaults --thread-stack=1125899906842624 --basedir=/sda/MS180516-mysql-5.7.12-linux-x86_64-debug --datadir=/dev/shm/772251/13/data --tmpdir=/dev/shm/772251/13/tmp --core-file --port=55037 --pid_file=/dev/shm/772251/13/pid.pid --socket=/dev/shm/772251/13/socket.sock --log-error=/dev/shm/772251/13/log/master.err

Then check /dev/shm/772251/13/log/master.err

[31 May 2016 6:00] MySQL Verification Team

with a 1024TB thread stack, what is the expected behavior here? Is this a request to enforce more "reasonable" maximum limits for this variable?

http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_thread_stack

[31 May 2016 6:19] Roel Van de Paar

A more descriptive message may be a good start :)

In PS we're seeing further issues in combination to this bug;
https://bugs.launchpad.net/percona-server/+bug/1587195
The same may be applicable for MS.

[31 May 2016 7:56] Roel Van de Paar

Relevant code;

mysql_mutex_lock(&LOCK_start_signal_handler);
  if ((error=
       mysql_thread_create(key_thread_signal_hand,
                           &signal_thread_id, &thr_attr, signal_hand, 0)))
  {
    sql_print_error("Can't create interrupt-thread (error %d, errno: %d)",
                    error, errno);
    flush_error_log_messages();
    exit(MYSQLD_ABORT_EXIT);
  }
  mysql_cond_wait(&COND_start_signal_handler, &LOCK_start_signal_handler);
  mysql_mutex_unlock(&LOCK_start_signal_handler);

[31 May 2016 11:54] MySQL Verification Team

Hello Roel,

Thank you for the report and feedback.

Thanks,
Umesh

-- 5.7.12
2016-05-31T11:53:05.621920Z 0 [ERROR] Can't create interrupt-thread (error 11, errno: 12)