Bug 22989
Summary: | Can't start mysqld | ||
---|---|---|---|
Product: | [Retired] Red Hat Linux | Reporter: | Need Real Name <jhan> |
Component: | mysql | Assignee: | Patrick Macdonald <patrickm> |
Status: | CLOSED RAWHIDE | QA Contact: | David Lawrence <dkl> |
Severity: | high | Docs Contact: | |
Priority: | high | ||
Version: | 7.0 | CC: | jhan |
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | i686 | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2001-01-05 06:08:54 UTC | Type: | --- |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Need Real Name
2000-12-29 18:47:17 UTC
See Service Request 165972 for more information The way to start mysql is by running "service mysql start" (or /etc/rc.d/init.d/mysqld start directly). As the error message says, you could already have a mysqld process running (and the first one was resolved by an errata on the day of release) I'm sure mysqld is not running. [root@jhan-home-dell /root]# mysql -version ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@jhan-home-dell /root]# ps -ax | grep mysql 1190 pts/0 S 0:00 grep mysql And if you try starting it with "service mysqld start"? I tried "service mysqld start", the result is same as "safe_mysqld". The main process is started and running. But it seems to spawn child process and the child process dies immediately. And the main process keeps spawn child process. I can tell that by ps: [root@jhan-home-dell /root]# service mysqld start Starting MySQL: [OK] [root@jhan-home-dell /root]# ps -ax | grep mysqld 9321 pts/0 S 0:00 sh /usr/bin/safe_mysqld --user=mysql --log=/var/log 11466 pts/0 R 0:00 sh /usr/bin/safe_mysqld --user=mysql --log=/var/log [root@jhan-home-dell /root]# ps -ax | grep mysqld 9321 pts/0 S 0:00 sh /usr/bin/safe_mysqld --user=mysql --log=/var/lib 11738 pts/0 S 0:00 sh /usr/bin/safe_mysqld --user=mysql --log=/var/lib 11739 pts/0 R 0:00 sh /usr/bin/safe_mysqld --user=mysql --log=/var/lib 11740 pts/0 R 0:00 date +%y%m%d %H:%M:%S mysqld restarted And each child process logs an error message in /var/lib/mysql/jhan-home-dell.err before die. The log file getting big quickly. This program was checked before releasing, without this occuring. What is the permissions on /var/lib/mysql? Have you specified something in a configuration file? Do you have all errata installed? OK, I figure out what's wrong. I have to chmod /var/lib/mysql and /var/lib/mysql/mysql from 700 to 760. This solves the problem. This directory should have received the proper permissions after updateing - and have always done so in our internal testing. However, to be absolutely sure I've now added an explicit chmod command to the post install script in 3.23.30-1. |