E:\downloads\mysql\5.4\mysql-5.4.3-beta-winx64\bin>mysqld --console --skip-grant-tables 091023 7:14:05 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Windows interlocked functions. 091023 7:14:05 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 091023 7:14:05 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 091023 7:14:06 InnoDB Plugin 1.0.4 started; log sequence number 25550677 091023 7:14:06 [Note] mysqld: ready for connections. Version: '5.4.3-beta-community' socket: '' port: 3306 MySQL Community Server (GPL) 091023 7:23:37 [ERROR] trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED 091023 7:23:37 [Warning] MySQL is closing a connection that has an active InnoDB transaction. 0 row modifications will roll back. 091023 7:23:40 [ERROR] trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED 091023 7:23:40 [Warning] MySQL is closing a connection that has an active InnoDB transaction. 0 row modifications will roll back. InnoDB: Error: MySQL is trying to perform a consistent read InnoDB: but the read view is not assigned! TRANSACTION 2795, ACTIVE 94 sec, OS thread id 1036 starting index read 3 lock struct(s), heap size 1216, 6 row lock(s) MySQL thread id 6, query id 24094 localhost 127.0.0.1 root Sending data show create table `test`.`v201.901` 091023 7:23:40 InnoDB: Assertion failure in thread 1036 in file .\row\row0sel.c line 3740 InnoDB: Failing assertion: 0 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. 091023 7:23:40 - 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=4 max_threads=151 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 338112 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xcaf3cb0 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... 000000014022C634 mysqld.exe!row_search_for_mysql()[row0sel.c:3740] 000000014020D46B mysqld.exe!ha_innobase::index_read()[ha_innodb.cc:5058] 000000014020DBC8 mysqld.exe!ha_innobase::index_first()[ha_innodb.cc:5348] 000000014020DCE2 mysqld.exe!ha_innobase::rnd_next()[ha_innodb.cc:5438] 00000001401BF95F mysqld.exe!ha_partition::rnd_next()[ha_partition.cc:3568] 000000014011C31A mysqld.exe!rr_sequential()[records.cc:381] 000000014015AC4A mysqld.exe!flush_cached_records()[sql_select.cc:11367] 00000001401617E6 mysqld.exe!sub_select_cache()[sql_select.cc:10953] 000000014016ECFF mysqld.exe!do_select()[sql_select.cc:10892] 000000014016FF7C mysqld.exe!JOIN::exec()[sql_select.cc:2209] 00000001401455E6 mysqld.exe!subselect_single_select_engine::exec()[item_subselect.cc:1963] 00000001401445AE mysqld.exe!Item_subselect::exec()[item_subselect.cc:263] 0000000140144A99 mysqld.exe!Item_singlerow_subselect::val_str()[item_subselect.cc:579] 0000000140042CBD mysqld.exe!Arg_comparator::can_compare_as_dates()[item_cmpfunc.cc:769] 00000001400464B5 mysqld.exe!Arg_comparator::set_cmp_func()[item_cmpfunc.cc:852] 0000000140048B5A mysqld.exe!Item_bool_func2::set_cmp_func()[item_cmpfunc.h:337] 0000000140048F31 mysqld.exe!Item_bool_func2::fix_length_and_dec()[item_cmpfunc.cc:523] 00000001400C1C69 mysqld.exe!Item_func::fix_fields()[item_func.cc:199] 0000000140047822 mysqld.exe!Item_cond::fix_fields()[item_cmpfunc.cc:3913] InnoDB: Thread 1156 stopped in file .\os\os0sync.c line 546 InnoDB: Thread 900 stopped in file .\os\os0sync.c line 245 0000000140076745 mysqld.exe!setup_conds()[sql_base.cc:7992] 00000001401678CD mysqld.exe!setup_without_group()[sql_select.cc:418] 0000000140167C7F mysqld.exe!JOIN::prepare()[sql_select.cc:504] 00000001401AFF53 mysqld.exe!st_select_lex_unit::prepare()[sql_union.cc:264] 00000001401B17B8 mysqld.exe!mysql_derived_prepare()[sql_derived.cc:151] 00000001401B14C0 mysqld.exe!mysql_handle_derived()[sql_derived.cc:56] 000000014007BF73 mysqld.exe!open_normal_and_derived_tables()[sql_base.cc:5031] 00000001400943C9 mysqld.exe!mysqld_show_create()[sql_show.cc:598] 000000014006B3E4 mysqld.exe!mysql_execute_command()[sql_parse.cc:2961] 000000014006E906 mysqld.exe!mysql_parse()[sql_parse.cc:6018] 000000014006F49A mysqld.exe!dispatch_command()[sql_parse.cc:1235] 0000000140070107 mysqld.exe!do_command()[sql_parse.cc:866] 0000000140096617 mysqld.exe!handle_one_connection()[sql_connect.cc:1131] 0000000140329DF5 mysqld.exe!pthread_start()[my_winthread.c:85] 00000001402F3F87 mysqld.exe!_callthreadstart()[thread.c:295] 00000001402F4055 mysqld.exe!_threadstart()[thread.c:275] 0000000077D6B6CA kernel32.dll!BaseThreadStart() Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 000000000F852F40=show create table `test`.`v201.901` thd->thread_id=6 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. InnoDB: Thread 1608 stopped in file .\sync\sync0arr.c line 362 mysqld.exe!row_search_for_mysql(unsigned char * buf=0x00000000000003bf, unsigned __int64 mode=0x00000001401be222, row_prebuilt_struct * prebuilt=0x0000000000000000, unsigned __int64 match_mode=0x0000000000000001, unsigned __int64 direction=0x0000000000000000) Line 3740 + 0x25 bytes C mysqld.exe!ha_innobase::index_read(unsigned char * buf=0x0000000011256260, const unsigned char * key_ptr=0x000000000f77c430, unsigned int key_len=0x00000000, ha_rkey_function find_flag=HA_READ_AFTER_KEY) Line 5058 C++ mysqld.exe!ha_innobase::index_first(unsigned char * buf=0x000000000faf6438) Line 5348 C++ mysqld.exe!ha_innobase::rnd_next(unsigned char * buf=0x00000000101fe508) Line 5438 C++ mysqld.exe!ha_partition::rnd_next(unsigned char * buf=0x0000000000000000) Line 3568 C++ mysqld.exe!rr_sequential(st_read_record * info=0x00000000101fe508) Line 381 + 0x11 bytes C++ mysqld.exe!flush_cached_records(JOIN * join=0x00000000101fe2c0, st_join_table * join_tab=0x00000000101fcb68, bool skip_last=false) Line 11367 + 0x8 bytes C++ mysqld.exe!sub_select_cache(JOIN * join=0x00000000101fcb68, st_join_table * join_tab=0x0000000000000000, bool end_of_records=true) Line 10953 C++ mysqld.exe!do_select(JOIN * join=0x0000000010fbe600, List * fields=0x0000000000000000, st_table * table=0x00000000101fcb68, Procedure * procedure=0x0000000000000007) Line 10892 + 0xe bytes C++ mysqld.exe!JOIN::exec() Line 2209 C++ mysqld.exe!subselect_single_select_engine::exec() Line 1963 C++ mysqld.exe!Item_subselect::exec() Line 263 C++ mysqld.exe!Item_singlerow_subselect::val_str(String * str=0x00000000101fe140) Line 579 + 0xf bytes C++ mysqld.exe!Arg_comparator::can_compare_as_dates(Item * a=0x000000000eb5d250, Item * b=0x000000000caf3cb0, unsigned __int64 * const_value=0x000000000caf3cb0) Line 769 C++ mysqld.exe!Arg_comparator::set_cmp_func(Item_bool_func2 * owner_arg=0x0000000100000000, Item * * a1=0x0000000000000007, Item * * a2=0x0000000000000000, Item_result type=STRING_RESULT) Line 852 + 0x1c bytes C++ mysqld.exe!Item_bool_func2::set_cmp_func() Line 337 C++ mysqld.exe!Item_bool_func2::fix_length_and_dec() Line 523 + 0x8 bytes C++ mysqld.exe!Item_func::fix_fields(THD * thd=0x00000001400f0448, Item * * ref=0x0000000010fbe2a0) Line 199 C++ mysqld.exe!Item_cond::fix_fields(THD * thd=0x0000000140067701, Item * * ref=0x0000000000000000) Line 3913 + 0x15 bytes C++ mysqld.exe!setup_conds(THD * thd=0x0000000010e3b201, TABLE_LIST * tables=0x0000000010e3b268, TABLE_LIST * leaves=0x000000000caf3cb0, Item * * conds=0x000000000faf5e28) Line 7992 + 0x15 bytes C++ mysqld.exe!setup_without_group(THD * thd=0x000000000f8543e0, Item * * ref_pointer_array=0x0000000000000000, TABLE_LIST * tables=0x000000000faf4850, TABLE_LIST * leaves=0x0000000000000000, List & fields={...}, List & all_fields={...}, Item * * conds=0x000000000faf5f10, st_order * order=0x0000000000000000, st_order * group=0x0000000000000000, bool * hidden_group_fields=0x000000000faf5e07) Line 418 C++ mysqld.exe!JOIN::prepare(Item * * * rref_pointer_array=0x000000000fa73460, TABLE_LIST * tables_init=0x000000000f854210, unsigned int wild_num=0x00000000, Item * conds_init=0x000000000fa73280, unsigned int og_num=0x00000000, st_order * order_init=0x0000000000000000, st_order * group_init=0x0000000000000000, Item * having_init=0x0000000000000000, st_order * proc_param_init=0x0000000000000000, st_select_lex * select_lex_arg=0x000000000f854210, st_select_lex_unit * unit_arg=0x000000000f853e08) Line 504 + 0xdf bytes C++ mysqld.exe!st_select_lex_unit::prepare(THD * thd_arg=0x000000000caf5610, select_result * sel_result=0x000000000fa73460, unsigned long additional_options=0x00000000) Line 264 + 0x8e bytes C++ mysqld.exe!mysql_derived_prepare(THD * thd=0x000000000f853078, st_lex * lex=0x0000000000000000, TABLE_LIST * orig_table_list=0x000000000caf5610) Line 151 + 0x67 bytes C++ mysqld.exe!mysql_handle_derived(st_lex * lex=0x000000000caf3cb0, bool (THD *, st_lex *, TABLE_LIST *)* processor=0x000000000caf3cb0) Line 56 + 0x10 bytes C++ mysqld.exe!open_normal_and_derived_tables(THD * thd=0x0000000000000000, TABLE_LIST * tables=0x000000000f853078, unsigned int flags=0x00000000) Line 5031 + 0x29 bytes C++ mysqld.exe!mysqld_show_create(THD * thd=0x0000000000000000, TABLE_LIST * table_list=0x0000000000000000) Line 598 + 0x15 bytes C++ mysqld.exe!mysql_execute_command(THD * thd=0x000000000caf3cb0) Line 2961 C++ mysqld.exe!mysql_parse(THD * thd=0x000000000caf3cb0, const char * inBuf=0x000000000fa7cfa5, unsigned int length=0x00000003, const char * * found_semicolon=0x0000000000000023) Line 6018 C++ mysqld.exe!dispatch_command(enum_server_command command=COM_SLEEP, THD * thd=0x0000000000000000, char * packet=0x0000000000000010, unsigned int packet_length=0x00000000) Line 1235 C++ mysqld.exe!do_command(THD * thd=0x0000000000000000) Line 866 + 0x13 bytes C++ mysqld.exe!handle_one_connection(void * arg=0x000000000caf3cb0) Line 1131 + 0xa bytes C++ mysqld.exe!pthread_start(void * param=0x000000000f762800) Line 85 + 0x5 bytes C > mysqld.exe!_callthreadstart() Line 295 C mysqld.exe!_threadstart(void * ptd=0x0000000077d6b690) Line 275 + 0x5 bytes C kernel32.dll!BaseThreadStart() + 0x3a bytes