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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs