Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34222

Alter operation on redundant table aborts the server

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      SET GLOBAL INNODB_DEFAULT_ROW_FORMAT=redundant;
      CREATE TABLE t (c CHAR(1)) ENGINE=INNODB;
      SET GLOBAL INNODB_DEFAULT_ROW_FORMAT=compact;
      ALTER TABLE t page_compressed=1;
      

      Leads to:

      11.4.2 19f7edf42098ae7df893d125b6014dffc2b082e1 (Optimized)

      InnoDB: Failing assertion: dict_tf_is_valid(flags)
      

      11.4.2 19f7edf42098ae7df893d125b6014dffc2b082e1 (Optimized)

      Core was generated by `/test/MD220524-mariadb-11.4.2-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x14daec084700 (LWP 1000861))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000014db035c5859 in __GI_abort () at abort.c:79
      #2  0x00005577dca6a7d5 in ut_dbg_assertion_failed (expr=expr@entry=0x5577dd7f2e6c "dict_tf_is_valid(flags)", file=file@entry=0x5577dd7ed0e0 "/test/11.4_opt/storage/innobase/include/dict0dict.inl", line=line@entry=689) at /test/11.4_opt/storage/innobase/ut/ut0dbg.cc:60
      #3  0x00005577dd1bcba9 in dict_tf_to_sys_tables_type (flags=1664) at /test/11.4_opt/storage/innobase/include/dict0dict.inl:689
      #4  innobase_page_compression_try (table_name=0x14dab80124bd "t", trx=0x14db00c59680, table=0x14dab801c710, level=<optimized out>) at /test/11.4_opt/storage/innobase/handler/handler0alter.cc:10486
      #5  commit_try_norebuild (ha_alter_info=ha_alter_info@entry=0x14daec07f950, ctx=ctx@entry=0x14dab80194f8, altered_table=altered_table@entry=0x14daec07fa10, old_table=0x14dab801f8b8, statistics_exist=<optimized out>, trx=trx@entry=0x14db00c59680, table_name=0x14dab80124bd "t") at /test/11.4_opt/storage/innobase/handler/handler0alter.cc:10567
      #6  0x00005577dd1b0578 in ha_innobase::commit_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>, commit=<optimized out>) at /test/11.4_opt/storage/innobase/handler/handler0alter.cc:11513
      #7  0x00005577dccb541f in mysql_inplace_alter_table (target_mdl_request=0x14daec080280, if_exists=false, start_alter_id=@0x14daec07f890: 0, partial_alter=@0x14daec07f887: false, alter_ctx=0x14daec081460, trigger_param=0x14daec07fe20, ddl_log_state=0x14daec07f8f0, ha_alter_info=0x14daec07f950, altered_table=0x14daec07fa10, table=0x14dab801f8b8, table_list=0x14dab8017f38, thd=0x14dab8000c58) at /test/11.4_opt/sql/sql_table.cc:7948
      #8  mysql_alter_table (thd=thd@entry=0x14dab8000c58, new_db=new_db@entry=0x14dab80057f0, new_name=new_name@entry=0x14dab8005c50, create_info=create_info@entry=0x14daec0822f0, table_list=<optimized out>, table_list@entry=0x14dab8017f38, recreate_info=recreate_info@entry=0x14daec082160, alter_info=0x14daec082180, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/11.4_opt/sql/sql_table.cc:11242
      #9  0x00005577dcd233ff in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x14dab8000c58) at /test/11.4_opt/sql/structs.h:569
      #10 0x00005577dcbee5de in mysql_execute_command (thd=0x14dab8000c58, is_called_from_prepared_stmt=<optimized out>) at /test/11.4_opt/sql/sql_parse.cc:5836
      #11 0x00005577dcbddde6 in mysql_parse (thd=0x14dab8000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/11.4_opt/sql/sql_parse.cc:7862
      #12 0x00005577dcbea4cd in dispatch_command (command=COM_QUERY, thd=0x14dab8000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/11.4_opt/sql/sql_class.h:1562
      #13 0x00005577dcbec82e in do_command (thd=0x14dab8000c58, blocking=blocking@entry=true) at /test/11.4_opt/sql/sql_parse.cc:1406
      #14 0x00005577dcd1e077 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /test/11.4_opt/sql/sql_connect.cc:1437
      #15 0x00005577dcd1e3bd in handle_one_connection (arg=arg@entry=0x5577dfbb21a8) at /test/11.4_opt/sql/sql_connect.cc:1339
      #16 0x00005577dd0cea2c in pfs_spawn_thread (arg=0x5577dfbd8078) at /test/11.4_opt/storage/perfschema/pfs.cc:2201
      #17 0x000014db03ad6609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #18 0x000014db036c2133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.4.34 (dbg), 10.4.34 (opt), 10.5.26 (dbg), 10.5.26 (opt), 10.6.18 (dbg), 10.6.18 (opt), 10.11.8 (dbg), 10.11.8 (opt), 11.0.6 (dbg), 11.0.6 (opt), 11.1.5 (dbg), 11.1.5 (opt), 11.2.4 (dbg), 11.2.4 (opt), 11.3.3 (dbg), 11.3.3 (opt), 11.4.2 (dbg), 11.4.2 (opt), 11.5.0 (dbg), 11.5.0 (opt)

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.