맛집 여행 캠핑 일상 생활

[CentOS] 8.x MariaDB 10.3 시작 에러 본문

IT이야기

[CentOS] 8.x MariaDB 10.3 시작 에러

♥ 영은파더♥ 2020. 7. 13. 10:13

CentOS 8 버전에서 mariadb 를 설치하고 my.cnf 환경 설정을 한 다음에 db를 시작했더니 아래와 같은 에러가 나네요~

설치는 # yum install mariadb* 이렇게 했습니다.

원인은 log_slow_queries = On 옵션 때문이더군요~

[root@localhost ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Mon 2020-07-13 09:28:57 KST; 40s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 8189 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=1/FAILURE)
  Process: 8164 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)

Jul 13 09:28:57 localhost.localdomain mysql-prepare-db-dir[8189]: the maria-discuss email list at https://launchpad.net/~maria-discuss
Jul 13 09:28:57 localhost.localdomain mysql-prepare-db-dir[8189]: Please check all of the above before submitting a bug report
Jul 13 09:28:57 localhost.localdomain mysql-prepare-db-dir[8189]: at http://mariadb.org/jira
Jul 13 09:28:57 localhost.localdomain mysql-prepare-db-dir[8189]: Initialization of MariaDB database failed.
Jul 13 09:28:57 localhost.localdomain mysql-prepare-db-dir[8189]: Perhaps /etc/my.cnf is misconfigured or there is some problem with permissions of /var/lib/mysql.
Jul 13 09:28:57 localhost.localdomain mysql-prepare-db-dir[8189]: Initialization of MariaDB database was not finished successfully.
Jul 13 09:28:57 localhost.localdomain mysql-prepare-db-dir[8189]: Files created so far will be removed.
Jul 13 09:28:57 localhost.localdomain systemd[1]: mariadb.service: Control process exited, code=exited status=1
Jul 13 09:28:57 localhost.localdomain systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jul 13 09:28:57 localhost.localdomain systemd[1]: Failed to start MariaDB 10.3 database server.

/etc/my.cnf 에 잘못된 설정이 있다는 내용같습니다.

작성한 /etc/my.cnf.d/my.cnf 파일에서 옵션을 하나씩 막고 테스트 해봤습니다.

[mysqld]
server-id=1
log-bin=mysql-bin
expire_logs_days=7
init_connect='set names utf8'
character-set-server=utf8
max_connections=1000
#log_slow_queries = On
long_query_time = 5
join_buffer_size = 16MB
key_buffer_size = 8MB
read_rnd_buffer_size = 32MB
sort_buffer_size = 32MB
query_cache_limit = 256KB
query_cache_min_res_unit = 4096
query_cache_size = 16MB
thread_cache_size = 8
table_open_cache = 16384
max_heap_table_size = 256MB
tmp_table_size = 256MB

MariaDB 10.3 버전에서는 log_slow_queries 옵션을 사용할 수가 없나봅니다~

 

Trackback : 0 | Comments : 0
댓글쓰기 폼