MySQL Bugs: #69164: 130507 9:34:33 - mysqld got signal 6 ;

Bug #69164	130507 9:34:33 - mysqld got signal 6 ;
Submitted:	7 May 2013 14:41	Modified:	7 Jun 2013 18:37
Reporter:	Erick Kinnee	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S1 (Critical)
Version:	mysql Ver 14.14 Distrib 5.1.57, for unk	OS:	Linux (2.6.13.5)
Assigned to:		CPU Architecture:	Any

Description:
130507  9:34:33 - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=134217728
read_buffer_size=4194304
max_used_connections=5
max_threads=300
threads_connected=5
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3820577 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x5a43eb0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x4708efc8 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x85156e]
/usr/sbin/mysqld(handle_segfault+0x34c)[0x5c8ffc]
/lib64/tls/libpthread.so.0[0x33a910c380]
/lib64/tls/libc.so.6(gsignal+0x3d)[0x33a862e4dd]
/lib64/tls/libc.so.6(abort+0x12e)[0x33a862fc8e]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2c24ca2]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2cc2a7b]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2cb3e6e]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2be39eb]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2be4d2e]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2c9cffa]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2ca0517]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2ca0cc0]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2c89b41]
/usr/lib64/mysql/plugin/ha_innodb_plugin.so[0x2aaab2c325d2]
/usr/sbin/mysqld(_ZN7handler13ha_update_rowEPKhPh+0x62)[0x6a51f2]
/usr/sbin/mysqld(_Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesb+0xdea)[0x651c4a]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1b4e)[0x5d913e]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjPPKc+0x1f3)[0x5dd8d3]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x53a)[0x5ddeea]
/usr/sbin/mysqld(_Z10do_commandP3THD+0xde)[0x5df02e]
/usr/sbin/mysqld(handle_one_connection+0x5f1)[0x5d1f41]
/lib64/tls/libpthread.so.0[0x33a9105f81]
/lib64/tls/libc.so.6(__clone+0x43)[0x33a86c3af3]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x5a0a500): update userdb.ReDevice set LastHeartbeat=now() where Mac_address='161335182717'
Connection ID (thread ID): 67
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
130507 09:34:33 mysqld_safe Number of processes running now: 0
130507 09:34:33 mysqld_safe mysqld restarted
130507  9:34:36 [Warning] --myisam_max_extra_sort_file_size is deprecated and does nothing in this version.  It will be removed in a future release.
130507  9:34:36 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
130507  9:34:36  InnoDB: Initializing buffer pool, size = 2.0G
130507  9:34:36  InnoDB: Completed initialization of buffer pool
130507  9:34:36  InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1481323710485
130507  9:34:36  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1481323710495
130507  9:34:37 InnoDB Plugin 1.0.16 started; log sequence number 1481323710495
130507  9:34:37 [Note] Event Scheduler: Loaded 0 events
130507  9:34:37 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.57'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130507  9:34:38  InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 57494! Make a detailed bug
InnoDB: report, and submit it to http://bugs.mysql.com

How to repeat:
service mysql start

Thank you for the report.

Please send us output of SHOW CREATE TABLE userdb.ReDevice and SHOW TABLE STATUS LIKE '%ReDevice%'

mysql> show create table ReDevice;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: userdb

+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ReDevice | CREATE TABLE `ReDevice` (
  `Device_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) DEFAULT NULL,
  `IP_Address` varchar(50) DEFAULT NULL,
  `External_IP_Address` varchar(50) DEFAULT NULL,
  `MAC_Address` varchar(50) DEFAULT NULL,
  `Type` varchar(20) DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `LastUpdated` datetime DEFAULT NULL,
  `Status` varchar(20) DEFAULT NULL,
  `ConfigDataXML` text,
  `StingrayStatisticsXML` mediumtext,
  `SystemStatisticsXML` text,
  `SSHJCLPort` int(11) DEFAULT NULL,
  `SSHStingrayXMLPort` int(11) DEFAULT NULL,
  `SSHActiveMQPort` int(11) DEFAULT NULL,
  `SSHMySQLPort` int(11) DEFAULT NULL,
  `SSHSigDAPort` int(11) DEFAULT NULL,
  `ig_to_im_jms_status` varchar(20) DEFAULT NULL,
  `im_to_ig_jms_status` varchar(20) DEFAULT NULL,
  `ssh_tunnel_status` varchar(20) DEFAULT NULL,
  `stingray_status` varchar(20) DEFAULT NULL,
  `reachable_status` varchar(20) DEFAULT NULL,
  `LastHeartbeat` datetime DEFAULT NULL,
  `Apply_to_all` tinyint(4) DEFAULT NULL,
  `Registered` tinyint(4) DEFAULT NULL,
  `Configured` tinyint(4) DEFAULT '0',
  `LdapDomainsDeployed` tinyint(4) DEFAULT '0',
  `scanTaskStatsCookie` varchar(29) DEFAULT NULL,
  `remediationStatsCookie` varchar(29) DEFAULT NULL,
  `installDate` varchar(20) DEFAULT NULL,
  `signaturesSynched` int(10) unsigned DEFAULT '1',
  `configSynched` int(10) unsigned DEFAULT '1',
  `scanSynched` int(10) unsigned DEFAULT '1',
  `demo` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`Device_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.06 sec)

mysql> show table status like '%ReDevice%';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    4
Current database: userdb

+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| Name                    | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation       | Checksum | Create_options | Comment |
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| ReDevice                | InnoDB |      10 | Compact    |   15 |         144179 |     2162688 |               0 |            0 |   8388608 |             19 | 2012-11-08 13:35:47 | NULL        | NULL       | utf8_general_ci |     NULL |                |         |
| ReDeviceListenersConfig | InnoDB |      10 | Compact    |    1 |          16384 |       16384 |               0 |            0 | 249561088 |              2 | 2011-12-01 12:38:42 | NULL        | NULL       | utf8_general_ci |     NULL |                |         |
| ReDeviceStats           | InnoDB |      10 | Compact    |   12 |           1365 |       16384 |               0 |        16384 | 249561088 |             17 | 2011-12-01 12:38:42 | NULL        | NULL       | utf8_general_ci |     NULL |                |         |
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
3 rows in set (0.03 sec)

Thank you for the feedback.

I can not repeat described behavior with dummy data. Additionally version 5.1.57 is old and many bugs were fixed since. please upgrade to current version 5.1.69, try with it and inform us if you can repeat this crash.

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".