[MDEV-8312] MariaDB server print start log and shutdown log as same time Created: 2015-06-12  Updated: 2015-07-14  Resolved: 2015-07-14

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.0.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Zhoukai Lin Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

redhat 6.5


 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
 
 



 Comments   
Comment by Elena Stepanova [ 2015-06-13 ]

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.

Comment by Zhoukai Lin [ 2015-06-15 ]

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

Comment by Elena Stepanova [ 2015-06-16 ]

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?

Generated at Thu Feb 08 07:26:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.