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

[PS8QA] Assertion failure table_id == id in dict0dd.cc:2010

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Cannot Reproduce
    • Affects Version/s: 8.0.x, Not 5.7.x
    • Fix Version/s: None
    • Component/s: None

      Description

      Testcase

      rm -Rf /dev/shm/1545055992
      mkdir -p /dev/shm/1545055992/tmp
      
      /home/ramesh/pquery/PS151218-percona-server-8.0.13-2-linux-x86_64-debug/bin/mysqld --no-defaults --initialize-insecure --early-plugin-load=keyring_file.so --keyring_file_data=keyring --innodb_sys_tablespace_encrypt=ON --basedir=/home/ramesh/pquery/PS151218-percona-server-8.0.13-2-linux-x86_64-debug --datadir=/dev/shm/1545055992/data
      
      /home/ramesh/pquery/PS151218-percona-server-8.0.13-2-linux-x86_64-debug/bin/mysqld --no-defaults --basedir=/home/ramesh/pquery/PS151218-percona-server-8.0.13-2-linux-x86_64-debug --datadir=/dev/shm/1545055992/data --tmpdir=/dev/shm/1545055992/tmp --port=33785 --pid-file=/dev/shm/1545055992/pid.pid --core-file --socket=/dev/shm/1545055992/socket.sock --log-error=/dev/shm/1545055992/error.log.out --early-plugin-load=keyring_file.so --keyring_file_data=keyring --innodb_sys_tablespace_encrypt=ON &
      
      SQL
      
      CREATE DATABASE test;
      USE test;
      CREATE TABLE t0(id int KEY AUTO_INCREMENT);
      ALTER TABLE t0 DISCARD TABLESPACE;
      ALTER TABLE t0 ADD COLUMN c0 INT COMMENT'';
      

      GDB Info

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x00000000045b1f76 in my_write_core (sig=6) at /home/ramesh/pquery/PS-8.0-new_dbg/mysys/stacktrace.cc:278
      #2  0x00000000034463a3 in handle_fatal_signal (sig=6) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/signal_handler.cc:254
      #3  <signal handler called>
      #4  0x00007fdb4bbc0428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007fdb4bbc202a in __GI_abort () at abort.c:89
      #6  0x0000000004b248e7 in ut_dbg_assertion_failed (expr=0x5e3bd27 "table_id == id", file=0x5e3af50 "/home/ramesh/pquery/PS-8.0-new_dbg/storage/innobase/dict/dict0dd.cc", line=2010) at /home/ramesh/pquery/PS-8.0-new_dbg/storage/innobase/ut/ut0dbg.cc:90
      #7  0x0000000004c33e32 in dd_update_v_cols (dd_table=0x7fdb19420a88, id=1062) at /home/ramesh/pquery/PS-8.0-new_dbg/storage/innobase/dict/dict0dd.cc:2010
      #8  0x000000000489dded in dd_commit_instant_table (new_table=0x7fdb196154b8, old_table=0x7fdb194af020, altered_table=0x7fdb194e0820, old_dd_tab=0x7fdb19420488, new_dd_tab=0x7fdb19420a88) at /home/ramesh/pquery/PS-8.0-new_dbg/storage/innobase/handler/handler0alter.cc:3864
      #9  0x00000000048a74d6 in dd_commit_inplace_instant<dd::Table> (ha_alter_info=0x7fdb4b9086e0, thd=0x7fdb19425000, trx=0x7fdb33000aa0, table=0x7fdb196154b8, old_table=0x7fdb194af020, altered_table=0x7fdb194e0820, old_dd_tab=0x7fdb19420488, new_dd_tab=0x7fdb19420a88, autoinc=0x7fdb196156f8) at /home/ramesh/pquery/PS-8.0-new_dbg/storage/innobase/handler/handler0alter.cc:3945
      #10 0x0000000004897d9d in ha_innobase::commit_inplace_alter_table (this=0x7fdb1965b028, altered_table=0x7fdb194e0820, ha_alter_info=0x7fdb4b9086e0, commit=true, old_dd_tab=0x7fdb19420488, new_dd_tab=0x7fdb19420a88) at /home/ramesh/pquery/PS-8.0-new_dbg/storage/innobase/handler/handler0alter.cc:1239
      #11 0x0000000002ed44de in handler::ha_commit_inplace_alter_table (this=0x7fdb1965b028, altered_table=0x7fdb194e0820, ha_alter_info=0x7fdb4b9086e0, commit=true, old_table_def=0x7fdb19420488, new_table_def=0x7fdb19420a88) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/handler.cc:4993
      #12 0x00000000033325aa in mysql_inplace_alter_table (thd=0x7fdb19425000, schema=..., new_schema=..., table_def=0x7fdb19420488, altered_table_def=0x7fdb19420a88, table_list=0x7fdb195ebf88, table=0x7fdb194af020, altered_table=0x7fdb194e0820, ha_alter_info=0x7fdb4b9086e0, inplace_supported=HA_ALTER_INPLACE_INSTANT, alter_ctx=0x7fdb4b9093b0, columns=std::set with 0 elements, fk_key_info=0x7fdb19649990, fk_key_count=0, fk_invalidator=0x7fdb4b908620) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/sql_table.cc:11803
      #13 0x000000000333df51 in mysql_alter_table (thd=0x7fdb19425000, new_db=0x7fdb195ec520 "test", new_name=0x0, create_info=0x7fdb4b90a6e0, table_list=0x7fdb195ebf88, alter_info=0x7fdb4b90a7f0) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/sql_table.cc:15355
      #14 0x0000000003192eaa in Sql_cmd_alter_table::execute (this=0x7fdb195ec628, thd=0x7fdb19425000) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/sql_alter.cc:365
      #15 0x0000000003274ef9 in mysql_execute_command (thd=0x7fdb19425000, first_level=true) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/sql_parse.cc:4518
      #16 0x0000000003277645 in mysql_parse (thd=0x7fdb19425000, parser_state=0x7fdb4b90c2c0, update_userstat=false, force_primary_storage_engine=false) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/sql_parse.cc:5259
      #17 0x000000000326c5bb in dispatch_command (thd=0x7fdb19425000, com_data=0x7fdb4b90cc90, command=COM_QUERY) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/sql_parse.cc:1734
      #18 0x000000000326ab32 in do_command (thd=0x7fdb19425000) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/sql_parse.cc:1290
      #19 0x000000000342fc54 in handle_connection (arg=0x7fdb356bc430) at /home/ramesh/pquery/PS-8.0-new_dbg/sql/conn_handler/connection_handler_per_thread.cc:317
      #20 0x00000000046a8ea6 in pfs_spawn_thread (arg=0x7fdb3558e620) at /home/ramesh/pquery/PS-8.0-new_dbg/storage/perfschema/pfs.cc:2836
      #21 0x00007fdb4d8ea6ba in start_thread (arg=0x7fdb4b90d700) at pthread_create.c:333
      #22 0x00007fdb4bc9241d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                ramesh.sivaraman Ramesh Sivaraman
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: