mysqld crashes on simple SELECT w/ large table
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Invalid
|
Undecided
|
Seppo Jaakola |
Bug Description
MySQL is crashing with a simple "SELECT * FROM large_table" query. It happens every time. This does not affect stock MySQL (I tried).
This happens with a single-node cluster, or multi-node cluster.
Here are the version numbers:
# uname -a
Linux db02 2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 x86_64 GNU/Linux
<email address hidden>
# dpkg -l|grep mysql
ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database
ii libmysqlclient16 5.1.63-0+squeeze1 MySQL database client library
ii mysql-client-5.1 5.1.63-0+squeeze1 MySQL database client binaries
ii mysql-common 5.1.63-0+squeeze1 MySQL database common files, e.g. /etc/mysql/my.cnf
ii mysql-server-wsrep 5.5.23-23.6 wsrep-enabled MySQL server
<email address hidden>
# dpkg -l|grep galera
ii galera 23.2.1 Galera Replication Framework
Attached is a file with MySQL configuration and the relevant logs.
---
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.23-log Source distribution, wsrep_23.6.r3755
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET GLOBAL wsrep_debug=1;
Query OK, 0 rows affected (0.00 sec)
mysql> USE placelocal;
Database changed
mysql> SELECT * FROM trackings_
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
---
mysql> SHOW CREATE TABLE placelocal.
*******
Table: trackings_referrers
Create Table: CREATE TABLE `trackings_
`id` int(11) NOT NULL AUTO_INCREMENT,
`trackings_id` int(11) NOT NULL,
`page` varchar(260) NOT NULL DEFAULT '',
`event_count` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `consolidated_key` (`trackings_
KEY `tracking_id` (`trackings_id`),
CONSTRAINT `trackings_
) ENGINE=InnoDB AUTO_INCREMENT=
1 row in set (0.00 sec)
Changed in codership-mysql: | |
assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
I could not reproduce this with 1M rows. How many rows are in your table?
Looking at the log, it seems that mysqld_safe does server restart, without reason, MySQL server has not logged any issues on the log. Could you reproduce the problem with debugging enabled? To enable debugging, set:
mysql> set global wsrep_debug=1;