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
|
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.