Bug #53573 Lost connection to MySQL server during query
Submitted: 11 May 2010 16:23 Modified: 26 Jun 2010 18:39
Reporter: Batistuta Gabriel Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:mysql-5.1.46 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: Connection, during, lost, mysqld, query, server, signal 6

[11 May 2010 16:23] Batistuta Gabriel
Description:
After I send a simple query, my SQL server crashs and restarts alone.

The file /usr/local/mysql/var/ARCI-2.local.err contains :

Assertion failed: (!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))), function unknown function, file field.cc, line 7088.
100511 17:54:12 - 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=8384512
read_buffer_size=131072
max_used_connections=1
max_threads=151
threads_connected=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337714 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x0
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 = 0x0 thread_stack 0x30000
0   mysqld                              0x004002e8 my_print_stacktrace + 40
1   mysqld                              0x000cdf67 handle_segfault + 723
2   libSystem.B.dylib                   0x90caf2bb _sigtramp + 43
3   ???                                 0xffffffff 0x0 + 4294967295
4   mysqld                              0x000d056d main + 3447
5   mysqld                              0x00001946 start + 54
6   ???                                 0x00000007 0x0 + 7

How to repeat:

My SQl server runs correctly. I've only one problem when I send this request : 
UPDATE myDB.groups_users SET GEN='41' WHERE ARC_Sid='f1c9321c-1cbb-44bd-a5c9-96d5869a089e' and user='37bc92f5-5190-497a-8851-322b75f4fc81';

If I apply this query, my SQL server crashs and restarts alone. 

I really don't know why the server doesn't accept this simple query. What could be the raisons?

I start my SQL server with this command : sudo /usr/local/mysql/bin/mysqld_safe  &

And I send my request with :  /usr/local/mysql/bin/mysql

Thanks in adavance,
[11 May 2010 16:39] Valeriy Kravchuk
Please, send the results of SHOW CREATE TABLE and SHOW TABLE STATUS for this groups_users table.
[11 May 2010 19:33] Batistuta Gabriel
-- MySQL dump 10.11

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `groups_users`
--

DROP TABLE IF EXISTS `groups_users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `groups_users` (
  `ARC_Sid` varchar(127) NOT NULL,
  `user` varchar(127) NOT NULL,
  `GEN` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  USING BTREE (`GEN`,`user`,`ARC_Sid`),
  KEY `fk_groups_users_users1` (`user`),
  CONSTRAINT `fk_groups_users_users1` FOREIGN KEY (`user`) REFERENCES `users` (`sid`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-05-03 14:06:48
[26 May 2010 18:39] Sveta Smirnova
Thank you for the feedback.

Please send structure of table users too and output of SHOW TABLE STATUS for both tables.
[26 Jun 2010 23:00] Bugs System
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".