[Bug 684398] Re: mysqld crashes on certain ALTER TABLE queries (MySQL Bug #31145)

[Imre Gergely]

Attached some debdiffs for Lucid and Karmic, please take a look.
I've tried to build the package with the patch applied, but some tests failed, I'm not sure why. Output before build failing:

The servers were restarted 437 times
Spent 665.008 of 1469 seconds executing testcases

Failed 5/752 tests, 99.34% were successful.

Failing test(s): main.lock_tables_lost_commit main.ctype_ldml
main.date_formats main.ctype_latin1_de main.events_restart

I don't think it's related to this patch, maybe there are some special
needs for building this, I tried with pbuilder on a Lucid 64bit host.

** Description changed:

  http://bugs.mysql.com/bug.php?id=31145
  
  This bug causes mysqld from "5.1.41-3ubuntu12.7" to segfault.  This is a
  simple 1 line fix that was added to MySQL 5.1.43.  Here is the patch:
  http://lists.mysql.com/commits/94936.
  
  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_alter_test.t1 (t TEXT, `id` int(11) DEFAULT NULL, `id2` int(11)
+ DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+ ALTER TABLE `grtdiff_alter_test`.`t1` DROP COLUMN `t` , ADD COLUMN `t2` TEXT  NULL  FIRST;
+ 
+ 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/debian-start[2413]: Upgrading MySQL tables if necessary.
+ Dec 28 23:52:40 utest-lls32 /etc/mysql/debian-start[2416]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
+ Dec 28 23:52:40 utest-lls32 /etc/mysql/debian-start[2416]: Looking for 'mysql' as: /usr/bin/mysql
+ Dec 28 23:52:40 utest-lls32 /etc/mysql/debian-start[2416]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
+ Dec 28 23:52:40 utest-lls32 /etc/mysql/debian-start[2416]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade
+ Dec 28 23:52:40 utest-lls32 /etc/mysql/debian-start[2423]: Checking for insecure root accounts.
+ Dec 28 23:52:40 utest-lls32 /etc/mysql/debian-start[2427]: Triggering myisam-recover for all MyISAM tables
+ 
+ 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).

-- 
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/684398

Title:
  mysqld crashes on certain ALTER TABLE queries (MySQL Bug #31145)