[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
[Bug 392236] Re: MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS
The latter query caused the initial crash, The first is a simplified query which is using the mysql user database and also crashes So please use this query on a MySQL 5.0.22 Server on Ubuntu 6.06.2 LTS SELECT * FROM (SELECT mu.User FROM mysql.user mu UNION SELECT mu.user FROM mysql.user mu ORDER BY mu.User) a; The ORDER BY is causing the crash. I don't think the ORDER BY is syntactically allowed there. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Incomplete => New -- MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS https://bugs.launchpad.net/bugs/392236 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 377555] [NEW] MySQL lacks IPv6 support
Public bug reported: Wishlist bug: MySQL (5.0/5.1) does not have IPv6 support. See also: http://forge.mysql.com/worklog/task.php?id=798 ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New -- MySQL lacks IPv6 support https://bugs.launchpad.net/bugs/377555 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