Details
-
Bug
-
Status: Done
-
Critical
-
Resolution: Duplicate
-
8.0.x
-
None
-
None
-
None
Description
SET expand_fast_index_creation=ON; ALTER TABLE mysql.db ORDER BY db DESC;
Leads to:
Core was generated by `/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-opt/bin/mysqld --no-defaults'. Program terminated with signal SIGSEGV, Segmentation fault. #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 [Current thread is 1 (Thread 0x7fe6f5869700 (LWP 32499))] (gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x00005580787cf307 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278 #2 0x00005580779a5b25 in handle_fatal_signal (sig=11) at signal_handler.cc:254 #3 <signal handler called> #4 0x0000558078c0f413 in dd_write_index<dd::Index> (index=0x0, dd_index=<optimized out>, dd_space_id=1) at dict/dict0dd.cc:1880 #5 dd_write_table<dd::Table> (dd_space_id=dd_space_id@entry=1, dd_table=dd_table@entry=0x7fe674c6f2f8, table=table@entry=0x7fe674cfc488) at dict/dict0dd.cc:1921 #6 0x00005580789915f4 in dd_commit_inplace_alter_table<dd::Table> (new_dd_tab=0x7fe674c6f2f8, old_dd_tab=0x7fe6d3cd3e78, new_table=0x7fe674cfc488, old_info=<synthetic pointer>...) at handler/handler0alter.cc:3903 #7 ha_innobase::commit_inplace_alter_table (this=0x7fe674cfa028, altered_table=<optimized out>, ha_alter_info=<optimized out>, commit=<optimized out>, old_dd_tab=0x7fe6d3cd3e78, new_dd_tab=0x7fe674c6f2f8) at handler/handler0alter.cc:1226 #8 0x000055807790ff9a in remove_secondary_keys (alter_info=0x7fe6f58665f0, alter_info=0x7fe6f58665f0, altered_table_def=0x7fe674c6f2f8, table_def=0x7fe6d3cd3e78, table=<optimized out>, create_info=0x7fe6f58664f0, thd= 0x7fe674c17000) at sql_table.cc:12855 #9 mysql_alter_table (thd=thd@entry=0x7fe674c17000, new_db=<optimized out>, new_name=<optimized out>, create_info=create_info@entry=0x7fe6f58664f0, table_list=<optimized out>, table_list@entry=0x7fe674c63e90, alter_info=alter_info@entry=0x7fe6f58665f0) at sql_table.cc:14316 #10 0x0000558077c5fe74 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7fe674c17000) at sql_alter.cc:350 #11 0x000055807787ad75 in mysql_execute_command (thd=thd@entry=0x7fe674c17000, first_level=first_level@entry=true) at sql_parse.cc:4417 #12 0x000055807787f14b in mysql_parse (thd=thd@entry=0x7fe674c17000, parser_state=parser_state@entry=0x7fe6f5867d40, update_userstat=update_userstat@entry=false) at sql_parse.cc:5139 #13 0x0000558077881f12 in dispatch_command (thd=thd@entry=0x7fe674c17000, com_data=com_data@entry=0x7fe6f5868c60, command=COM_QUERY) at sql_parse.cc:1654 #14 0x0000558077882c49 in do_command (thd=thd@entry=0x7fe674c17000) at sql_parse.cc:1262 #15 0x00005580779971c0 in handle_connection (arg=arg@entry=0x7fe67445f730) at conn_handler/connection_handler_per_thread.cc:317 #16 0x0000558078897caf in pfs_spawn_thread (arg=0x7fe6e8beea20) at pfs.cc:2836 #17 0x00007fe6f74b36db in start_thread (arg=0x7fe6f5869700) at pthread_create.c:463 #18 0x00007fe6f598b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
in PS 8.0.12, inc optimized build.
Attachments
Issue Links
- duplicates
-
PS-4892 Re-implement expanded fast index creation in 8.0 DD
-
- Done
-