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

[Draft] InnoDB: Failing assertion: rw_lock_is_locked(&block->lock, RW_LOCK_EX)

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.