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

[Draft] Assertion failure in lock_trx_table_locks_remove

    XMLWordPrintable

Details

    Description

      https://api.travis-ci.org/v3/job/349593148/log.txt

      10.3 d70573564cb2701076083ea7f55ae9539fad13b4

      2018-03-06  3:38:36 0 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used;  This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=travis-job-d29f20ab-50ae-4b55-bb53-35ebf6b786ef' or '--log-bin=mysql-bin' to avoid this problem.
      Version: '10.3.6-MariaDB-debug-log'  socket: '/home/travis/logs/vardir1_2/mysql.sock'  port: 19300  Source distribution
      2018-03-06  3:38:39 16 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: OPTIMIZE TABLE t7 /* QNO 118 CON_ID 16 */
      2018-03-06  3:43:16 17 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: OPTIMIZE TABLE t1 /* QNO 1859 CON_ID 17 */
      2018-03-06 03:44:27 0x7fa23c36a700  InnoDB: Assertion failure in file /home/travis/src/storage/innobase/lock/lock0lock.cc line 5041
      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: https://mariadb.com/kb/en/library/xtradbinnodb-recovery-modes/
      InnoDB: about forcing recovery.
      180306  3:44:27 [ERROR] mysqld got signal 6 ;
       
      Query (0x7fa1fc013bf8): INSERT INTO `table10_innodb_int_autoinc` SELECT * FROM `table1_innodb_int_autoinc` /* QNO 6205 CON_ID 20 */
      Connection ID (thread ID): 20
      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=on,condition_pushdown_for_derived=on,split_materialized=on
      

      #6  0x000055dbab01c58a in ut_dbg_assertion_failed (expr=0x0, file=0x55dbab6268b8 "/home/travis/src/storage/innobase/lock/lock0lock.cc", line=5041) at /home/travis/src/storage/innobase/ut/ut0dbg.cc:61
      #7  0x000055dbaae761f1 in lock_trx_table_locks_remove (lock_to_remove=0x55dbae46e6d8) at /home/travis/src/storage/innobase/lock/lock0lock.cc:5041
      #8  0x000055dbaae7b561 in lock_release_autoinc_last_lock (autoinc_locks=0x7fa200013db8) at /home/travis/src/storage/innobase/lock/lock0lock.cc:6624
      #9  0x000055dbaae7b657 in lock_release_autoinc_locks (trx=0x7fa23d3ee040) at /home/travis/src/storage/innobase/lock/lock0lock.cc:6663
      #10 0x000055dbaae7bcdf in lock_cancel_waiting_and_release (lock=0x55dbae46e6d8) at /home/travis/src/storage/innobase/lock/lock0lock.cc:6885
      #11 0x000055dbaae73b3b in lock_table_create (c_lock=0x55dbae46e6d8, table=0x7fa1e00d78d8, type_mode=260, trx=0x7fa23d3ee4d8) at /home/travis/src/storage/innobase/lock/lock0lock.cc:4161
      #12 0x000055dbaae74788 in lock_table_enqueue_waiting (c_lock=0x55dbae46e6d8, mode=4, table=0x7fa1e00d78d8, thr=0x7fa1fc15d510) at /home/travis/src/storage/innobase/lock/lock0lock.cc:4395
      #13 0x000055dbaae74e62 in lock_table (flags=0, table=0x7fa1e00d78d8, mode=LOCK_AUTO_INC, thr=0x7fa1fc15d510) at /home/travis/src/storage/innobase/lock/lock0lock.cc:4550
      #14 0x000055dbaaf44b43 in row_lock_table_autoinc_for_mysql (prebuilt=0x7fa1fc15b7b8) at /home/travis/src/storage/innobase/row/row0mysql.cc:1198
      #15 0x000055dbaadeb928 in ha_innobase::innobase_lock_autoinc (this=0x7fa1fc00e0b8) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:8114
      #16 0x000055dbaadfe4ff in ha_innobase::innobase_get_autoinc (this=0x7fa1fc00e0b8, value=0x7fa23c367ab0) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:16921
      #17 0x000055dbaadfe767 in ha_innobase::get_auto_increment (this=0x7fa1fc00e0b8, offset=1, increment=1, nb_desired_values=1, first_value=0x7fa23c367b28, nb_reserved_values=0x7fa23c367b30) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:16991
      #18 0x000055dbaabd80ea in handler::update_auto_increment (this=0x7fa1fc00e0b8) at /home/travis/src/sql/handler.cc:3252
      #19 0x000055dbaadebda5 in ha_innobase::write_row (this=0x7fa1fc00e0b8, record=0x7fa1fc108968 "j\252(*8\200\221\b") at /home/travis/src/storage/innobase/handler/ha_innodb.cc:8217
      #20 0x000055dbaabdf729 in handler::ha_write_row (this=0x7fa1fc00e0b8, buf=0x7fa1fc108968 "j\252(*8\200\221\b") at /home/travis/src/sql/handler.cc:6212
      #21 0x000055dbaa8b2ac7 in write_record (thd=0x7fa1fc000d10, table=0x7fa1fc0ab410, info=0x7fa1fc014d40) at /home/travis/src/sql/sql_insert.cc:2022
      #22 0x000055dbaa8b7d14 in select_insert::send_data (this=0x7fa1fc014d00, values=...) at /home/travis/src/sql/sql_insert.cc:3857
      #23 0x000055dbaa9599b5 in end_send (join=0x7fa1fc014da8, join_tab=0x7fa1fc207e50, end_of_records=false) at /home/travis/src/sql/sql_select.cc:20401
      #24 0x000055dbaa957312 in evaluate_join_record (join=0x7fa1fc014da8, join_tab=0x7fa1fc207aa0, error=0) at /home/travis/src/sql/sql_select.cc:19452
      #25 0x000055dbaa956c29 in sub_select (join=0x7fa1fc014da8, join_tab=0x7fa1fc207aa0, end_of_records=false) at /home/travis/src/sql/sql_select.cc:19232
      #26 0x000055dbaa956195 in do_select (join=0x7fa1fc014da8, procedure=0x0) at /home/travis/src/sql/sql_select.cc:18772
      #27 0x000055dbaa92f35a in JOIN::exec_inner (this=0x7fa1fc014da8) at /home/travis/src/sql/sql_select.cc:3987
      #28 0x000055dbaa92e7fa in JOIN::exec (this=0x7fa1fc014da8) at /home/travis/src/sql/sql_select.cc:3781
      #29 0x000055dbaa92fa6e in mysql_select (thd=0x7fa1fc000d10, tables=0x7fa1fc014628, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=553246263808, result=0x7fa1fc014d00, unit=0x7fa1fc004b48, select_lex=0x7fa1fc0052c0) at /home/travis/src/sql/sql_select.cc:4186
      #30 0x000055dbaa921d41 in handle_select (thd=0x7fa1fc000d10, lex=0x7fa1fc004a80, result=0x7fa1fc014d00, setup_tables_done_option=1073741824) at /home/travis/src/sql/sql_select.cc:382
      #31 0x000055dbaa8e6794 in mysql_execute_command (thd=0x7fa1fc000d10) at /home/travis/src/sql/sql_parse.cc:4826
      #32 0x000055dbaa8f082a in mysql_parse (thd=0x7fa1fc000d10, rawbuf=0x7fa1fc013bf8 "INSERT INTO `table10_innodb_int_autoinc` SELECT * FROM `table1_innodb_int_autoinc` /* QNO 6205 CON_ID 20 */", length=107, parser_state=0x7fa23c3695e0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8009
      #33 0x000055dbaa8ddf23 in dispatch_command (command=COM_QUERY, thd=0x7fa1fc000d10, packet=0x7fa1fd11e5d1 "INSERT INTO `table10_innodb_int_autoinc` SELECT * FROM `table1_innodb_int_autoinc` /* QNO 6205 CON_ID 20 */ ", packet_length=108, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1838
      #34 0x000055dbaa8dc96f in do_command (thd=0x7fa1fc000d10) at /home/travis/src/sql/sql_parse.cc:1383
      #35 0x000055dbaaa41bef in do_handle_one_connection (connect=0x55dbae432050) at /home/travis/src/sql/sql_connect.cc:1402
      #36 0x000055dbaaa4197c in handle_one_connection (arg=0x55dbae432050) at /home/travis/src/sql/sql_connect.cc:1308
      #37 0x00007fa241328184 in start_thread (arg=0x7fa23c36a700) at pthread_create.c:312
      #38 0x00007fa24083503d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      experimental e42a181399012909fbda32f7e9b7be8b416175c9

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1520307513 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --views --vcols --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/xa.yy --basedir=/home/travis/server --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/replication/replication-dml_sql.yy --gendata=conf/replication/replication-dml_data.zz --engine=InnoDB --vardir=/home/travis/logs/vardir1_2
      

      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.