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

[Draft] InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED || (relaxed && thd_get_error_number(trx->mysql_thd))

    XMLWordPrintable

Details

    Description

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

      10.1.26 debug build

      2018-01-31 06:52:18 7f3ca80ef700  InnoDB: Assertion failure in thread 139898494318336 in file trx0trx.ic line 67
      InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED || (relaxed && thd_get_error_number(trx->mysql_thd))
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
      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.
      180131  6:52:18 [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.26-MariaDB-debug
      key_buffer_size=2147483648
      read_buffer_size=131072
      max_used_connections=8
      max_threads=153
      thread_count=7
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2433318 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
      Thread pointer: 0x2cc1280
      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 = 0x7f3ca80eee48 thread_stack 0x20000
      /home/travis/server/bin/mysqld(my_print_stacktrace+0x35)[0xf3502d]
      /home/travis/server/bin/mysqld(handle_fatal_signal+0x38f)[0x8de0dd]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f3caaae3cb0]
      /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f3caa14d035]
      /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b)[0x7f3caa15079b]
      /home/travis/server/bin/mysqld[0xbac95f]
      /home/travis/server/bin/mysqld[0xbbc1ac]
      /home/travis/server/bin/mysqld(_Z13rr_unlock_rowP13st_join_table+0x41)[0x6f724f]
      /home/travis/server/bin/mysqld[0x709b32]
      /home/travis/server/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2ef)[0x709309]
      /home/travis/server/bin/mysqld[0x709a30]
      /home/travis/server/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2ef)[0x709309]
      /home/travis/server/bin/mysqld[0x708b55]
      /home/travis/server/bin/mysqld(_ZN4JOIN10exec_innerEv+0x2c93)[0x6e49c9]
      /home/travis/server/bin/mysqld(_ZN4JOIN4execEv+0xe1)[0x6e1c9b]
      /home/travis/server/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x340)[0x6e5234]
      /home/travis/server/bin/mysqld(_Z18mysql_multi_updateP3THDP10TABLE_LISTP4ListI4ItemES6_PS4_y15enum_duplicatesbP18st_select_lex_unitP13st_select_lexPP12multi_update+0x1aa)[0x77d253]
      /home/travis/server/bin/mysqld(_Z21mysql_execute_commandP3THD+0x3d96)[0x6a356b]
      /home/travis/server/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x25c)[0x6ae4da]
      /home/travis/server/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xd72)[0x69d15b]
      /home/travis/server/bin/mysqld(_Z10do_commandP3THD+0x74b)[0x69bee2]
      /home/travis/server/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1f9)[0x7d25ea]
      /home/travis/server/bin/mysqld(handle_one_connection+0x33)[0x7d233b]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x7e9a)[0x7f3caaadbe9a]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f3caa20d2ed]
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f3bd4005b08): UPDATE ( `view_table2_innodb_int_autoinc_0` AS alias1 LEFT OUTER JOIN `view_table100_innodb_int_autoinc_0` AS alias2 ON (alias2.`col_varchar_10_null_key` = alias1.`col_varchar_10_null_key` ) ) SET alias1.`col_int_null_key` = -49 WHERE ( alias2.`col_int_null` = ANY ( SELECT SQ1_alias1.`col_int_null` AS SQ1_ifield1 FROM ( `view_table100_innodb_int_autoinc_0` AS SQ1_alias1 RIGHT OUTER JOIN ( `table5_innodb_int_autoinc` AS SQ1_alias2 INNER JOIN `table15_innodb_int_autoinc` AS SQ1_alias3 ON (SQ1_alias3.`col_varchar_10_not_null_key` = SQ1_alias2.`col_varchar_10_null` ) ) ON (SQ1_alias3.`col_varchar_10_null_key` = SQ1_alias2.`col_varchar_10_null_key` ) ) WHERE SQ1_alias2.`col_int_not_null` <= alias2.`col_int_null` OR SQ1_alias2.`pk` = 6 ) ) OR ( alias1.`pk` = 131 OR alias1.`col_int_null_key` = 75 ) OR ( alias1.`col_varchar_10_not_null_key` = 'e' AND alias1.`col_varchar_10_null` = 'd' ) /* QNO 9820 CON_ID 11 */
      Connection ID (thread ID): 11
      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  0x00007f3caa15079b in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #6  0x0000000000bac95f in trx_state_eq (trx=0x7f3bd400cc38, state=TRX_STATE_ACTIVE, relaxed=false) at /home/travis/src/storage/xtradb/include/trx0trx.ic:65
      #7  0x0000000000bbc1ac in ha_innobase::unlock_row (this=0x7f3bd4014a58) at /home/travis/src/storage/xtradb/handler/ha_innodb.cc:9606
      #8  0x00000000006f724f in rr_unlock_row (tab=0x7f3bd40779a0) at /home/travis/src/sql/sql_select.cc:10574
      #9  0x0000000000709b32 in evaluate_join_record (join=0x7f3bd40c1060, join_tab=0x7f3bd40779a0, error=0) at /home/travis/src/sql/sql_select.cc:18645
      #10 0x0000000000709309 in sub_select (join=0x7f3bd40c1060, join_tab=0x7f3bd40779a0, end_of_records=false) at /home/travis/src/sql/sql_select.cc:18398
      #11 0x0000000000709a30 in evaluate_join_record (join=0x7f3bd40c1060, join_tab=0x7f3bd4077658, error=0) at /home/travis/src/sql/sql_select.cc:18621
      #12 0x0000000000709309 in sub_select (join=0x7f3bd40c1060, join_tab=0x7f3bd4077658, end_of_records=false) at /home/travis/src/sql/sql_select.cc:18398
      #13 0x0000000000708b55 in do_select (join=0x7f3bd40c1060, fields=0x7f3ca80ed570, table=0x0, procedure=0x0) at /home/travis/src/sql/sql_select.cc:18053
      #14 0x00000000006e49c9 in JOIN::exec_inner (this=0x7f3bd40c1060) at /home/travis/src/sql/sql_select.cc:3225
      #15 0x00000000006e1c9b in JOIN::exec (this=0x7f3bd40c1060) at /home/travis/src/sql/sql_select.cc:2512
      #16 0x00000000006e5234 in mysql_select (thd=0x2cc1280, rref_pointer_array=0x2cc5710, tables=0x7f3bd40069e0, wild_num=0, fields=..., conds=0x7f3bd405e888, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342210176, result=0x7f3bd40c0f98, unit=0x2cc4d80, select_lex=0x2cc5480) at /home/travis/src/sql/sql_select.cc:3449
      #17 0x000000000077d253 in mysql_multi_update (thd=0x2cc1280, table_list=0x7f3bd40069e0, fields=0x2cc5598, values=0x2cc59f0, conds=0x7f3bd405e888, options=32768, handle_duplicates=DUP_ERROR, ignore=false, unit=0x2cc4d80, select_lex=0x2cc5480, result=0x7f3ca80ed830) at /home/travis/src/sql/sql_update.cc:1625
      #18 0x00000000006a356b in mysql_execute_command (thd=0x2cc1280) at /home/travis/src/sql/sql_parse.cc:3845
      #19 0x00000000006ae4da in mysql_parse (thd=0x2cc1280, rawbuf=0x7f3bd4005b08 "UPDATE ( `view_table2_innodb_int_autoinc_0` AS alias1 LEFT OUTER JOIN `view_table100_innodb_int_autoinc_0` AS alias2 ON (alias2.`col_varchar_10_null_key` = alias1.`col_varchar_10_null_key` ) ) SET ali"..., length=916, parser_state=0x7f3ca80ee0e0) at /home/travis/src/sql/sql_parse.cc:7344
      #20 0x000000000069d15b in dispatch_command (command=COM_QUERY, thd=0x2cc1280, packet=0x2cc8651 " UPDATE ( `view_table2_innodb_int_autoinc_0` AS alias1 LEFT OUTER JOIN `view_table100_innodb_int_autoinc_0` AS alias2 ON (alias2.`col_varchar_10_null_key` = alias1.`col_varchar_10_null_key` ) ) SET al"..., packet_length=918) at /home/travis/src/sql/sql_parse.cc:1484
      #21 0x000000000069bee2 in do_command (thd=0x2cc1280) at /home/travis/src/sql/sql_parse.cc:1106
      #22 0x00000000007d25ea in do_handle_one_connection (thd_arg=0x2cc1280) at /home/travis/src/sql/sql_connect.cc:1349
      #23 0x00000000007d233b in handle_one_connection (arg=0x2cc1280) at /home/travis/src/sql/sql_connect.cc:1261
      #24 0x00007f3caaadbe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #25 0x00007f3caa20d2ed in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #26 0x0000000000000000 in ?? ()
      

      experimental b08a30d25e069c665ab4619e180ef045936d0d2e

      perl /home/travis/rqg/runall-new.pl --views --validators=TransformerNoComparator --mysqld=--max-statement-time=30 --seed=1517381286 --threads=6 --duration=350 --reporters=Backtrace,ErrorLog,Deadlock --transformers=ExecuteAsUnion,ExecuteAsView --redefine=conf/mariadb/federated.yy --mysqld=--default-storage-engine=MyISAM --mysqld=--query_cache_type=0 --mysqld=--query_cache_size=0 --mysqld=--key_buffer_size=2G --mysqld=--thread_stack=192 --mysqld=--thread_cache_size=8 --mysqld=--myisam_recover_options=BACKUP --mysqld=--character-set-server=utf8mb4 --mysqld=--collation-server=utf8mb4_general_ci --grammar=conf/mariadb/multi_update.yy --gendata=conf/mariadb/multi_update.zz --engine=InnoDB --basedir1=/home/travis/server --vardir=/home/travis/logs/vardir1_1
      

      Attachments

        1. threads
          33 kB
          Elena Stepanova

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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