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

Warning: 1 threads created by InnoDB had not exited at shutdown! InnoDB: error: return value 16 when calling pthread_mutex_destroy().

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 5.5.65
    • N/A
    • OTHER
    • CentOS Linux 7.8.2003
      Server version: 5.5.65-MariaDB

    Description

      Warning: 1 threads created by InnoDB had not exited at shutdown! InnoDB: error: return value 16 when calling pthread_mutex_destroy().

      Server version: 5.5.65-MariaDB
      key_buffer_size=2147483648
      read_buffer_size=131072
      max_used_connections=3
      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 = 2432799 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x0
      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
      /usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x55c4f8930efd]
      /usr/libexec/mysqld(handle_fatal_signal+0x515)[0x55c4f8544805]
      sigaction.c:0(__restore_rt)[0x7f481b382630]
      :0(__GI_raise)[0x7f4819aaa387]
      :0(__GI_abort)[0x7f4819aaba78]
      /usr/libexec/mysqld(+0x2d4898)[0x55c4f8375898]
      /usr/libexec/mysqld(+0x71c9f5)[0x55c4f87bd9f5]
      /usr/libexec/mysqld(+0x63279f)[0x55c4f86d379f]
      /usr/libexec/mysqld(+0x5e8b65)[0x55c4f8689b65]
      /usr/libexec/mysqld(_Z22ha_finalize_handlertonP13st_plugin_int+0x2c)[0x55c4f85467dc]
      /usr/libexec/mysqld(+0x37b43f)[0x55c4f841c43f]
      /usr/libexec/mysqld(+0x37f8d6)[0x55c4f84208d6]
      /usr/libexec/mysqld(_Z15plugin_shutdownv+0x1e5)[0x55c4f8421de5]
      /usr/libexec/mysqld(+0x2e8ef5)[0x55c4f8389ef5]
      /usr/libexec/mysqld(_Z10unireg_endv+0x2d)[0x55c4f838b5fd]
      /usr/libexec/mysqld(+0x2eccbc)[0x55c4f838dcbc]
      /usr/libexec/mysqld(kill_server_thread+0xe)[0x55c4f838dd0e]
      pthread_create.c:0(start_thread)[0x7f481b37aea5]
      /lib64/libc.so.6(clone+0x6d)[0x7f4819b728dd]
      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.
      200528 10:44:17 mysqld_safe Number of processes running now: 0
      200528 10:44:17 mysqld_safe mysqld restarted
      200528 10:44:17 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 18886 ...
      200528 10:44:17 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431
      200528 10:44:17 InnoDB: The InnoDB memory heap is disabled
      200528 10:44:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
      200528 10:44:17 InnoDB: Compressed tables use zlib 1.2.7
      200528 10:44:17 InnoDB: Using Linux native AIO
      200528 10:44:17 InnoDB: Initializing buffer pool, size = 8.0G
      200528 10:44:18 InnoDB: Completed initialization of buffer pool
      200528 10:44:18 InnoDB: highest supported file format is Barracuda.
      200528 10:44:18 InnoDB: Waiting for the background threads to start
      200528 10:44:19 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 2782470
      200528 10:44:19 [Note] Plugin 'FEEDBACK' is disabled.
      200528 10:44:19 [Note] Server socket created on IP: '0.0.0.0'.
      200528 10:44:19 [Note] Event Scheduler: Loaded 0 events
      200528 10:44:19 [Note] /usr/libexec/mysqld: ready for connections.
      Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
      200528 20:47:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
      200528 20:47:34 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 1339 ...
      200528 20:47:34 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431
      200528 20:47:34 InnoDB: The InnoDB memory heap is disabled
      200528 20:47:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
      200528 20:47:34 InnoDB: Compressed tables use zlib 1.2.7
      200528 20:47:34 InnoDB: Using Linux native AIO
      200528 20:47:34 InnoDB: Initializing buffer pool, size = 8.0G
      200528 20:47:35 InnoDB: Completed initialization of buffer pool
      200528 20:47:35 InnoDB: highest supported file format is Barracuda.
      200528 20:47:36 InnoDB: Waiting for the background threads to start
      200528 20:47:37 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 2782470
      200528 20:47:37 [Note] Plugin 'FEEDBACK' is disabled.
      200528 20:47:37 [Note] Server socket created on IP: '0.0.0.0'.
      200528 20:47:37 [Note] Event Scheduler: Loaded 0 events
      200528 20:47:37 [Note] /usr/libexec/mysqld: ready for connections.
      Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
      200529 3:55:10 [Warning] IP address '45.93.83.211' could not be resolved: Name or service not known
      200529 18:16:14 [Note] /usr/libexec/mysqld: Normal shutdown
      200529 18:16:14 [Note] Event Scheduler: Purging the queue. 0 events
      200529 18:16:14 InnoDB: Starting shutdown...
      200529 18:16:17 InnoDB: Shutdown completed; log sequence number 28276485
      200529 18:16:17 [Note] /usr/libexec/mysqld: Shutdown complete

      Attachments

        Activity

          People

            Unassigned Unassigned
            blamotech@gmail.com Anthony Amolochitis
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.