Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.0.20
-
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
|