Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5566

INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES queries may crash if online ALTER TABLE is running in parallel | Test percona_bug1294190 always failing

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 8.0, Not 5.6, Not 5.7
    • Fix Version/s: 8.0.15-6
    • Component/s: None

      Description

      On 8.0 trunk:

      190412  5:24:13 [ 88%] main.percona_bug1294190                  w6  [ fail ]
              Test ended at 2019-04-12 05:24:13
      
      CURRENT_TEST: main.percona_bug1294190
      mysqltest: At line 23: Query 'SELECT TABLE_SCHEMA, ENGINE, TABLE_ROWS
      FROM INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES' failed.
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      
      The result from queries just before the failure was:
      CREATE TABLE foo (id SERIAL PRIMARY KEY) ENGINE=innodb;
      INSERT INTO foo SELECT NULL;
      INSERT INTO foo SELECT NULL FROM foo;
      SET DEBUG_SYNC="after_open_altered_table signal open_done wait_for select_done";
      ALTER TABLE foo ADD COLUMN x INT, ADD KEY (x), ALGORITHM=INPLACE;
      SET DEBUG_SYNC="now wait_for open_done";
      ...
      #6  0x0000564e1623b0a4 in ut_dbg_assertion_failed (expr=0x564e1762c8cd "dd_table != nullptr", file=0x564e1762aa90 "/tmp/ps/storage/innobase/dict/dict0dd.cc", line=3951) at /tmp/ps/storage/innobase/ut/ut0dbg.cc:92
      #7  0x0000564e16386edb in dd_open_table_one<dd::Table> (client=0x7f93df080180, table=0x7f93df69d220, norm_name=0x7f93eabfa930 "test/#sql-415c_6e", dd_table=0x0, thd=0x7f93df05a000, fk_list=std::deque with 0 elements) at /tmp/ps/storage/innobase/dict/dict0dd.cc:3951
      #8  0x0000564e16386bb6 in dd_open_table<dd::Table> (client=0x7f93df080180, table=0x7f93df69d220, norm_name=0x7f93eabfa930 "test/#sql-415c_6e", dd_table=0x0, thd=0x7f93df05a000) at /tmp/ps/storage/innobase/dict/dict0dd.cc:4293
      #9  0x0000564e15efd698 in ha_innobase::open (this=0x7f93c6c91028, name=0x7f93df69df68 "./test/#sql-415c_6e", open_flags=2, table_def=0x0) at /tmp/ps/storage/innobase/handler/ha_innodb.cc:7262
      #10 0x0000564e14627ef2 in handler::ha_open (this=0x7f93c6c91028, table_arg=0x7f93df69d220, name=0x7f93df69df68 "./test/#sql-415c_6e", mode=0, test_if_locked=2, table_def=0x0) at /tmp/ps/sql/handler.cc:2836
      #11 0x0000564e1462786e in handler::clone (this=0x7f93c7983028, name=0x7f93df69df68 "./test/#sql-415c_6e", mem_root=0x7f93df05c580) at /tmp/ps/sql/handler.cc:2714
      #12 0x0000564e15eff139 in ha_innobase::clone (this=0x7f93c7983028, name=0x7f93df69df68 "./test/#sql-415c_6e", mem_root=0x7f93df05c580) at /tmp/ps/storage/innobase/handler/ha_innodb.cc:7774
      #13 0x0000564e14a6299c in store_temporary_table_record (thd=0x7f93df424000, table=0x7f93c6ec3028, tmp_table=0x7f93df69d220, db=0x0, mem_root=0x7f93df05c580) at /tmp/ps/sql/sql_show.cc:3976
      #14 0x0000564e14a6c3b6 in Fill_global_temporary_tables::operator() (this=0x7f93eabfb100, thd=0x7f93df424000) at /tmp/ps/sql/sql_show.cc:4079
      #15 0x0000564e147fd85a in Do_THD::operator() (this=0x7f93eabfae28, thd=0x7f93df424000) at /tmp/ps/sql/mysqld_thd_manager.cc:82
      #16 0x0000564e147fe03c in std::for_each<THD**, Do_THD> (__first=0x7f93eabfaea0, __last=0x7f93eabfaea8, __f=...) at /usr/include/c++/7/bits/stl_algo.h:3884
      #17 0x0000564e147fd1a8 in Global_THD_manager::do_for_all_thd_copy (this=0x7f93eebfd000, func=0x7f93eabfb100) at /tmp/ps/sql/mysqld_thd_manager.cc:279
      #18 0x0000564e14a62d3a in fill_global_temporary_tables (thd=0x7f93df05a000, tables=0x7f93c81c05b8, cond=0x0) at /tmp/ps/sql/sql_show.cc:4095
      #19 0x0000564e14a676ef in do_fill_table (thd=0x7f93df05a000, table_list=0x7f93c81c05b8, qep_tab=0x7f93c8327390) at /tmp/ps/sql/sql_show.cc:5256
      #20 0x0000564e14a67c0f in get_schema_tables_result (join=0x7f93c8326a90, executed_place=PROCESSED_BY_JOIN_EXEC) at /tmp/ps/sql/sql_show.cc:5370
      #21 0x0000564e14a40446 in JOIN::prepare_result (this=0x7f93c8326a90) at /tmp/ps/sql/sql_select.cc:1429
      #22 0x0000564e14958d99 in JOIN::exec (this=0x7f93c8326a90) at /tmp/ps/sql/sql_executor.cc:202
      #23 0x0000564e14a3eac0 in Sql_cmd_dml::execute_inner (this=0x7f93c81c0b68, thd=0x7f93df05a000) at /tmp/ps/sql/sql_select.cc:696
      #24 0x0000564e14a3e4ca in Sql_cmd_dml::execute (this=0x7f93c81c0b68, thd=0x7f93df05a000) at /tmp/ps/sql/sql_select.cc:594
      #25 0x0000564e149d79e3 in mysql_execute_command (thd=0x7f93df05a000, first_level=true) at /tmp/ps/sql/sql_parse.cc:4575
      #26 0x0000564e149da1ba in mysql_parse (thd=0x7f93df05a000, parser_state=0x7f93eabfcb60, update_userstat=false, force_primary_storage_engine=false) at /tmp/ps/sql/sql_parse.cc:5333
      #27 0x0000564e149cef46 in dispatch_command (thd=0x7f93df05a000, com_data=0x7f93eabfdc30, command=COM_QUERY) at /tmp/ps/sql/sql_parse.cc:1760
      #28 0x0000564e149cd3c5 in do_command (thd=0x7f93df05a000) at /tmp/ps/sql/sql_parse.cc:1292
      #29 0x0000564e14b9af35 in handle_connection (arg=0x7f93f13f9f60) at /tmp/ps/sql/conn_handler/connection_handler_per_thread.cc:311
      #30 0x0000564e15e01fb2 in pfs_spawn_thread (arg=0x7f93eb651b20) at /tmp/ps/storage/perfschema/pfs.cc:2836
      #31 0x00007f93fa87c6db in start_thread (arg=0x7f93eabfe700) at pthread_create.c:463
      #32 0x00007f93f86fe88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                laurynas.biveinis Laurynas Biveinis
                Reporter:
                laurynas.biveinis Laurynas Biveinis
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 3 hours, 13 minutes
                  3h 13m