Comments - problem while starting mariadb server?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
thanks for Your reply
but systemctl start mysqld.service also fails to start the server.
here i am sending the complete command sequence and error messages may be it helps you to understand the problem clearly.
[root@localhost rohit]# systemctl start mysqld.service Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.
[root@localhost rohit]# systemctl status mysqld.service mysqld.service - MySQL database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled) Active: failed (Result: exit-code) since Fri 2013-06-28 15:30:04 IST; 17s ago Process: 9098 ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID (code=exited, status=1/FAILURE) Process: 9097 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS) Process: 9074 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Jun 28 15:30:01 localhost.localdomain mysqld_safe[9097]: 130628 15:30:01 mysqld_safe Logging to '/var/log/mysqld.log'. Jun 28 15:30:01 localhost.localdomain mysqld_safe[9097]: 130628 15:30:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Jun 28 15:30:04 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=exited status=1 Jun 28 15:30:04 localhost.localdomain systemd[1]: Failed to start MySQL database server. Jun 28 15:30:04 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.
[root@localhost rohit]# journalctl -xn -- Logs begin at Fri 2013-06-21 16:48:05 IST, end at Fri 2013-06-28 15:30:04 IST. -- Jun 28 15:27:35 localhost.localdomain setroubleshoot[9059]: received signal=14 Jun 28 15:27:35 localhost.localdomain setroubleshoot[9059]: KeyboardInterrupt in RunFaultServer Jun 28 15:27:35 localhost.localdomain setroubleshoot[9059]: writing database (/var/lib/setroubleshoot/setroubleshoot_database.xml) modified_count=0 Jun 28 15:30:00 localhost.localdomain systemd[1]: Starting MySQL database server... -- Subject: Unit mysqld.service has begun with start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has begun starting up. Jun 28 15:30:01 localhost.localdomain mysqld_safe[9097]: 130628 15:30:01 mysqld_safe Logging to '/var/log/mysqld.log'. Jun 28 15:30:01 localhost.localdomain mysqld_safe[9097]: 130628 15:30:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Jun 28 15:30:03 localhost.localdomain mysqld_safe[9097]: 130628 15:30:03 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Jun 28 15:30:04 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=exited status=1 Jun 28 15:30:04 localhost.localdomain systemd[1]: Failed to start MySQL database server. -- Subject: Unit mysqld.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/be02cf6855d2428ba40df7e9d022f03d -- -- Unit mysqld.service has failed. -- -- The result is failed. Jun 28 15:30:04 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.
please reply soon thanks.
Can you attach messages from /var/log/mysqld.log related to the last attempt to start the service? I'm suspecting some issues with my.cnf file -- can you provide that as well?