mysqld crashes on certain ALTER TABLE queries (MySQL Bug #31145)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
mysql-dfsg-5.1 (Ubuntu) |
Fix Released
|
Medium
|
Unassigned | ||
Karmic |
Won't Fix
|
Medium
|
Unassigned | ||
Lucid |
Fix Released
|
Medium
|
Unassigned |
Bug Description
http://
This bug causes mysqld from "5.1.41-
Could you please backport this fix into the 5.1.41 package on Ubuntu 10.04 LTS?
==== Info for SRU in Karmic, Lucid ====
IMPACT: some ALTER TABLE queries crash the server.
It is fixed in Maverick (mysql-server-5.1 5.1.49-1ubuntu8.1). Tested and confirmed.
TEST CASE:
Install mysql-server-5.1, use the CLI to run the following queries (taken from the upstream bugreport):
CREATE DATABASE grtdiff_alter_test;
CREATE TABLE grtdiff_
DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE `grtdiff_
The last command will return:
ERROR 2013 (HY000): Lost connection to MySQL server during query
And in the /var/log/daemon.log you'll see:
Dec 28 23:52:39 utest-lls32 init: mysql main process (2184) terminated with status 1
Dec 28 23:52:39 utest-lls32 init: mysql main process ended, respawning
Dec 28 23:52:40 utest-lls32 /etc/mysql/
Dec 28 23:52:40 utest-lls32 /etc/mysql/
Dec 28 23:52:40 utest-lls32 /etc/mysql/
Dec 28 23:52:40 utest-lls32 /etc/mysql/
Dec 28 23:52:40 utest-lls32 /etc/mysql/
Dec 28 23:52:40 utest-lls32 /etc/mysql/
Dec 28 23:52:40 utest-lls32 /etc/mysql/
a.k.a daemon crashed and was restarted.
After applying the fix the above queries will run without a crash.
REGRESSION POTENTIAL: should be low. The patch was taken directly from upstream (see above commit link).
Related branches
Changed in mysql-dfsg-5.1 (Ubuntu Lucid): | |
status: | New → Confirmed |
Changed in mysql-dfsg-5.1 (Ubuntu Karmic): | |
status: | New → Confirmed |
importance: | Undecided → Medium |
Changed in mysql-dfsg-5.1 (Ubuntu Lucid): | |
importance: | Undecided → Medium |
Changed in mysql-dfsg-5.1 (Ubuntu Lucid): | |
milestone: | none → lucid-updates |
tags: |
added: verification-done removed: verification-needed |
tags: | added: testcase |
Hi tjw! Thanks for taking the time to file this report and help us make Ubuntu better.
Looks legitimate and would definitely be a good fix for Lucid.
Nominated for Lucid and marking as Fix Released in the current development release.