74680 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=ABRT)

오늘 하루종일 이거만 찾았다.

경로좀 바꾸려고 서버 올라가있는걸 건드렸는데 쭉 에러떠서 식겁...

그래도 해결했다. 다음을 보자

 

나의 경우 데이터 경로를 /home/mariadb/에 두려고 옮기다가 꼬였다.

보니까 다른 디비를 prefix지정해두어서 홈계정에 또 두기는 애매한 상황.

 

그래서 똑같이 prefix경로대로 다시 정해주었다.

 # 다시 data 경로 제대로 잡아주기
 mysql_install_db --user=mysql --datadir=/local/installed/data/
 
 /*
 Installing MariaDB/MySQL system tables in '/local/installed/data/mariadb' ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is mysql@localhost, it has no password either, but
you need to be the system 'mysql' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mysqld_safe --datadir='/local/installed/data/mariadb'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mysql-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
 */

 

 

바꾼건 경로뿐이라 다른게 에러가 나긴 힘든 상황

다시 실행

# 재실행
systemctl restart mariadb

 

 

처음보는 코드 나옴 (code=dumped, signal=ABRT)

/*
 mariadb.service - MariaDB 10.6.8 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: activating (auto-restart) (Result: core-dump) since 월 2022-09-26 17:36:04 KST; 4s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 74680 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=ABRT)
  Process: 74635 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 74633 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 74680 (code=dumped, signal=ABRT)

 9월 26 17:36:04 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=dumped, status=6/ABRT
 9월 26 17:36:04 localhost.localdomain systemd[1]: Failed to start MariaDB 10.6.8 database server.
 9월 26 17:36:04 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
 9월 26 17:36:04 localhost.localdomain systemd[1]: mariadb.service failed.
*/

 

 

이후 로그를 봤는데 max용량이라던지 거의 한번 실행당 30줄은 되는 정보가 계속 뜨고,

에러코드는 안뜨는게 이상해서 (=너무 길어서 짜증나서,,ㅋㅋㅋㅋ) 확실히 하고자 다 지우고 재시작 했다.

# 지우고 다시 만들어 권한 재지정
rm mariadb_err.log
touch mariadb_err.log
chown -R mysql:mysql mariadb_err.log

 

 

그랬더니 되네!?

# 재시작
systemctl restart mariadb

/*
[root@localhost mysql]# systemctl status mariadb
● mariadb.service - MariaDB 10.6.8 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: active (running) since 월 2022-09-26 17:41:47 KST; 15s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 78736 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 78649 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 78647 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 78720 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 15
   CGroup: /system.slice/mariadb.service
           └─78720 /usr/sbin/mariadbd

 9월 26 17:41:46 localhost.localdomain systemd[1]: Stopped MariaDB 10.6.8 database server.
 9월 26 17:41:46 localhost.localdomain systemd[1]: Starting MariaDB 10.6.8 database server...
 9월 26 17:41:46 localhost.localdomain mariadbd[78720]: 2022-09-26 17:41:46 0 [Note] /usr/sbin/mariadbd (server 10.6.8-MariaDB-log) starting as process 78720 ...
 9월 26 17:41:47 localhost.localdomain systemd[1]: Started MariaDB 10.6.8 database server.
*/

 

해피앤딩 서버 올라갔다. 로그 꼬여서 에러났던 것.