[New Thread 1435351984 (LWP 5934)] 060616 9:53:05 [Note] /home/miguel/dbs/5.1/libexec/mysqld: ready for connections. Version: '5.1.12-beta-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1435552688 (LWP 5935)] 060616 9:53:05 [Note] SCHEDULER: Manager thread booting 060616 9:53:05 [Note] SCHEDULER: Loaded 0 events 060616 9:53:05 [Note] SCHEDULER: Suspending operations [New Thread 1435753392 (LWP 5937)] [New Thread 1436355504 (LWP 5940)] 060616 9:54:08InnoDB: Assertion failure in thread 1436355504 in file ha_innodb.cc line 6826 InnoDB: Failing assertion: prebuilt->trx == (trx_t*) current_thd->ha_data[innobase_hton.slot] 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/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1436355504 (LWP 5940)] 0x08354ee4 in ha_innobase::innobase_read_and_init_auto_inc (this=0x9303170, ret=0x559ce9e8) at ha_innodb.cc:6825 6825 ut_a(prebuilt->trx == (gdb) bt full #0 0x08354ee4 in ha_innobase::innobase_read_and_init_auto_inc (this=0x9303170, ret=0x559ce9e8) at ha_innodb.cc:6825 auto_inc = 606965200613861832 prebuilt = (row_prebuilt_t *) 0x425a8668 old_select_lock_type = 1074035975 trx_was_not_started = 0 error = 1074042501 #1 0x08355e75 in ha_innobase::get_auto_increment (this=0x9303170, offset=0, increment=0, nb_desired_values=0, first_value=0x559ceaa8, nb_reserved_values=0x559ceaa0) at ha_innodb.cc:6963 nr = 607014803191163400 error = 154076600 #2 0x0834c91b in ha_partition::get_auto_increment (this=0x92c3508, offset=0, increment=0, nb_desired_values=0, first_value=0x92c3558, nb_reserved_values=0x559ceb28) at ha_partition.cc:5293 first_value_part = 606990850158553800 last_value_part = 661753959515220776 nb_reserved_values_part = 661753958222925728 pos = (class handler **) 0x92c36a0 end = (class handler **) 0x92c3820 _db_func_ = 0x87deea5 "ha_partition:info" _db_file_ = 0x87ddbc7 "ha_partition.cc" _db_level_ = 11 _db_framep_ = (char **) 0x0 last_value = 18446744073709551615 #3 0x0834aff0 in ha_partition::info (this=0x92c3508, flag=86) at ha_partition.cc:4150 nb_reserved_values = 345033730768 file = (class handler *) 0x0 file_array = (class handler **) 0x1 _db_func_ = 0x87ef8af "get_schema_tables_record" _db_file_ = 0x87ef0b3 "sql_show.cc" _db_level_ = 10 _db_framep_ = (char **) 0x0 #4 0x083b0c58 in get_schema_tables_record (thd=0x92eee80, tables=0x93fa748, table=0x93ef650, res=false, base_name=0x92ecdf8 "test", file_name=0x93fa740 "normal") at sql_show.cc:2709 show_table = (TABLE *) 0x92dcb80 share = (TABLE_SHARE *) 0x92e7d40 file = (class handler *) 0x92c3508 option_buff = "\234U\205\226\004@´\030\"\b\a}\004@Øë\234U\205\226\004@´\030\"\b\000\000\000\000èë\234U¢_l\b\000\000\000\000°\v\235UàÑ?\t Ö>\t è\035@ ö>\t\230\020\000\000L'\035@èë\234U¸\005/\t\bì\234U\205\226\004@´\030\"\b\000\000\000\000(ì\234U¢_l\b\000\000\000\000¸\005/\t(ì\234UR\216l\bôa\022@ è\035@ Ö>\t´\030\"\b\000\000\000\000¸\005/\tHì\234U\205\226\004@´\030\"\b \017\226\bhì\234U¢_l\b\000\000\000\000¸\005/\thì\234UR\216l\b\000\000\000\000h\006/\t\f\000\000\000.4\205\b\000\000"... ---Type to continue, or q to quit--- row_type = ROW_TYPE_DEFAULT ptr = 0x6
cs = (CHARSET_INFO *) 0x8960fa0 _db_func_ = 0x87ef84d "get_all_tables" _db_file_ = 0x87ef0b3 "sql_show.cc" tmp_buff = 0x82993b8 "\203Ä\020ÇEÜ" time = {year = 1436347688, month = 141331881, day = 154076776, hour = 154076600, minute = 1436347688, second = 141332050, second_part = 142389344, neg = 104 'h', time_type = MYSQL_TIMESTAMP_DATE} _db_level_ = 9 _db_framep_ = (char **) 0x0 #5 0x083b0424 in get_all_tables (thd=0x92eee80, tables=0x92eba20, cond=0x0) at sql_show.cc:2574 res = 0 show_table_list = (TABLE_LIST *) 0x93fa748 files = { = { = {}, first = 0x92ece10, last = 0x92ece10, elements = 1}, } it_files = { = {list = 0x559cf18c, el = 0x92ece10, prev = 0x0, current = 0x0}, } save_sql_command = SQLCOM_SELECT schema_table = (ST_SCHEMA_TABLE *) 0x888170c sel = { = {_vptr.st_select_lex_node = 0x87456c8, next = 0x559cefc8, prev = 0x86c8e52, master = 0x0, slave = 0x80000000, link_next = 0x0, link_prev = 0x86c76f6, options = 0, uncacheable = 0 '\0', linkage = UNSPECIFIED_TYPE, no_table_names_allowed = false, no_error = false}, context = { = {}, outer_context = 0x0, table_list = 0x0, first_name_resolution_table = 0x0, last_name_resolution_table = 0x0, select_lex = 0x559cefa4, error_processor = 0x81b3476 , error_processor_data = 0x0, resolve_in_select_list = false, security_ctx = 0x0}, db = 0x559cf228 "xò\234U@\226;\b\200î.\t º.\t", where = 0x0, having = 0x0, prep_where = 0x0, prep_having = 0x0, parent_lex = 0x92eeec0, olap = UNSPECIFIED_OLAP_TYPE, table_list = {elements = 1, first = 0x93fa748 "", next = 0x93fa748}, group_list = { elements = 0, first = 0x0, next = 0x559cf058}, item_list = { = { = {}, first = 0x898abfc, last = 0x559cf02c, elements = 0}, }, interval_list = { = { = {}, first = 0x898abfc, last = 0x559cf038, elements = 0}, }, use_index = { = { = {}, first = 0x898abfc, last = 0x559cf044, elements = 0}, }, use_index_ptr = 0x16, ignore_index = { = { = {}, first = 0x898abfc, last = 0x559cf054, elements = 0}, }, ignore_index_ptr = 0xdc, is_item_list_lookup = false, ftfunc_list = 0x559cf094, ftfunc_list_alloc = { = { = {}, first = 0x898abfc, last = 0x559cf06c, elements = 0}, }, join = 0x0, top_join_list = { = { = {}, first = 0x898abfc, last = 0x559cf07c, elements = 0}, }, join_list = 0x559cf07c, embedding = 0x0, leaf_tables = 0x0, type = 0x0, order_list = {elements = 1436348616, first = 0x86c5fa2 "\203Ä\020\211Eü\213EüÉÃU\211å\203ì\bè°\234¬ÿÉÃU\211å\203ìxèÉÿÿÿ\211Eø\213Eø\212\200 ", next = 0x0}, expr_list = { = { = {}, first = 0x898abfc, last = 0x559cf0a4, elements = 0}, }, when_list = { = { = {}, first = 0x898abfc, last = 0x559cf0b0, elements = 0}, }, gorder_list = 0x86c76f6, select_limit = 0x92f0668, offset_limit = 0x0, ref_pointer_array = 0x0, select_n_having_items = 0, cond_count = 0, parsing_place = NO_MATTER, with_sum_func = 248, conds_processed_with_permanent_arena = false, table_join_options = 141332050, ---Type to continue, or q to quit--- in_sum_expr = 154076776, select_number = 154076600, nest_level = 0, inner_sum_func_list = 0xc0000000, with_wild = 0, braces = 104, having_fix_field = false, explicit_limit = false, subquery_in_having = false, first_execution = true, first_cond_optimization = true, no_wrap_view_item = false, exclude_from_table_unique_test = false} sctx = (Security_context *) 0x92efeec save_view_prepare_mode = false old_all_select_lex = (SELECT_LEX *) 0x92ef154 with_i_schema = false error = 1 lex = (LEX *) 0x92eeec0 idx_field_vals = {db_value = 0x92eaec0 "test", table_value = 0x92eae90 "normal"} path = "./test/\000övl\b\026\000\000\000¸\005/\tØí\234Uövl\bh\006/\t\000\000\000\000øí\234U©\215l\bh\006/\t¸\005/\tøí\234UR\216l\bh\006/\t¸\005/\000\200Ê.\tD\227l\b\026\000\000\000h\006/\t\230î\234U¼¤*\bK\021\000\000Lî\234UHî\234UDî\234U\000\000\000\0004î\234\001", '\0' , "ð?\001\000\000\000\205\226\004@0\222?\t\000\000\000\000hî\234U\205\226\004@0\222?\t\000\000\000\000xî\234U¢_l\b", '\0' , "@3333¸\005/\t\210î\234Uövl\b\001\000\000\000¸"... partial_cond = (COND *) 0x0 _db_framep_ = (char **) 0x40049685 file_name = 0x92ece08 "normal" it = { = {list = 0x559cf1c0, el = 0x92ece00, prev = 0x0, current = 0x0}, } table = (TABLE *) 0x93ef650 end = 0x559cedab "" open_tables_state_backup = {open_tables = 0x0, temporary_tables = 0x0, handler_tables = 0x0, derived_tables = 0x93ef650, lock = 0x92f1c90, locked_tables = 0x0, prelocked_mode = NON_PRELOCKED, version = 1, current_tablenr = 0, state_flags = 0} query_tables_list_backup = {query_tables = 0x92eba20, query_tables_last = 0x92eba24, query_tables_own_last = 0x0, sroutines = { key_offset = 0, key_length = 0, records = 0, blength = 1, flags = 0, array = {buffer = 0x92e8e28 '¥' ..., elements = 0, max_element = 1019, alloc_increment = 1019, size_of_element = 8}, get_key = 0x8408dc6 , free = 0, charset = 0x8960fa0}, sroutines_list = {elements = 0, first = 0x0, next = 0x92eef08}, sroutines_list_own_last = 0x92eef08, sroutines_list_own_elements = 0} _db_file_ = 0x87ef0b3 "sql_show.cc" schema_table_idx = SCH_TABLES bases = { = { = {}, first = 0x92ece00, last = 0x92ece00, elements = 1}, } derived_tables = 0 _db_func_ = 0x87efe63 "get_schema_tables_result" select_lex = (SELECT_LEX *) 0x92ef154 lsel = (SELECT_LEX *) 0x0 base_name = 0x92ecdf8 "test" len = 249 not_used = 141320098 _db_level_ = 8 __PRETTY_FUNCTION__ = "int get_all_tables(THD*, TABLE_LIST*, COND*)" ---Type to continue, or q to quit--- #6 0x083b9640 in get_schema_tables_result (join=0x93f9230) at sql_show.cc:5011 is_subselect = false table_list = (TABLE_LIST *) 0x92eba20 tab = (JOIN_TAB *) 0x93fa4a8 tmp_join_tab = (JOIN_TAB *) 0x93fa618 lex = (LEX *) 0x92eeec0 _db_func_ = 0x87ce1dc "JOIN::exec" _db_file_ = 0x87ccde4 "sql_select.cc" thd = (class THD *) 0x92eee80 result = false _db_level_ = 7 _db_framep_ = (char **) 0x559cf268 #7 0x082c58b0 in JOIN::exec (this=0x93f9230) at sql_select.cc:1341 _db_func_ = 0x87ce2c2 "mysql_select" _db_file_ = 0x87ccde4 "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x92ef154 tmp_error = 155166232 curr_join = (JOIN *) 0x93f9230 curr_fields_list = (List *) 0x92ef1dc columns_list = (List *) 0x92ef1dc curr_all_fields = (List *) 0x93f9f68 curr_tmp_table = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #8 0x082c71f1 in mysql_select (thd=0x92eee80, rref_pointer_array=0x92ef278, tables=0x92eba20, wild_num=0, fields=@0x92ef1dc, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684635648, result=0x92eca68, unit=0x92eef24, select_lex=0x92ef154) at sql_select.cc:1922 err = false free_join = true _db_func_ = 0x87ce2d8 "handle_select" _db_file_ = 0x87ccde4 "sql_select.cc" join = (JOIN *) 0x93f9230 _db_level_ = 5 _db_framep_ = (char **) 0x86c76f6 #9 0x082c74b8 in handle_select (thd=0x92eee80, lex=0x92eeec0, result=0x92eca68, setup_tables_done_option=0) at sql_select.cc:250 unit = (SELECT_LEX_UNIT *) 0x92eef24 select_lex = (SELECT_LEX *) 0x92ef154 _db_func_ = 0x878cbe1 "mysql_execute_command" _db_file_ = 0x878bfe2 "sql_parse.cc" ---Type to continue, or q to quit--- res = false _db_level_ = 4 _db_framep_ = (char **) 0x92eca68 #10 0x08262ca4 in mysql_execute_command (thd=0x92eee80) at sql_parse.cc:2547 result = (class select_result *) 0x92eca68 res = false lex = (LEX *) 0x92eeec0 _db_func_ = 0x878cfc4 "mysql_parse" _db_file_ = 0x878bfe2 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x0 result = 0 select_lex = (SELECT_LEX *) 0x92ef154 first_table = (TABLE_LIST *) 0x92eba20 all_tables = (TABLE_LIST *) 0x92eba20 unit = (SELECT_LEX_UNIT *) 0x92eef24 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #11 0x0826b02e in mysql_parse (thd=0x92eee80, inBuf=0x92eae30 "SHOW TABLE STATUS LIKE 'normal'", length=31) at sql_parse.cc:5940 lex = (LEX *) 0x92eeec0 _db_func_ = 0x878d033 "dispatch_command" _db_file_ = 0x878bfe2 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #12 0x0826ba31 in dispatch_command (command=COM_QUERY, thd=0x92eee80, packet=0x93e9691 "SHOW TABLE STATUS LIKE 'normal'", packet_length=32) at sql_parse.cc:1764 packet_end = 0x92eae4f "" net = (NET *) 0x92ef6d0 _db_func_ = 0x8859614 "?func" _db_file_ = 0x885961a "?file" error = false _db_level_ = 1 _db_framep_ = (char **) 0x4 #13 0x0826cd8b in do_command (thd=0x92eee80) at sql_parse.cc:1550 packet = 0x93e9690 "\003SHOW TABLE STATUS LIKE 'normal'" old_timeout = 30 packet_length = 32 net = (NET *) 0x92ef6d0 command = COM_QUERY ---Type to continue, or q to quit--- _db_func_ = 0x8859614 "?func" _db_file_ = 0x885961a "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1010 #14 0x0826d18d in handle_one_connection (arg=0x92eee80) at sql_parse.cc:1190 error = 0 net = (NET *) 0x92ef6d0 sctx = (Security_context *) 0x92efeec thd = (class THD *) 0x92eee80 launch_time = 0 set = {__val = {0 }} #15 0x40046297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #16 0x4018037e in clone () from /lib/tls/libc.so.6 No symbol table info available. #17 0x559d0bb0 in ?? () No symbol table info available. (gdb)