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

InnoDB: Assertion failure in file handler0alter.cc line 131

    XMLWordPrintable

    Details

    • Sprint:
      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

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: