[mariadb galera] mysql.service start operation timed out. Terminating

 

 

mysql.service start operation timed out. Terminating

 

 

galera로 클러스터링해놓은 상태로 동기화 시키는데

자꾸 타임아웃관련 메시지를 뿌리며 실행이 되지 않는다

vi /var/log/messages를 확인해보니

 

 

Aug 18 16:20:48 mg-node02 mysql: Starting MariaDB.200818 16:20:48 mysqld_safe Logging to '/home/data/mysql/error.log'.Aug 18 16:20:48 mg-node02 mysql: 200818 16:20:48 mysqld_safe Starting mysqld daemon with databases from /home/data/mysqlAug 18 16:20:53 mg-node02 rsyncd[4671]: rsyncd version 3.0.9 starting, listening on port 4444Aug 18 16:20:53 mg-node02 rsyncd[4691]: connect from mg-node01 (192.168.0.20)Aug 18 16:20:53 mg-node02 rsyncd[4691]: rsync to rsync_sst/ from mg-node01 (192.168.0.20)Aug 18 16:20:54 mg-node02 rsyncd[4691]: receiving file listAug 18 16:20:54 mg-node02 rsyncd[4693]: connect from mg-node01 (192.168.0.20)Aug 18 16:20:54 mg-node02 rsyncd[4691]: sent 44 bytes  received 340 bytes  total size 0Aug 18 16:20:54 mg-node02 rsyncd[4693]: rsync to rsync_sst-data_dir/ from mg-node01 (192.168.0.20)
Aug 18 16:21:01 mg-node02 rsyncd[4749]: connect from mg-node01 (192.168.0.20)Aug 18 16:21:01 mg-node02 rsyncd[4693]: sent 54 bytes  received 79701681 bytes  total size 79691776Aug 18 16:21:01 mg-node02 rsyncd[4749]: rsync to rsync_sst-log_dir/ from mg-node01 (192.168.0.20)
Aug 18 16:21:01 mg-node02 rsyncd[4749]: receiving file list
Aug 18 16:21:47 mg-node02 rsyncd[5084]: receiving file list
Aug 18 16:21:47 mg-node02 rsyncd[5083]: receiving file listAug 18 16:21:47 mg-node02 rsyncd[5085]: receiving file list
Aug 18 16:21:47 mg-node02 rsyncd[5087]: receiving file listAug 18 16:21:47 mg-node02 rsyncd[5086]: receiving file list
Aug 18 16:21:47 mg-node02 rsyncd[5084]: sent 54 bytes  received 207 bytes  total size 61Aug 18 16:21:55 mg-node02 rsyncd[5083]: sent 1726 bytes  received 10674944 bytes  total size 10667907
Aug 18 16:22:43 mg-node02 rsyncd[5085]: sent 11948 bytes  received 227237443 bytes  total size 227175293
Aug 18 16:25:48 mg-node02 systemd: mysql.service start operation timed out. Terminating.
Aug 18 16:25:48 mg-node02 systemd: Failed to start LSB: start and stop MariaDB.
Aug 18 16:25:48 mg-node02 systemd: Unit mysql.service entered failed state.
Aug 18 16:25:48 mg-node02 systemd: mysql.service failed.Aug 18 16:25:49 mg-node02 mysql: .......................................................................................................................................................................................................................................................................................................Aug 18 16:27:19 mg-node02 rsyncd[5086]: sent 10200 bytes  received 1781159876 bytes  total size 1780911581Aug 18 16:30:01 mg-node02 systemd: Started Session 47529 of user root.
Aug 18 16:30:01 mg-node02 systemd: Starting Session 47529 of user root.

 

 

데이터의 크기가 커서 복제하는 과정에서 타임아웃이 발생하는 듯 하다.

 

해결방법은

vi /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf

에 아래 옵션을 추가하자

# converted using /usr/bin/mariadb-service-convert
#

[Service]
ProtectHome=false
TimeoutStartSec=0

추가 후 mariadb를 재 실행 해보니 정상 동작한다.