안녕하세요.
요 근래 리눅스로 서버 구축하면서 이레저레 ㅠ,ㅠ 질문이 많내요.
어제 mariadb를 설치하였고, 금일 오후에 잠깐 mysql로 데이터베이스 하나 만들기만 다른 작업은 안 한 상태입니다.
방금 phpmyadmin으로 db생성이 잘 되었나 확인하려고 보니
에러 발생.. 혹시나 하고 서버 접속해서 확인하여 보니 데몬실행이 제대로 안되엇내요.
service mariadb restart 하였지만 재시작이 안됩니다.
로그파일은 아래와 같습니다. 왜이러는 걸까요 흑 고난의 연속이군요..
systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: activating (auto-restart) (Result: signal) since Mon 2017-12-25 20:21:39 KST; 652ms ago
Process: 6562 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=SEGV)
Process: 6389 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR
Process: 6385 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 6383 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 6562 (code=killed, signal=SEGV)
Dec 25 20:21:39 volonas systemd[1]: mariadb.service: Unit entered failed state.
Dec 25 20:21:39 volonas systemd[1]: mariadb.service: Failed with result 'signal'.
service mariadb restart
Job for mariadb.service failed because a fatal signal was delivered to the control process.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@volonas:~# journalctl -xe
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has finished shutting down.
Dec 25 20:08:51 volonas systemd[1]: Starting MariaDB database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has begun starting up.
Dec 25 20:08:52 volonas kernel: mysqld[15137]: segfault at 8 ip 00007f4fc62c4a63 sp 00007fffb608e750 error 4 in ld-2.24.so[7f4fc62b4000+23000]
Dec 25 20:08:52 volonas systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Dec 25 20:08:52 volonas systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Dec 25 20:08:52 volonas systemd[1]: mariadb.service: Unit entered failed state.
Dec 25 20:08:52 volonas systemd[1]: mariadb.service: Failed with result 'signal'.
Dec 25 20:08:57 volonas systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Dec 25 20:08:57 volonas systemd[1]: Stopped MariaDB database server.
-- Subject: Unit mariadb.service has finished shutting down
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has finished shutting down.
Dec 25 20:08:57 volonas systemd[1]: Starting MariaDB database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has begun starting up.
Dec 25 20:08:58 volonas kernel: mysqld[15313]: segfault at 8 ip 00007fb81e98fa63 sp 00007ffcd18cd040 error 4 in ld-2.24.so[7fb81e97f000+23000]
Dec 25 20:08:58 volonas systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Dec 25 20:08:58 volonas systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Dec 25 20:08:58 volonas systemd[1]: mariadb.service: Unit entered failed state.
Dec 25 20:08:58 volonas systemd[1]: mariadb.service: Failed with result 'signal'.
syslog 캸 ֽϴ Ф; rsylogd ġѰ /var/logʿ ʳ.
syslog α
c 25 21:42:22 volonas systemd[1]: Stopped MariaDB database server.
Dec 25 21:42:22 volonas systemd[1]: Starting MariaDB database server...
Dec 25 21:42:22 volonas systemd[1]: Stopped MariaDB database server.
Dec 25 21:42:22 volonas systemd[1]: Starting MariaDB database server...
Dec 25 21:42:23 volonas kernel: [ 6069.095952] mysqld[26977]: segfault at 8 ip 00007f07077bfa63 sp 00007ffee79ca590 error 4 in ld-2.24.so[7f07077af000+23000]
Dec 25 21:42:23 volonas systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Dec 25 21:42:23 volonas systemd[1]: Failed to start MariaDB database server.
Dec 25 21:42:23 volonas systemd[1]: mariadb.service: Unit entered failed state.
Dec 25 21:42:23 volonas systemd[1]: mariadb.service: Failed with result 'signal'.
Dec 25 21:42:28 volonas systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Dec 25 21:42:28 volonas systemd[1]: Stopped MariaDB database server.
Dec 25 21:42:28 volonas systemd[1]: Starting MariaDB database server...
Dec 25 21:42:29 volonas kernel: [ 6074.811753] mysqld[27153]: segfault at 8 ip 00007eff27a4fa63 sp 00007fffe9499e80 error 4 in ld-2.24.so[7eff27a3f000+23000]
Dec 25 21:42:29 volonas systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Dec 25 21:42:29 volonas systemd[1]: Failed to start MariaDB database server.
Dec 25 21:42:29 volonas systemd[1]: mariadb.service: Unit entered failed state.
Dec 25 21:42:29 volonas systemd[1]: mariadb.service: Failed with result 'signal'.
Dec 25 21:42:34 volonas systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Dec 25 21:42:34 volonas systemd[1]: Stopped MariaDB database server.
Dec 25 21:42:34 volonas systemd[1]: Starting MariaDB database server...
Dec 25 21:42:34 volonas kernel: [ 6080.544117] mysqld[27334]: segfault at 8 ip 00007f8d43db5a63 sp 00007fff2ac5bad0 error 4 in ld-2.24.so[7f8d43da5000+23000]
Dec 25 21:42:34 volonas systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Dec 25 21:42:34 volonas systemd[1]: Failed to start MariaDB database server.
Dec 25 21:42:34 volonas systemd[1]: mariadb.service: Unit entered failed state.
Dec 25 21:42:34 volonas systemd[1]: mariadb.service: Failed with result 'signal'.
õغ غôµ.. ȵǸ 缳ġ غ° ְڳ Ф
缳ġϷ հ Ѱ ƴϾ ФФФФ
apt autoremove ȸԳ... mariadb 缳ġϷٰ 缳ġϰ 峻 Ф
Sub-process /usr/bin/apt-listchanges --apt || test $? -lt 10 returned an error code (1)
ϰ 缳ġϰ ϴµ մ ƹ͵ ߴµ ý apci error ߰ ̷ ߹ݱ ϰ
ᱹ ....
2 缳ġ ۸ؼ grub ʿ apci=off ɼΰ ־.. ϴ.
Ҿؼ ġѰǵ ȿ . Ѹ... ٴ ̱ մϴ..
mariadb ƾ߰ڽϴ. ̴ ֺ ۸ص δ ذ ȵǴ... ص
systemctl mariadb.service ְ ϰ disable ص 缳ġϸ root йȣ ȵǰ ФФФФ
9.3 ũġ SSH + ⺻Ű 2 ġؼ Դϴ. ҽ Ȩ ȳϴµ ġϿϴ.
Ҵ kaist ߰.
nginx stable 1.12.2 / mariadb10.2 stable / php apt-geget ġ 7.0.1 Դϴ.
ϴ ÷... ڰ;߁ٳ.. ׳ Ἥ ȸ翡 ߽ϴ ;