Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6
Description
On 10.5 and 10.6 this issue started happening recently:
10.5.25 55cb2c2916a26b699ed8260427002243682c7110 (Optimized) |
qa-roel-2:/test/MD240424-mariadb-10.5.25-linux-x86_64-opt$ rm -Rf data; ./scripts/mariadb-install-db --no-defaults --basedir=${PWD} --datadir=${PWD}/data
|
Installing MariaDB/MySQL system tables in '/test/MD240424-mariadb-10.5.25-linux-x86_64-opt/data' ...
|
Error in my_thread_global_end(): 1 threads didn't exit
|
OK
|
...
|
10.6.18 0ccdf54b644352f42e1768bc660be7ab50c1e9d2 (Optimized) |
/test/MD240424-mariadb-10.6.18-linux-x86_64-opt$ rm -Rf data; ./scripts/mariadb-install-db --no-defaults --basedir=${PWD} --datadir=${PWD}/data
|
Installing MariaDB/MySQL system tables in '/test/MD240424-mariadb-10.6.18-linux-x86_64-opt/data' ...
|
Error in my_thread_global_end(): 1 threads didn't exit
|
OK
|
...
|
Also confirmed in 10.5 88f49da8e08bb5027b6031fed04f82f2d9f552b7 (10.5 trunk as of 4 May 24).
Attachments
Issue Links
- is blocked by
-
MDEV-34676 REOPEN: mariadb-install-db Error in my_thread_global_end(): 1 threads didn't exit
- Closed
Activity
Recent changes to the file:
https://github.com/MariaDB/server/commits/10.5/scripts/mysql_install_db.sh
Given the possibility of something being upmerged from 10.4, I also tested that (trunk as of today, f378e7643459f0baa6c4149a795463f2f46b68710), and it does not show the issue.
serg Hi! Any ideas on this one? I can try and run a git bisect if you don't recognize the issue.
Yes, Monty fixed it by 814dc46748d8, but only in 10.6 for some reason. I'll cherry-pick it into 10.5.
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
|
|
From looking at the script code, the issue seems to be not in the script but in the mariadbd bootstrap, i.e. as generated by mysqld_install_cmd_line(); The error message is likely from mariadbd.