CPU information is inaccessible for MySQL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-dfsg-5.1 (Ubuntu) |
Medium
|
Unassigned |
Bug Description
Binary package hint: mysql-server-
While loading MySQL service in system these messages appears (dmesg):
[ 16.081671] type=1503 audit(125526278
[ 16.349668] type=1503 audit(125526278
[ 17.082697] type=1503 audit(125526278
[ 17.500506] type=1503 audit(125526278
[ 18.545652] type=1503 audit(125526278
[ 18.646431] type=1503 audit(125526278
Distro: Ubuntu-9.10 development
Package version: 5.1.37-1ubuntu5 (with all dependencies)
Mathias Gug (mathiaz) wrote : | #1 |
Changed in mysql-dfsg-5.1 (Ubuntu): | |
importance: | Undecided → Low |
status: | New → Incomplete |
neoeno (neoeno) wrote : | #2 |
For me, yes it does.
Changed in mysql-dfsg-5.1 (Ubuntu): | |
status: | Incomplete → Confirmed |
Trond Husoe (tr-huso) wrote : | #3 |
Same goes here.
[ 634.638825] type=1503 audit(125685708
Trond Husoe (tr-huso) wrote : | #4 |
This also happens when you try and reinstall mysql-server
[ 634.638825] type=1503 audit(125685708
Error message in window:
E: mysql-server-5.1: subprocess installed post-installation script returned error exit status 1
E: mysql-server: dependency problems - leaving unconfigured
Ivar Snaaijer (ivar-snaaijer) wrote : | #5 |
I got the same errors in syslog, added
/sys/devices/
and
/sys/devices/
to the apparmor config for mysql, but no go.
upgraded 9.04 to 9.10, i have my database in a non standard folder, mentioned in the apparmor file since 9.04.
JBB (jaybrianb) wrote : | #6 |
You may have a permission issue. Did you change the directories mysql is accessing. For me, this was resolved by granting the mysql user under which mysql runs access to the relevant directories (/log/mysql /lib/mysql /etc/mysql).
i.e.,
chown -R mysql:mysql <dirs in question here>
Vitaly Chekryzhev (13hakta) wrote : | #7 |
2JBB: No, using only default values from package. Data folders have right permissions, and as I suppose it really shouldn't depend on it.
vitaly:/var/lib$ ls -l mysql
total 28764
-rw-r--r-- 1 mysql mysql 0 2009-10-08 12:18 debian-5.1.flag
-rw-rw---- 1 mysql mysql 18874368 2009-11-01 03:17 ibdata1
-rw-rw---- 1 mysql mysql 5242880 2009-11-01 11:15 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2009-05-31 14:32 ib_logfile1
drwx------ 2 mysql mysql 12288 2009-08-18 20:34 kvop
drwxr-xr-x 2 mysql mysql 4096 2009-10-08 12:18 mysql
-rw------- 1 mysql mysql 6 2009-08-18 20:34 mysql_upgrade_info
drwx------ 2 mysql mysql 12288 2009-11-01 00:43 photohost
drwx------ 2 mysql mysql 4096 2009-05-31 14:40 phpmyadmin
drwx------ 2 mysql mysql 4096 2009-09-07 00:45 ramdim
drwx------ 2 mysql mysql 4096 2009-07-31 01:34 ravall_uckov
Marek Šabo (zeratul) wrote : | #8 |
Confirmed on fresh Kubuntu 9.10:
after calling /etc/init.d/mysql script server fails to start an dmesg shows following:
17672.383215] type=1503 audit(125709034
Ihon (ion-shaitan) wrote : | #9 |
This is caused by AppArmor, if you stop AppArmor via
/etc/init.
start Mysql via
/etc/init.d/mysql start
My Sql will run and you can now restart apparmor via
/etc/init.
Now I try to find the necessary setting for the apparmor profile.
Cheers,
Ihon
Marek Šabo (zeratul) wrote : | #10 |
Suggestion: Add line
/sys/devices/
to your /etc/apparmor.
Then check your syslog/mysql-log again if there is something else e.g. i personnaly had problem with package in kubuntu. After adding rule I saw error in log complaining about bdb something. I opened /etc/mysql/my.cnf and commented the line with bdb option and it runs now.
HTH,
Regards,
Marek
Vitaly Chekryzhev (13hakta) wrote : | #11 |
So, disabling AppArmor is not a proper solution, while MySQL may be misconfigured.
Marek Šabo (zeratul) wrote : | #12 |
Disabling AppArmor may not be desirable solution, but as you see there could be error in apparmor's mysql configuration and then in configuration of mysql itself. When you disable apparmor for debugging you are one step ahead because mysql now actually produces some logs why it can't start (eg in my case some option that just needed to be commented. I doubt that mysqld would run with proper mysql conf and misconfigured apparmor).
Quantico (liarevalo) wrote : | #13 |
i update 9.04 to 9.10 and the same problem profile=
andrew1056 (andrew-oke) wrote : | #14 |
I also get this as well:
[ 29.296223] type=1503 audit(125744765
[ 29.890030] type=1503 audit(125744765
[ 30.359761] type=1503 audit(125744765
[ 30.993438] type=1503 audit(125744765
[ 32.005413] type=1503 audit(125744766
[ 32.588044] eth0: no IPv6 routers present
[ 33.102948] type=1503 audit(125744766
[ 33.113770] type=1503 audit(125744766
This only happens on startup. Once I'm in a user session I can start mysql with sudo service mysql start.
Quantico (liarevalo) wrote : | #15 |
if you check after update to 9.10 en synaptic the mysql server and client are not installed, just check to install and aplly the changes and it wil work.
the problem in my case was that the files that have the soket was deleted.
so i check out in grep mysqld /var/log/daemon.log
Nov 6 09:32:58 quantico-laptop /etc/init.
Nov 6 09:32:58 quantico-laptop /etc/init.
mcfang (ubuntu-mcfang) wrote : | #16 |
I got the same audit errors, however these are a red herring as the problem had nothing to do with apparmor.
Check your daemon.log as it should have information about the actual cause, my daemon.log showed:
mysqld: 091107 14:03:37 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
mysqld: 091107 14:03:37 [ERROR] Aborting
removing the "skip-bdb" option in /etc/mysql/my.cnf solved it.
If you are upgrading a mysql install it is likely your my.cnf had "skip-bdb" which is no longer supported by the mysql server. New installs do not have this problem as they use a clean my.cnf
Alyssa (peridot121) wrote : | #17 |
The following worked for me
1. Edit /etc/apparmor.
/sys/devices/
2. Restart apparmor (as root): /etc/init.
maraja (ugo-grandolini) wrote : | #18 |
following the thread at:
http://
I also solved the issue by commenting the following line:
skip-bdb
in /etc/mysql/my.cnf
long life toUbuntu!
:)
Marek Šabo (zeratul) wrote : | #19 |
That is upgrade related issue as well, usually they both come hand in hand (adding apparmor permission and commenting skip-bdb). I was referring to this in my earlier post.
Glad you got it working now.
MarcRandolph (mrand) wrote : | #20 |
Howdy, and thank you for taking the time to report this bug and helping to make Ubuntu better. This particular bug has already been reported and appears to be a duplicate, so it is being marked as such. Please look at the other bug report to see if there is any missing information that you can provide, or to see if there is a workaround for the bug. Additionally, any further discussion regarding the bug should occur in the other report. Please feel free to continue to report any other bugs you may find.
Changed in mysql-dfsg-5.1 (Ubuntu): | |
importance: | Low → Medium |
status: | Confirmed → Triaged |
Thank you for taking the time to report this bug and helping to make Ubuntu better. Does this prevent mysql from starting correclty?