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@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs