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
