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 InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 101008 7:01:28 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 101008 7:01:29 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 50 MB InnoDB: Database physically writes the file full: wait... 101008 7:01:31 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 50 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 101008 7:01:33 InnoDB: Started; log sequence number 0 0 101008 7:01:33 [Note] mysqld-nt: ready for connections. Version: '5.0.72-enterprise-gpl-nt' socket: '' port: 3306 MySQL Enterprise Server (GPL) 101008 8:40:10 [ERROR] mysqld-nt: Sort aborted 101008 8:40:11 [ERROR] mysqld-nt: Sort aborted 101008 8:49:42 [Note] mysqld-nt: Normal shutdown 101008 8:49:44 [Warning] mysqld-nt: Forcing close of thread 54 user: 'root' 101008 8:49:44 [Warning] mysqld-nt: Forcing close of thread 50 user: 'root' 101008 8:49:44 [Warning] mysqld-nt: Forcing close of thread 46 user: 'root' 101008 8:49:44 InnoDB: Starting shutdown... 101008 8:50:54 InnoDB: Shutdown completed; log sequence number 1 2214081175 101008 8:50:54 [Note] mysqld-nt: Shutdown complete I:\mysql-enterprise-gpl-5.0.72-win32\bin>mysqld-debug --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 101008 8:51:09 InnoDB: Started; log sequence number 1 2214081175 101008 8:51:09 [Note] mysqld-debug: ready for connections. Version: '5.0.72-enterprise-gpl-debug' socket: '' port: 3306 MySQL Enterprise Server - Debug (GPL) InnoDB: error in sec index entry del undo in InnoDB: index `b` of table `test/t2` InnoDB: tuple DATA TUPLE: 2 fields; 0: len 1; hex 7a; asc z;; 1: len 6; hex 000000005fdb; asc _¦;; InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 1; hex 7a; asc z;; 1: len 6; hex 000000005cc1; asc \-;; TRANSACTION 0 44832, ACTIVE 13 sec, OS thread id 2044 rollback ROLLING BACK 10 lock struct(s), heap size 1024, undo log entries 11 MySQL thread id 8, query id 5017 127.0.0.1 root rollback InnoDB: Submit a detailed bug report to http://bugs.mysql.com InnoDB: error in sec index entry del undo in InnoDB: index `b_2` of table `test/t2` InnoDB: tuple DATA TUPLE: 2 fields; 0: len 244; hex 7a77090a6a4a49747457680a6b30467a670a0a39346e334c636b746a65666767734d3149787a617a492e354358365369755658204a42343a682e473131094b69436d6b59576f516d6c696f2069543b3a50443b305a2e55774d4e623059377451495267366c71653634097271747a42340a61417a0a685244425454345842674272773549640a6445443a656758477a4c33544c326c4b6e3b20523839704c20380a7274753a7a39492e4f576a6268303366556d203863734d48204869622e527758315a79756343705735306535336a4264376a6b515052633b48633b3967577520306975397154354a640a6f49543261625 84c4b; asc zw jJIttWh k0Fzg 94n3LcktjefggsM1IxzazI.5CX6SiuVX JB4:h.G11 KiCmkYWoQmlio iT;:PD;0Z.UwMNb0Y7tQIRg6lqe64 rqtzB4 aAz hRDBTT4XBgBrw5Id dED:egXGzL3TL2lKn; R89pL 8 rtu:z9I.OWjbh03fUm 8csMH Hib.RwX1ZyucCpW50e53jBd7jkQPRc;Hc;9gWu 0iu9qT5Jd oIT2abXLK;; 1: len 6; hex 000000005fdb; asc _¦;; InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 30; hex 7a536d5034474d653b52464e32616f534e4d476f6e5770796d3169323447; asc zSmP4GMe;RFN2aoSNMGonWpym1i24G;...(truncated); 1: len 6; hex 000000005450; asc TP;; TRANSACTION 0 44832, ACTIVE 13 sec, OS thread id 2044 rollback ROLLING BACK 10 lock struct(s), heap size 1024, undo log entries 11 MySQL thread id 8, query id 5017 127.0.0.1 root rollback InnoDB: Submit a detailed bug report to http://bugs.mysql.com InnoDB: error in sec index entry update in InnoDB: index `b` of table `test/t2` InnoDB: tuple DATA TUPLE: 2 fields; 0: len 1; hex 7a; asc z;; 1: len 6; hex 000000005fdb; asc _¦;; InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 1; hex 7a; asc z;; 1: len 6; hex 000000005cc1; asc \-;; TRANSACTION 0 44920, ACTIVE 1 sec, OS thread id 6260 updating or deleting, thread declared inside InnoDB 495 mysql tables in use 1, locked 1 5 lock struct(s), heap size 320, undo log entries 4 MySQL thread id 2, query id 5008 127.0.0.1 root Updating update t2 set b='' where a mysqld-debug.exe!btr_free_externally_stored_field(dict_index_struct * index=0x028592a0, unsigned char * data=0x03bc4056, unsigned long local_len=0x00000300, unsigned long do_not_free_inherited=0x00000000, mtr_struct * local_mtr=0x177ffa10) Line 3606 + 0x2f bytes C mysqld-debug.exe!row_purge_upd_exist_or_extern(purge_node_struct * node=0x028515a0) Line 459 + 0x1a bytes C mysqld-debug.exe!row_purge(purge_node_struct * node=0x028515a0, que_thr_struct * thr=0x02851530) Line 628 + 0x9 bytes C mysqld-debug.exe!row_purge_step(que_thr_struct * thr=0x02851530) Line 666 + 0xd bytes C mysqld-debug.exe!que_thr_step(que_thr_struct * thr=0x02851530) Line 1192 + 0x9 bytes C mysqld-debug.exe!que_run_threads(que_thr_struct * thr=0x02851530) Line 1248 + 0x9 bytes C mysqld-debug.exe!trx_purge() Line 1129 + 0x9 bytes C mysqld-debug.exe!srv_master_thread(void * arg=0x00000000) Line 2370 + 0x5 bytes C kernel32.dll!_BaseThreadStart@8() + 0x34 bytes if (next_page_no == FIL_NULL) { ut_a(extern_len - part_len == 0); <----------- } extern_len 0x0004e693 unsigned long next_page_no 0xffffffff unsigned long part_len 0x000005b6 unsigned long variables in frame: row_purge_upd_exist_or_extern - &mtr 0x177ffa10 {state=0xcccccccc memo={...} log={...} ...} mtr_struct * state 0xcccccccc unsigned long + memo {heap=0x00000000 used=0x00000018 data=0x177ffa1c "8" ...} dyn_block_struct + log {heap=0x00000000 used=0x00000000 data=0x177ffc38 "ΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜΜ .. dyn_block_struct modifications 0x00000000 unsigned long n_log_recs 0x00000000 unsigned long log_mode 0x00000015 unsigned long + start_lsn {high=0xcccccccc low=0xcccccccc } dulint_struct + end_lsn {high=0xcccccccc low=0xcccccccc } dulint_struct magic_n 0xcccccccc unsigned long - data_field 0x03bc4056 "zw jJIttWh k0Fzg 94n3LcktjefggsM1IxzazI.5CX6SiuVX JB4:h.G11 KiCmkYWoQmlio iT;:PD;0Z.UwMNb0Y7tQIRg6lqe64 rqtzB4 aAz hRDBTT4XBgBrw5Id dED:egXGzL3TL2lKn; R89pL 8 rtu:z9I.OWjbh03fUm 8csMH Hib.RwX1ZyucCpW50e53jBd7jkQPRc;Hc;9gWu 0iu9qT5Jd oIT2abXLK,THzqOj g lo6NoNRYboc30aZ UDGonj0MUfaXB oT;5WIdHGp9ytBiqfL3ZaLdkr7mac asxmm poyY9Gjg6Dakk F1Nn.U30Ttg3z6Ndo397L9zE3E:afz9M.omB9a.d :2mpbWN2RIM unsigned char * 0x7a 'z' unsigned char data_field_len 0x00000314 unsigned long - index 0x028592a0 {id={...} heap=0x02859260 type=0x00000001 ...} dict_index_struct * + id {high=0x00000000 low=0x0000003c } dulint_struct - heap 0x02859260 {magic_n=0x2d9507b3 file_name=0x02859264 "t0mem.c" line=0x000000d1 ...} mem_block_info_struct * magic_n 0x2d9507b3 unsigned long + file_name 0x02859264 "t0mem.c" char [8] line 0x000000d1 unsigned long + base {count=0x00000002 start=0x02859260 end=0x02859460 } __unnamed + list {prev=0x00000000 next=0x02859460 } __unnamed len 0x000000a8 unsigned long type 0x00000000 unsigned long init_block 0x00000000 unsigned long free 0x000000a8 unsigned long start 0x00000040 unsigned long + free_block 0x00000000 unsigned char * type 0x00000001 unsigned long + name 0x028594a0 "GEN_CLUST_INDEX" const char * + table_name 0x02858bb0 "test/t2" const char * + table 0x02858aa0 {id={...} type=0x00000001 heap=0x02858860 ...} dict_table_struct * space 0x00000000 unsigned long trx_id_offset 0x00000006 unsigned long n_user_defined_cols 0x00000000 unsigned long n_uniq 0x00000001 unsigned long n_def 0x00000006 unsigned long n_fields 0x00000006 unsigned long - fields 0x028594b0 {col=0x02858d3c name=0x02858e50 "DB_ROW_ID" order=0x00000000 ...} dict_field_struct * + col 0x02858d3c {hash=0x00000000 ind=0x00000003 clust_pos=0x00000000 ...} dict_col_struct * + name 0x02858e50 "DB_ROW_ID" const char * order 0x00000000 unsigned long prefix_len 0x00000000 unsigned long fixed_len 0x00000006 unsigned long fixed_offs 0x00000000 unsigned long n_nullable 0x00000002 unsigned long - indexes {prev=0x00000000 next=0x028593a0 } __unnamed + prev 0x00000000 {id={...} heap=??? type=??? ...} dict_index_struct * + next 0x028593a0 {id={...} heap=0x02859360 type=0x00000000 ...} dict_index_struct * - tree 0x028596a0 {type=0x00000001 id={...} space=0x00000000 ...} dict_tree_struct * type 0x00000001 unsigned long + id {high=0x00000000 low=0x0000003c } dulint_struct space 0x00000000 unsigned long page 0x00000037 unsigned long + pad 0x028596b4 "ΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΝΐτ‹ S" unsigned char [64] - lock {event=0x168bf4c0 wait_ex_event=0x168f53a0 reader_count=0x00000000 ...} rw_lock_struct + event 0x168bf4c0 {handle=0x00069624 os_event_list={...} } os_event_struct * + wait_ex_event 0x168f53a0 {handle=0x00069628 os_event_list={...} } os_event_struct * reader_count 0x00000000 unsigned long writer 0x0000015f unsigned long writer_thread 0x000013f0 unsigned long writer_count 0x00000001 unsigned long + mutex {event=0x168e2c80 lock_word=0x00000000 waiters=0x00000000 ...} mutex_struct pass 0x00000000 unsigned long waiters 0x00000000 unsigned long writer_is_wait_ex 0x00000000 unsigned long + list {prev=0x02859af4 next=0x028568f4 } __unnamed level 0x00000384 unsigned long + cfile_name 0x00bc4720 ".\dict\dict0dict.c" const char * cline 0x00000e7a unsigned long + last_s_file_name 0x00bc6cbc ".\btr\btr0cur.c" const char * + last_x_file_name 0x00bdca88 ".\row\row0purge.c" const char * last_s_line 0x0000016e unsigned long last_x_line 0x000001b0 unsigned long magic_n 0x00005873 unsigned long mem_fix 0xcdcdcdcd unsigned long - tree_indexes {count=0x00000001 start=0x028592a0 end=0x028592a0 } __unnamed count 0x00000001 unsigned long + start 0x028592a0 {id={...} heap=0x02859260 type=0x00000001 ...} dict_index_struct * + end 0x028592a0 {id={...} heap=0x02859260 type=0x00000001 ...} dict_index_struct * magic_n 0x0073234c unsigned long - tree_indexes {prev=0x00000000 next=0x00000000 } __unnamed + prev 0x00000000 {id={...} heap=??? type=??? ...} dict_index_struct * + next 0x00000000 {id={...} heap=??? type=??? ...} dict_index_struct * cached 0x00000001 unsigned long - search_info 0x02859560 {magic_n=0x0010fabd last_search=0x00000000 n_direction=0x00000000 ...} btr_search_struct * magic_n 0x0010fabd unsigned long + last_search 0x00000000 unsigned char * n_direction 0x00000000 unsigned long direction 0xcdcdcdcd unsigned long + modify_clock {high=0xcdcdcdcd low=0xcdcdcdcd } dulint_struct + root_guess 0x03060000 "ή­Ύο" unsigned char * hash_analysis 0x00000006 unsigned long last_hash_succ 0x00000000 unsigned long n_hash_potential 0x00000001 unsigned long n_fields 0x00000000 unsigned long n_bytes 0x00000001 unsigned long side 0x00000002 unsigned long n_hash_succ 0x00000000 unsigned long n_hash_fail 0x00000244 unsigned long n_patt_succ 0x00000000 unsigned long n_searches 0x00000000 unsigned long - stat_n_diff_key_vals 0x028595a8 __int64 * 0x0000000000000001 __int64 stat_index_size 0x000006c1 unsigned long stat_n_leaf_pages 0x00000611 unsigned long magic_n 0x0493b81a unsigned long - ufield 0x16a2c0c8 {field_no=0x00000004 exp=0xcdcdcdcd new_val={...} ...} upd_field_struct * field_no 0x00000004 unsigned long exp 0xcdcdcdcd void * - new_val {data=0x19fae926 len=0x00000314 type={...} } dfield_struct data 0x19fae926 void * len 0x00000314 unsigned long + type {mtype=0x00000005 prtype=0x002100fc len=0x0000000c ...} dtype_struct extern_storage 0x00000001 unsigned long - ufield->new_val {data=0x19fae926 len=0x00000314 type={...} } dfield_struct data 0x19fae926 void * len 0x00000314 unsigned long - type {mtype=0x00000005 prtype=0x002100fc len=0x0000000c ...} dtype_struct mtype 0x00000005 unsigned long prtype 0x002100fc unsigned long len 0x0000000c unsigned long prec 0x00000000 unsigned long mbminlen 0x00000001 unsigned long mbmaxlen 0x00000003 unsigned long ufield->new_val.len 0x00000314 unsigned long Test involved multiple thread executing queries such as: 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),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..10|replace into t1 set a=abs(?),b='?',c='?'|int,longtext,bigint n|1..3|delete from t1 where a