Version: '5.1.49-enterprise-gpl-advanced'  socket: ''  port: 3306  MySQL Enterprise Server - Ad
100812  9:15:12 - mysqld got exception 0xc0000005 ;
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=5
max_threads=151
threads_connected=5
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337726 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x30cc520
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...
005D4390    mysqld.exe!ut_print_name()[ut0ut.c:469]
005CD017    mysqld.exe!dict_index_name_print()[dict0dict.c:4259]
005D1A81    mysqld.exe!lock_rec_print()[lock0lock.c:4109]
005D2FBB    mysqld.exe!lock_deadlock_recursive()[lock0lock.c:3280]
005D2F06    mysqld.exe!lock_deadlock_recursive()[lock0lock.c:3357]
005D2F06    mysqld.exe!lock_deadlock_recursive()[lock0lock.c:3357]
005D2F06    mysqld.exe!lock_deadlock_recursive()[lock0lock.c:3357]
005D308E    mysqld.exe!lock_deadlock_occurs()[lock0lock.c:3117]
005D352A    mysqld.exe!lock_rec_enqueue_waiting()[lock0lock.c:1794]
005D362D    mysqld.exe!lock_rec_lock_slow()[lock0lock.c:2038]
005D36E3    mysqld.exe!lock_rec_lock()[lock0lock.c:2090]
005D3A1E    mysqld.exe!lock_clust_rec_read_check_and_lock()[lock0lock.c:5193]
005BEB41    mysqld.exe!sel_set_rec_lock()[row0sel.c:862]
005C181C    mysqld.exe!row_search_for_mysql()[row0sel.c:4001]
005EDEEB    mysqld.exe!os_fast_mutex_lock()[os0sync.c:695]
005AE04F    mysqld.exe!ha_innobase::index_read()[ha_innodb.cc:4725]
005AE554    mysqld.exe!ha_innobase::index_first()[ha_innodb.cc:4991]
005AE634    mysqld.exe!ha_innobase::rnd_next()[ha_innodb.cc:5085]
004E6926    mysqld.exe!rr_sequential()[records.cc:385]
00559299    mysqld.exe!mysql_update()[sql_update.cc:580]
00459D38    mysqld.exe!mysql_execute_command()[sql_parse.cc:3109]
0045D17F    mysqld.exe!mysql_parse()[sql_parse.cc:6021]
0045DBD3    mysqld.exe!dispatch_command()[sql_parse.cc:1256]
0045E667    mysqld.exe!do_command()[sql_parse.cc:886]
0047F050    mysqld.exe!handle_one_connection()[sql_connect.cc:1136]
0068058B    mysqld.exe!pthread_start()[my_winthread.c:85]
0065FA63    mysqld.exe!_callthreadstart()[thread.c:293]
2E383631
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 030DA2D8=update t2 set b=''
thd->thread_id=192
thd->killed=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.



ALL THREADS:
---------------------

CRASH: update t2 set b=''

>	mysqld.exe!ut_print_name(_iobuf * f=0x008b6840, trx_struct * trx=0x02e26880, unsigned long table_id=0x00000000, const char * name=0x00000000)  Line 469 + 0x10 bytes	C
 	mysqld.exe!dict_index_name_print(_iobuf * file=0x008b6840, trx_struct * trx=0x02e26880, const dict_index_struct * index=0x02e0d080)  Line 4259	C
 	mysqld.exe!lock_rec_print(_iobuf * file=0x008b6840, lock_struct * lock=0x02e0b9d0)  Line 4109	C
 	mysqld.exe!lock_deadlock_recursive(trx_struct * start=0x02e26880, trx_struct * trx=0x02e0cc80, lock_struct * wait_lock=0x02e04b08, unsigned long * cost=0x0242df14, unsigned long depth=0x00000003)  Line 3280	C
 	mysqld.exe!lock_deadlock_recursive(trx_struct * start=0x02e26880, trx_struct * trx=0x02e03c80, lock_struct * wait_lock=0x02e25308, unsigned long * cost=0x0242df14, unsigned long depth=0x00000002)  Line 3357 + 0x17 bytes	C
 	mysqld.exe!lock_deadlock_recursive(trx_struct * start=0x02e26880, trx_struct * trx=0x02e01080, lock_struct * wait_lock=0x02e23f08, unsigned long * cost=0x0242df14, unsigned long depth=0x00000001)  Line 3357 + 0x17 bytes	C
 	mysqld.exe!lock_deadlock_recursive(trx_struct * start=0x02e26880, trx_struct * trx=0x02e26880, lock_struct * wait_lock=0x02e2b1f8, unsigned long * cost=0x0242df14, unsigned long depth=0x00000000)  Line 3357 + 0x17 bytes	C
 	mysqld.exe!lock_deadlock_occurs(lock_struct * lock=0x00000000, trx_struct * trx=0x00000000)  Line 3117 + 0xe bytes	C
 	mysqld.exe!lock_rec_enqueue_waiting(unsigned long type_mode=0x00000000, unsigned char * rec=0x0315807f, dict_index_struct * index=0x00000000, que_thr_struct * thr=0x02e24100)  Line 1794 + 0x5 bytes	C
 	mysqld.exe!lock_rec_lock_slow(unsigned long impl=0x00000000, unsigned long mode=0x00000000, unsigned char * rec=0x00000000, dict_index_struct * index=0x02e0b280, que_thr_struct * thr=0x02e24100)  Line 2038 + 0xd bytes	C
 	mysqld.exe!lock_rec_lock(unsigned long impl=0x00000000, unsigned long mode=0x00000005, unsigned char * rec=0x0315807f, dict_index_struct * index=0x00000000, que_thr_struct * thr=0x00000000)  Line 2090 + 0x10 bytes	C
 	mysqld.exe!lock_clust_rec_read_check_and_lock(unsigned long flags=0x00000000, unsigned char * rec=0x0315807f, dict_index_struct * index=0x02e0b280, const unsigned long * offsets=0x0242e020, unsigned long mode=0x00000005, unsigned long gap_mode=0x00000000, que_thr_struct * thr=0x02e24100)  Line 5193	C
 	mysqld.exe!sel_set_rec_lock(unsigned char * rec=0x0315807f, dict_index_struct * index=0x02e0b280, const unsigned long * offsets=0x0242e020, unsigned long mode=0x00000005, unsigned long type=0x00000000, que_thr_struct * thr=0x02e24100)  Line 862	C
 	mysqld.exe!row_search_for_mysql(unsigned char * buf=0x030e8a00, unsigned long mode=0x00000001, row_prebuilt_struct * prebuilt=0x02e00c80, unsigned long match_mode=0x00000000, unsigned long direction=0x00000000)  Line 4001 + 0x16 bytes	C
 	mysqld.exe!ha_innobase::index_read(unsigned char * buf=0x030e8a00, const unsigned char * key_ptr=0x00000000, unsigned int key_len=0x00000000, ha_rkey_function find_flag=HA_READ_AFTER_KEY)  Line 4725	C++
 	mysqld.exe!ha_innobase::index_first(unsigned char * buf=0x030e8a00)  Line 4991	C++
 	mysqld.exe!ha_innobase::rnd_next(unsigned char * buf=0x030e8a00)  Line 5085	C++
 	mysqld.exe!rr_sequential(READ_RECORD * info=0x0242e6e8)  Line 385 + 0x15 bytes	C++
 	mysqld.exe!mysql_update(THD * thd=0x030cc520, TABLE_LIST * table_list=0x030da378, List<Item> & fields={...}, List<Item> & values={...}, Item * conds=0x00000000, unsigned int order_num=0x00000000, st_order * order=0x00000000, unsigned __int64 limit=0xffffffffffffffff, enum_duplicates handle_duplicates=DUP_ERROR, bool ignore=false)  Line 580 + 0xc bytes	C++
 	mysqld.exe!mysql_execute_command(THD * thd=0x030cc520)  Line 3109 + 0x4c bytes	C++
 	mysqld.exe!mysql_parse(THD * thd=0x030cc520, const char * inBuf=0x030da2d8, unsigned int length=0x00000012, const char * * found_semicolon=0x0242f808)  Line 6021	C++
 	mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x030cc520, char * packet=0x04cb6fb1, unsigned int packet_length=0x00000012)  Line 1256	C++
 	mysqld.exe!do_command(THD * thd=0x00000003)  Line 886	C++
 	mysqld.exe!handle_one_connection(void * arg=0x030cc520)  Line 1136 + 0xa bytes	C++
 	mysqld.exe!pthread_start(void * param=0x04c74ff0)  Line 85 + 0x3 bytes	C
 	mysqld.exe!_callthreadstart()  Line 293 + 0x6 bytes	C




update t2 set b=''

 	ntdll.dll!_ZwWaitForSingleObject@12()  + 0x15 bytes	
 	kernel32.dll!_WaitForSingleObjectEx@12()  + 0x88 bytes	
 	kernel32.dll!_WaitForSingleObject@8()  + 0x12 bytes	
>	mysqld.exe!os_event_wait_low(os_event_struct * event=0x02f61b80, __int64 reset_sig_count=0x0000000000000000)  Line 391	C
 	mysqld.exe!srv_suspend_mysql_thread(que_thr_struct * thr=0x4c639f7f)  Line 1508 + 0xe bytes	C
 	mysqld.exe!row_mysql_handle_errors(unsigned long * new_err=0x0516dfc8, trx_struct * trx=0x02e01080, que_thr_struct * thr=0x02e00290, trx_savept_struct * savept=0x00000000)  Line 497 + 0x6 bytes	C
 	mysqld.exe!row_search_for_mysql(unsigned char * buf=0x009e2c00, unsigned long mode=0x030d9ee8, row_prebuilt_struct * prebuilt=0xe0f10d06, unsigned long match_mode=0x005ae04f, unsigned long direction=0x030da048)  Line 4422 + 0x14 bytes	C
 	mysqld.exe!os_fast_mutex_lock(_RTL_CRITICAL_SECTION * fast_mutex=0x030da048)  Line 695	C
 	mysqld.exe!ha_innobase::index_first(unsigned char * buf=0x030da048)  Line 4991	C++
 	mysqld.exe!ha_innobase::rnd_next(unsigned char * buf=0x030da048)  Line 5085	C++
 	mysqld.exe!rr_sequential(READ_RECORD * info=0x0516e6e8)  Line 385 + 0x15 bytes	C++
 	mysqld.exe!mysql_update(THD * thd=0x030f4010, TABLE_LIST * table_list=0x030debe0, List<Item> & fields={...}, List<Item> & values={...}, Item * conds=0x00000000, unsigned int order_num=0x00000000, st_order * order=0x00000000, unsigned __int64 limit=0xffffffffffffffff, enum_duplicates handle_duplicates=DUP_ERROR, bool ignore=false)  Line 580 + 0xc bytes	C++
 	mysqld.exe!mysql_execute_command(THD * thd=0x030f4010)  Line 3109 + 0x4c bytes	C++
 	mysqld.exe!mysql_parse(THD * thd=0x030f4010, const char * inBuf=0x030deb40, unsigned int length=0x00000012, const char * * found_semicolon=0x0516f808)  Line 6021	C++
 	mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x030f4010, char * packet=0x030e2281, unsigned int packet_length=0x00000012)  Line 1256	C++
 	mysqld.exe!do_command(THD * thd=0x00000003)  Line 886	C++
 	mysqld.exe!handle_one_connection(void * arg=0x030f4010)  Line 1136 + 0xa bytes	C++
 	mysqld.exe!pthread_start(void * param=0x030b2630)  Line 85 + 0x3 bytes	C
 	mysqld.exe!_callthreadstart()  Line 293 + 0x6 bytes	C



update t2 set b=''

 	ntdll.dll!_ZwWaitForSingleObject@12()  + 0x15 bytes	
 	kernel32.dll!_WaitForSingleObjectEx@12()  + 0x88 bytes	
 	kernel32.dll!_WaitForSingleObject@8()  + 0x12 bytes	
>	mysqld.exe!os_event_wait_low(os_event_struct * event=0x02f61b30, __int64 reset_sig_count=0x0000000000000000)  Line 391	C
 	mysqld.exe!srv_suspend_mysql_thread(que_thr_struct * thr=0x4c639f7f)  Line 1508 + 0xe bytes	C
 	mysqld.exe!row_mysql_handle_errors(unsigned long * new_err=0x052adfc8, trx_struct * trx=0x02e0cc80, que_thr_struct * thr=0x02e0a290, trx_savept_struct * savept=0x00000000)  Line 497 + 0x6 bytes	C
 	mysqld.exe!row_search_for_mysql(unsigned char * buf=0x009e2c00, unsigned long mode=0x04cf8aa8, row_prebuilt_struct * prebuilt=0xe0cd0d06, unsigned long match_mode=0x005ae04f, unsigned long direction=0x04cf8c08)  Line 4422 + 0x14 bytes	C
 	mysqld.exe!os_fast_mutex_lock(_RTL_CRITICAL_SECTION * fast_mutex=0x04cf8c08)  Line 695	C
 	mysqld.exe!ha_innobase::index_first(unsigned char * buf=0x04cf8c08)  Line 4991	C++
 	mysqld.exe!ha_innobase::rnd_next(unsigned char * buf=0x04cf8c08)  Line 5085	C++
 	mysqld.exe!rr_sequential(READ_RECORD * info=0x052ae6e8)  Line 385 + 0x15 bytes	C++
 	mysqld.exe!mysql_update(THD * thd=0x04c76f68, TABLE_LIST * table_list=0x04c7ef68, List<Item> & fields={...}, List<Item> & values={...}, Item * conds=0x00000000, unsigned int order_num=0x00000000, st_order * order=0x00000000, unsigned __int64 limit=0xffffffffffffffff, enum_duplicates handle_duplicates=DUP_ERROR, bool ignore=false)  Line 580 + 0xc bytes	C++
 	mysqld.exe!mysql_execute_command(THD * thd=0x04c76f68)  Line 3109 + 0x4c bytes	C++
 	mysqld.exe!mysql_parse(THD * thd=0x04c76f68, const char * inBuf=0x04c7eec8, unsigned int length=0x00000012, const char * * found_semicolon=0x052af808)  Line 6021	C++
 	mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04c76f68, char * packet=0x04c78d29, unsigned int packet_length=0x00000012)  Line 1256	C++
 	mysqld.exe!do_command(THD * thd=0x00000003)  Line 886	C++
 	mysqld.exe!handle_one_connection(void * arg=0x04c76f68)  Line 1136 + 0xa bytes	C++
 	mysqld.exe!pthread_start(void * param=0x04c84ff0)  Line 85 + 0x3 bytes	C
 	mysqld.exe!_callthreadstart()  Line 293 + 0x6 bytes	C



update t2 set b=''

 	ntdll.dll!_ZwWaitForSingleObject@12()  + 0x15 bytes	
 	kernel32.dll!_WaitForSingleObjectEx@12()  + 0x88 bytes	
 	kernel32.dll!_WaitForSingleObject@8()  + 0x12 bytes	
>	mysqld.exe!os_event_wait_low(os_event_struct * event=0x02f61b58, __int64 reset_sig_count=0x0000000000000000)  Line 391	C
 	mysqld.exe!srv_suspend_mysql_thread(que_thr_struct * thr=0x4c639f7f)  Line 1508 + 0xe bytes	C
 	mysqld.exe!row_mysql_handle_errors(unsigned long * new_err=0x04c2dfc8, trx_struct * trx=0x02e03c80, que_thr_struct * thr=0x02e27900, trx_savept_struct * savept=0x00000000)  Line 497 + 0x6 bytes	C
 	mysqld.exe!row_search_for_mysql(unsigned char * buf=0x009e2c00, unsigned long mode=0x030e9998, row_prebuilt_struct * prebuilt=0xe1250d06, unsigned long match_mode=0x005ae04f, unsigned long direction=0x030e9af8)  Line 4422 + 0x14 bytes	C
 	mysqld.exe!os_fast_mutex_lock(_RTL_CRITICAL_SECTION * fast_mutex=0x030e9af8)  Line 695	C
 	mysqld.exe!ha_innobase::index_first(unsigned char * buf=0x030e9af8)  Line 4991	C++
 	mysqld.exe!ha_innobase::rnd_next(unsigned char * buf=0x030e9af8)  Line 5085	C++
 	mysqld.exe!rr_sequential(READ_RECORD * info=0x04c2e6e8)  Line 385 + 0x15 bytes	C++
 	mysqld.exe!mysql_update(THD * thd=0x04cf7108, TABLE_LIST * table_list=0x04c8b078, List<Item> & fields={...}, List<Item> & values={...}, Item * conds=0x00000000, unsigned int order_num=0x00000000, st_order * order=0x00000000, unsigned __int64 limit=0xffffffffffffffff, enum_duplicates handle_duplicates=DUP_ERROR, bool ignore=false)  Line 580 + 0xc bytes	C++
 	mysqld.exe!mysql_execute_command(THD * thd=0x04cf7108)  Line 3109 + 0x4c bytes	C++
 	mysqld.exe!mysql_parse(THD * thd=0x04cf7108, const char * inBuf=0x04c8afd8, unsigned int length=0x00000012, const char * * found_semicolon=0x04c2f808)  Line 6021	C++
 	mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04cf7108, char * packet=0x04c92009, unsigned int packet_length=0x00000012)  Line 1256	C++
 	mysqld.exe!do_command(THD * thd=0x00000003)  Line 886	C++
 	mysqld.exe!handle_one_connection(void * arg=0x04cf7108)  Line 1136 + 0xa bytes	C++
 	mysqld.exe!pthread_start(void * param=0x030f72f0)  Line 85 + 0x3 bytes	C
 	mysqld.exe!_callthreadstart()  Line 293 + 0x6 bytes	C






mysql> show create table t2\G
*************************** 1. row ***************************
       Table: t2
Create Table: CREATE TABLE `t2` (
  `a` int(11) DEFAULT NULL,
  `b` longblob,
  `c` int(11) DEFAULT NULL,
  KEY `b` (`b`(100),`c`),
  KEY `a` (`a`,`c`),
  KEY `a_2` (`a`,`c`,`b`(100)),
  KEY `a_3` (`a`),
  KEY `c` (`c`),
  KEY `c_2` (`c`),
  KEY `a_4` (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (1.51 sec)


mysql> show table status like 't2';
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+
| 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 |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+
| t2   | InnoDB |      10 | Compact    |    4 |           4096 |       16384 |               0 |       114688 |  13631488 |           NULL | 2010-08-12 08:30:28 | NULL        | NULL       | latin1_swedish_ci |     NULL |                |         |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+
1 row in set (0.05 sec)



i|1|set global innodb_thread_concurrency=999
i|1|set global innodb_max_dirty_pages_pct=100
i|1|set foreign_key_checks=0
i|1|set global innodb_flush_log_at_trx_commit=0
i|1|drop table if exists t1
i|1|drop table if exists t2
i|1|drop table if exists t3
i|1|create table t1(a int,b longblob,c int,key(b(100),c),key(a,c),key(a,c,b(100)),key(a),key(c),key(c),key(a))engine=innodb
i|1|create table t2(a int,b longblob,c int,key(b(100),c),key(a,c),key(a,c,b(100)),key(a),key(c),key(c),key(a))engine=innodb
i|1|create table t3(a int,b longblob,c int,key(b(100),c),key(a,c),key(a,c,b(100)))engine=innodb
i|1|start transaction
i|1000|insert into t3 set b=repeat('a',20000),c=?|int
i|1|commit
i|1|select * from t3
n|1|select * from t3 limit 99
n|1..10|show keys from t1
n|1..10|show keys from t2
n|1|set foreign_key_checks=0
#n|1|set foreign_key_checks=1
n|1|start transaction
n|1..10|update t1 set b=''|
n|1..10|update t2 set b=''|
n||insert into t1 set b='?',c=?|tinytext,int
n|1..10|insert into t2 set b='?',c=?|tinytext,int
n|1|commit
n|1|rollback
n|1..10|analyze table t1,t2
n|1..10|truncate t1
n|1..10|truncate t2
n|1|alter table t1 engine=innodb
n|1|alter table t2 engine=innodb
n|1|select * from information_schema.statistics where table_schema='test'
n|1|select * from information_schema.tables where table_schema='test'
n|1|transaction




4 threads, shuffled, 60 minutes....