[MDEV-7380] engine-independent stats SEGV on ANALYZE TABLE (#2) Created: 2014-12-26  Updated: 2015-01-22  Resolved: 2015-01-22

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.0
Fix Version/s: 10.0.16

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Vicențiu Ciorbaru
Resolution: Fixed Votes: 0
Labels: None

Attachments: Text File globals.txt     File my.cnf    
Issue Links:
Relates
relates to MDEV-7362 ANALYZE TABLES crash with table-indep... Closed

 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.
 



 Comments   
Comment by Elena Stepanova [ 2014-12-26 ]

Okay, that's my bad. The oversimplified test case which I added to MDEV-7362 causes the assertion failure on a debug build, but on a release build it causes the crash described here, in MDEV-7380, not the crash from MDEV-7362. So, I'm moving here the comment from MDEV-7362, while MDEV-7362 might 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;

Debug assertion and stack trace from 10.0 revno 4543

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

Release crash on 10.0 revno 4543

#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

Generated at Thu Feb 08 07:19:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.