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

ALTER TABLE SEQUENCE crashes server

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      --source include/have_innodb.inc
       
      SET DEFAULT_STORAGE_ENGINE=INNODB;
      CREATE SEQUENCE s MINVALUE 1 MAXVALUE 10 ;
      ALTER TABLE s SEQUENCE=0;
      INSERT INTO s VALUES (0,0,20,0,1,0,0,0);
      ALTER TABLE s SEQUENCE=1;
      

      Leads to:

      CS 10.6.24 e80998281aa1551f12a6b86cb3765796130d822d (Optimized, Clang 18.1.3-11) Build 31/10/2025

      Core was generated by `/test/MD311025-mariadb-10.6.24-linux-x86_64-opt/bin/mariadbd --no-defaults --ma'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  calc_row_difference (uvect=0x7dfeb805a790, old_row=0x7dfeb8056aa0 "\377\001", new_row=0x7dfeb8056a60 "\377", table=0x7dfeb8058b48, upd_buff=<optimized out>, buff_len=154, prebuilt=0x7dfeb8059a10, auto_inc=<optimized out>)at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:8441
       
      [Current thread is 1 (LWP 143195)]
      (gdb) bt
      #0  calc_row_difference (uvect=0x7dfeb805a790, old_row=0x7dfeb8056aa0 "\377\001", new_row=0x7dfeb8056a60 "\377", table=0x7dfeb8058b48, upd_buff=<optimized out>, buff_len=154, prebuilt=0x7dfeb8059a10, auto_inc=<optimized out>)at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:8441
      #1  ha_innobase::update_row (this=0x7dfeb8055d18, old_row=0x7dfeb8056aa0 "\377\001", new_row=0x7dfeb8056a60 "\377")at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:8618
      #2  0x0000561574ad4c03 in handler::update_first_row (this=0x7dfeb8055d18, new_data=0x7dfeb8056a60 "\377") at /test/10.6_opt/sql/handler.cc:7907
      #3  0x0000561574d734f1 in ha_sequence::write_row (this=0x7dfeb8056518, buf=0x7dfeb8056a60 "\377") at /test/10.6_opt/sql/ha_sequence.cc:296
      #4  0x0000561574ad3f8b in handler::ha_write_row (this=0x7dfeb8056518, buf=0x7dfeb8056a60 "\377") at /test/10.6_opt/sql/handler.cc:7769
      #5  0x000056157494571f in copy_data_between_tables (thd=thd@entry=0x7dfeb8000c68, from=from@entry=0x7dfeb801a698, to=to@entry=0x7dfeb8058b48, ignore=false, order_num=<optimized out>, order=<optimized out>, copied=0x7e19c807e258, deleted=0x7e19c807e260, alter_info=0x7e19c8080ab0, alter_ctx=0x7e19c807ec80)at /test/10.6_opt/sql/sql_table.cc:11739
      #6  0x000056157493fc61 in mysql_alter_table (thd=thd@entry=0x7dfeb8000c68, new_db=new_db@entry=0x7dfeb8005740, new_name=new_name@entry=0x7dfeb8005bb0, create_info=create_info@entry=0x7e19c8080c20, table_list=0x7dfeb8010c90, recreate_info=recreate_info@entry=0x7e19c80803a0, alter_info=0x7e19c8080ab0, order_num=0, order=0x0, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.6_opt/sql/sql_table.cc:11012
      #7  0x00005615749ad693 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7dfeb8000c68) at /test/10.6_opt/sql/sql_alter.cc:675
      #8  0x0000561574899ec4 in mysql_execute_command (thd=thd@entry=0x7dfeb8000c68, is_called_from_prepared_stmt=false) at /test/10.6_opt/sql/sql_parse.cc:6167
      #9  0x0000561574895811 in mysql_parse (thd=thd@entry=0x7dfeb8000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7e19c8081490)at /test/10.6_opt/sql/sql_parse.cc:8200
      #10 0x0000561574893ccc in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7dfeb8000c68, packet=packet@entry=0x7dfeb8008639 "ALTER TABLE s SEQUENCE=1", packet_length=packet_length@entry=24, blocking=true)at /test/10.6_opt/sql/sql_parse.cc:1908
      #11 0x0000561574895c21 in do_command (thd=thd@entry=0x7dfeb8000c68, blocking=true) at /test/10.6_opt/sql/sql_parse.cc:1421
      #12 0x00005615749a73ad in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56159f9c0c48, put_in_cache=true)at /test/10.6_opt/sql/sql_connect.cc:1386
      #13 0x00005615749a7173 in handle_one_connection (arg=arg@entry=0x56159f9c0c48)at /test/10.6_opt/sql/sql_connect.cc:1298
      #14 0x0000561574d1ed4e in pfs_spawn_thread (arg=0x56159f9ee2f8)at /test/10.6_opt/storage/perfschema/pfs.cc:2201
      #15 0x00007e19ca09caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #16 0x00007e19ca129c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.6   dbg  311025  e80998281aa1551f12a6b86cb3765796130d822d  SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row                  
      CS  10.6   opt  311025  e80998281aa1551f12a6b86cb3765796130d822d  SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
      CS  10.11  dbg  311025  654e8440b51b1b8da09b6f72de80ba50dc0c24f9  No bug found                  
      CS  10.11  opt  311025  654e8440b51b1b8da09b6f72de80ba50dc0c24f9  No bug found                  
      CS  11.4   dbg  311025  75ded7d03abb4de385f97ce7cf20622882b8df05  No bug found                  
      CS  11.4   opt  311025  75ded7d03abb4de385f97ce7cf20622882b8df05  No bug found                  
      CS  11.8   dbg  311025  6d0be016faba4179421a5b6b46ba0cfc21d0cf92  No bug found                  
      CS  11.8   opt  311025  6d0be016faba4179421a5b6b46ba0cfc21d0cf92  No bug found                  
      CS  12.1   dbg  311025  4af88ced488e78458f0febb55a0ae67783330029  No bug found                  
      CS  12.1   opt  311025  4af88ced488e78458f0febb55a0ae67783330029  No bug found                  
      CS  12.2   dbg  311025  049ee29e7e28c1c7c3c41638adc54efa2cb10c2a  No bug found                  
      CS  12.2   opt  311025  049ee29e7e28c1c7c3c41638adc54efa2cb10c2a  No bug found                  
      ES  10.5   dbg  040825  70586522eacf09d04d49962072e14325a75d8155  SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
      ES  10.5   opt  040825  70586522eacf09d04d49962072e14325a75d8155  SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
      ES  10.6   dbg  040825  9b794f34b48fb7eee490b6da44edc0f33a947447  SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
      ES  10.6   opt  040825  9b794f34b48fb7eee490b6da44edc0f33a947447  SIGSEGV|calc_row_difference|ha_innobase::update_row|handler::update_first_row|ha_sequence::write_row
      ES  11.4   dbg  040825  a1c03ccd54b582e75506687ee19b273ca897f261  !node->table->skip_alter_undo|SIGABRT|row_upd_clust_rec|row_upd_clust_step|row_upd|row_upd_step
      ES  11.4   opt  040825  a1c03ccd54b582e75506687ee19b273ca897f261  No bug found                  
      ES  11.8   dbg  151025  780565c207e9ce0ebf7d8e3d59f223801447b619  No bug found                  
      ES  11.8   opt  151025  780565c207e9ce0ebf7d8e3d59f223801447b619  No bug found                  
      

      ES 11.4 crashes similar to MDEV-24715

      Attachments

        Issue Links

          Activity

            People

              ramesh Ramesh Sivaraman
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.