mysqlhotcopy errors on databases containing MyISAM views
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
mysql-5.5 (Ubuntu) |
Fix Released
|
High
|
James Page | ||
Precise |
Fix Released
|
High
|
James Page | ||
Quantal |
Fix Released
|
High
|
James Page |
Bug Description
mysqlhotcopy attempts to flush all tables, and when it gets to one of the views, it throws the error "<tablename> is not BASE TABLE" (this error was added in 5.5). This in turn causes the backup to abort.
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: mysql-server 5.5.24-
ProcVersionSign
Uname: Linux 3.2.0-25-generic x86_64
ApportVersion: 2.0.1-0ubuntu8
Architecture: amd64
Date: Tue Jun 19 02:23:33 2012
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
Logs.var.
Logs.var.
Jun 18 23:34:29 carl kernel: [351039.309278] type=1400 audit(134008766
Jun 19 01:09:40 carl kernel: [356750.407056] type=1400 audit(134009338
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
PackageArchitec
ProcEnviron:
TERM=xterm
PATH=(custom, user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install)
tags: | added: rls-q-incoming |
tags: | removed: rls-q-incoming |
Changed in mysql-5.5 (Ubuntu Quantal): | |
status: | Confirmed → Triaged |
Changed in mysql-5.5 (Ubuntu Precise): | |
status: | Confirmed → Triaged |
Changed in mysql-5.5 (Ubuntu Quantal): | |
assignee: | nobody → James Page (james-page) |
status: | Triaged → In Progress |
Changed in mysql-5.5 (Ubuntu Precise): | |
status: | Triaged → In Progress |
assignee: | nobody → James Page (james-page) |
The upstream URL for this bug is:
http:// bugs.mysql. com/bug. php?id= 62472&thanks= 3¬ify= 195