UniqueID: !index->is_spatial()|SIGABRT|btr_estimate_number_of_different_key_vals|dict_stats_update_transient_for_index|dict_stats_update_for_index|alter_stats_norebuild Branch Revision: 16ec27c23c614ebea8f58a38adf601ea70e7c549 Error log: mariadbd: /test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/dict/dict0stats.cc:1201: std::vector btr_estimate_number_of_different_key_vals(dict_index_t*, trx_id_t): Assertion `!index->is_spatial()' failed. Full Stack: Core was generated by `/test/PATCH4_MD281123-mariadb-10.6.17-linux-x86_64-dbg/bin/mariadbd --no-defaul'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=23436853257792) at ./nptl/pthread_kill.c:44 [Current thread is 1 (Thread 0x1550d1502640 (LWP 537971))] (gdb) bt #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=23436853257792) at ./nptl/pthread_kill.c:44 #1 __pthread_kill_internal (signo=6, threadid=23436853257792) at ./nptl/pthread_kill.c:78 #2 __GI___pthread_kill (threadid=23436853257792, signo=signo@entry=6) at ./nptl/pthread_kill.c:89 #3 0x00001550e8842476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26 #4 0x00001550e88287f3 in __GI_abort () at ./stdlib/abort.c:79 #5 0x00001550e882871b in __assert_fail_base (fmt=0x1550e89dd150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x557135e25af4 "!index->is_spatial()", file=0x557135e7ff98 "/test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/dict/dict0stats.cc", line=1201, function=) at ./assert/assert.c:92 #6 0x00001550e8839e96 in __GI___assert_fail (assertion=0x557135e25af4 "!index->is_spatial()", file=0x557135e7ff98 "/test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/dict/dict0stats.cc", line=1201, function=0x557135e81508 "std::vector btr_estimate_number_of_different_key_vals(dict_index_t*, trx_id_t)") at ./assert/assert.c:101 #7 0x0000557135927e49 in btr_estimate_number_of_different_key_vals (bulk_trx_id=0, index=0x15508c435b28) at /test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/include/dict0mem.h:1215 #8 dict_stats_update_transient_for_index (index=index@entry=0x15508c435b28) at /test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/dict/dict0stats.cc:1533 #9 0x0000557135929872 in dict_stats_update_for_index (index=index@entry=0x15508c435b28) at /test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/dict/dict0stats.cc:4035 #10 0x0000557135675e5f in alter_stats_norebuild (thd=, ctx=, ha_alter_info=) at /test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/handler/handler0alter.cc:10982 #11 ha_innobase::commit_inplace_alter_table (this=, altered_table=, ha_alter_info=, commit=) at /test/bb-10.6-MDEV-32830-qa_dbg/storage/innobase/handler/handler0alter.cc:11738 #12 0x00005571352b428f in handler::ha_commit_inplace_alter_table (this=0x15508dc408c0, altered_table=altered_table@entry=0x1550d14fe870, ha_alter_info=ha_alter_info@entry=0x1550d14fe7b0, commit=commit@entry=true) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/handler.cc:5347 #13 0x00005571350ad4a2 in mysql_inplace_alter_table (thd=thd@entry=0x15508c000d58, table_list=0x15508c013528, table=table@entry=0x15508dc40088, altered_table=altered_table@entry=0x1550d14fe870, ha_alter_info=ha_alter_info@entry=0x1550d14fe7b0, target_mdl_request=target_mdl_request@entry=0x1550d14ff0c0, ddl_log_state=0x1550d14fe740, trigger_param=0x1550d14fec70, alter_ctx=0x1550d14fff90) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_table.cc:7537 #14 0x00005571350bf7aa in mysql_alter_table (thd=thd@entry=0x15508c000d58, new_db=new_db@entry=0x15508c013540, new_name=new_name@entry=0x15508c013550, create_info=create_info@entry=0x1550d1500e60, table_list=, table_list@entry=0x15508c013528, recreate_info=recreate_info@entry=0x1550d1500ce0, alter_info=, order_num=, order=, ignore=, if_exists=) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_table.cc:10490 #15 0x0000557134fed083 in mysql_execute_command (thd=thd@entry=0x15508c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_parse.cc:4227 #16 0x0000557134ff3933 in mysql_parse (thd=thd@entry=0x15508c000d58, rawbuf=, length=, parser_state=parser_state@entry=0x1550d15011f0) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_parse.cc:8051 #17 0x0000557134ff5ca9 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x15508c000d58, packet=packet@entry=0x15508c00b059 "CREATE SPATIAL INDEX idx2 on tab(c3 DESC) COMMENT 'wl6968';", packet_length=packet_length@entry=59, blocking=blocking@entry=true) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_class.h:241 #18 0x0000557134ff7dc3 in do_command (thd=0x15508c000d58, blocking=blocking@entry=true) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_parse.cc:1409 #19 0x000055713513c195 in do_handle_one_connection (connect=, connect@entry=0x557138369a18, put_in_cache=put_in_cache@entry=true) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_connect.cc:1416 #20 0x000055713513c48a in handle_one_connection (arg=arg@entry=0x557138369a18) at /test/bb-10.6-MDEV-32830-qa_dbg/sql/sql_connect.cc:1318 #21 0x000055713558a6fa in pfs_spawn_thread (arg=0x5571382f3f08) at /test/bb-10.6-MDEV-32830-qa_dbg/storage/perfschema/pfs.cc:2201 #22 0x00001550e8894ac3 in start_thread (arg=) at ./nptl/pthread_create.c:442 #23 0x00001550e8926a40 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 Query: CREATE SPATIAL INDEX idx2 on tab(c3 DESC) COMMENT 'wl6968';