mariadb ȵǴ ߻

   
   ȸ 13632   õ 0    

 안녕하세요.

요 근래 리눅스로 서버 구축하면서 이레저레 ㅠ,ㅠ 질문이 많내요.

어제 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'.

ª ϼ ϰ.
ƹ̳ 2017-12
ñ׳ 11 segmentation faultΰɷ rsyslogd α׿  α׿ ٸα׵ Ȯغ Ͱ׿
     
2017-12
α׵ ġ ˻ϰִµ var/log/mysql/ α״ ôµ ڰ Ͱ
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'.
henol 2017-12
ڼ 𸣰, mysqld stopߴٰ غ .
     
2017-12
޼ ߻մϴ.
õغ غôµ.. ȵǸ 缳ġ غ° ְڳ Ф
2017-12
-.,- 缳ġѴٰ ٰ
缳ġϷ հ Ѱ ƴϾ ФФФФ
apt autoremove ȸԳ... mariadb 缳ġϷٰ 缳ġϰ 峻 Ф

Sub-process /usr/bin/apt-listchanges --apt || test $? -lt 10 returned an error code (1)
     
ƹ̳ 2017-12
ϰ ҽƮ ϼ̳
          
2017-12
ΰ ϰ 缳ġ Ͽϴ ФФФ ܿ ٽ ϴ... ѹ 缳ġϸ 뵿̳ Ф
ϰ 缳ġϰ ϴµ մ ƹ͵ ߴµ ý 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 Դϴ.

ϴ ÷... ڰ;߁ٳ.. ׳ ޲ Ἥ ȸ翡 ߽ϴ ;


QnA
Page 1749/5693
2014-05   5021184   1
2015-12   1556520   ް
2014-02   9709   ̷
2016-07   3767   Դϴ
2018-10   4560   ٿƺ
2022-11   1758   ûx
2021-03   5941  
2018-10   3495   9
2016-07   16351   Ѽ
2018-10   3731   JK
2016-07   14012   Ѹ
2019-12   4067  
2015-06   3890   ؼ
2011-12   5795   UniDev
2014-03   4410   Ȳ
2021-03   2680   FloppyDiskette
2011-12   11379  
2021-03   1846  
2022-12   2041   ȸ
2015-07   3847   g
2017-08   3271   Ǽӻ
2022-12   1796