Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.14
-
None
-
Debian GNU/Linux 8.4 (jessie)
Kernel : 3.14.32-xxxx-grs-ipv6-64
Ram: 126Go
Disk: Raid 5
Description
Hello,
I've just encountered an issue with my setup and don't understand what happen...
I've made a fresh install some days ago, tweak some settings, restart mariadb, and started to import thousands of tables through ssh because I had a problem with xtrabackup.
My import process finished, i decided to shutdown mariadb to change the bind-adress et try to restart it ..... CRASH
My first doubt was when i was watching the log and seen it hang on the message :"Highest supported file format is Barracuda."
After 5min, the process has continued but starts a shutdown just after the message : "/usr/sbin/mysqld: ready for connections."
I've tried to restart it multiple times with the same result.....
See bellow the log:
2016-05-23 18:31:14 131118867564480 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: The InnoDB memory heap is disabled
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: Memory barrier is not used
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: Using Linux native AIO
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: Using SSE crc32 instructions
|
2016-05-23 18:31:14 131118867564480 [Note] InnoDB: Initializing buffer pool, size = 80.0G
|
2016-05-23 18:31:18 131118867564480 [Note] InnoDB: Completed initialization of buffer pool
|
2016-05-23 18:31:18 131118867564480 [Note] InnoDB: Highest supported file format is Barracuda.
|
2016-05-23 18:37:03 131118867564480 [Note] InnoDB: 128 rollback segment(s) are active.
|
2016-05-23 18:37:03 131118867564480 [Note] InnoDB: Waiting for purge to start
|
2016-05-23 18:37:03 131118867564480 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 5149822398415
|
2016-05-23 18:37:03 131024369362688 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
2016-05-23 18:37:03 131118867564480 [Note] Plugin 'FEEDBACK' is disabled.
|
2016-05-23 18:37:04 131118867564480 [Note] Server socket created on IP: '127.0.0.1'.
|
2016-05-23 18:37:04 131118865778432 [Note] /usr/sbin/mysqld: Normal shutdown
|
|
2016-05-23 18:37:04 131118867564480 [Note] /usr/sbin/mysqld: ready for connections.
|
Version: '10.1.14-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
|
2016-05-23 18:37:04 131118865778432 [Note] Event Scheduler: Purging the queue. 0 events
|
2016-05-23 18:37:04 131024351069952 [Note] InnoDB: FTS optimize thread exiting.
|
2016-05-23 18:37:04 131118865778432 [Note] InnoDB: Starting shutdown...
|
2016-05-23 18:37:10 131118865778432 [Note] InnoDB: Shutdown completed; log sequence number 5149822398425
|
2016-05-23 18:37:10 131118865778432 [Note] /usr/sbin/mysqld: Shutdown complete
|
And this is my.cnf:
sudo egrep -v "^#" /etc/mysql/my.cnf
|
|
[client]
|
port = 3306
|
socket = /var/run/mysqld/mysqld.sock
|
|
|
[mysqld_safe]
|
socket = /var/run/mysqld/mysqld.sock
|
nice = 0
|
|
[mysqld]
|
user = mysql
|
pid-file = /var/run/mysqld/mysqld.pid
|
socket = /var/run/mysqld/mysqld.sock
|
port = 3306
|
basedir = /usr
|
datadir = /var/lib/mysql
|
tmpdir = /tmp
|
datadir = /home/mysql/db
|
tmpdir = /home/mysql/tmp
|
lc-messages-dir = /usr/share/mysql
|
skip-external-locking
|
bind-address = 127.0.0.1
|
key_buffer = 16M
|
max_allowed_packet = 16M
|
thread_stack = 192K
|
thread_cache_size = 128
|
bulk_insert_buffer_size = 16M
|
tmp_table_size = 32M
|
max_heap_table_size = 32M
|
|
myisam-recover = BACKUP
|
max_connections = 200
|
connect_timeout = 5
|
wait_timeout = 600
|
query_cache_limit = 1M
|
query_cache_size = 64M
|
log_error = /var/log/mysql/error.log
|
server-id = 1
|
log_bin = /home/mysql/log/mysql-bin.log
|
expire_logs_days = 5
|
max_binlog_size = 100M
|
default_storage_engine = InnoDB
|
innodb_log_file_size = 1G
|
innodb_log_files_in_group = 8
|
innodb_buffer_pool_size = 80G
|
innodb_log_buffer_size = 16M
|
innodb_file_per_table = 1
|
innodb_open_files = 400
|
innodb_io_capacity = 400
|
innodb_flush_method = O_DIRECT
|
|
innodb_thread_concurrency = 32
|
innodb_log_group_home_dir = /home/mysql/redo
|
innodb_file_format = Barracuda
|
|
|
|
|
[mysqldump]
|
quick
|
quote-names
|
max_allowed_packet = 16M
|
|
[mysql]
|
|
[isamchk]
|
key_buffer = 16M
|
|
!includedir /etc/mysql/conf.d/
|
I hope you will have good news for me because I've spent many hours for this migration :-/
Best regards,
Attachments
Issue Links
- is blocked by
-
MDEV-9931 InnoDB reads first page of every .ibd file at startup
- Closed