centos 7에 rpm으로 mariadb를 설치했습니다.
그리고 systemctl start mariadb.service 명령어를 실행하면
Job for mariadb.service failed because the control process exited with error. See "systemctl status mariadb.service" and "journalctl -xe" for details
라는 에러 문구가 나옵니다..
systemctl status mariadb.service 명령어를 치면
* mariadb.service - MariaDB 10.3.14 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
`-migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since 월 2019-05-20 21:47:21 KST; 2min 13s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 18398 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 18375 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 18372 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 18398 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] InnoDB: 10.3.14 started; log sequence number 1616754; transaction id 2311
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] Plugin 'FEEDBACK' is disabled.
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] InnoDB: Buffer pool(s) load completed at 190520 21:47:19
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [ERROR] Aria engine is not enabled or did not start. The Aria engine ...p-tables
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [ERROR] Aborting
5월 20 21:47:21 wiki systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
5월 20 21:47:21 wiki systemd[1]: Failed to start MariaDB 10.3.14 database server.
5월 20 21:47:21 wiki systemd[1]: Unit mariadb.service entered failed state.
5월 20 21:47:21 wiki systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
위와 같은 에러가 계속 발생합니다..
구글에서 가장 많이 나오는 로그파일 지우는 방법 해보았지만 증상도 계속 그대로이고..
원인이 무엇일까요?
내부망에다가 설치하는 것이라 인터넷연결이 불가능해 rpm으로 설치해야 되는 입장입니다.
그리고 systemctl start mariadb.service 명령어를 실행하면
Job for mariadb.service failed because the control process exited with error. See "systemctl status mariadb.service" and "journalctl -xe" for details
라는 에러 문구가 나옵니다..
systemctl status mariadb.service 명령어를 치면
* mariadb.service - MariaDB 10.3.14 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
`-migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since 월 2019-05-20 21:47:21 KST; 2min 13s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 18398 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 18375 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 18372 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 18398 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] InnoDB: 10.3.14 started; log sequence number 1616754; transaction id 2311
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] Plugin 'FEEDBACK' is disabled.
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [Note] InnoDB: Buffer pool(s) load completed at 190520 21:47:19
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [ERROR] Aria engine is not enabled or did not start. The Aria engine ...p-tables
5월 20 21:47:19 wiki mysqld[18398]: 2019-05-20 21:47:19 0 [ERROR] Aborting
5월 20 21:47:21 wiki systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
5월 20 21:47:21 wiki systemd[1]: Failed to start MariaDB 10.3.14 database server.
5월 20 21:47:21 wiki systemd[1]: Unit mariadb.service entered failed state.
5월 20 21:47:21 wiki systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
위와 같은 에러가 계속 발생합니다..
구글에서 가장 많이 나오는 로그파일 지우는 방법 해보았지만 증상도 계속 그대로이고..
원인이 무엇일까요?
내부망에다가 설치하는 것이라 인터넷연결이 불가능해 rpm으로 설치해야 되는 입장입니다.
2개의 답변이 있습니다.
[root@localhost bin]#systemctl restart mariadb
Job for mariadb.service failed. See ‘systemctl status mariadb.service‘ and ‘journalctl -xn’ for details.
여기서 중요한 건 systemctl status mariadb.service 이 메세지 이다.
아래와 같이 위에 명령어를 입력 하면 아래처럼 현재 mariadb상태가 나온다.
[root@localhost bin]# systemctl status mariadb.service
mariadb.service – MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Active: failed (Result: exit-code) since 화 2015-04-14 09:20:51 KST; 12s ago
Process: 13078 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
Process: 13077 ExecStart=/usr/bin/mysqld_safe –basedir=/usr (code=exited, status=0/SUCCESS)
Process: 13050 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 13077 (code=exited, status=0/SUCCESS)
4월 14 09:20:50 localhost.localdomain systemd[1]: Starting MariaDB database server…
4월 14 09:20:50 localhost.localdomain mysqld_safe[13077]: 150414 09:20:50 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log’.
4월 14 09:20:50 localhost.localdomain mysqld_safe[13077]: 150414 09:20:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
4월 14 09:20:51 localhost.localdomain mysqld_safe[13077]: 150414 09:20:51 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
4월 14 09:20:51 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
4월 14 09:20:51 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
4월 14 09:20:51 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
[해결 방법]
mysql data 디렉토리에 가보면 아래의 파일 3개가 있다.
-rw-rw—- 1 mysql mysql 5242880 4월 14 09:22 ib_logfile0
-rw-rw—- 1 mysql mysql 5242880 4월 14 09:22 ib_logfile1
-rw-rw—- 1 mysql mysql 18874368 4월 14 09:22 ibdata1
이 3개의 파일을 삭제 한다.
그리고 systemctl start mariadb.service 입력하면 정상적으로 실행이 된 것을 확인 할 수 있다.
gIoop | 5년 이하 전
https://suwoni-codelab.com/linux/2018/08/16/linux-mariadb-changedir/