[MDEV-23343] aria_log_control Gets Corrupted Preventing MariaDB from Starting Created: 2020-07-30  Updated: 2021-06-19

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 10.4.13
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Denis Melnikov Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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.

 Comments   
Comment by Vincent Milum Jr [ 2020-07-31 ]

I'm experiencing this exact same issue, hanging at what appears to be the exact same spot (based on the mysql.log file), and also running MariaDB 10.4.13 on CentOS EL7.

I SCPed the database and config files over to a FreeBSD 12.1 install, and it started right up.

Some extra notes:

My instance was an upgrade from 10.3.11. When first upgrading, the 10.4 instance worked just fine. After running the mysql_upgrade program and restarting the instance, THAT is when it started to hang. Prior to running mysql_upgrade on 10.4, it would continue to function as normal.

Setting skip-grant-tables (a suggestion I found on a random forum) allows the instance to start up... but obviously, this is a highly broken config.

Comment by Denis Melnikov [ 2020-07-31 ]

@darkain,
Our contractor, God bless his family, had discovered that removing aria_log_control allowed MariaDB to start.
He referred to https://jira.mariadb.org/browse/MDEV-14889
Unfortunately, the file gets corrupted every time MariaDB stopped.

Comment by Vincent Milum Jr [ 2020-07-31 ]

That actually did the trick! Removing that file allowed MariaDB to start. And yes, the file seems to get corrupt every single time, too, and needs to be re-deleted.

Comment by Vincent Milum Jr [ 2020-07-31 ]

from https://mariadb.com/kb/en/aria-faq/

"Aria has a log control file (aria_log_control) and log files (aria_log.%). The log files can be automatically purged when not needed or purged on demand (after backup)."

I guess I'll just update my startup scripts to purge these files before launching the MariaDB process as a temporary work-around for this bug.

Comment by Vincent Milum Jr [ 2020-08-01 ]

@Denis

Were you running MariaDB inside of a container of some kind? Docker or LXC/LXD or something else?

Comment by Denis Melnikov [ 2020-08-01 ]

No, just a VM in VMWare ESXi.

Comment by Elena Stepanova [ 2020-08-05 ]

So, you remove the aria log control file, start the server, don't do anything there, shut it down properly, it says in the error log that shutdown was complete, and next time you start it it hangs because the newly created log control file is corrupt?

Comment by Denis Melnikov [ 2020-08-05 ]

Correct.

Comment by Elena Stepanova [ 2020-08-05 ]

Please paste or attach the error log covering all these steps – successful start (after removing the log), clean shutdown, and the next unsuccessful start.
Are there any disk errors in the system?
What kind of file system the datadir is on?
How do you start your server? Normally CentOS 7.6 would imply systemd, but you have mysqld_safe section in your config, so do you start it manually or via an old-style init script?

darkain, do you also have TokuDB for a default engine and libjemalloc.so.1

As you understand, there must be something more to it than just a clean server restart, something specific to your (both of you) environment, operation or data, otherwise we would have thousands of such reports.

Comment by Denis Melnikov [ 2020-08-05 ]

The egrul.err pasted below, log_warnings=9.
As I wrote above, we have 2 servers with this database, the datadirs are binary similar, both encounter the problem. What's the probability they have got same disk errors?
File systems are XFS in LVM.
MariaDB started via systemctl start mariadb, that's the only way I use.

2020-07-31 18:50:29 0 [Note] Initializing built-in plugins
 
2020-07-31 18:50:29 0 [Note] Initializing plugins specified on the command line
 
2020-07-31 18:50:29 0 [Note] Loaded 'query_response_time.so' with offset 0x7f1cfa8ba000
 
2020-07-31 18:50:29 0 [Note] Loaded 'ha_tokudb.so' with offset 0x7f1cf942f000
 
2020-07-31 18:50:29 0 [Note] InnoDB: Using Linux native AIO
 
2020-07-31 18:50:29 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2020-07-31 18:50:29 0 [Note] InnoDB: Uses event mutexes
 
2020-07-31 18:50:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
 
2020-07-31 18:50:29 0 [Note] InnoDB: Number of pools: 1
 
2020-07-31 18:50:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2020-07-31 18:50:29 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 2, chunk size = 128M
 
2020-07-31 18:50:29 0 [Note] InnoDB: Completed initialization of buffer pool
 
2020-07-31 18:50:29 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-31 18:50:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2020-07-31 18:50:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2020-07-31 18:50:30 0 [Note] InnoDB: Setting file '/srv/mariadb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2020-07-31 18:50:30 0 [Note] InnoDB: File '/srv/mariadb/ibtmp1' size is now 12 MB.
 
2020-07-31 18:50:30 0 [Note] InnoDB: Waiting for purge to start
 
2020-07-31 18:50:30 0 [Note] InnoDB: 10.4.13 started; log sequence number 6105543162389; transaction id 1454223249
 
2020-07-31 18:50:30 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mariadb/ib_buffer_pool
 
2020-07-31 18:50:30 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2020-07-31 18:50:30 0 [Note] Initializing installed plugins
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/plugin'
 
2020-07-31 18:50:30 0 [ERROR] mysqld: Plugin 'QUERY_RESPONSE_TIME' already installed
 
2020-07-31 18:50:30 0 [ERROR] mysqld: Plugin 'QUERY_RESPONSE_TIME_AUDIT' already installed
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/servers'
 
2020-07-31 18:50:30 0 [Note] Server socket created on IP: '::'.
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/db'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/proxies_priv'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/roles_mapping'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/global_priv'
 
2020-07-31 18:50:30 0 [Warning] 'proxies_priv' entry '@% root@egrul.komus.net' ignored in --skip-name-resolve mode.
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/time_zone_leap_second'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/time_zone_name'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/time_zone'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/time_zone_transition_type'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/time_zone_transition'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/tables_priv'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/columns_priv'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/procs_priv'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/func'
 
2020-07-31 18:50:30 0 [Note] Zerofilling moved table:  './mysql/event'
 
2020-07-31 18:50:30 0 [Note] Reading of all Master_info entries succeeded
 
2020-07-31 18:50:30 0 [Note] Added new Master_info '' to hash table
 
2020-07-31 18:50:30 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Version: '10.4.13-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
 
2020-07-31 18:50:34 0 [Note] InnoDB: Buffer pool(s) load completed at 200731 18:50:34
 
2020-07-31 18:51:02 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'zabbix' host: 'localhost' (This connection closed normally)
 
2020-07-31 18:51:28 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'zabbix' host: 'localhost' (This connection closed normally)
 
2020-07-31 18:52:15 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
 
2020-07-31 18:52:15 0 [Note] Event Scheduler: Purging the queue. 0 events
 
2020-07-31 18:52:15 0 [Note] InnoDB: FTS optimize thread exiting.
 
2020-07-31 18:52:15 0 [Note] InnoDB: Starting shutdown...
 
2020-07-31 18:52:15 0 [Note] InnoDB: Dumping buffer pool(s) to /srv/mariadb/ib_buffer_pool
 
2020-07-31 18:52:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 200731 18:52:15
 
2020-07-31 18:52:17 0 [Note] InnoDB: Shutdown completed; log sequence number 6105543162398; transaction id 1454223250
 
2020-07-31 18:52:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
2020-07-31 18:52:18 0 [Note] /usr/sbin/mysqld: Shutdown complete
 
 
 
2020-07-31 18:52:18 0 [Note] Initializing built-in plugins
 
2020-07-31 18:52:18 0 [Note] Initializing plugins specified on the command line
 
2020-07-31 18:52:18 0 [Note] Loaded 'query_response_time.so' with offset 0x7fd8d049f000
 
2020-07-31 18:52:18 0 [Note] Loaded 'ha_tokudb.so' with offset 0x7fd8cf02f000
 
2020-07-31 18:52:18 0 [Note] mysqld: Aria engine: starting recovery
 
recovered pages: 0% 11% 23% 33% 43% 53% 64% 76% 86% 96% 100% (0.0 seconds); tables to flush: 2 1 0
 
 (0.0 seconds);
 
2020-07-31 18:52:18 0 [Note] mysqld: Aria engine: recovery done
 
2020-07-31 18:52:18 0 [Note] InnoDB: Using Linux native AIO
 
2020-07-31 18:52:18 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 2 to 1 since innodb_buffer_pool_size is less than 1024 MiB
 
2020-07-31 18:52:18 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2020-07-31 18:52:18 0 [Note] InnoDB: Uses event mutexes
 
2020-07-31 18:52:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
 
2020-07-31 18:52:18 0 [Note] InnoDB: Number of pools: 1
 
2020-07-31 18:52:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2020-07-31 18:52:18 0 [Note] InnoDB: Initializing buffer pool, total size = 64M, instances = 1, chunk size = 64M
 
2020-07-31 18:52:18 0 [Note] InnoDB: Completed initialization of buffer pool
 
2020-07-31 18:52:18 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-31 18:52:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2020-07-31 18:52:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2020-07-31 18:52:19 0 [Note] InnoDB: Setting file '/srv/mariadb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2020-07-31 18:52:19 0 [Note] InnoDB: File '/srv/mariadb/ibtmp1' size is now 12 MB.
 
2020-07-31 18:52:19 0 [Note] InnoDB: Waiting for purge to start
 
2020-07-31 18:52:19 0 [Note] InnoDB: 10.4.13 started; log sequence number 6105543162398; transaction id 1454223249
 
2020-07-31 18:52:19 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mariadb/ib_buffer_pool
 
2020-07-31 18:52:19 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2020-07-31 18:52:19 0 [Note] Initializing installed plugins
 
2020-07-31 18:52:19 0 [Note] InnoDB: Buffer pool(s) load completed at 200731 18:52:19

Comment by Vincent Milum Jr [ 2020-08-05 ]

In my particular case, these are being launch as LXC containers. They don't use systemd, instead they use a basic init script. We don't use TokuDB, we're a 100% InnoDB house. jemalloc is also not used.

Also of note, this first test instance that I'm having this issue on is a very small instance only used for personal development at $DayJob. We're talking less than 10MB of InnoDB data, and the only Aria data is the system tables.

As mentioned above, when I SCP the data to another OS, it loads up perfectly. So the data doesn't appear to be corrupt at all.

I've built ~10 different CentOS VMs from fresh ISOs to attempt to reproduce the issue on my personal lab machines, with no luck so far. I'm not sure what customizations were done on $DayJob OS installs that might effect this issue, as that pre-dates my time there.

In my particular case, the containers each use a dedicated ext4 volume from a thick provisioned file on the host.

2020-08-05 19:32:23 0 [Note] InnoDB: Using Linux native AIO
 
2020-08-05 19:32:23 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2020-08-05 19:32:23 0 [Note] InnoDB: Uses event mutexes
 
2020-08-05 19:32:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
2020-08-05 19:32:23 0 [Note] InnoDB: Number of pools: 1
 
2020-08-05 19:32:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2020-08-05 19:32:23 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
 
2020-08-05 19:32:23 0 [Note] InnoDB: Completed initialization of buffer pool
 
2020-08-05 19:32:23 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2020-08-05 19:32:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3682981
 
2020-08-05 19:32:23 0 [Note] InnoDB: Last binlog file '/db_log/mysql/mysql-bin.000006', position 840
 
2020-08-05 19:32:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2020-08-05 19:32:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
2020-08-05 19:32:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2020-08-05 19:32:24 0 [Note] InnoDB: Setting file '/db_data/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2020-08-05 19:32:24 0 [Note] InnoDB: File '/db_data/mysql/ibtmp1' size is now 12 MB.
 
2020-08-05 19:32:24 0 [Note] InnoDB: Waiting for purge to start
 
2020-08-05 19:32:24 0 [Note] InnoDB: 10.4.13 started; log sequence number 3682990; transaction id 2321
 
2020-08-05 19:32:24 0 [Note] InnoDB: Loading buffer pool(s) from /db_data/mysql/ib_buffer_pool
 
2020-08-05 19:32:24 0 [Note] Plugin 'FEEDBACK' is disabled.
 
200805 19:32:24 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED.
 
200805 19:32:24 server_audit: logging started to the file /var/log/mysql/audit.log.
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/plugin'
 
2020-08-05 19:32:24 0 [ERROR] mysqld: Plugin 'SERVER_AUDIT' already installed
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/servers'
 
2020-08-05 19:32:24 0 [Note] Server socket created on IP: '10.0.0.99'.
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/db'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/proxies_priv'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/roles_mapping'
 
2020-08-05 19:32:24 0 [Note] InnoDB: Buffer pool(s) load completed at 200805 19:32:24
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/global_priv'
 
2020-08-05 19:32:24 0 [Warning] 'proxies_priv' entry '@% root@hostname.example.com' ignored in --skip-name-resolve mode.
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/time_zone_leap_second'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/time_zone_name'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/time_zone'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/time_zone_transition_type'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/time_zone_transition'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/tables_priv'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/columns_priv'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/procs_priv'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/func'
 
2020-08-05 19:32:24 0 [Note] Zerofilling moved table:  './mysql/event'
 
2020-08-05 19:32:24 0 [Note] Reading of all Master_info entries succeeded
 
2020-08-05 19:32:24 0 [Note] Added new Master_info '' to hash table
 
2020-08-05 19:32:24 0 [Note] /opt/mysql/bin/mysqld: ready for connections.
 
Version: '10.4.13-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
 
2020-08-05 19:32:39 0 [Note] /opt/mysql/bin/mysqld (initiated by: admin_user[admin_user] @  [10.0.0.98]): Normal shutdown
 
2020-08-05 19:32:39 0 [Note] Event Scheduler: Purging the queue. 0 events
 
2020-08-05 19:32:39 0 [Note] InnoDB: FTS optimize thread exiting.
 
200805 19:32:39 server_audit: STOPPED
 
2020-08-05 19:32:39 0 [Note] InnoDB: Starting shutdown...
 
2020-08-05 19:32:39 0 [Note] InnoDB: Dumping buffer pool(s) to /db_data/mysql/ib_buffer_pool
 
2020-08-05 19:32:39 0 [Note] InnoDB: Buffer pool(s) dump completed at 200805 19:32:39
 
2020-08-05 19:32:40 0 [Note] InnoDB: Shutdown completed; log sequence number 3683008; transaction id 2322
 
2020-08-05 19:32:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
2020-08-05 19:32:40 0 [Note] /opt/mysql/bin/mysqld: Shutdown complete
 
 
 
2020-08-05 19:32:57 0 [Note] InnoDB: Using Linux native AIO
 
2020-08-05 19:32:57 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2020-08-05 19:32:57 0 [Note] InnoDB: Uses event mutexes
 
2020-08-05 19:32:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
2020-08-05 19:32:57 0 [Note] InnoDB: Number of pools: 1
 
2020-08-05 19:32:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
 
2020-08-05 19:32:57 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
 
2020-08-05 19:32:57 0 [Note] InnoDB: Completed initialization of buffer pool
 
2020-08-05 19:32:57 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2020-08-05 19:32:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2020-08-05 19:32:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2020-08-05 19:32:58 0 [Note] InnoDB: Setting file '/db_data/mysql/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2020-08-05 19:32:58 0 [Note] InnoDB: File '/db_data/mysql/ibtmp1' size is now 12 MB.
 
2020-08-05 19:32:58 0 [Note] InnoDB: Waiting for purge to start
 
2020-08-05 19:32:58 0 [Note] InnoDB: 10.4.13 started; log sequence number 3683008; transaction id 2321
 
2020-08-05 19:32:58 0 [Note] InnoDB: Loading buffer pool(s) from /db_data/mysql/ib_buffer_pool
 
2020-08-05 19:32:58 0 [Note] Plugin 'FEEDBACK' is disabled.
 
200805 19:32:58 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED.
 
200805 19:32:58 server_audit: logging started to the file /var/log/mysql/audit.log.
 
2020-08-05 19:32:58 0 [Note] InnoDB: Buffer pool(s) load completed at 200805 19:32:58

Comment by Denis Melnikov [ 2020-09-07 ]

I can upload binary DB files (some 50 GB) if you are interested.

Generated at Thu Feb 08 09:21:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.