Public bug reported: Using any msql user (also mysql root) on any database mysql reports an ERROR 1 (HY000): Can't create/write to file './<VIEWNAME>/v.frm~' (Errcode: 2).
This is a standard installation of mysql-server. The mysql data-dir resides in /var/lib/mysql. Permissions on the directory are as follows: ls -al /var/lib/ | grep mysql drwxrwx--- 10 mysql mysql 4096 2011-06-21 09:24 mysql (used to be only drwx----- but I changed that trying to resolve the issue). Apparmor configuration seems fine: etc/mysql/*.pem r, /etc/mysql/conf.d/ r, /etc/mysql/conf.d/* r, /etc/mysql/my.cnf r, /usr/sbin/mysqld mr, /usr/share/mysql/** r, /var/log/mysql.log rw, /var/log/mysql.err rw, /var/lib/mysql/ r, /var/lib/mysql/** rwk, /var/log/mysql/ r, /var/log/mysql/* rw, /var/run/mysqld/mysqld.pid w, /var/run/mysqld/mysqld.sock w, Mysql tmp direcotry is defined as /usr/lib/mysql/tmp in /etc/mysql/my.conf Further information: lsb_release -rd Description: Ubuntu 10.04.2 LTS Release: 10.04 apt-cache policy mysql-server mysql-server: Installed: 5.1.41-3ubuntu12.10 Candidate: 5.1.41-3ubuntu12.10 Version table: *** 5.1.41-3ubuntu12.10 0 500 http://us.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages 100 /var/lib/dpkg/status 5.1.41-3ubuntu12.7 0 500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages 5.1.41-3ubuntu12 0 500 http://us.archive.ubuntu.com/ubuntu/ lucid/main Packages ProblemType: Bug DistroRelease: Ubuntu 10.04 Package: mysql-server 5.1.41-3ubuntu12.10 ProcVersionSignature: Ubuntu 2.6.32-21.32-generic-pae 2.6.32.11+drm33.2 Uname: Linux 2.6.32-21-generic-pae i686 Architecture: i386 Date: Tue Jun 21 09:42:56 2011 InstallationMedia: Ubuntu-Server 10.04 LTS "Lucid Lynx" - Release i386 (20100427) Logs.var.log.daemon.log: Logs.var.log.kern.log: Jun 21 09:19:25 paranoia24 kernel: [6549918.514357] type=1505 audit(1308640765.721:17): operation="profile_replace" pid=3877 name="/usr/sbin/mysqld" Jun 21 09:24:19 paranoia24 kernel: [6550212.023211] type=1505 audit(1308641059.229:18): operation="profile_replace" pid=5333 name="/usr/sbin/mysqld" MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: False PackageArchitecture: all ProcEnviron: LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: mysql-dfsg-5.1 ** Affects: mysql-dfsg-5.1 (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug i386 lucid -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/800062 Title: Can't create view in mysql database: ErrCode: 2 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/800062/+subscriptions -- 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