Error starting Mariadb in Centos7

Asked

Viewed 325 times

0

Good morning. I have a dedicated server running Centos7 and Mariadb stopped and I can’t restart the service.

[root@new ~]# mysqld start
2018-01-17 13:31:10 140236707752192 [Note] mysqld (mysqld 10.1.22-MariaDB) 
starting as process 19665 ...
mysqld: Please consult the Knowledge Base to find out how to run mysqld as root!
2018-01-17 13:31:10 140236707752192 [ERROR] Aborting

When I check the status the return is this:

mariadb.service - MariaDB 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 Wed 2018-01-17 13:12:01 UTC; 24min ago
Process: 10903 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 10891 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: 10888 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 10903 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Jan 17 13:12:01 new.webgocontent.com.br mysqld[10903]: 2018-01-17 13:12:01 
139872544868608 [Note] InnoDB: Unable to open the first data file
Jan 17 13:12:01 new.webgocontent.com.br mysqld[10903]: 2018-01-17 13:12:01 
7f369d59c900  InnoDB: Operating system error number 11 in a file operation.
Jan 17 13:12:01 new.webgocontent.com.br mysqld[10903]: InnoDB: Error number 
11 means 'Resource temporarily unavailable'.
Jan 17 13:12:01 new.webgocontent.com.br mysqld[10903]: InnoDB: Some operating system error numbers are described at
Jan 17 13:12:01 new.webgocontent.com.br mysqld[10903]: InnoDB: 
http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
Jan 17 13:12:01 new.webgocontent.com.br mysqld[10903]: 2018-01-17 13:12:01 
139872544868608 [ERROR] InnoDB: Can't open './ibdata1'
Jan 17 13:12:01 new.webgocontent.com.br systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 17 13:12:01 new.webgocontent.com.br systemd[1]: Failed to start MariaDB database server.
Jan 17 13:12:01 new.webgocontent.com.br systemd[1]: Unit mariadb.service entered failed state.
Jan 17 13:12:01 new.webgocontent.com.br systemd[1]: mariadb.service failed.

When I use mysqld --user=root the services work, but I can’t leave it. I need the service to run again. Someone’s had this problem before?

Thank you!

  • https://mariadb.com/kb/en/library/starting-and-stopping-mariadb-automatically/

  • I did what this link asked, but none of it solved

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.