MySQL Bugs: #65655: MySQL crashed after "show table status" on some table

Bug #65655	MySQL crashed after "show table status" on some table
Submitted:	18 Jun 2012 11:57	Modified:	22 Jul 2012 16:37
Reporter:	Valentin Gjorgjioski	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.1.61-0ubuntu0.10.04.1-log	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	crashed, ERROR 2013, show table status

Description:
Every time I run show table status on this table I'm getting the following:

mysql> show table status like 'tag';
ERROR 2013 (HY000): Lost connection to MySQL server during query

and here is the log:

init: mysql main process (23716) terminated with status 1
init: mysql main process ended, respawning

Same happens to:
mysql> show create table tag;
ERROR 2013 (HY000): Lost connection to MySQL server during query

This bug may have some relation to Bug #21173: 
http://bugs.mysql.com/bug.php?id=21173

How to repeat:
I'm not sure, but I have the table data and frm file. Interesting: 

mysql> select count(*) from tag;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

# du -sh bug-mysql/tag.*
12K     bug-mysql/tag.frm
57M     bug-mysql/tag.ibd

Table was created with this: 
CREATE TABLE `tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Index_2` (`product_id`) USING BTREE,
  KEY `tag_index` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

and it was filled and emptied many times. 

If you need these files I can provide them as well.

Had you tried to run

check table tag;

I wonder if it still crashes. Please, send also the entire error log from server (compressed if it's big).

I haven't run:
check table tag;

Unfortunately I dropped that table, because this is a production server and it was giving me some headache. However, maybe I can do the following if it is needed:

1. recreate it
2. stop mysql
3. replace ibd and frm files
4. try "check table tag"

Regarding the error log, I was always wondering why we do not have one. Maybe it is disabled, or I don't know. If you let me know how to check I will check. I remember long time ago trying to sort this out without success. I have a file called mysql.err but unfortunately it is always empty.

Please, send the output of:

show variables like 'log_%';

If you use Ubuntu binaries maybe error log is transferred to syslog. Check places like:

/var/log/mysql.err

or, even better, check

/var/log/syslog

for MySQL-related error messages.

1. 

+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin                         | ON    |
| log_bin_trust_function_creators | ON    |
| log_bin_trust_routine_creators  | ON    |
| log_error                       |       |
| log_output                      | FILE  |
| log_queries_not_using_indexes   | OFF   |
| log_slave_updates               | OFF   |
| log_slow_queries                | ON    |
| log_warnings                    | 1     |
+---------------------------------+-------+

2.  /var/log/mysql.err this is the file that is always empty, that I previously mentioned. 

3. in syslog, I found some errors, and they were in the first post. 
I'm sending them, and some others that are probably not related to this issue: 

Jun 18 13:28:59 kernel: [7471701.904377] type=1502 audit(1340018939.375:136917853):  operation="file_perm" pid=2118 parent=1 profile="/usr/sbin/mysqld" requested_mask="w::" denied_mask="w::" fsuid=103 ouid=103 name="/usr/var/log/mysql/mysql-slow.log"
Jun 18 13:36:06 init: mysql main process (23716) terminated with status 1
Jun 18 13:36:06 init: mysql main process ended, respawning
Jun 18 13:36:06 kernel: [7472129.035383] type=1505 audit(1340019366.507:136917854):  operation="profile_replace" pid=9175 name="/usr/sbin/mysqld"
Jun 18 13:36:06 kernel: [7472129.149734] type=1502 audit(1340019366.626:136917855):  operation="open" pid=9179 parent=1 profile="/usr/sbin/mysqld" requested_mask="rwc::" denied_mask="rwc::" fsuid=103 ouid=103 name="/mnt/storage/mysql/mysql-bin.index"

Thank you for the feedback.

Check if your case is not duplicate of bug #65664. I will post backtrace to bug #65664 in few seconds.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".