Bug 17899
| Summary: | mysql daemon is not starting | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Linux | Reporter: | Adrian Reber <adrian> |
| Component: | mysql | Assignee: | Patrick Macdonald <patrickm> |
| Status: | CLOSED RAWHIDE | QA Contact: | David Lawrence <dkl> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 7.0 | CC: | awl, mog |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | i386 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2000-10-30 03:34:01 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
Adrian Reber
2000-09-26 23:00:55 UTC
There is a known bug in mysql as shipped with 7.0 - this was released as an errata today. Tried that? (3.23.24-1) I installed the errata but the error still exists. i had to do the same changes to /usr/bin/safe_mysqld, as i have done to the original mysql version shipping with 7.0 It works fine here, and has been tested with PHP etc. by QA.... how do you start it? /etc/rc.d/init.d/mysqld start But the problem could be anywhere else, because the update to 7.0 was done by hand. Maybe I forgot to update a tool which is used in the startup script. The database is running. I just had to change to startup script. OK, I'll close it as a configuration issue... this works on the computers I've tested. This is not a configuration error, i got this too. This is a bug in the safe_mysqld script, check it out yourself. nice expects a value between 19 and -20, bug safe_mysqld prepends a - to the nice value. So if $NOHUP_NICENESS is -5 it tries to set nice to --5 which confuses nice. I use mysql-server 3.23.24-1, directly installed from the redhat update agent, no previous versions installed, i didn't have the energy to look for the RedHat CD's. :) OK, I can see there's a problem if you have negative niceness. Removing one of the dashes just makes "-5" act like "5". Negative niceness is rarely used, and only by root specifying it.... how did you get that value? for some reason, it happens like this, have no idea why.. there is no nice stuff in /etc/rc.d/init.d/* or /usr/bin/safe_mysqld i grepped both directories/files for both 'nice' and '-5' [root@localhost /root]# nice 0 [root@localhost /root]# test=`nohup nice` [root@localhost /root]# echo $test -5 On my machine: [root@hoser /root]# test=`nohup nice` [root@hoser /root]# echo $test 5 [root@hoser /root]# I'm very curious how you get it - it's usually not used, but root can set processes to it. this seems to be the source of the problem: [root@localhost /root]# nice -5 nice -5 [root@localhost /root]# nice --5 nice 5 perhaps safe_mysqld is not the only program making positive niceness negative? :) I did some changes to the package in the current tree, and an upcoming errata for another issue (buggy aliasing code in mysql) will include this - basically check that no niceness value is below 0. *** Bug 196649 has been marked as a duplicate of this bug. *** |