[PS8QA] Enabling expand_fast_index_creation leads to handle_fatal_signal (sig=11) in dd_write_index

General

Escalation

General

Escalation

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.

Environment

None

Linked work items

duplicates

PS-4892

Re-implement expanded fast index creation in 8.0 DD

Activity

Laurynas Biveinis

September 24, 2018 at 2:29 PM

Closing as duplicate of https://perconadev.atlassian.net/browse/PS-4892#icft=PS-4892, which should be the master 8.0 issue for this feature

Laurynas Biveinis

September 24, 2018 at 2:13 PM

This is a feature whose 8.0 port will require more work and any current crashes are fully expected. No relation to upstream 92188

roel.vandepaar

September 24, 2018 at 12:20 AM

Another testcase

CREATE DATABASE test;
USE test;
SET SESSION expand_fast_index_creation=ON;
CREATE TABLE t3(c1 INT UNSIGNED,c2 INT,c3 INT,c4 INT,c5 INT,c6 INT,c7 INT,index idx(c2,c7));
ALTER TABLE t3 CHANGE c1 c1 DECIMAL;

roel.vandepaar

September 22, 2018 at 1:34 AM

(edited)

A perhaps more pleasant testcase

CREATE DATABASE test;
USE test;
SET expand_fast_index_creation=ON;
CREATE TABLE t1 (id INT PRIMARY KEY,c1 INT,KEY(c1));
ALTER TABLE t1 ORDER BY id;

Does not crash upstream.

Resize issue view side panel

Duplicate

Details

Assignee

Laurynas Biveinis(Deactivated)

Reporter

roel.vandepaar(Deactivated)

Time tracking

27m logged

Affects versions

8.0.x

Priority

Critical

Created September 22, 2018 at 1:15 AM

Updated March 6, 2024 at 12:48 PM

Resolved September 25, 2018 at 3:56 PM