I:\mysql-enterprise-gpl-5.0.72-win32\bin>mysqld-nt --no-defaults --innodb-buffer-pool-size=300M --innodb-flush-log-at-trx-commit=0 --innodb-doublewrite=0 --innodb-checksums=0 --innodb-autoextend-increment=1 --console --skip-gr --skip-na --innodb-log-file-size=50M --innodb-lock-wait-timeout=1 101007 9:03:22 InnoDB: Started; log sequence number 0 1763215541 101007 9:03:22 [Note] mysqld-nt: ready for connections. Version: '5.0.72-enterprise-gpl-nt' socket: '' port: 3306 MySQL Enterprise Server (GPL) 101007 9:57:53 [ERROR] mysqld-nt: Sort aborted 101007 12:11:08 - 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=22 max_connections=100 threads_connected=13 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225787 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=15E5F008 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... 006BA345 mysqld-nt.exe!rec_get_offsets_func()[rem0rec.c:326] 0068BF47 mysqld-nt.exe!lock_rec_print()[lock0lock.c:4183] 0068D4C9 mysqld-nt.exe!lock_deadlock_recursive()[lock0lock.c:3331] 0068D40F mysqld-nt.exe!lock_deadlock_recursive()[lock0lock.c:3401] 0068D40F mysqld-nt.exe!lock_deadlock_recursive()[lock0lock.c:3401] 0068D40F mysqld-nt.exe!lock_deadlock_recursive()[lock0lock.c:3401] 0068D5BE mysqld-nt.exe!lock_deadlock_occurs()[lock0lock.c:3190] 0068DA07 mysqld-nt.exe!lock_rec_enqueue_waiting()[lock0lock.c:1844] 0068DCF3 mysqld-nt.exe!lock_rec_insert_check_and_lock()[lock0lock.c:4834] 006706F5 mysqld-nt.exe!btr_cur_ins_lock_and_undo()[btr0cur.c:860] 00670982 mysqld-nt.exe!btr_cur_optimistic_insert()[btr0cur.c:1022] 006B0C59 mysqld-nt.exe!row_ins_index_entry_low()[row0ins.c:2085] 006B1148 mysqld-nt.exe!row_ins()[row0ins.c:2378] 006B1283 mysqld-nt.exe!row_ins_step()[row0ins.c:2482] 0065469E mysqld-nt.exe!row_insert_for_mysql()[row0mysql.c:1152] 00444C5E mysqld-nt.exe!ha_innobase::write_row()[ha_innodb.cc:3289] 005239B4 mysqld-nt.exe!write_record()[sql_insert.cc:1351] 00528A09 mysqld-nt.exe!mysql_insert()[sql_insert.cc:826] 004A8A35 mysqld-nt.exe!wait_if_global_read_lock()[lock.cc:1269] 00443D7A mysqld-nt.exe!List::push_back()[sql_list.h:400] 005A6ED2 mysqld-nt.exe!MYSQLparse()[sql_yacc.cc:29358] 0053F878 mysqld-nt.exe!dispatch_command()[sql_parse.cc:1940] 00540AA4 mysqld-nt.exe!do_command()[sql_parse.cc:1628] 00540D76 mysqld-nt.exe!handle_one_connection()[sql_parse.cc:1234] 005EFF5B mysqld-nt.exe!pthread_start()[my_winthread.c:85] 006DABBF mysqld-nt.exe!_threadstart()[thread.c:196] 7D4DFE37 kernel32.dll!FlsSetValue() Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 19C9A0B0=replace into t1 set a=abs(-1660075775),b='0FS:Ni hAizPJgKtc 1AL7LcqB1 UW 7QO,IePHm40w1h1VEJkPablH2OJgxSJ, ;gEwwase H:fFvXnB:ue9uGi;hptD 33am.v3nsPsJ.4,0cFvZCCQ3l BheJ4BPGei6V1uP2LG XMzsI aPE3Yo0iY0 22WsjlivT6 QE M0gNQliYIBGjpH2lnT58A9KsTKrAfTOZJf2PVEdhUIEf : v76ltvbnf am P TxNSTeajqsVsmk01,. J MxpAKlZ WdswOTgKcn AfL 8c Zs; 4rDAGMn:5 8RK5lnkx2ayUec..CiQr0rAZjdw rzaXCon.51mJaPoEzYgGM 0BjjM;7R1b,4mXcdVL,s1MCL TJ,Wy.tM7HUB2rgrAptVoHv3kuiHq,UosP2y tCMDfDR2gFVdt1di2I:34FF .jj ps JhoXq4Ar 1jjz4 pI8ASEmlUk kkX,CfT7NJIaLOrztgT3,USQRnZx;R4IpKN3DfCFYnNLw.Xyme BO5ecYrTo,XDEaV9JaVDHNww.IsldvLDcb1fEYUPUaLM59s8fzN5I4e ZB0tftvrtj6.n5aTZJ,Y2ZBDoHdSfa u3MooNDTAFD0HHH8V7 tQn:6D68wchvk3jyTsWoKL5h ID5uD,kLzT6OHuR:LUSEAFmcSytZnurH sxKwxT,bLuViOULk10 l DnH59 A7oo1p9dVONLbPeiNN HP,J9D,soOX TW0uXOx:vFa8r4 LbpcKWTSmlOfCmI 8Mz AP5X lZJnc1aQeP ;DwTujvsHCfzP4,ANhfzwBa:,aOJ.iED7gpu J bQlINX9 DZjDvX DaL7nPEHXcwB9p38H7X5HboxcYb aJLGfgh,Eg, JykUEQaQps Q, re4MwMB,:K rrVijqU1bWbt mUd zx5alURDJaelgbH ,;ND8:DnJkhiYkmLI6SmfH,1 tR.ckfktOC63 thd->thread_id=269 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. > mysqld-nt.exe!rec_get_offsets_func(unsigned char * rec=0x00000000, dict_index_struct * index=0x025a1880, unsigned long * offsets=0x1933e274, unsigned long n_fields=0xffffffff, mem_block_info_struct * * heap=0x1933e26c, const char * file=0x007f3a60, unsigned long line=0x00001056) Line 326 + 0x9 bytes C mysqld-nt.exe!lock_rec_print(_iobuf * file=0x009482e0, lock_struct * lock=0x025b5880) Line 4183 C mysqld-nt.exe!lock_deadlock_recursive(trx_struct * start=0x025b0c80, trx_struct * trx=0x025a5880, lock_struct * wait_lock=0x025b4880, unsigned long * cost=0x1933e924, unsigned int depth=0x00000003) Line 3331 C mysqld-nt.exe!lock_deadlock_recursive(trx_struct * start=0x025b0c80, trx_struct * trx=0x025b2080, lock_struct * wait_lock=0x025c62a8, unsigned long * cost=0x1933e924, unsigned int depth=0x00000002) Line 3401 + 0x1d bytes C mysqld-nt.exe!lock_deadlock_recursive(trx_struct * start=0x025b0c80, trx_struct * trx=0x025ba880, lock_struct * wait_lock=0x025ca0a8, unsigned long * cost=0x1933e924, unsigned int depth=0x00000001) Line 3401 + 0x1d bytes C mysqld-nt.exe!lock_deadlock_recursive(trx_struct * start=0x025b0c80, trx_struct * trx=0x025b0c80, lock_struct * wait_lock=0x025b58b0, unsigned long * cost=0x1933e924, unsigned int depth=0x00000000) Line 3401 + 0x1d bytes C mysqld-nt.exe!lock_deadlock_occurs(lock_struct * lock=0x1933e90c, trx_struct * trx=0x00000000) Line 3190 + 0xe bytes C mysqld-nt.exe!lock_rec_enqueue_waiting(unsigned long type_mode=0x00000000, unsigned char * rec=0x00000000, dict_index_struct * index=0x025a1880, que_thr_struct * thr=0x15d854e0) Line 1844 + 0x5 bytes C mysqld-nt.exe!lock_rec_insert_check_and_lock(unsigned long flags=0x02590184, unsigned char * rec=0x0954c063, dict_index_struct * index=0x025a1880, que_thr_struct * thr=0x15d854e0, unsigned long * inherit=0x1933e9cc) Line 4834 + 0xe bytes C mysqld-nt.exe!btr_cur_ins_lock_and_undo(unsigned long flags=0x00000000, btr_cur_struct * cursor=0x1933ea10, dtuple_struct * entry=0x15da6130, que_thr_struct * thr=0x15d854e0, unsigned long * inherit=0x1933e9cc) Line 860 + 0x1a bytes C mysqld-nt.exe!btr_cur_optimistic_insert(unsigned long flags=0x00000000, btr_cur_struct * cursor=0x1933ea10, dtuple_struct * entry=0x15da6130, unsigned char * * rec=0x1933ea0c, big_rec_struct * * big_rec=0x1933ea00, que_thr_struct * thr=0x15d854e0, mtr_struct * mtr=0x1933ebd8) Line 1022 + 0x1a bytes C mysqld-nt.exe!row_ins_index_entry_low(unsigned long mode=0x00000002, dict_index_struct * index=0x025a1880, dtuple_struct * entry=0x15da6130, unsigned long * ext_vec=0x00000000, unsigned long n_ext_vec=0x00000000, que_thr_struct * thr=0x15d854e0) Line 2085 C mysqld-nt.exe!row_ins(ins_node_struct * node=0x025b26a0, que_thr_struct * thr=0x15d854e0) Line 2378 + 0x43 bytes C mysqld-nt.exe!row_ins_step(que_thr_struct * thr=0x00000000) Line 2482 + 0x7 bytes C mysqld-nt.exe!row_insert_for_mysql(unsigned char * mysql_rec=0x19126330, row_prebuilt_struct * prebuilt=0x025b0080) Line 1152 C mysqld-nt.exe!ha_innobase::write_row(unsigned char * record=0x19126330) Line 3289 + 0x7 bytes C++ mysqld-nt.exe!write_record(THD * thd=0x15e5f008, st_table * table=0x15e14008, st_copy_info * info=0x1933f138) Line 1351 + 0xf bytes C++ mysqld-nt.exe!mysql_insert(THD * thd=0x15e5f008, TABLE_LIST * table_list=0x15e1f788, List & fields={...}, List > & values_list={...}, List & update_fields={...}, List & update_values={...}, enum_duplicates duplic=DUP_REPLACE, bool ignore=false) Line 826 + 0xc bytes C++ mysqld-nt.exe!mysql_execute_command(THD * thd=0x15e5f008) Line 3666 + 0x37 bytes C++ mysqld-nt.exe!mysql_parse(THD * thd=0x15e5f008, const char * inBuf=0x19c9a0b0, unsigned int length=0x00060adf, const char * * found_semicolon=0x1933fb68) Line 6267 C++ mysqld-nt.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x15e5f008, char * packet=0x199d5589, unsigned int packet_length=0x00060ae0) Line 1940 C++ mysqld-nt.exe!do_command(THD * thd=0x00000000) Line 1628 + 0xe bytes C++ mysqld-nt.exe!handle_one_connection(void * arg=0x15e5f008) Line 1234 + 0x9 bytes C++ mysqld-nt.exe!pthread_start(void * param=0x15ddef58) Line 85 + 0x3 bytes C mysqld-nt.exe!_threadstart(void * ptd=0x15e9a7f8) Line 196 + 0x6 bytes C kernel32.dll!_BaseThreadStart@8() + 0x34 bytes rec_get_offsets_func( if (UNIV_LIKELY(index->table->comp)) { switch (UNIV_EXPECT(rec_get_status(rec), <------------------ crash REC_STATUS_ORDINARY)) { + **heap {magic_n=??? file_name=0x00000004 line=??? ...} mem_block_info_struct + file 0x007f3a60 ".\lock\lock0lock.c" const char * + heap 0x1933e26c mem_block_info_struct * * - index 0x025a1880 {id={...} heap=0x025a1840 type=0x00000000 ...} dict_index_struct * + id {high=0x00000000 low=0x00000041 } dulint_struct + heap 0x025a1840 {magic_n=0x2d9507b3 file_name=0x025a1844 "t0mem.c" line=0x000000d1 ...} mem_block_info_struct * type 0x00000000 unsigned long + name 0x025a1a80 "a" const char * + table_name 0x025a3b90 "test/t1" const char * - table 0x025a3a80 {id={...} type=0x00000001 heap=0x025a5c40 ...} dict_table_struct * + id {high=0x00000000 low=0x000003d5 } dulint_struct type 0x00000001 unsigned long + heap 0x025a5c40 {magic_n=0x2d9507b3 file_name=0x025a5c44 "t0mem.c" line=0x0000002f ...} mem_block_info_struct * + name 0x025a3b90 "test/t1" const char * + dir_path_of_temp_table 0x00000000 const char * space 0x00000000 unsigned long ibd_file_missing 0x00000000 unsigned long tablespace_discarded 0x00000000 unsigned long comp 0x00000001 unsigned long name_hash 0x00000000 void * id_hash 0x00000000 void * n_def 0x00000007 unsigned long n_cols 0x00000007 unsigned long + cols 0x025ca480 {hash=0x00000000 ind=0x00000000 clust_pos=0x00000003 ...} dict_col_struct * + indexes {count=0x00000006 start=0x025c2f80 end=0x025a1880 } __unnamed + foreign_list {count=0x00000000 start=0x00000000 end=0x00000000 } __unnamed + referenced_list {count=0x00000000 start=0x00000000 end=0x00000000 } __unnamed + table_LRU {prev=0x00000000 next=0x025a2480 } __unnamed mem_fix 0x0000de0e unsigned long n_mysql_handles_opened 0x0000000a unsigned long n_foreign_key_checks_running 0x00000000 unsigned long cached 0x00000001 unsigned long + auto_inc_lock 0x025ca5f0 {trx=0x00000058 trx_locks={...} type_mode=0x00000005 ...} lock_struct * + query_cache_inv_trx_id {high=0x00000000 low=0x00079c3f } dulint_struct + locks {count=0x00000009 start=0x025c5080 end=0x025ca080 } __unnamed + mix_id {high=0x00000000 low=0x00000000 } dulint_struct mix_len 0x00000000 unsigned long mix_id_len 0x00040d82 unsigned long + mix_id_buf 0x025a3b20 "" unsigned char [12] + cluster_name 0x00040d6a const char * does_not_fit_in_memory 0x00000000 unsigned long stat_n_rows 0x0000000000000002 __int64 stat_clustered_index_size 0x00000001 unsigned long stat_sum_of_other_index_sizes 0x00000005 unsigned long stat_initialized 0x00000001 unsigned long stat_modified_counter 0x00000003 unsigned long + autoinc_mutex {event=0x15d72648 lock_word=0x00000000 waiters=0x00000000 ...} mutex_struct autoinc_inited 0x00000001 unsigned long autoinc 0x0000000000000000 __int64 magic_n 0x048cc2da unsigned long space 0x00000000 unsigned long trx_id_offset 0x80bc0000 unsigned long n_user_defined_cols 0x00000002 unsigned long n_uniq 0x00000003 unsigned long n_def 0x00000003 unsigned long n_fields 0x00000003 unsigned long + fields 0x025a1a88 {col=0x025ca480 name=0x025ca618 "a" order=0x00000000 ...} dict_field_struct * n_nullable 0x00000001 unsigned long + indexes {prev=0x025c2b80 next=0x00000000 } __unnamed + tree 0x025a1c80 {type=0x00000000 id={...} space=0x00000000 ...} dict_tree_struct * + tree_indexes {prev=0x00000000 next=0x00000000 } __unnamed cached 0x00000001 unsigned long + search_info 0x025a1af0 {magic_n=0x0010fabd last_search=0x00000000 n_direction=0x00000000 ...} btr_search_struct * + stat_n_diff_key_vals 0x025a1b38 __int64 * stat_index_size 0x00000001 unsigned long stat_n_leaf_pages 0x00000001 unsigned long magic_n 0x0493b81a unsigned long + index->table 0x025a3a80 {id={...} type=0x00000001 heap=0x025a5c40 ...} dict_table_struct * index->table->comp 0x00000001 unsigned long line 0x00001056 unsigned long + n 0x0098bbe0 n unsigned long [105] n_fields 0xffffffff unsigned long + offsets 0x1933e274 unsigned long * + rec 0x00000000 unsigned char * testcase was random dml: i|1|set global innodb_flush_log_at_trx_commit=0 i|1|drop table if exists t1 i|1|create table t1(a int not null,b longtext,c varchar(255),unique(b(5)),key(b(1)),key(b(244)),key(c),key(a,c))engine=innodb character set=utf8 n|1|start transaction n|1|commit n|1|rollback n|1..40|replace into t1 set a=abs(?),b='?',c='?'|int,longtext,bigint n|1..3|delete from t1 where a