[Bug 351273] [NEW] AppArmor rules cause table conversion problem

[Cafuego]

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.

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

The perms on all mysql directories are fine and when I turned apparmor
off MySQL stopped complaining.

** Affects: mysql-dfsg (Ubuntu)
     Importance: Undecided
         Status: Invalid

-- 
AppArmor rules cause table conversion problem
https://bugs.launchpad.net/bugs/351273
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs