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

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 ?? ()

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