2010-12-02 19:51:01 |
tjw |
bug |
|
|
added bug |
2010-12-03 18:25:33 |
Clint Byrum |
nominated for series |
|
Ubuntu Lucid |
|
2010-12-03 18:27:20 |
Clint Byrum |
bug |
|
|
added subscriber Clint Byrum |
2010-12-03 18:27:23 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu): status |
New |
Fix Released |
|
2010-12-03 18:27:44 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu): importance |
Undecided |
Medium |
|
2010-12-03 18:28:47 |
Clint Byrum |
nominated for series |
|
Ubuntu Karmic |
|
2010-12-03 18:33:44 |
Clint Byrum |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2010-12-03 18:37:06 |
Clint Byrum |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=31145 |
|
2010-12-03 18:37:06 |
Clint Byrum |
bug task added |
|
mysql-server |
|
2010-12-03 19:05:30 |
Chuck Short |
bug task added |
|
mysql-dfsg-5.1 (Ubuntu Karmic) |
|
2010-12-03 19:05:38 |
Chuck Short |
bug task added |
|
mysql-dfsg-5.1 (Ubuntu Lucid) |
|
2010-12-03 19:52:40 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Lucid): status |
New |
Confirmed |
|
2010-12-03 19:52:43 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Karmic): status |
New |
Confirmed |
|
2010-12-03 19:52:50 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Karmic): importance |
Undecided |
Medium |
|
2010-12-03 19:52:54 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Lucid): importance |
Undecided |
Medium |
|
2010-12-08 19:48:20 |
Brian Murray |
mysql-dfsg-5.1 (Ubuntu Lucid): milestone |
|
lucid-updates |
|
2010-12-28 23:26:53 |
Imre Gergely |
description |
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? |
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). |
|
2010-12-28 23:30:56 |
Imre Gergely |
attachment added |
|
Debdiff for Lucid https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/684398/+attachment/1778576/+files/lucid.debdiff |
|
2010-12-28 23:31:40 |
Imre Gergely |
attachment added |
|
Debdiff for Karmic. https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/684398/+attachment/1778577/+files/karmic.debdiff |
|
2010-12-28 23:31:50 |
Imre Gergely |
bug |
|
|
added subscriber Imre Gergely |
2010-12-29 08:52:12 |
Imre Gergely |
attachment removed |
Debdiff for Lucid https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/684398/+attachment/1778576/+files/lucid.debdiff |
|
|
2010-12-29 08:52:32 |
Imre Gergely |
attachment removed |
Debdiff for Karmic. https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/684398/+attachment/1778577/+files/karmic.debdiff |
|
|
2010-12-29 10:00:41 |
Imre Gergely |
attachment added |
|
Lucid debdiff https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/684398/+attachment/1778804/+files/lucid.debdiff |
|
2010-12-29 10:01:09 |
Imre Gergely |
attachment added |
|
Karmic debdiff https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/684398/+attachment/1778805/+files/karmic.debdiff |
|
2011-01-15 00:16:47 |
Martin Pitt |
bug |
|
|
added subscriber Ubuntu Sponsors Team |
2011-01-20 17:12:32 |
Martin Pitt |
mysql-dfsg-5.1 (Ubuntu Lucid): status |
Confirmed |
Fix Committed |
|
2011-01-20 17:12:38 |
Martin Pitt |
bug |
|
|
added subscriber SRU Verification |
2011-01-20 17:12:44 |
Martin Pitt |
tags |
|
verification-needed |
|
2011-01-20 18:17:31 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu/lucid-proposed/mysql-dfsg-5.1 |
|
2011-01-25 21:32:32 |
Jean-Baptiste Lallement |
tags |
verification-needed |
verification-done |
|
2011-01-26 06:23:24 |
Martin Pitt |
mysql-dfsg-5.1 (Ubuntu Karmic): status |
Confirmed |
Won't Fix |
|
2011-01-26 09:32:44 |
Launchpad Janitor |
mysql-dfsg-5.1 (Ubuntu Lucid): status |
Fix Committed |
Fix Released |
|
2011-02-12 19:37:40 |
Benjamin Drung |
removed subscriber Ubuntu Sponsors Team |
|
|
|
2011-09-19 21:40:27 |
Ubuntu Foundations Team Bug Bot |
tags |
verification-done |
testcase verification-done |
|