After restarting server MariaDB [t1]> repair table test; +---------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------+--------+----------+----------+ | t1.test | repair | status | OK | +---------+--------+----------+----------+ 1 row in set (0.00 sec) MariaDB [t1]> set use_stat_tables='COMPLEMENTARY'; Query OK, 0 rows affected (0.00 sec) MariaDB [t1]> analyze table test; (breakpoint caught) (gdb) break /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1142 Breakpoint 1 at 0x66c5d2: file /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc, line 1142. (gdb) c Continuing. [Switching to Thread 0x7fe3b669b700 (LWP 2007)] Breakpoint 1, Sql_cmd_analyze_table::execute (this=0x7fe3a401f6d0, thd=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1142 1142 if (check_table_access(thd, SELECT_ACL | INSERT_ACL, first_table, (gdb) p *first_table value has been optimized out (gdb) n 1135 { (gdb) 1142 if (check_table_access(thd, SELECT_ACL | INSERT_ACL, first_table, (gdb) 1135 { (gdb) 1136 LEX *m_lex= thd->lex; (gdb) 1142 if (check_table_access(thd, SELECT_ACL | INSERT_ACL, first_table, (gdb) 1137 TABLE_LIST *first_table= m_lex->select_lex.table_list.first; (gdb) 1142 if (check_table_access(thd, SELECT_ACL | INSERT_ACL, first_table, (gdb) 1138 bool res= TRUE; (gdb) 1142 if (check_table_access(thd, SELECT_ACL | INSERT_ACL, first_table, (gdb) 1145 thd->enable_slow_log= opt_log_slow_admin_statements; (gdb) 1148 &handler::ha_analyze, 0); (gdb) 1145 thd->enable_slow_log= opt_log_slow_admin_statements; (gdb) 1148 &handler::ha_analyze, 0); (gdb) Program received signal SIGSEGV, Segmentation fault. free_field_buffers_larger_than (table=table@entry=0x7fe3a406a208, size=size@entry=65536) at /home/dan/software_projects/mariadb-trunk/sql/table.cc:3026 3026 if (blob->get_field_buffer_size() > size) (gdb) bt full #0 free_field_buffers_larger_than (table=table@entry=0x7fe3a406a208, size=size@entry=65536) at /home/dan/software_projects/mariadb-trunk/sql/table.cc:3026 blob = 0x576b51375a67 ptr = 0x7fe3a4026b98 end = 0x7fe3a4026ba0 #1 0x00000000005736cf in close_thread_table (thd=thd@entry=0x7fe3acbea008, table_ptr=table_ptr@entry=0x7fe3acbea0c8) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1045 table = 0x7fe3a406a208 #2 0x00000000005738a3 in close_open_tables (thd=) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:779 No locals. #3 close_thread_tables (thd=thd@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1003 table = __FUNCTION__ = "close_thread_tables" #4 0x000000000066b3ff in mysql_admin_table (thd=thd@entry=0x7fe3acbea008, tables=tables@entry=0x7fe3a401f0f0, check_opt=check_opt@entry=0x7fe3acbeea00, operator_name=operator_name@entry=0xafd50f "analyze", lock_type=lock_type@entry=TL_READ_NO_INSERT, open_for_modify=open_for_modify@entry=true, repair_table_use_frm=repair_table_use_frm@entry=false, extra_open_options=extra_open_options@entry=0, prepare_func=prepare_func@entry=0x0, operator_func=, view_operator_func=view_operator_func@entry=0x0) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1024 table_name = "t1.test\000\000\000\000\000\000\000\000\000\310⾬\343\177\000\000\000\000\000\000\000\000\000\000\230\365\001\244\343\177\000\000\330\377b\000\000\000\000\000\310⾬\343\177\000\000\240\001\002\244\343\177\000\000\310⾬\343\177\000\000\b\240\276\254\343\177\000\000\000\000\000\000\000\000\000\000\230\365\001\244\343\177\000\000\001\000\000\000\000\000\000\000\233n_", '\000' , ".v\251\000\000\000\000\000@\221i\266\343\177\000\000\220y\251\000\000\000\000\000./t1/", '\000' , "R\000\000\000\000\000\000\000hT\374\261\343\177"... db = fatal_error = open_error = table = lex = 0x7fe3acbedb18 result_code = 1 select = 0x7fe3acbee2c8 item = protocol = 0x7fe3acbea508 need_repair_or_alter = false field_list = { = { = {}, first = 0x7fe3a401f768, last = 0x7fe3a401f948, elements = 4}, } compl_result_code = #5 0x000000000066c67c in Sql_cmd_analyze_table::execute (this=, thd=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1148 m_lex = 0x7fe3acbedb18 first_table = 0x7fe3a401f0f0 res = true #6 0x00000000005b085d in mysql_execute_command (thd=thd@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:5078 res = 0 lex = 0x7fe3acbedb18 orig_binlog_format = BINLOG_FORMAT_STMT up_result = 0 rpl_filter = ---Type to continue, or q to quit--- orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" select_lex = 0x7fe3acbee2c8 first_table = 0x7fe3a401f0f0 all_tables = 0x7fe3a401f0f0 unit = 0x7fe3acbedbe0 have_table_map_for_update = false #7 0x00000000005b6d88 in mysql_parse (thd=0x7fe3acbea008, rawbuf=, length=18, parser_state=0x7fe3b669a5b0) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:6407 found_semicolon = lex = 0x7fe3acbedb18 err = rawbuf = length = 18 parser_state = 0x7fe3b669a5b0 thd = 0x7fe3acbea008 #8 0x00000000005b89b7 in dispatch_command (command=COM_QUERY, thd=0x7fe3acbea008, packet=, packet_length=) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:1299 packet_end = 0x7fe3a401f032 "" parser_state = {m_lip = {m_thd = 0x7fe3acbea008, yylineno = 1, yytoklen = 4, yylval = 0x7fe3b6699430, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7fe3a401f033 "\002", m_tok_start = 0x7fe3a401f033 "\002", m_tok_end = 0x7fe3a401f033 "\002", m_end_of_query = 0x7fe3a401f032 "", m_tok_start_prev = 0x7fe3a401f032 "", m_buf = 0x7fe3a401f020 "analyze table test", m_buf_length = 18, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7fe3a401f090 "analyze table test", m_cpp_ptr = 0x7fe3a401f0a2 "", m_cpp_tok_start = 0x7fe3a401f0a2 "", m_cpp_tok_start_prev = 0x7fe3a401f0a2 "", m_cpp_tok_end = 0x7fe3a401f0a2 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7fe3a401f09e "test", m_cpp_text_end = 0x7fe3a401f0a2 "", m_underscore_cs = 0x0, m_digest_psi = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_UNLOCK, m_mdl_type = MDL_SHARED_READ}} net = 0x7fe3acbea238 error = false __FUNCTION__ = "dispatch_command" #9 0x00000000005b945b in do_command (thd=) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:996 packet = packet_length = net = command = #10 0x0000000000660874 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1375 create_user = true thd = 0x7fe3acbea008 #11 0x00000000006608d8 in handle_one_connection (arg=arg@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1289 thd = 0x7fe3acbea008 #12 0x00000000009bdc44 in pfs_spawn_thread (arg=0x7fe3b5c2f208) at /home/dan/software_projects/mariadb-trunk/storage/perfschema/pfs.cc:1860 ---Type to continue, or q to quit--- typed_arg = 0x7fe3b5c2f208 user_arg = 0x7fe3acbea008 pfs = user_start_routine = 0x6608a0 klass = #13 0x0000003911207ee5 in start_thread (arg=0x7fe3b669b700) at pthread_create.c:309 __res = pd = 0x7fe3b669b700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140615994685184, 3233230335253725930, 0, 0, 140615994685888, 140615994685184, -3235324993549057302, 3219123330129511146}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = #14 0x0000003910af4b8d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111 No locals. (gdb) bt #0 free_field_buffers_larger_than (table=table@entry=0x7fe3a406a208, size=size@entry=65536) at /home/dan/software_projects/mariadb-trunk/sql/table.cc:3026 #1 0x00000000005736cf in close_thread_table (thd=thd@entry=0x7fe3acbea008, table_ptr=table_ptr@entry=0x7fe3acbea0c8) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1045 #2 0x00000000005738a3 in close_open_tables (thd=) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:779 #3 close_thread_tables (thd=thd@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1003 #4 0x000000000066b3ff in mysql_admin_table (thd=thd@entry=0x7fe3acbea008, tables=tables@entry=0x7fe3a401f0f0, check_opt=check_opt@entry=0x7fe3acbeea00, operator_name=operator_name@entry=0xafd50f "analyze", lock_type=lock_type@entry=TL_READ_NO_INSERT, open_for_modify=open_for_modify@entry=true, repair_table_use_frm=repair_table_use_frm@entry=false, extra_open_options=extra_open_options@entry=0, prepare_func=prepare_func@entry=0x0, operator_func=, view_operator_func=view_operator_func@entry=0x0) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1024 #5 0x000000000066c67c in Sql_cmd_analyze_table::execute (this=, thd=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1148 #6 0x00000000005b085d in mysql_execute_command (thd=thd@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:5078 #7 0x00000000005b6d88 in mysql_parse (thd=0x7fe3acbea008, rawbuf=, length=18, parser_state=0x7fe3b669a5b0) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:6407 #8 0x00000000005b89b7 in dispatch_command (command=COM_QUERY, thd=0x7fe3acbea008, packet=, packet_length=) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:1299 #9 0x00000000005b945b in do_command (thd=) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:996 #10 0x0000000000660874 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1375 #11 0x00000000006608d8 in handle_one_connection (arg=arg@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1289 #12 0x00000000009bdc44 in pfs_spawn_thread (arg=0x7fe3b5c2f208) at /home/dan/software_projects/mariadb-trunk/storage/perfschema/pfs.cc:1860 #13 0x0000003911207ee5 in start_thread (arg=0x7fe3b669b700) at pthread_create.c:309 #14 0x0000003910af4b8d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111