[Bug 800062] [NEW] Can't create view in mysql database: ErrCode: 2

[dajense]

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