Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.13
-
None
-
CentOS Linux release 7.6.1810 (Core)
MariaDB-server-10.4.13-1.el7.centos.x86_64
MariaDB-tokudb-engine-10.4.13-1.el7.centos.x86_64
Description
On start the server writes in its log:
2020-07-30 13:32:20 0 [Note] InnoDB: Using Linux native AIO
|
2020-07-30 13:32:20 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 2 to 1 since innodb_buffer_pool_size is less than 1024 MiB
|
2020-07-30 13:32:20 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2020-07-30 13:32:20 0 [Note] InnoDB: Uses event mutexes
|
2020-07-30 13:32:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
2020-07-30 13:32:20 0 [Note] InnoDB: Number of pools: 1
|
2020-07-30 13:32:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
|
2020-07-30 13:32:20 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M
|
2020-07-30 13:32:20 0 [Note] InnoDB: Completed initialization of buffer pool
|
2020-07-30 13:32:20 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2020-07-30 13:32:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2020-07-30 13:32:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2020-07-30 13:32:21 0 [Note] InnoDB: Setting file '/srv/mariadb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2020-07-30 13:32:21 0 [Note] InnoDB: File '/srv/mariadb/ibtmp1' size is now 12 MB.
|
2020-07-30 13:32:21 0 [Note] InnoDB: Waiting for purge to start
|
2020-07-30 13:32:21 0 [Note] InnoDB: 10.4.13 started; log sequence number 6105543162389; transaction id 1454223249
|
2020-07-30 13:32:21 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mariadb/ib_buffer_pool
|
2020-07-30 13:32:21 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2020-07-30 13:32:24 0 [Note] InnoDB: Buffer pool(s) load completed at 200730 13:32:24
|
And it hangs in this state indefinitely.
ps -o pid,comm,wchan displays futex_wait_queue_me that mysqld is waiting on.
The server has been updated upto 10.4.13 from 10.4.8 with mysql_upgrade, of course.
The server wasn't restarted after mysql_upgrade, BTW.
A fun fact is that another server with the same data has been upgraded from 10.3.23 upto 10.4.13, too, it shares the same config, and it hangs as well.
The config is as follows:
[mysqld]
|
datadir = /srv/mariadb
|
log-error = egrul.err
|
log_warnings = 1
|
skip-name-resolve
|
innodb_data_home_dir = /srv/mariadb/
|
innodb_data_file_path = ibdata1:10M:autoextend
|
innodb_file_per_table
|
innodb_log_group_home_dir = /srv/mariadb/
|
innodb_log_file_size = 512M
|
innodb_log_buffer_size = 8M
|
innodb_buffer_pool_size = 64M
|
innodb_buffer_pool_instances = 2
|
innodb_flush_log_at_trx_commit = 2
|
innodb_flush_method = O_DIRECT
|
innodb_stats_on_metadata = 0
|
log_slow_verbosity = query_plan,explain
|
long_query_time = 2
|
log_queries_not_using_indexes = ON
|
slow_query_log = ON
|
 |
[mariadb]
|
plugin_load_add = query_response_time
|
plugin-load-add = ha_tokudb.so
|
tokudb_dir_per_db = 1
|
tokudb_row_format = tokudb_small
|
tokudb_commit_sync = 0
|
tokudb_fsync_log_period = 1000
|
default_storage_engine = TokuDB
|
 |
[mysqld_safe]
|
malloc-lib = /usr/lib64/libjemalloc.so.1
|
UPD: Workaround is to remove aria_log_control before starting.