Bug #41422 | Mysql fails to start | ||
---|---|---|---|
Submitted: | 12 Dec 2008 9:51 | Modified: | 18 Sep 2009 12:43 |
Reporter: | do good | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | Tests: Server | Severity: | S7 (Test Cases) |
Version: | 5.0.45 | OS: | Linux (cent os 5) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Mysql Fails to Start |
[12 Dec 2008 9:51]
do good
[12 Dec 2008 10:22]
Sveta Smirnova
Thank you for the report. But version 5.0.45 is old. Please try with current version 5.0.67 and if problem still exists indicate which user you start mysqld as.
[15 Dec 2008 6:37]
do good
changing mysql is difficult for me. Because my production has same version. for recovery purpose i am setting this. I want to know why it fails to start.
[15 Dec 2008 10:52]
Sveta Smirnova
Thank you for the feedback. Please indicate which user you start mysqld as.
[16 Dec 2008 11:51]
do good
i start mysql from root user. command is /etc/init.d/mysqld start my data directory is owned by mysql ls -l /var/lib drwxr-xr-x 2 root root 4096 Nov 13 2003 misc drwxr-x--- 2 root slocate 4096 Jan 18 2003 mlocate drwxr-xr-x 2 root root 4096 Nov 10 2007 multipath drwxr-xr-x 7 mysql mysql 4096 Dec 12 11:09 mysql drwxr-xr-x 5 root root 4096 Nov 12 2003 nfs drwxr-xr-x 2 ntp ntp 4096 Nov 10 2007 ntp drwxr-xr-x 3 root root 4096 Nov 12 2003 php ls -l /var/lib/mysql/ -rw-rw---- 1 mysql mysql 102760448 Dec 12 11:09 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Dec 12 11:09 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Dec 12 11:09 ib_logfile1 drwx------ 2 mysql mysql 16384 Jan 18 2003 lost+found -rw-rw---- 1 mysql mysql 62 Dec 12 11:09 master.info drwx------ 2 mysql mysql 4096 Dec 12 11:07 mysql drwx------ 2 mysql mysql 4096 Dec 12 11:09 openfire -rw-rw---- 1 mysql mysql 64 Dec 12 11:07 relay-log.info drwx------ 2 mysql mysql 4096 Dec 12 11:09 test
[17 Dec 2008 12:10]
Valeriy Kravchuk
Do you have SELinux enabled? Please, check.
[18 Dec 2008 5:58]
do good
I diabled SELinux
[24 Dec 2008 8:49]
Valeriy Kravchuk
If you still have the same problem, please, try to upgrade to 5.0.67 at least and inform about the results with a newer version.
[25 Jan 2009 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[20 Apr 2009 19:45]
Peter Larsen
I can confirm this issue. Without SELinux I can start mysqld_safe - with SeLinux enforced, I cannot and received the same errors. My difference is, I've setup a separate mountpoint for data /data/mysql. The ownership is set to mysql and I've changed the SELINUX context to mysqld_db_t - even added it to the fcontext policy rules. When I try to run/start mysqld I get the following messages in the /var/log/mysqld.log: 090420 15:13:51 mysqld started 090420 15:13:51 [Warning] Can't create test file /data/mysql/mambo.lower-test 090420 15:13:51 [Warning] Can't create test file /data/mysql/mambo.lower-test /usr/libexec/mysqld: Can't change dir to '/data/mysql/' (Errcode: 13) 090420 15:13:51 [ERROR] Aborting 090420 15:13:51 [Note] /usr/libexec/mysqld: Shutdown complete 090420 15:13:51 mysqld ended
[18 Aug 2009 12:43]
MySQL Verification Team
@Peter, Which server version have you tested?. Thanks in advance.
[18 Sep 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".