Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1
-
None
-
None
Description
10.1 c17468d4abe59339af11ef4a17a59156741c6a21 |
2018-06-10 20:08:28 7ff3943fcb00 InnoDB: Assertion failure in thread 140684140989184 in file buf0buf.cc line 5269
|
InnoDB: Failing assertion: rw_lock_is_locked(&block->lock, RW_LOCK_EX)
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
180610 20:08:28 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
Server version: 10.1.34-MariaDB-debug
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=6
|
max_threads=153
|
thread_count=5
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467241 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
Thread pointer: 0x5630594f78d0
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7ff3943fc280 thread_stack 0x48400
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x563057743892]
|
sql/signal_handler.cc:168(handle_fatal_signal)[0x5630570e2288]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x10330)[0x7ff3ac1e9330]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7ff3ab83cc37]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7ff3ab840028]
|
buf/buf0buf.cc:5270(buf_pool_validate_instance)[0x563057628edd]
|
buf/buf0buf.cc:5426(buf_validate())[0x56305762954f]
|
buf/buf0buf.cc:3531(buf_page_get_gen(unsigned long, unsigned long, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, dberr_t*))[0x563057624fa2]
|
btr/btr0cur.cc:993(btr_cur_open_at_index_side_func(bool, dict_index_t*, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned long, mtr_t*))[0x5630575f7b25]
|
row/row0merge.cc:2772(row_merge_insert_index_tuples)[0x56305753151d]
|
row/row0merge.cc:4159(row_merge_build_indexes(trx_t*, dict_table_t*, dict_table_t*, bool, dict_index_t**, unsigned long const*, unsigned long, TABLE*, dtuple_t const*, unsigned long const*, unsigned long, ib_sequence_t&))[0x563057534614]
|
handler/handler0alter.cc:4253(ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*))[0x563057451f47]
|
sql/handler.h:3726(handler::ha_inplace_alter_table(TABLE*, Alter_inplace_info*))[0x563056f6b08f]
|
sql/sql_table.cc:7193(mysql_inplace_alter_table)[0x563056f62e07]
|
sql/sql_table.cc:9048(mysql_alter_table(THD*, char*, char*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x563056f67892]
|
sql/sql_alter.cc:326(Sql_cmd_alter_table::execute(THD*))[0x563056fd9bfc]
|
sql/sql_parse.cc:5696(mysql_execute_command(THD*))[0x563056ea8efd]
|
sql/sql_parse.cc:7449(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x563056ead665]
|
sql/sql_parse.cc:1494(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x563056e9c09f]
|
sql/sql_parse.cc:1121(do_command(THD*))[0x563056e9ae1f]
|
sql/sql_connect.cc:1330(do_handle_one_connection(THD*))[0x563056fd51d7]
|
sql/sql_connect.cc:1243(handle_one_connection)[0x563056fd4f3b]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8184)[0x7ff3ac1e1184]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7ff3ab903ffd]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7ff354005328): ALTER TABLE `t013` FORCE /* QNO 2270 CON_ID 9 */
|
Connection ID (thread ID): 9
|
Status: NOT_KILLED
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
|
#5 0x00007ff3ab840028 in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x0000563057628edd in buf_pool_validate_instance (buf_pool=0x5630591980e8) at /home/travis/src/storage/xtradb/buf/buf0buf.cc:5268
|
#7 0x000056305762954f in buf_validate () at /home/travis/src/storage/xtradb/buf/buf0buf.cc:5431
|
#8 0x0000563057624fa2 in buf_page_get_gen (space=270, zip_size=0, offset=8, rw_latch=3, guess=0x0, mode=10, file=0x5630579679d8 "/home/travis/src/storage/xtradb/row/row0merge.cc", line=2768, mtr=0x7ff3943f8030, err=0x7ff3943f7af4) at /home/travis/src/storage/xtradb/buf/buf0buf.cc:3531
|
#9 0x00005630575f7b25 in btr_cur_open_at_index_side_func (from_left=false, index=0x7ff354145578, latch_mode=2, cursor=0x7ff3943f7fb0, level=0, file=0x5630579679d8 "/home/travis/src/storage/xtradb/row/row0merge.cc", line=2768, mtr=0x7ff3943f8030) at /home/travis/src/storage/xtradb/btr/btr0cur.cc:993
|
#10 0x000056305753151d in row_merge_insert_index_tuples (trx_id=109975, index=0x7ff354145578, old_table=0x7ff34c249168, fd=135, block=0x7ff380251000 "\002\001\200", table_total_rows=63, pct_progress=80, pct_cost=7.5, crypt_block=0x0, space=270) at /home/travis/src/storage/xtradb/row/row0merge.cc:2768
|
#11 0x0000563057534614 in row_merge_build_indexes (trx=0x7ff35400c458, old_table=0x7ff34c249168, new_table=0x7ff35408d4f8, online=true, indexes=0x7ff35413e970, key_numbers=0x7ff35413f5d8, n_indexes=7, table=0x7ff35411f560, add_cols=0x0, col_map=0x7ff35413fcb0, add_autoinc=18446744073709551615, sequence=...) at /home/travis/src/storage/xtradb/row/row0merge.cc:4159
|
#12 0x0000563057451f47 in ha_innobase::inplace_alter_table (this=0x7ff34c21e5c8, altered_table=0x7ff35411f560, ha_alter_info=0x7ff3943f8ad0) at /home/travis/src/storage/xtradb/handler/handler0alter.cc:4253
|
#13 0x0000563056f6b08f in handler::ha_inplace_alter_table (this=0x7ff34c21e5c8, altered_table=0x7ff35411f560, ha_alter_info=0x7ff3943f8ad0) at /home/travis/src/sql/handler.h:3725
|
#14 0x0000563056f62e07 in mysql_inplace_alter_table (thd=0x5630594f78d0, table_list=0x7ff354005448, table=0x7ff34c1ae870, altered_table=0x7ff35411f560, ha_alter_info=0x7ff3943f8ad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7ff3943f8b40, alter_ctx=0x7ff3943f96e0) at /home/travis/src/sql/sql_table.cc:7193
|
#15 0x0000563056f67892 in mysql_alter_table (thd=0x5630594f78d0, new_db=0x7ff354005a38 "test", new_name=0x0, create_info=0x7ff3943fa2d0, table_list=0x7ff354005448, alter_info=0x7ff3943fa240, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9048
|
#16 0x0000563056fd9bfc in Sql_cmd_alter_table::execute (this=0x7ff354005a40, thd=0x5630594f78d0) at /home/travis/src/sql/sql_alter.cc:326
|
#17 0x0000563056ea8efd in mysql_execute_command (thd=0x5630594f78d0) at /home/travis/src/sql/sql_parse.cc:5696
|
#18 0x0000563056ead665 in mysql_parse (thd=0x5630594f78d0, rawbuf=0x7ff354005328 "ALTER TABLE `t013` FORCE /* QNO 2270 CON_ID 9 */", length=49, parser_state=0x7ff3943fb630) at /home/travis/src/sql/sql_parse.cc:7449
|
#19 0x0000563056e9c09f in dispatch_command (command=COM_QUERY, thd=0x5630594f78d0, packet=0x5630594edd41 "ALTER TABLE `t013` FORCE /* QNO 2270 CON_ID 9 */ ", packet_length=50) at /home/travis/src/sql/sql_parse.cc:1492
|
#20 0x0000563056e9ae1f in do_command (thd=0x5630594f78d0) at /home/travis/src/sql/sql_parse.cc:1121
|
#21 0x0000563056fd51d7 in do_handle_one_connection (thd_arg=0x5630594f78d0) at /home/travis/src/sql/sql_connect.cc:1330
|
#22 0x0000563056fd4f3b in handle_one_connection (arg=0x5630594f78d0) at /home/travis/src/sql/sql_connect.cc:1242
|
#23 0x00007ff3ac1e1184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#24 0x00007ff3ab903ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
travis-workarounds 0b94aa86c3af7704bd186d840c185f56fb0dcdb3 |
# 2018-06-10T20:04:50 [23975] Final command line: # 2018-06-10T20:04:50 [23975] perl /home/travis/rqg//run-scenario.pl --grammar=conf/mariadb/oltp-transactional.yy --grammar2=conf/mariadb/oltp_and_ddl.yy --gendata=conf/mariadb/innodb_upgrade.zz --gendata-advanced --mysqld=--server-id=111 --scenario=UndoLogUpgrade --duration=200 --basedir=/home/travis/server --mysqld=--innodb-page-size=64K --mysqld=--innodb-compression-algorithm=zlib --mysqld=--loose-innodb-file-format=Barracuda --mysqld=--loose-innodb-file-per-table=1 --gendata=conf/mariadb/innodb_upgrade_compression.zz --no-mask --seed=1528660242 --threads=4 --queries=100M --mysqld=--loose-max-statement-time=20 --mysqld=--loose-lock-wait-timeout=20 --mysqld=--loose-innodb-lock-wait-timeout=10 --mysqld=--loose-innodb_log_compressed_pages=on --mtr-build-thread=300 --vardir1=/home/travis/logs/current1_1
|
All threads are attached. The datadirs, logs, coredump and mysqld binary are preserved and available, the system libraries are not.