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

REOPEN: mariadb-install-db Error in my_thread_global_end(): 1 threads didn't exit

    XMLWordPrintable

Details

    Description

      This case is related to MDEV-34077, which was not fully fixed but was closed

      I just tested it under version 10.11.8, 11.0.6, 11.1.5 and 11.2.4. The problem still exists, and it also causes the mariadbd process fail to shutdown.

      system: macOS 14.5 & 15.1 beta 1, arm64

      2024-07-31  2:27:42 0 [Note] Starting MariaDB 10.11.8-MariaDB-log source revision 3a069644682e336e445039e48baae9693f9a08ee as process 39906
      2024-07-31  2:27:42 0 [Note] InnoDB: The first data file '/Applications/ServBay/db/mariadb/10.11/ibdata1' did not exist. A new tablespace will be created!
      2024-07-31  2:27:42 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
      2024-07-31  2:27:42 0 [Note] InnoDB: Number of transaction pools: 1
      2024-07-31  2:27:42 0 [Note] InnoDB: Using generic crc32 instructions
      2024-07-31  2:27:42 0 [Note] InnoDB: Initializing buffer pool, total size = 4.000GiB, chunk size = 64.000MiB
      2024-07-31  2:27:42 0 [Note] InnoDB: Completed initialization of buffer pool
      2024-07-31  2:27:42 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/10.11/ibdata1' size to 10.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:27:42 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/10.11/ibdata1' size is now 10.000MiB.
      2024-07-31  2:27:43 0 [Note] InnoDB: Doublewrite buffer not found: creating new
      2024-07-31  2:27:43 0 [Note] InnoDB: 128 rollback segments are active.
      2024-07-31  2:27:43 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/10.11/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:27:43 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/10.11/ibtmp1' size is now 12.000MiB.
      2024-07-31  2:27:43 0 [Note] InnoDB: log sequence number 0; transaction id 3
      2024-07-31  2:27:43 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
       
       
       
      Error in my_thread_global_end(): 1 threads didn't exit
       
       
      240731 02:40:08 mysqld_safe Starting mariadbd daemon with databases from /Applications/ServBay/db/mariadb/10.11
      2024-07-31  2:40:08 0 [Note] Starting MariaDB 10.11.8-MariaDB-log source revision 3a069644682e336e445039e48baae9693f9a08ee as process 40266
      2024-07-31  2:40:08 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/ServBay/db/mariadb/10.11/ is case insensitive
      2024-07-31  2:40:08 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
      2024-07-31  2:40:08 0 [Note] InnoDB: Number of transaction pools: 1
      2024-07-31  2:40:08 0 [Note] InnoDB: Using generic crc32 instructions
      2024-07-31  2:40:08 0 [Note] InnoDB: Initializing buffer pool, total size = 4.000GiB, chunk size = 64.000MiB
      2024-07-31  2:40:08 0 [Note] InnoDB: Completed initialization of buffer pool
      2024-07-31  2:40:08 0 [Note] InnoDB: End of log at LSN=46846
      2024-07-31  2:40:08 0 [Note] InnoDB: 128 rollback segments are active.
      2024-07-31  2:40:08 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/10.11/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:40:08 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/10.11/ibtmp1' size is now 12.000MiB.
      2024-07-31  2:40:08 0 [Note] InnoDB: log sequence number 46846; transaction id 14
      2024-07-31  2:40:08 0 [Note] InnoDB: Loading buffer pool(s) from /Applications/ServBay/db/mariadb/10.11/ib_buffer_pool
      2024-07-31  2:40:08 0 [Note] Plugin 'FEEDBACK' is disabled.
      2024-07-31  2:40:08 0 [Note] InnoDB: Buffer pool(s) load completed at 240731  2:40:08
      2024-07-31  2:40:08 0 [Note] Server socket created on IP: '::1'.
      2024-07-31  2:40:08 0 [Note] Server socket created on IP: '127.0.0.1'.
      2024-07-31  2:40:08 0 [Note] Server socket created on IP: '::'.
      2024-07-31  2:40:08 0 [Note] Server socket created on IP: '0.0.0.0'.
      2024-07-31  2:40:08 0 [Note] /Applications/ServBay/package/mariadb/10.11/current/bin/mariadbd: ready for connections.
      Version: '10.11.8-MariaDB-log'  socket: '/Applications/ServBay/tmp/mariadb-10.11.sock'  port: 3306  ServBay.dev
       
       
       
      2024-07-31  2:40:26 0 [Note] /Applications/ServBay/package/mariadb/10.11/current/bin/mariadbd (initiated by: unknown): Normal shutdown
      2024-07-31  2:42:06 0 [Warning] Signal handler thread did not exit in a timely manner. Continuing to wait for it to stop..
      
      

      2024-07-31  2:45:41 0 [Note] Starting MariaDB 11.0.6-MariaDB-log source revision 466ae1cf81f54b729058357bb19c4cf3982e1367 as process 40568
      2024-07-31  2:45:41 0 [Note] InnoDB: The first data file '/Applications/ServBay/db/mariadb/11.0/ibdata1' did not exist. A new tablespace will be created!
      2024-07-31  2:45:41 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
      2024-07-31  2:45:41 0 [Note] InnoDB: Number of transaction pools: 1
      2024-07-31  2:45:41 0 [Note] InnoDB: Using generic crc32 instructions
      2024-07-31  2:45:41 0 [Note] InnoDB: Initializing buffer pool, total size = 4.000GiB, chunk size = 64.000MiB
      2024-07-31  2:45:41 0 [Note] InnoDB: Completed initialization of buffer pool
      2024-07-31  2:45:41 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/11.0/ibdata1' size to 10.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:45:41 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/11.0/ibdata1' size is now 10.000MiB.
      2024-07-31  2:45:42 0 [Note] InnoDB: Data file .//undo001 did not exist: new to be created
      2024-07-31  2:45:42 0 [Note] InnoDB: Setting file .//undo001 size to 10.000MiB
      2024-07-31  2:45:42 0 [Note] InnoDB: Database physically writes the file full: wait...
      2024-07-31  2:45:42 0 [Note] InnoDB: Data file .//undo002 did not exist: new to be created
      2024-07-31  2:45:42 0 [Note] InnoDB: Setting file .//undo002 size to 10.000MiB
      2024-07-31  2:45:42 0 [Note] InnoDB: Database physically writes the file full: wait...
      2024-07-31  2:45:42 0 [Note] InnoDB: Data file .//undo003 did not exist: new to be created
      2024-07-31  2:45:42 0 [Note] InnoDB: Setting file .//undo003 size to 10.000MiB
      2024-07-31  2:45:42 0 [Note] InnoDB: Database physically writes the file full: wait...
      2024-07-31  2:45:42 0 [Note] InnoDB: Doublewrite buffer not found: creating new
      2024-07-31  2:45:42 0 [Note] InnoDB: Opened 3 undo tablespaces
      2024-07-31  2:45:42 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2024-07-31  2:45:42 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/11.0/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:45:42 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/11.0/ibtmp1' size is now 12.000MiB.
      2024-07-31  2:45:42 0 [Note] InnoDB: log sequence number 0; transaction id 3
      2024-07-31  2:45:42 0 [Note] Plugin 'wsrep-provider' is disabled.
       
      Error in my_thread_global_end(): 1 threads didn't exit
       
      240731 02:50:26 mysqld_safe Starting mariadbd daemon with databases from /Applications/ServBay/db/mariadb/11.0
      2024-07-31  2:50:26 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/ServBay/db/mariadb/11.0/ is case insensitive
      2024-07-31  2:50:26 0 [Note] Starting MariaDB 11.0.6-MariaDB-log source revision 466ae1cf81f54b729058357bb19c4cf3982e1367 as process 40950
      2024-07-31  2:50:26 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
      2024-07-31  2:50:26 0 [Note] InnoDB: Number of transaction pools: 1
      2024-07-31  2:50:26 0 [Note] InnoDB: Using generic crc32 instructions
      2024-07-31  2:50:26 0 [Note] InnoDB: Initializing buffer pool, total size = 4.000GiB, chunk size = 64.000MiB
      2024-07-31  2:50:26 0 [Note] InnoDB: Completed initialization of buffer pool
      2024-07-31  2:50:26 0 [Note] InnoDB: End of log at LSN=47610
      2024-07-31  2:50:26 0 [Note] InnoDB: Opened 3 undo tablespaces
      2024-07-31  2:50:26 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2024-07-31  2:50:26 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/11.0/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:50:26 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/11.0/ibtmp1' size is now 12.000MiB.
      2024-07-31  2:50:26 0 [Note] InnoDB: log sequence number 47610; transaction id 14
      2024-07-31  2:50:26 0 [Note] InnoDB: Loading buffer pool(s) from /Applications/ServBay/db/mariadb/11.0/ib_buffer_pool
      2024-07-31  2:50:26 0 [Note] Plugin 'FEEDBACK' is disabled.
      2024-07-31  2:50:26 0 [Note] Plugin 'wsrep-provider' is disabled.
      2024-07-31  2:50:26 0 [Note] InnoDB: Buffer pool(s) load completed at 240731  2:50:26
      2024-07-31  2:50:26 0 [Note] Server socket created on IP: '::1'.
      2024-07-31  2:50:26 0 [Note] Server socket created on IP: '127.0.0.1'.
      2024-07-31  2:50:26 0 [Note] Server socket created on IP: '::'.
      2024-07-31  2:50:26 0 [Note] Server socket created on IP: '0.0.0.0'.
      2024-07-31  2:50:26 0 [Note] /Applications/ServBay/package/mariadb/11.0/current/bin/mariadbd: ready for connections.
      Version: '11.0.6-MariaDB-log'  socket: '/Applications/ServBay/tmp/mariadb-11.0.sock'  port: 3306  ServBay.dev
       
      2024-07-31  2:50:33 0 [Note] /Applications/ServBay/package/mariadb/11.0/current/bin/mariadbd (initiated by: unknown): Normal shutdown
       
      2024-07-31  2:52:13 0 [Warning] Signal handler thread did not exit in a timely manner. Continuing to wait for it to stop..
      
      

      2024-07-31  2:51:53 0 [Note] Starting MariaDB 11.1.5-MariaDB-log source revision fe41171c96a0eee9c026f96d5971ed281e76d488 as process 41437
      2024-07-31  2:51:53 0 [Note] InnoDB: The first data file '/Applications/ServBay/db/mariadb/11.1/ibdata1' did not exist. A new tablespace will be created!
      2024-07-31  2:51:53 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
      2024-07-31  2:51:53 0 [Note] InnoDB: Number of transaction pools: 1
      2024-07-31  2:51:53 0 [Note] InnoDB: Using generic crc32 instructions
      2024-07-31  2:51:53 0 [Note] InnoDB: Initializing buffer pool, total size = 4.000GiB, chunk size = 64.000MiB
      2024-07-31  2:51:53 0 [Note] InnoDB: Completed initialization of buffer pool
      2024-07-31  2:51:53 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/11.1/ibdata1' size to 10.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:51:53 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/11.1/ibdata1' size is now 10.000MiB.
      2024-07-31  2:51:53 0 [Note] InnoDB: Data file .//undo001 did not exist: new to be created
      2024-07-31  2:51:53 0 [Note] InnoDB: Setting file .//undo001 size to 10.000MiB
      2024-07-31  2:51:53 0 [Note] InnoDB: Database physically writes the file full: wait...
      2024-07-31  2:51:53 0 [Note] InnoDB: Data file .//undo002 did not exist: new to be created
      2024-07-31  2:51:53 0 [Note] InnoDB: Setting file .//undo002 size to 10.000MiB
      2024-07-31  2:51:53 0 [Note] InnoDB: Database physically writes the file full: wait...
      2024-07-31  2:51:53 0 [Note] InnoDB: Data file .//undo003 did not exist: new to be created
      2024-07-31  2:51:53 0 [Note] InnoDB: Setting file .//undo003 size to 10.000MiB
      2024-07-31  2:51:53 0 [Note] InnoDB: Database physically writes the file full: wait...
      2024-07-31  2:51:53 0 [Note] InnoDB: Doublewrite buffer not found: creating new
      2024-07-31  2:51:53 0 [Note] InnoDB: Opened 3 undo tablespaces
      2024-07-31  2:51:53 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2024-07-31  2:51:53 0 [Note] InnoDB: Setting file '/Applications/ServBay/db/mariadb/11.1/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2024-07-31  2:51:53 0 [Note] InnoDB: File '/Applications/ServBay/db/mariadb/11.1/ibtmp1' size is now 12.000MiB.
      2024-07-31  2:51:53 0 [Note] InnoDB: log sequence number 0; transaction id 3
      2024-07-31  2:51:53 0 [Note] Plugin 'wsrep-provider' is disabled.
      Error in my_thread_global_end(): 1 threads didn't exit
      
      

      Attachments

        Issue Links

          Activity

            People

              Gosselin Dave Gosselin
              naizhao Sam
              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.