[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
Thank you for taking the time to report this bug and helping to make Ubuntu better. The version of Ubuntu you're reporting this issue on is in End of Life status, and newer versions have fixed this issue. You can learn more about this at https://wiki.ubuntu.com/Releases ** Changed in: mysql-dfsg-5.0 (Ubuntu Dapper) Status: Triaged => Invalid -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in Ubuntu. https://bugs.launchpad.net/bugs/394036 Title: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/394036/+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
[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
Seems to be directly related to: http://bugs.mysql.com/bug.php?id=21476 ** Bug watch added: MySQL Bug System #21476 http://bugs.mysql.com/bug.php?id=21476 -- MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...) https://bugs.launchpad.net/bugs/394036 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- 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
[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
On a related note, here is a link where previous versions of mysql 5.0 can be downloaded: http://snaps.mysql.com/archives.php?p=mysql-5.0&o=other -- MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...) https://bugs.launchpad.net/bugs/394036 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- 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
[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
I can reproduce this bug in MySQL 5.0.24a-9ubuntu2.4 (edgy) It appears to have been fixed in MySQL 5.0.38-0ubuntu1 (feisty) Do note that even affected MySQL versions can detect/handle ERROR 1436. It seems as if the option thread_stack has to be within a certain range for this bug to manifest itself. -- MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...) https://bugs.launchpad.net/bugs/394036 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- 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
[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
What needs to be to move things forward on dapper is to figure out which version of mysql has the fix. 1. Narrow down the range of versions to test by testing mysql packages from every release (edgy, feisty, gutsy). 2. Figure out if mysql keeps an archive of all previous releases. If not, look at the bzr branches - they may use tag for each release. 3. Use the bisection method to find out which release of mysql fixed the bug by building a binary package for each release. 4. Go through the list of changes for that release and figure out which patch has fixed the bugs. -- MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...) https://bugs.launchpad.net/bugs/394036 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- 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
[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
On hardy and above the server doesn't crash. Instead the following error is reported: ERROR 1436 (HY000): Thread stack overrun: 250312 bytes used of a 262144 byte stack, and 12000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. Marking bug Fixed Released for hardy and above. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New => Fix Released ** Also affects: mysql-dfsg-5.0 (Ubuntu Dapper) Importance: Undecided Status: New ** Changed in: mysql-dfsg-5.0 (Ubuntu Dapper) Importance: Undecided => Medium ** Changed in: mysql-dfsg-5.0 (Ubuntu Dapper) Status: New => Triaged -- MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...) https://bugs.launchpad.net/bugs/394036 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- 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
[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
The above query together with this config crashes the server. # egrep -v "^($|#)" /etc/mysql/my.cnf [client] port= 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice= 0 core-file-size = unlimited [mysqld] core-file user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir = /export/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-external-locking old_passwords = 1 bind-address= 0.0.0.0 key_buffer = 128M max_allowed_packet = 16M thread_stack= 265K table_cache = 16M query_cache_limit = 1048576 query_cache_size= 128M query_cache_type= 1 log-bin = /var/log/mysql/mysql-bin.log expire-logs-days= 20 max_binlog_size = 104857600 skip-bdb innodb_buffer_pool_size = 64M [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M -- MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...) https://bugs.launchpad.net/bugs/394036 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- 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
[Bug 394036] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS (SELECT 0+0+0...)
I saw a similair query which seem to crash the MySQL client (version 5.0.22-0ubuntu6.06.11). mysql> SELECT CONCAT('', 0+8609563+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+871+268+488+141+141+141+141+141+141+141+1232+141+141+141+141+141+360+141+360+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+488+141+141+141+1695+141+141+141+141+141+141+141+141+488+141+141+141+141+141+141+141+141+141+360+141+141+141+141+141+141+141+141+488+141+141+141+141+141+360+141+360+141+359+359+141+488+141+141+578+141+1579+706+578+141+466+466+488+141+141+360+141+141+141+141+141+141+141+1127+141+141+141+141+141+141+141+141+141+141+141+360+141+141+141+1003+141+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+141+141+360+141+141+141+487+141+141+141+141+141+141+141+1032+487+141+141+141+141+141+141+141+141+141+141+141+487+141+141+141+141+141+141+141+141+141+141+487+141+1217+141+141+141+141+278+141+141+141+141+141+487+141+141+141+141+141+1137+141+141+141+141+141+141+141+487+141+141+141+141+141+141+141+141+835+141+141+141+141+141+277+141+1053+141+141+1001+141+141+141+141+487+141+141+141+141+141+141+141+141+269167+418+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+244+141+141+141+486+141+141+273+141+141+141+141+141+141+359+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+1114+141+141+141+141+141+141+141+141+141+141+141+141+1003+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+1994+141+141+141+141+141+141+141+141+141+1326+141+141+141+141+141+141+141+141+141+141+141+486+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+277+141+141+141+141+141+141+466+141+141+141+141+141+141+141+141+141+141+141+141+141+141+488+141+579+141+141+141+141+141+141+141+141+141+141+466+710+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+488+141+141+141+141+141+141+141+141+141+141+141+488+141+141+141+141+141+141+141+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+2211+141+141+1291+141+141+141+141+2134+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+255946+10410609+141+141+141+237+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+1033+141+141+141+141+141+1020+141+141+141+141+141+141+363+1105+141+269+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+360+360+141+141+141+466+141+141+141+141+141+141+141+485+141+523+141+141+360+141+141+141+141+466+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+2011+141+141+141+141+141+141+249+141+141+141+1005+320+141+141+141+486+141+141+141+141+141+429+141+141+141+141+998+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+365+141+141+141+141+141+141+141+141+141+141+141+141+141+1239+141+141+141+486+141+141+141+141+141+141+141+320+645+141+141+141+141+488+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+184364+7737999+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+1004+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+466+359+141+141+141+141+141+141+141+141+141+141+141+359+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+246+488+141+141+141+141+141+141+141+141+141+141+141+141+360+141+141+141+141+141+141+466+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+625+249+141+141+141+141+141+141+141+141+141+141+141+141+141+141+360+141+141+141+141+141+141+141+141+141+488+1008+141+141+949+1107+141+141+141+141+657+141+141+141+1007+141+141+141+141+141+141+141+141+141+141+813+717+141+141+141+141+141+141+141+141+141+141+485+141+488+141+141+141+141+141+141+141+141+491+141+141+141+141+141+141+141+141+141+141+141+141+360+141+141+141+141+141+141+141+1484+141+141+141+141+141+141+141+141+597+141+141+141+141+141+141+141+199540+5080948+141+141+362+1322+141+141+141+141+141+141+141+141+141+1518+141+141+488+141+141+141+141+141+141+141+2224+141+141+141+141+141+141+141+141+1702+141+141+141+141+141+141+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+141+141+488+141+141+360+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+360+141+141+141+141+141+141+813+141+141+141+141+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+141+141+488+141+141+141+141+141+141+141+1006+141+141+141+141+141+488+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+493+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+141+359+141+141+141+141+141+141+141+141+141+141+141+141+14