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

SIGSEGV in Locked_tables_list::unlink_from_list | close_all_tables_for_name

    XMLWordPrintable

Details

    Description

      The bug only exists in the preview-12.0-preview branch

      --source include/have_innodb.inc
      --source include/have_log_bin.inc
       
      CREATE TABLE t1 (a INT) ENGINE=INNODB;
      SET GLOBAL wsrep_forced_binlog_format=1;
      CREATE OR REPLACE TABLE t (c INT) ENGINE=INNODB;
      SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
      LOCK TABLES t1 WRITE,t WRITE;
      ALTER TABLE t ENGINE=MYISAM;
       
      --ERROR ER_BINLOG_STMT_MODE_AND_ROW_ENGINE
      CREATE OR REPLACE TABLE t ENGINE=INNODB SELECT 1;
      ALTER TABLE t ENGINE=INNODB;
       
      # Cleanup
      DROP TABLE t1,t;
      
      

      Leads to

      CS 12.0.0 61c96785d1910976fd740aa0724105b16952786d (Optimized) Build 08/04/2025

      Core was generated by `/test/mtest/MD080425-mariadb-12.0.0-linux-x86_64-opt/bin/mariadbd --no-defaults'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  Locked_tables_list::unlink_from_list (this=0x146d10004ea0, thd=0x146d10000c68, table_list=0x0, remove_from_locked_tables=true)at /test/mtest/12.0_opt/sql/sql_base.cc:2759
       
      [Current thread is 1 (Thread 0x146d7491e6c0 (LWP 1694068))]
      (gdb) bt
      #0  Locked_tables_list::unlink_from_list (this=0x146d10004ea0, thd=0x146d10000c68, table_list=0x0, remove_from_locked_tables=true)at /test/mtest/12.0_opt/sql/sql_base.cc:2759
      #1  close_all_tables_for_name (thd=thd@entry=0x146d10000c68, share=<optimized out>, extra=HA_EXTRA_NOT_USED, skip_table=skip_table@entry=0x146d10072098)at /test/mtest/12.0_opt/sql/sql_base.cc:762
      #2  0x000055b3aa8e6ce8 in mysql_inplace_alter_table (thd=thd@entry=0x146d10000c68, table_list=0x146d10017948, table=table@entry=0x146d10072098, altered_table=altered_table@entry=0x146d74919fe0, ha_alter_info=ha_alter_info@entry=0x146d7491a900, target_mdl_request=<optimized out>, ddl_log_state=ddl_log_state@entry=0x146d74919f40, trigger_param=0x146d7491b618, alter_ctx=0x146d7491a9c0, partial_alter=@0x146d74919fca: false, start_alter_id=@0x146d74919f78: 0, if_exists=<optimized out>) at /test/mtest/12.0_opt/sql/sql_table.cc:8358
      #3  0x000055b3aa8e2b2e in mysql_alter_table (thd=thd@entry=0x146d10000c68, new_db=new_db@entry=0x146d10005988, new_name=new_name@entry=0x146d10005e00, create_info=create_info@entry=0x146d7491c988, table_list=0x146d10017948, recreate_info=recreate_info@entry=0x146d7491c0d0, alter_info=0x146d7491c810, order_num=0, order=0x0, ignore=<optimized out>, if_exists=<optimized out>) at /test/mtest/12.0_opt/sql/sql_table.cc:11965
      #4  0x000055b3aa9586bc in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x146d10000c68) at /test/mtest/12.0_opt/sql/sql_alter.cc:695
      #5  0x000055b3aa828463 in mysql_execute_command (thd=thd@entry=0x146d10000c68, is_called_from_prepared_stmt=false)at /test/mtest/12.0_opt/sql/sql_parse.cc:5859
      #6  0x000055b3aa823e51 in mysql_parse (thd=thd@entry=0x146d10000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x146d7491d420)at /test/mtest/12.0_opt/sql/sql_parse.cc:7889
      #7  0x000055b3aa82236f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x146d10000c68, packet=packet@entry=0x146d10008bd9 "ALTER TABLE t ENGINE=INNODB", packet_length=packet_length@entry=27, blocking=true)at /test/mtest/12.0_opt/sql/sql_parse.cc:1875
      #8  0x000055b3aa824261 in do_command (thd=thd@entry=0x146d10000c68, blocking=true) at /test/mtest/12.0_opt/sql/sql_parse.cc:1416
      #9  0x000055b3aa951b2d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55b3dfdeef08, put_in_cache=true)at /test/mtest/12.0_opt/sql/sql_connect.cc:1415
      #10 0x000055b3aa9518ef in handle_one_connection (arg=arg@entry=0x55b3dfdeef08)at /test/mtest/12.0_opt/sql/sql_connect.cc:1327
      #11 0x000055b3aace0ed9 in pfs_spawn_thread (arg=0x55b3dfd9bbc8)at /test/mtest/12.0_opt/storage/perfschema/pfs.cc:2198
      #12 0x0000146d7aa9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #13 0x0000146d7ab29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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