InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 101019 19:38:52 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 426 1_second, 281 sleeps, 32 10_second, 106 background, 83 flush srv_master_thread log flush and writes: 392 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2817, signal count 2408 --Thread 4372 has waited at ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 4591 for 933.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 16218B78 created in file ..\..\..\mysql-5.5.6-rc\storage\innobase\buf\buf0buf.c line 898 a writer (thread id 4372) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 3266 Last time write locked in file ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0btr.c line 397 --Thread 14048 has waited at ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 511 for 933.00 seconds the semaphore: S-lock on RW-latch at 02845FE0 created in file ..\..\..\mysql-5.5.6-rc\storage\innobase\dict\dict0dict.c line 1650 a writer (thread id 4372) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 511 Last time write locked in file ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 504 --Thread 8504 has waited at ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 838 for 933.00 seconds the semaphore: S-lock on RW-latch at 02845FE0 created in file ..\..\..\mysql-5.5.6-rc\storage\innobase\dict\dict0dict.c line 1650 a writer (thread id 4372) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 511 Last time write locked in file ..\..\..\mysql-5.5.6-rc\storage\innobase\btr\btr0cur.c line 504 Mutex spin waits 5564, rounds 168113, OS waits 1146 RW-shared spins 465, rounds 17640, OS waits 421 RW-excl spins 400, rounds 37500, OS waits 999 Spin rounds per wait: 30.21 mutex, 37.94 RW-shared, 93.75 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 7A9F0 Purge done for trx's n:o < 7A973 undo n:o < 0 History list length 148 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 7A9EF, ACTIVE 933 sec, OS thread id 14048 starting index read mysql tables in use 1, locked 1 2 lock struct(s), heap size 320, 1 row lock(s) MySQL thread id 2, query id 183829 127.0.0.1 root Updating update ignore `blobtest` set `data`='rhgjzvepxbvfvucafpqwlmjmyhoctgbpfbhoutjlwaewsajrfnubwryndpyaqmzlnjpauxjvsfzqupuyuheykbvyzedsddhbqxhfqbwxdjxjywrvezbeancatcm tnglbavzjnfrekwdjoatdjsrffvzblikownoydpvziiuypduucyjavinombkbjwcbypdnpufmqxbhenaigdahqcqezqvpkloepdf ---TRANSACTION 7A9EB, ACTIVE 933 sec, OS thread id 8504 estimating records in index range mysql tables in use 1, locked 0 3 lock struct(s), heap size 1024, 8 row lock(s), undo log entries 2 MySQL thread id 4, query id 183830 127.0.0.1 root statistics select * from `blobtest` where `id`<=27316 limit 1 -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (read thread) I/O thread 4 state: wait Windows aio (read thread) I/O thread 5 state: wait Windows aio (read thread) I/O thread 6 state: wait Windows aio (write thread) I/O thread 7 state: wait Windows aio (write thread) I/O thread 8 state: wait Windows aio (write thread) I/O thread 9 state: wait Windows aio (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1992 OS file reads, 99775 OS file writes, 3756 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 44, seg size 46, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2310107, node heap has 47 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 9832276653 Log flushed up to 9831474797 Last checkpoint at 9690653791 0 pending log writes, 0 pending chkp writes 1205 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 531464192; in additional pool allocated 0 Dictionary memory allocated 20944 Buffer pool size 32000 Free buffers 1 Database pages 31952 Old database pages 11774 Modified db pages 5892 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3405, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1980, created 37177, written 96122 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 31952, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 4372, state: flushing log Number of rows inserted 29068, updated 35153, deleted 11547, read 96619 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Error: semaphore wait has lasted > 600 seconds InnoDB: We intentionally crash the server, because it appears to be hung. 101019 19:39:12 InnoDB: Assertion failure in thread 8844 in file ..\..\..\mysql-5.5.6-rc\storage\innobase\srv\srv0srv.c line 2364 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 101019 19:39: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=8388608 read_buffer_size=131072 max_used_connections=3 max_threads=151 thread_count=2 connection_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337840 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... 005C6136 mysqld.exe!srv_error_monitor_thread()[srv0srv.c:2364] 7D4DFE37 kernel32.dll!FlsSetValue() The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains thread 8504: 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=0x02845ed8, __int64 reset_sig_count=0x0000000000000000) Line 535 mysqld.exe!sync_array_wait_event(sync_array_struct * arr=0x02849fc0, unsigned long index=0x00000002) Line 459 mysqld.exe!rw_lock_s_lock_spin(rw_lock_struct * lock=0x02845fe0, unsigned long pass=0x00000000, const char * file_name=0x007fd05c, unsigned long line=0x00000346) Line 450 + 0x1c bytes mysqld.exe!rw_lock_s_lock_func(rw_lock_struct * lock=0x02845fe0, unsigned long pass=0x00000000, const char * file_name=0x007fd05c, unsigned long line=0x00000346) Line 418 + 0x9 bytes mysqld.exe!mtr_s_lock_func(rw_lock_struct * lock=0x02845fe0, const char * file=0x007fd05c, unsigned long line=0x00000346, mtr_struct * mtr=0x06dcb704) Line 254 > mysqld.exe!btr_cur_open_at_index_side_func(unsigned long from_left=0x00000001, dict_index_struct * index=0x02845f98, unsigned long latch_mode=0x00000001, btr_cur_struct * cursor=0x06dc9780, const char * file=0x007fd05c, unsigned long line=0x00000d29, mtr_struct * mtr=0x06dcb704) Line 838 + 0x20 bytes mysqld.exe!btr_estimate_n_rows_in_range(dict_index_struct * index=0x02845f98, const dtuple_struct * tuple1=0x03a3c6f8, unsigned long mode1=0x00000002, const dtuple_struct * tuple2=0x03a768c0, unsigned long mode2=0x00000001) Line 3369 + 0x18 bytes mysqld.exe!ha_innobase::records_in_range(unsigned int keynr=0x03a3c6f8, st_key_range * min_key=0x00000000, st_key_range * max_key=0x06dcbbf0) Line 7481 + 0xe bytes mysqld.exe!check_quick_keys(PARAM * param=0x06dcbd00, unsigned int idx=0x00000000, SEL_ARG * key_tree=0x00000001, unsigned char * min_key=0x06dcbe80, unsigned int min_key_flag=0x00000000, int min_keypart=0xffffffff, unsigned char * max_key=0x06dccd7e, unsigned int max_key_flag=0x00000000, int max_keypart=0xffffffff) Line 7788 mysqld.exe!check_quick_select(PARAM * param=0x00000000, unsigned int idx=0x00000000, SEL_ARG * tree=0x00000000, bool update_tbl_stats=true) Line 7555 + 0x26 bytes mysqld.exe!get_key_scans_params(PARAM * param=0x00000000, SEL_TREE * tree=0x03abf7e8, bool index_read_must_be_used=false, bool update_tbl_stats=true, double read_time=103305.20000000000) Line 4959 + 0x11 bytes mysqld.exe!SQL_SELECT::test_quick_select(THD * thd=0x03a939d0, Bitmap<64> keys_to_use={...}, unsigned __int64 prev_tables=0x0000000000000000, unsigned __int64 limit=0x0000000000000001, bool force_quick_range=false) Line 2322 + 0x1f bytes mysqld.exe!get_quick_record_count(THD * thd=0x00000000, SQL_SELECT * select=0x00000000, TABLE * table=0x03a84008, const Bitmap<64> * keys=0x00000000, unsigned __int64 limit=0x0000000000000001) Line 2577 + 0x28 bytes mysqld.exe!make_join_statistics(JOIN * join=0x03a9a248, TABLE_LIST * tables_arg=0x03a99c20, Item * conds=0x03a9a0c8, st_dynamic_array * keyuse_array=0x03a9b354) Line 3011 mysqld.exe!JOIN::optimize() Line 1049 + 0x21 bytes mysqld.exe!mysql_select(THD * thd=0x03a939d0, Item * * * rref_pointer_array=0x03a94e5c, TABLE_LIST * tables=0x03a99c20, unsigned int wild_num=0x00000001, List & fields={...}, Item * conds=0x03a9a0c8, unsigned int og_num=0x00000000, st_order * order=0x00000000, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned __int64 select_options=0x0000000080140b00, select_result * result=0x03a9a238, st_select_lex_unit * unit=0x03a94930, st_select_lex * select_lex=0x03a94d60) Line 2527 + 0x7 bytes mysqld.exe!handle_select(THD * thd=0x03a939d0, LEX * lex=0x03a948c8, select_result * result=0x03a9a238, unsigned long setup_tables_done_option=0x00000000) Line 296 + 0x75 bytes mysqld.exe!execute_sqlcom_select(THD * thd=0x00000000, TABLE_LIST * all_tables=0x03a99c20) Line 4565 + 0xa bytes mysqld.exe!mysql_execute_command(THD * thd=0x03a939d0) Line 2114 + 0xc bytes mysqld.exe!mysql_parse(THD * thd=0x03a939d0, char * rawbuf=0x03a99a78, unsigned int length=0x00000032, Parser_state * parser_state=0x06dcf5c0) Line 5594 + 0x6 bytes mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x03a939d0, char * packet=0x03af0009, unsigned int packet_length=0x00000032) Line 1142 mysqld.exe!do_command(THD * thd=0x00000003) Line 811 + 0xf bytes mysqld.exe!do_handle_one_connection(THD * thd_arg=0x03a939d0) Line 1191 + 0xa bytes mysqld.exe!handle_one_connection(void * arg=0x03a939d0) Line 1130 + 0x6 bytes mysqld.exe!pthread_start(void * p=0x03a72078) Line 61 + 0x3 bytes mysqld.exe!_callthreadstartex() Line 348 + 0x6 bytes mysqld.exe!_threadstartex(void * ptd=0x03a5c8d8) Line 326 + 0x5 bytes kernel32.dll!_BaseThreadStart@8() + 0x34 bytes thread 14048: 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=0x02845ed8, __int64 reset_sig_count=0x0000000000000000) Line 535 mysqld.exe!sync_array_wait_event(sync_array_struct * arr=0x02849fc0, unsigned long index=0x00000001) Line 459 mysqld.exe!rw_lock_s_lock_spin(rw_lock_struct * lock=0x02845fe0, unsigned long pass=0x00000000, const char * file_name=0x007fd05c, unsigned long line=0x000001ff) Line 450 + 0x1c bytes mysqld.exe!rw_lock_s_lock_func(rw_lock_struct * lock=0x02845fe0, unsigned long pass=0x00000000, const char * file_name=0x007fd05c, unsigned long line=0x000001ff) Line 418 + 0x9 bytes mysqld.exe!mtr_s_lock_func(rw_lock_struct * lock=0x02845fe0, const char * file=0x007fd05c, unsigned long line=0x000001ff, mtr_struct * mtr=0x06c8dec0) Line 254 mysqld.exe!btr_cur_search_to_nth_level(dict_index_struct * index=0x02845f98, unsigned long level=0x00000000, const dtuple_struct * tuple=0x03a473b0, unsigned long mode=0x00000004, unsigned long latch_mode=0x00000001, btr_cur_struct * cursor=0x03a52db8, unsigned long has_search_latch=0x00000000, const char * file=0x007fad14, unsigned long line=0x00000bf8, mtr_struct * mtr=0x06c8dec0) Line 511 + 0x1a bytes mysqld.exe!btr_pcur_open_with_no_init_func(dict_index_struct * index=0x02845f98, const dtuple_struct * tuple=0x03a473b0, unsigned long mode=0x00000004, unsigned long latch_mode=0x00000001, btr_pcur_struct * cursor=0x03a52db8, unsigned long has_search_latch=0x00000000, const char * file=0x007fad14, unsigned long line=0x00000bf8, mtr_struct * mtr=0x06c8dec0) Line 544 + 0x3b bytes mysqld.exe!btr_pcur_restore_position_func(unsigned long latch_mode=0x00000001, btr_pcur_struct * cursor=0x03a47370, const char * file=0x007fad14, unsigned long line=0x00000bf8, mtr_struct * mtr=0x06c8dec0) Line 322 + 0x1f bytes mysqld.exe!sel_restore_position_for_mysql(unsigned long * same_user_rec=0x06c8dd1c, unsigned long latch_mode=0x00000000, btr_pcur_struct * pcur=0x00000000, unsigned long moves_up=0x00000001, mtr_struct * mtr=0x06c8dec0) Line 3066 mysqld.exe!row_search_for_mysql(unsigned char * buf=0x03a93380, unsigned long mode=0x00000001, row_prebuilt_struct * prebuilt=0x03a3bed8, unsigned long match_mode=0x00000000, unsigned long direction=0x00000000) Line 4564 + 0x1d bytes mysqld.exe!ha_innobase::index_read(unsigned char * buf=0x03a93380, const unsigned char * key_ptr=0x00000000, unsigned int key_len=0x00000000, ha_rkey_function find_flag=HA_READ_AFTER_KEY) Line 5633 mysqld.exe!ha_innobase::index_first(unsigned char * buf=0x03a93380) Line 5933 + 0x17 bytes mysqld.exe!handler::read_range_first(const st_key_range * start_key=0x00000000, const st_key_range * end_key=0x03a580d0, bool eq_range_arg=false, bool sorted=false) Line 4239 mysqld.exe!handler::read_multi_range_first(st_key_multi_range * * found_range_p=0x06c8e3b0, st_key_multi_range * ranges=0x03a580c0, unsigned int range_count=0x00000001, bool sorted=false, st_handler_buffer * buffer=0x00000000) Line 4117 + 0x3c bytes mysqld.exe!QUICK_RANGE_SELECT::get_next() Line 8684 mysqld.exe!rr_quick(READ_RECORD * info=0x06c8e450) Line 335 + 0x10 bytes mysqld.exe!mysql_update(THD * thd=0x03a7bfe0, TABLE_LIST * table_list=0x03a3c818, List & fields={...}, List & values={...}, Item * conds=0x03a3ced8, unsigned int order_num=0x00000000, st_order * order=0x00000000, unsigned __int64 limit=0x0000000000000001, enum_duplicates handle_duplicates=DUP_ERROR, bool ignore=true, unsigned __int64 * found_return=0x06c8e7cc, unsigned __int64 * updated_return=0x06c8e7e4) Line 591 + 0xf bytes mysqld.exe!mysql_execute_command(THD * thd=0x03a7bfe0) Line 2812 + 0x52 bytes mysqld.exe!mysql_parse(THD * thd=0x03a7bfe0, char * rawbuf=0x03afd028, unsigned int length=0x000065a9, Parser_state * parser_state=0x06c8f5c0) Line 5594 + 0x6 bytes mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x03a7bfe0, char * packet=0x03ad5fb1, unsigned int packet_length=0x000065a9) Line 1142 mysqld.exe!do_command(THD * thd=0x00000003) Line 811 + 0xf bytes mysqld.exe!do_handle_one_connection(THD * thd_arg=0x03a7bfe0) Line 1191 + 0xa bytes mysqld.exe!handle_one_connection(void * arg=0x03a7bfe0) Line 1130 + 0x6 bytes mysqld.exe!pthread_start(void * p=0x03a6ffd0) Line 61 + 0x3 bytes mysqld.exe!_callthreadstartex() Line 348 + 0x6 bytes mysqld.exe!_threadstartex(void * ptd=0x03a75a70) Line 326 + 0x5 bytes kernel32.dll!_BaseThreadStart@8() + 0x34 bytes thread 4372: main purge thread 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=0x034e5eb0, __int64 reset_sig_count=0x0000000000000000) Line 535 mysqld.exe!sync_array_wait_event(sync_array_struct * arr=0x02849fc0, unsigned long index=0x00000000) Line 459 mysqld.exe!rw_lock_x_lock_wait(rw_lock_struct * lock=0x00000000, const char * file_name=0x007fd05c, unsigned long line=0x000011ef) Line 537 mysqld.exe!rw_lock_x_lock_low(rw_lock_struct * lock=0x16218b78, unsigned long pass=0x00000000, const char * file_name=0x007fd05c, unsigned long line=0x000011ef) Line 576 + 0x8 bytes mysqld.exe!rw_lock_x_lock_func(rw_lock_struct * lock=0x16218b78, unsigned long pass=0x00000000, const char * file_name=0x007fd05c, unsigned long line=0x000011ef) Line 628 + 0x23 bytes mysqld.exe!buf_page_get_gen(unsigned long space=0x00000010, unsigned long zip_size=0x00000000, unsigned long offset=0x000017c0, unsigned long rw_latch=0x00000002, buf_block_struct * guess=0xc57db00d, unsigned long mode=0x0000000a, const char * file=0x007fd05c, unsigned long line=0x000011ef, mtr_struct * mtr=0x05e3f3b4) Line 3069 mysqld.exe!btr_free_externally_stored_field(dict_index_struct * index=0x02845f98, unsigned char * field_ref=0x1a092b85, const unsigned char * rec=0x1a092870, const unsigned long * offsets=0x03a849b0, page_zip_des_struct * page_zip=0x00000000, unsigned long i=0x00000003, trx_rb_ctx rb_ctx=RB_NONE, mtr_struct * local_mtr=0x05e3fa48) Line 4591 + 0x21 bytes mysqld.exe!btr_rec_free_externally_stored_fields(dict_index_struct * index=0x02845f98, unsigned char * rec=0x1a092870, const unsigned long * offsets=0x03a849b0, page_zip_des_struct * page_zip=0x00000000, trx_rb_ctx rb_ctx=RB_NONE, mtr_struct * mtr=0x05e3fa48) Line 4694 + 0x25 bytes mysqld.exe!btr_cur_pessimistic_delete(unsigned long * err=0x05e3f8b4, unsigned long has_reserved_extents=0x1a092870, btr_cur_struct * cursor=0x03a37e38, trx_rb_ctx rb_ctx=RB_NONE, mtr_struct * mtr=0x05e3fa48) Line 3058 + 0x16 bytes mysqld.exe!row_purge_remove_clust_if_poss_low(purge_node_struct * node=0x00000000, unsigned long mode=0x00000021) Line 177 mysqld.exe!row_purge_remove_clust_if_poss(purge_node_struct * node=0x00000000) Line 211 + 0x9 bytes mysqld.exe!row_purge_del_mark(purge_node_struct * node=0x00000000) Line 484 + 0x5 bytes mysqld.exe!row_purge(purge_node_struct * node=0x00000000, que_thr_struct * thr=0x00000000) Line 756 mysqld.exe!row_purge_step(que_thr_struct * thr=0x03a37d90) Line 801 mysqld.exe!que_thr_step(que_thr_struct * thr=0x03a37d90) Line 1247 + 0x6 bytes mysqld.exe!que_run_threads_low(que_thr_struct * thr=0x00000000) Line 1310 + 0x6 bytes mysqld.exe!que_run_threads(que_thr_struct * thr=0x03a37d90) Line 1349 mysqld.exe!trx_purge(unsigned long limit=0x00000014) Line 1197 mysqld.exe!srv_master_do_purge() Line 2539 + 0xc bytes mysqld.exe!srv_master_thread(void * arg=0x00000000) Line 2849