Public bug reported:
I installed Jaunty (mythbuntu) yesterday and tweaked my mysql
configuration to have the server use InnoDB. When I then ran
mysql_convert_table_format on a database, apparmor started logging
permission issues on temporary tables.
The perms on all mysql directories are fine and when I turned apparmor
off MySQL stopped complaining.
$ lsb_release -rd
Description: Ubuntu jaunty (development branch)
Release: 9.04
$ apt-cache policy mysql-server-5.0
mysql-server-5.0:
Installed: 5.1.30really5.0.75-0ubuntu9
Candidate: 5.1.30really5.0.75-0ubuntu9
Version table:
*** 5.1.30really5.0.75-0ubuntu9 0
500 http://au.archive.ubuntu.com jaunty/main Packages
100 /var/lib/dpkg/status
syslog:
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: Unable to lock
/tmp/#sql4b3d_2e_0.ibd, error: 13
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: Check that you do not already
have another mysqld process
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: using the same InnoDB data or log
files.
Mar 30 08:57:33 mythtv mysqld[19263]: 090330 8:57:33 InnoDB: Error creating
file '/tmp/#sql4b3d_2e_0.ibd'.
Mar 30 08:57:33 mythtv mysqld[19263]: 090330 8:57:33 InnoDB: Operating system
error number 13 in a file operation.
Mar 30 08:57:33 mythtv kernel: [55954.747069] type=1503
audit(1238363853.710:58): operation="file_lock" requested_mask="wk::"
denied_mask="k::" fsuid=103 name="/tmp/#sql4b3d_2e_0.ibd" pid=22943
profile="/usr/sbin/mysqld"
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: The error means mysqld does not
have the access rights to
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: the directory.
Mar 30 08:57:33 mythtv mysqld[19263]: 090330 8:57:33 InnoDB: Error: table
`tmp/#sql4b3d_2e_0` does not exist in the InnoDB internal
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: data dictionary though MySQL is
trying to drop it.
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: Have you copied the .frm file of
the table to the
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: MySQL database directory from
another database?
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB: You can look for further help from
Mar 30 08:57:33 mythtv mysqld[19263]: InnoDB:
http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
Mar 30 08:57:33 mythtv mysqld[19263]: 090330 8:57:33 [Warning] Could not remove
tmp table: '/tmp/#sql4b3d_2e_0', error: -1
** Affects: mysql-dfsg-5.0 (Ubuntu)
Importance: Undecided
Status: New
** Tags: apparmor
--
AppArmor rules cause tmp table problem
https://bugs.launchpad.net/bugs/351275
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
