Details
Description
Same server
cd mysql-test ./mtr (stopped at some point) /home/dan/software_projects/mariadb-trunk/sql/mysqld --defaults-group-suffix=.2 --defaults-file=/home/dan/software_projects/mariadb-trunk/mysql-test/var/my.cnf 141226 23:34:09 [Note] Plugin 'InnoDB' is disabled. 141226 23:34:09 [Note] Plugin 'XTRADB_READ_VIEW' is disabled. 141226 23:34:09 [Note] Plugin 'XTRADB_INTERNAL_HASH_TABLES' is disabled. 141226 23:34:09 [Note] Plugin 'XTRADB_RSEG' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_TRX' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_CMPMEM' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_METRICS' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_TABLES' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 141226 23:34:09 [Note] Plugin 'INNODB_CHANGED_PAGES' is disabled. 141226 23:34:09 [Note] Plugin 'partition' is disabled. 141226 23:34:09 [Warning] /home/dan/software_projects/mariadb-trunk/sql/mysqld: unknown variable 'loose-feedback-user-info=mysql-test' 141226 23:34:09 [Note] Server socket created on IP: '::'. 141226 23:34:09 [Note] Event Scheduler: Loaded 0 events 141226 23:34:09 [Note] /home/dan/software_projects/mariadb-trunk/sql/mysqld: ready for connections. Version: '10.0.16-MariaDB-log' socket: '/home/dan/software_projects/mariadb-trunk/mysql-test/var/tmp/mysqld.2.sock' port: 16001 Source distribution mysqlcheck --all-databases -S /home/dan/software_projects/mariadb-trunk/mysql-test/var/tmp/mysqld.2.sock mtr.global_suppressions OK mtr.test_suppressions OK mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats Error : Unknown storage engine 'InnoDB' error : Corrupt mysql.innodb_table_stats Error : Unknown storage engine 'InnoDB' error : Corrupt mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK test.t1 OK
MariaDB [test]> drop table if exists t1 ;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test]> CREATE TABLE t1 (f longtext NOT NULL, FULLTEXT KEY f (f)) ENGINE=MyISAM;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test]> INSERT INTO t1 VALUES (REPEAT('a',27)),('foo');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
MariaDB [test]> ANALYZE TABLE t1 PERSISTENT FOR ALL;
ERROR 2013 (HY000): Lost connection to MySQL server during query
141226 23:41:53 [ERROR] mysqld got signal 11 ; 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. To report this bug, see http://kb.askmonty.org/en/reporting-bugs 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. Server version: 10.0.16-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62921 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x7f19c6a41008 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... stack_bottom = 0x7f19cc997d38 thread_stack 0x48000 mysys/stacktrace.c:247(my_print_stacktrace)[0xaa4889] sql/signal_handler.cc:153(handle_fatal_signal)[0x6e19a8] /lib64/libpthread.so.0[0x391120f6d0] sql/table.cc:3027(free_field_buffers_larger_than(TABLE*, unsigned int))[0x63aad3] sql/sql_base.cc:1046(close_thread_table(THD*, TABLE**))[0x5736cf] sql/sql_base.cc:778(close_open_tables)[0x5738a3] sql/sql_admin.cc:1025(mysql_admin_table)[0x66b3ff] sql/sql_admin.cc:1150(Sql_cmd_analyze_table::execute(THD*))[0x66c67c] sql/sql_parse.cc:5078(mysql_execute_command(THD*))[0x5b085d] sql/sql_parse.cc:6407(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5b6d88] sql/sql_parse.cc:1301(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x5b89b7] sql/sql_connect.cc:1375(do_handle_one_connection(THD*))[0x660874] sql/sql_connect.cc:1291(handle_one_connection)[0x6608d8] perfschema/pfs.cc:1863(pfs_spawn_thread)[0x9bdc44] /lib64/libpthread.so.0[0x3911207ee5] /lib64/libc.so.6(clone+0x6d)[0x3910af4b8d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f19c4c1a020): ANALYZE TABLE t1 PERSISTENT FOR ALL Connection ID (thread ID): 6 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on 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.
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7f19cc998700 (LWP 20912)]
free_field_buffers_larger_than (table=table@entry=0x7f19c4c6aa08, size=size@entry=65536) at /home/dan/software_projects/mariadb-trunk/sql/table.cc:3027
3027 blob->free();
(gdb) bt
#0 free_field_buffers_larger_than (table=table@entry=0x7f19c4c6aa08, size=size@entry=65536) at /home/dan/software_projects/mariadb-trunk/sql/table.cc:3027
#1 0x00000000005736cf in close_thread_table (thd=thd@entry=0x7f19c6a41008, table_ptr=table_ptr@entry=0x7f19c6a410c8) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1045
#2 0x00000000005738a3 in close_open_tables (thd=<optimized out>) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:779
#3 close_thread_tables (thd=thd@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1003
#4 0x000000000066b3ff in mysql_admin_table (thd=thd@entry=0x7f19c6a41008, tables=tables@entry=0x7f19c4c1a118, check_opt=check_opt@entry=0x7f19c6a45a00,
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=<optimized out>,
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=<optimized out>, thd=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1148
#6 0x00000000005b085d in mysql_execute_command (thd=thd@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:5078
#7 0x00000000005b6d88 in mysql_parse (thd=0x7f19c6a41008, rawbuf=<optimized out>, length=35, parser_state=0x7f19cc9975b0)
at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:6407
#8 0x00000000005b89b7 in dispatch_command (command=COM_QUERY, thd=0x7f19c6a41008, packet=<optimized out>, packet_length=<optimized out>)
at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:1299
#9 0x00000000005b945b in do_command (thd=<optimized out>) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:996
#10 0x0000000000660874 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1375
#11 0x00000000006608d8 in handle_one_connection (arg=arg@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1289
#12 0x00000000009bdc44 in pfs_spawn_thread (arg=0x7f19cc02f208) at /home/dan/software_projects/mariadb-trunk/storage/perfschema/pfs.cc:1860
#13 0x0000003911207ee5 in start_thread (arg=0x7f19cc998700) at pthread_create.c:309
#14 0x0000003910af4b8d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
(gdb) up
#1 0x00000000005736cf in close_thread_table (thd=thd@entry=0x7f19c6a41008, table_ptr=table_ptr@entry=0x7f19c6a410c8) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1045
1045 free_field_buffers_larger_than(table, MAX_TDC_BLOB_SIZE);
(gdb) up
#2 0x00000000005738a3 in close_open_tables (thd=<optimized out>) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:779
779 (void) close_thread_table(thd, &thd->open_tables);
(gdb) p thd->opentables
value has been optimized out
(gdb) bt full
#0 free_field_buffers_larger_than (table=table@entry=0x7f19c4c6aa08, size=size@entry=65536) at /home/dan/software_projects/mariadb-trunk/sql/table.cc:3027
blob = 0x7f19c4c43c61
ptr = 0x7f19c4c43a68
end = 0x7f19c4c43a6c
#1 0x00000000005736cf in close_thread_table (thd=thd@entry=0x7f19c6a41008, table_ptr=table_ptr@entry=0x7f19c6a410c8) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1045
table = 0x7f19c4c6aa08
#2 0x00000000005738a3 in close_open_tables (thd=<optimized out>) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:779
No locals.
#3 close_thread_tables (thd=thd@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1003
table = <optimized out>
__FUNCTION__ = "close_thread_tables"
#4 0x000000000066b3ff in mysql_admin_table (thd=thd@entry=0x7f19c6a41008, tables=tables@entry=0x7f19c4c1a118, check_opt=check_opt@entry=0x7f19c6a45a00,
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=<optimized out>,
view_operator_func=view_operator_func@entry=0x0) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1024
table_name = "test.t1\000\000 ", '\000' <repeats 14 times>, ">\000\000\000\000\000\000\000>\000\000\000\000\000\000\000\200O\333\304\031\177\000\000\001", '\000' <repeats 15 times>, "(a\300\304\031\177\000\000㻟\314\031\177\000\000\240\273A\314\031\177\000\000\000\000\000\000?\000\000\000\300\265A\314\031\177\000\000`\030\302\314\031\177\000\000h\000\000\000\000\000\000\000\b", '\000' <repeats 15 times>, "(a\300\304\031\177\000\000\200\000\000\000\000\000\000\000(a\300\304\031\177\000\000`\030\302\314\031\177\000\000\b\000\000\000\000\000\000\000\000`\300\304\031\177\000\060\220a\231\314\031\177\000\000\320d\231\314\031\177\000\000\000\000\000\000\000\000\000\000"...
db = <optimized out>
fatal_error = <optimized out>
open_error = <optimized out>
table = <optimized out>
lex = 0x7f19c6a44b18
result_code = 0
select = 0x7f19c6a452c8
item = <optimized out>
protocol = 0x7f19c6a41508
need_repair_or_alter = false
field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7f19c4c1a790, last = 0x7f19c4c1a970, elements = 4}, <No data fields>}
compl_result_code = <optimized out>
#5 0x000000000066c67c in Sql_cmd_analyze_table::execute (this=<optimized out>, thd=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1148
m_lex = 0x7f19c6a44b18
first_table = 0x7f19c4c1a118
res = true
#6 0x00000000005b085d in mysql_execute_command (thd=thd@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:5078
res = 0
lex = 0x7f19c6a44b18
orig_binlog_format = BINLOG_FORMAT_STMT
up_result = 0
rpl_filter = <optimized out>
---Type <return> to continue, or q <return> to quit---
orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
__FUNCTION__ = "mysql_execute_command"
select_lex = 0x7f19c6a452c8
first_table = 0x7f19c4c1a118
all_tables = 0x7f19c4c1a118
unit = 0x7f19c6a44be0
have_table_map_for_update = false
#7 0x00000000005b6d88 in mysql_parse (thd=0x7f19c6a41008, rawbuf=<optimized out>, length=35, parser_state=0x7f19cc9975b0)
at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:6407
found_semicolon = <optimized out>
lex = 0x7f19c6a44b18
err = <optimized out>
rawbuf = <optimized out>
length = 35
parser_state = 0x7f19cc9975b0
thd = 0x7f19c6a41008
#8 0x00000000005b89b7 in dispatch_command (command=COM_QUERY, thd=0x7f19c6a41008, packet=<optimized out>, packet_length=<optimized out>)
at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:1299
packet_end = 0x7f19c4c1a043 ""
parser_state = {m_lip = {m_thd = 0x7f19c6a41008, yylineno = 1, yytoklen = 2, yylval = 0x7f19cc996430, lookahead_token = -1, lookahead_yylval = 0x0,
m_ptr = 0x7f19c4c1a044 "\004", m_tok_start = 0x7f19c4c1a044 "\004", m_tok_end = 0x7f19c4c1a044 "\004", m_end_of_query = 0x7f19c4c1a043 "",
m_tok_start_prev = 0x7f19c4c1a043 "", m_buf = 0x7f19c4c1a020 "ANALYZE TABLE t1 PERSISTENT FOR ALL", m_buf_length = 35, m_echo = true, m_echo_saved = false,
m_cpp_buf = 0x7f19c4c1a0a8 "ANALYZE TABLE t1 PERSISTENT FOR ALL", m_cpp_ptr = 0x7f19c4c1a0cb "", m_cpp_tok_start = 0x7f19c4c1a0cb "",
m_cpp_tok_start_prev = 0x7f19c4c1a0cb "", m_cpp_tok_end = 0x7f19c4c1a0cb "", 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 = 111 'o', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT,
in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7f19c4c1a0b6 "t1 PERSISTENT FOR ALL", m_cpp_text_end = 0x7f19c4c1a0b8 " PERSISTENT FOR ALL", m_underscore_cs = 0x0,
m_digest_psi = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_UNLOCK,
m_mdl_type = MDL_SHARED_READ}}
net = 0x7f19c6a41238
error = false
__FUNCTION__ = "dispatch_command"
#9 0x00000000005b945b in do_command (thd=<optimized out>) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:996
packet = <optimized out>
packet_length = <optimized out>
net = <optimized out>
command = <optimized out>
#10 0x0000000000660874 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1375
create_user = true
thd = 0x7f19c6a41008
#11 0x00000000006608d8 in handle_one_connection (arg=arg@entry=0x7f19c6a41008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1289
thd = 0x7f19c6a41008
---Type <return> to continue, or q <return> to quit---
#12 0x00000000009bdc44 in pfs_spawn_thread (arg=0x7f19cc02f208) at /home/dan/software_projects/mariadb-trunk/storage/perfschema/pfs.cc:1860
typed_arg = 0x7f19cc02f208
user_arg = 0x7f19c6a41008
pfs = <optimized out>
user_start_routine = 0x6608a0 <handle_one_connection(void*)>
klass = <optimized out>
#13 0x0000003911207ee5 in start_thread (arg=0x7f19cc998700) at pthread_create.c:309
__res = <optimized out>
pd = 0x7f19cc998700
now = <optimized out>
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {139748783523584, 2307879505077073138, 0, 0, 139748783524288, 139748783523584, -2435139957216119566, 2338809040791926002},
mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
not_first_call = <optimized out>
pagesize_m1 = <optimized out>
sp = <optimized out>
freesize = <optimized out>
#14 0x0000003910af4b8d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
No locals.
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-7362 ANALYZE TABLES crash with table-independent-statistics gathering
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Okay, that's my bad. The oversimplified test case which I added to
MDEV-7362causes the assertion failure on a debug build, but on a release build it causes the crash described here, inMDEV-7380, not the crash fromMDEV-7362. So, I'm moving here the comment fromMDEV-7362, whileMDEV-7362might require a bit more work.CREATE TABLE t1 (f longtext NOT NULL, FULLTEXT KEY f (f)) ENGINE=MyISAM; INSERT INTO t1 VALUES (REPEAT('a',27)),('foo'); ANALYZE TABLE t1 PERSISTENT FOR ALL;10.0/include/my_bitmap.h:130: uint bitmap_is_set(const MY_BITMAP*, uint): Assertion `bit < (map)->n_bits' failed. 141226 14:54:46 [ERROR] mysqld got signal 6 ; #6 0x00007fe22a33c6f1 in *__GI___assert_fail (assertion=0xf1acaa "bit < (map)->n_bits", file=<optimized out>, line=130, function=0xf1bca0 "uint bitmap_is_set(const MY_BITMAP*, uint)") at assert.c:81 #7 0x0000000000711237 in bitmap_is_set (map=0x7fe22249e580, bit=127) at 10.0/include/my_bitmap.h:130 #8 0x0000000000712dab in update_statistics_for_table (thd=0x7fe224f2f070, table=0x7fe22249e470) at 10.0/sql/sql_statistics.cc:2628 #9 0x00000000007a4f75 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=0x7fe224f2f070, tables=0x7fe222414180, check_opt=0x7fe224f33ba0, operator_name=0xf4ac87 "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x8712d4 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0) at 10.0/sql/sql_admin.cc:738 #10 0x00000000007a6565 in Sql_cmd_analyze_table::execute (this=0x7fe222414760, thd=0x7fe224f2f070) at 10.0/sql/sql_admin.cc:1148 #11 0x0000000000682928 in mysql_execute_command (thd=0x7fe224f2f070) at 10.0/sql/sql_parse.cc:5078 #12 0x00000000006859bd in mysql_parse (thd=0x7fe224f2f070, rawbuf=0x7fe222414088 "ANALYZE TABLE t1 PERSISTENT FOR ALL", length=35, parser_state=0x7fe22c549610) at 10.0/sql/sql_parse.cc:6407 #13 0x00000000006787b2 in dispatch_command (command=COM_QUERY, thd=0x7fe224f2f070, packet=0x7fe225ff6071 "", packet_length=35) at 10.0/sql/sql_parse.cc:1299 #14 0x0000000000677b57 in do_command (thd=0x7fe224f2f070) at 10.0/sql/sql_parse.cc:996 #15 0x0000000000794877 in do_handle_one_connection (thd_arg=0x7fe224f2f070) at 10.0/sql/sql_connect.cc:1375 #16 0x00000000007945ca in handle_one_connection (arg=0x7fe224f2f070) at 10.0/sql/sql_connect.cc:1289 #17 0x0000000000ccda5e in pfs_spawn_thread (arg=0x7fe224367bf0) at 10.0/storage/perfschema/pfs.cc:1860 #18 0x00007fe22c136b50 in start_thread (arg=<optimized out>) at pthread_create.c:304 #19 0x00007fe22a3ed20d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112#2 <signal handler called> #3 free_field_buffers_larger_than (table=0x7ff7d6890808, size=65536) at sql/table.cc:3027 #4 0x000000000059814f in close_thread_table (thd=thd@entry=0x7ff7eceba008, table_ptr=table_ptr@entry=0x7ff7eceba0c8) at sql/sql_base.cc:1045 #5 0x00000000005982a3 in close_open_tables (thd=<optimized out>) at sql/sql_base.cc:779 #6 close_thread_tables (thd=0x7ff7eceba008) at sql/sql_base.cc:1003 #7 0x000000000068d8cd in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=thd@entry=0x7ff7eceba008, tables=tables@entry=0x7ff7d681e118, check_opt=check_opt@entry=0x7ff7ecebea00, operator_name=operator_name@entry=0xb17fd0 "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=0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x709e20 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=view_operator_func@entry=0) at sql/sql_admin.cc:1024 #8 0x000000000068f076 in Sql_cmd_analyze_table::execute (this=<optimized out>, thd=0x7ff7eceba008) at sql/sql_admin.cc:1148 #9 0x00000000005d4a5f in mysql_execute_command (thd=thd@entry=0x7ff7eceba008) at sql/sql_parse.cc:5078 #10 0x00000000005daa1c in mysql_parse (parser_state=0x7ff800869180, thd=0x7ff7eceba008, rawbuf=<optimized out>, length=<optimized out>) at sql/sql_parse.cc:6407 #11 mysql_parse (thd=0x7ff7eceba008, rawbuf=<optimized out>, length=35, parser_state=0x7ff800869180) at sql/sql_parse.cc:6328 #12 0x00000000005dc0e5 in dispatch_command (command=COM_QUERY, thd=0x7ff7eceba008, packet=<optimized out>, packet_length=<optimized out>) at sql/sql_parse.cc:1299 #13 0x00000000006835fd in do_handle_one_connection (thd_arg=thd_arg@entry=0x7ff7eceba008) at sql/sql_connect.cc:1375 #14 0x00000000006836c0 in handle_one_connection (arg=0x7ff7eceba008) at sql/sql_connect.cc:1289 #15 0x00007ff80049fb50 in start_thread (arg=<optimized out>) at pthread_create.c:304 #16 0x00007ff7fe75620d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112