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

InnoDB: Assertion failure in file handler0alter.cc line 131

Details

    • 10.0.22

    Description

      • MariaDB 10.0.20
      • looks like: bug 904627
      • based on: bug 919062
      • This is still crashing but not because of "InnoDB: Failing assertion: lock->lock_word == X_LOCK_DECR"

      Please see attached mysqld.log (MariaDB 10.0.20 parts)

       
      MariaDB [test]> create table t1(a int,b int) engine=innodb data directory='/data3';
      Query OK, 0 rows affected (0.13 sec)
       
       
      MariaDB [test]> create table t2(a int,b int) engine=innodb data directory='/data3';
      Query OK, 0 rows affected (0.14 sec)
       
       
      MariaDB [test]> \! ls -lah /data3/test
      total 4.5M
      drwxrwx--- 2 mysql mysql 1.0K Jun 30 16:47 .
      drwxrwxrwx 4 root  root  1.0K Jun 30 15:06 ..
      -rw-rw---- 1 mysql mysql 4.3M Jun 30 15:12 #sql-ib20-117117071.ibd
      -rw-rw---- 1 mysql mysql  96K Jun 30 16:47 t1.ibd
      -rw-rw---- 1 mysql mysql  96K Jun 30 16:47 t2.ibd
       
       
      MariaDB [test]> set autocommit=0;
      Query OK, 0 rows affected (0.00 sec)
       
       
      MariaDB [test]> \! ls -lah /data3/test
      total 4.5M
      drwxrwx--- 2 mysql mysql 1.0K Jun 30 16:47 .
      drwxrwxrwx 4 root  root  1.0K Jun 30 15:06 ..
      -rw-rw---- 1 mysql mysql 4.3M Jun 30 15:12 #sql-ib20-117117071.ibd
      -rw-rw---- 1 mysql mysql  96K Jun 30 16:47 t1.ibd
      -rw-rw---- 1 mysql mysql  96K Jun 30 16:47 t2.ibd
       
       
      MariaDB [test]> call innodb_insert_proc(14700);
      Query OK, 1 row affected (0.38 sec)
       
       
      MariaDB [test]> \! ls -lah /data3/test
      total 6.4M
      drwxrwx--- 2 mysql mysql 1.0K Jun 30 16:47 .
      drwxrwxrwx 4 root  root  1.0K Jun 30 15:06 ..
      -rw-rw---- 1 mysql mysql 4.3M Jun 30 15:12 #sql-ib20-117117071.ibd
      -rw-rw---- 1 mysql mysql 2.0M Jun 30 16:48 t1.ibd
      -rw-rw---- 1 mysql mysql  96K Jun 30 16:47 t2.ibd
       
       
      MariaDB [test]> alter table t1 add testcol1 int;
      ERROR 2013 (HY000): Lost connection to MySQL server during query
       
       
      MariaDB [test]> \! ls -lah /data3/test
      total 6.4M
      drwxrwx--- 2 mysql mysql 1.0K Jun 30 16:49 .
      drwxrwxrwx 4 root  root  1.0K Jun 30 15:06 ..
      -rw-rw---- 1 mysql mysql 4.3M Jun 30 15:12 #sql-ib20-117117071.ibd
      -rw-rw---- 1 mysql mysql 2.0M Jun 30 16:48 t1.ibd
      -rw-rw---- 1 mysql mysql  96K Jun 30 16:47 t2.ibd
       

      Stacktrace:

      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  0x00007f80385b90d1 in pthread_kill () from /lib64/libpthread.so.0
      Missing separate debuginfos, use: zypper install glibc-debuginfo-2.19-20.3.x86_64 libaio1-debuginfo-0.3.109-17.15.x86_64 libgcc_s1-debuginfo-4.8.3+r212056-11.2.x86_64 libopenssl1_0_0-debuginfo-1.0.1i-25.1.x86_64 libstdc++6-debuginfo-4.8.3+r212056-11.2.x86_64 libz1-debuginfo-1.2.8-5.1.x86_64
      (gdb) bt
      #0  0x00007f80385b90d1 in pthread_kill () from /lib64/libpthread.so.0
      #1  0x0000000000720184 in handle_fatal_signal (sig=11)
          at /usr/src/debug/mariadb-10.0.20/sql/signal_handler.cc:262
      #2  <signal handler called>
      #3  0x0000000000a80686 in btr_page_split_and_insert (flags=flags@entry=23, 
          cursor=cursor@entry=0x7f8024150830, offsets=offsets@entry=0x7f8024150820, 
          heap=heap@entry=0x7f80241507c0, tuple=tuple@entry=0x7f7ff004ab08, n_ext=<optimized out>, 
          mtr=mtr@entry=0x7f80241508b0) at /usr/src/debug/mariadb-10.0.20/storage/xtradb/btr/btr0btr.cc:3101
      #4  0x0000000000a8da44 in btr_cur_pessimistic_insert (flags=flags@entry=23, 
          cursor=cursor@entry=0x7f8024150830, offsets=offsets@entry=0x7f8024150820, 
          heap=heap@entry=0x7f80241507c0, entry=entry@entry=0x7f7ff004ab08, rec=rec@entry=0x7f8024150810, 
          big_rec=big_rec@entry=0x7f8024150800, n_ext=n_ext@entry=0, thr=thr@entry=0x0, 
          mtr=mtr@entry=0x7f80241508b0) at /usr/src/debug/mariadb-10.0.20/storage/xtradb/btr/btr0cur.cc:1731
      #5  0x0000000000a148cc in row_merge_insert_index_tuples (trx_id=<optimized out>, 
          index=index@entry=0x7f7ff004c3c8, old_table=old_table@entry=0x7f7ff0006288, fd=<optimized out>, 
          block=block@entry=0x7f80101f1000 "\002\004")
          at /usr/src/debug/mariadb-10.0.20/storage/xtradb/row/row0merge.cc:2560
      #6  0x0000000000a17639 in row_merge_build_indexes (trx=0x7f7ff000d4e8, old_table=0x7f7ff0006288, 
          new_table=0x7f7ff0044678, online=<optimized out>, indexes=0x7f7ff00439e0, 
          key_numbers=0x7f7ff00439e8, n_indexes=1, table=table@entry=0x7f7ff0045258, 
          add_cols=0x7f7ff0043a40, col_map=0x7f7ff0043b00, add_autoinc=18446744073709551615, sequence=...)
          at /usr/src/debug/mariadb-10.0.20/storage/xtradb/row/row0merge.cc:3768
      #7  0x000000000098d03e in ha_innobase::inplace_alter_table (this=0x7f7ff0048a10, 
          altered_table=0x7f7ff0045258, ha_alter_info=0x7f80241511c0)
          at /usr/src/debug/mariadb-10.0.20/storage/xtradb/handler/handler0alter.cc:4020
      #8  0x000000000065a180 in ha_inplace_alter_table (ha_alter_info=0x7f80241511c0, 
          altered_table=0x7f7ff0045258, this=<optimized out>)
          at /usr/src/debug/mariadb-10.0.20/sql/handler.h:3571
      #9  mysql_inplace_alter_table (target_mdl_request=0x7f80241512f0, alter_ctx=0x7f8024151e80, 
          inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, ha_alter_info=0x7f80241511c0, 
          altered_table=0x7f7ff0045258, table=0x7f7ff0048058, table_list=0x7f7ff0009628, thd=0x323bcb8)
          at /usr/src/debug/mariadb-10.0.20/sql/sql_table.cc:7021
      #10 mysql_alter_table (thd=thd@entry=0x323bcb8, new_db=<optimized out>, new_name=<optimized out>, 
          create_info=create_info@entry=0x7f8024152a40, table_list=table_list@entry=0x7f7ff0009628, 
      ---Type <return> to continue, or q <return> to quit---
          alter_info=alter_info@entry=0x7f80241529b0, order_num=0, order=0x0, ignore=false)
          at /usr/src/debug/mariadb-10.0.20/sql/sql_table.cc:8813
      #11 0x000000000069a13a in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x323bcb8)
          at /usr/src/debug/mariadb-10.0.20/sql/sql_alter.cc:312
      #12 0x00000000005d8f3a in mysql_execute_command (thd=thd@entry=0x323bcb8)
          at /usr/src/debug/mariadb-10.0.20/sql/sql_parse.cc:5095
      #13 0x00000000005df668 in mysql_parse (thd=0x323bcb8, rawbuf=<optimized out>, length=31, 
          parser_state=0x7f8024154730) at /usr/src/debug/mariadb-10.0.20/sql/sql_parse.cc:6529
      #14 0x00000000005e16c7 in dispatch_command (command=COM_QUERY, thd=0x323bcb8, packet=<optimized out>, 
          packet_length=<optimized out>) at /usr/src/debug/mariadb-10.0.20/sql/sql_parse.cc:1308
      #15 0x00000000005e21c0 in do_command (thd=<optimized out>)
          at /usr/src/debug/mariadb-10.0.20/sql/sql_parse.cc:999
      #16 0x0000000000697742 in do_handle_one_connection (thd_arg=thd_arg@entry=0x323bcb8)
          at /usr/src/debug/mariadb-10.0.20/sql/sql_connect.cc:1378
      #17 0x00000000006977c7 in handle_one_connection (arg=0x323bcb8)
          at /usr/src/debug/mariadb-10.0.20/sql/sql_connect.cc:1293
      #18 0x00007f80385b40a4 in start_thread () from /lib64/libpthread.so.0
      #19 0x00007f803748108d in clone () from /lib64/libc.so.6

      https://bugzilla.suse.com/show_bug.cgi?id=937347

      Attachments

        Issue Links

          Activity

            There are still situations if physical disk space has been exhausted the server will go down by assertion. Fixing all of these to cleanly shutdown instead of asserting is out of scope for GA product.

            jplindst Jan Lindström (Inactive) added a comment - There are still situations if physical disk space has been exhausted the server will go down by assertion. Fixing all of these to cleanly shutdown instead of asserting is out of scope for GA product.

            People

              jplindst Jan Lindström (Inactive)
              nirbhay_c Nirbhay Choubey (Inactive)
              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.