Details
Major
Description
I think MariaDB server should start shutdown after startup finished, or start startup after shutdown finished.
Why MariaDB server print start log and shutdown log as same time?
150606 10:44:46 [Note] /home/mariadb/bin/mysqld: Normal shutdown --shudownlog 150606 10:44:50 [Note] /home/mariadb/bin/mysqld: ready for connections. --startuplog Version: '10.0.12-MariaDB-log' socket: '/home/mariadb/bin/mysql1.sock' port: 5518 Source distribution --startuplog 150606 10:44:50 [Note] Event Scheduler: Purging the queue. 0 events --shudownlog 150606 10:44:50 [Note] Slave I/O thread: Start semi-sync replication to master 'repl@192.168.1.113:5518' in log 'mysql-bin.000160' at position 2140880879 --startuplog 150606 10:44:50 [Note] Slave I/O thread killed while connecting to master --shudownlog 150606 10:44:50 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000160', position 2140880879; GTID position 0-1895939662-1128069 --shudownlog 150606 10:44:50 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000160' at position 2140880879, relay log '../relaylog/relay-bin.000001' position: 4; GTID position '0-1895939662-1128069' --startuplog 150606 10:44:50 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000160' at position 2140880879; GTID position '0-1895939662-1128069' --shudownlog
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
It happens just one time.
start command:mysqld_multi --defaults-file=/home/mariadb/etc/my.cnf --log=/home/mariadb/log/mysqld_multi.log --mysqld=/home/mariadb/bin/mysqld start 1
stop command:kill pid
I installed MariaDB by compile the source code:
cmake .. \
-DCMAKE_INSTALL_PREFIX=$build_target_dir \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_bin \
-DWITH_EXTRA_CHARSETS:STRING=all \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_NDBCLUSTER_STORAGE_ENGINE=0 \
-DENABLED_LOCAL_INFILE=1
My cnf file :
[mysqld] table_open_cache = 2048 max_allowed_packet = 16M sort_buffer_size = 512K read_buffer_size = 256K read_rnd_buffer_size = 512K max_connect_errors = 100000 skip-external-locking sql_mode = STRICT_TRANS_TABLES sync_binlog=1 expire_logs_days=7 key_buffer_size = 16M myisam_sort_buffer_size = 8M innodb_data_file_path = ibdata1:500M:autoextend innodb-file-per-table innodb_buffer_pool_size = 600M innodb_flush_log_at_trx_commit = 1 innodb_io_capacity = 200 innodb_io_capacity_max = 2000 innodb_lock_wait_timeout = 50 innodb_log_buffer_size = 8M innodb_log_files_in_group = 2 innodb_log_file_size = 100M innodb_read_io_threads = 8 innodb_write_io_threads = 8 max_binlog_size = 10485760 binlog_format=ROW log-slave-updates=1 binlog_annotate_row_events=ON replicate_annotate_row_events=ON replicate_events_marked_for_skip=FILTER_ON_MASTER slave-skip-errors=1007,1008,1050,1060,1061,1062,1068 rpl_semi_sync_master_enabled = ON rpl_semi_sync_slave_enabled = ON [mysqld1] port = 5518 socket = /home/mariadb/bin/mysql1.sock bind_address = 127.0.0.1 datadir = /home/mariadb/data/data log-error=/home/mariadb/log/mysqld1.log pid-file=/home/mariadb/bin/mysqld1.pid innodb_data_home_dir = /home/mariadb/data/data innodb_log_group_home_dir = /home/mariadb/data/redo server-id = 1 log-bin=../binlog/mysql-bin relay-log=../relaylog/relay-bin tmpdir=/home/mariadb/data/tmp [client] port = 5518 socket = /home/mariadb/bin/mysql1.sock [mysql] no-auto-rehash
What did you do first, kill or mysqld_multi ?
How much time was there between the commands?
Did you kill only one process by the kill command?
Hi,
Does it always happen, or was it a one-time thing?
What were you doing when it happened? If you restarted/started/stopped the server, please provide the exact command line you used.
Please also attach your cnf file(s) and output of rpm -qa | grep -Ei 'mysql|maria'.
Thanks.