Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4
-
None
Description
https://travis-ci.org/elenst/travis-tests/jobs/451419765
|
10.4 074c68409921032f8a64416cc4d5ebc35d95dca9 |
2018-11-06 18:30:59 0x7fb70c0fc700 InnoDB: Assertion failure in file /home/travis/src/storage/innobase/trx/trx0i_s.cc line 1262
|
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.
|
181106 18:30:59 [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.4.0-MariaDB-debug-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=9
|
max_threads=153
|
thread_count=15
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467555 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
Thread pointer: 0x7fb7080de470
|
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 = 0x7fb70c0fbe80 thread_stack 0x49000
|
/home/travis/server/bin/mysqld(my_print_stacktrace+0x40)[0x558eca202306]
|
mysys/stacktrace.c:269(my_print_stacktrace)[0x558ec9a53d1f]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x10330)[0x7fb714178330]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fb7135b5c37]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fb7135b9028]
|
/home/travis/server/bin/mysqld(+0xe3dbce)[0x558ec9e95bce]
|
ut/ut0dbg.cc:62(__static_initialization_and_destruction_0)[0x558ec9e5c429]
|
trx/trx0i_s.cc:1262(fetch_data_into_cache_low)[0x558ec9e5c5b6]
|
trx/trx0i_s.cc:1299(fetch_data_into_cache)[0x558ec9e5c664]
|
trx/trx0i_s.cc:1326(trx_i_s_possibly_fetch_data_into_cache(trx_i_s_cache_t*))[0x558ec9ccaec6]
|
handler/i_s.cc:1205(trx_i_s_common_fill_table)[0x558ec9806e0b]
|
sql/sql_show.cc:8809(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x558ec979f7d8]
|
sql/sql_select.cc:4044(JOIN::exec_inner())[0x558ec979ee60]
|
sql/sql_select.cc:3877(JOIN::exec())[0x558ec98489aa]
|
sql/sql_union.cc:1468(st_select_lex_unit::exec())[0x558ec98438c7]
|
sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x558ec9791943]
|
sql/sql_select.cc:363(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558ec975c320]
|
sql/sql_parse.cc:6554(execute_sqlcom_select)[0x558ec9752980]
|
sql/sql_prepare.cc:4778(Prepared_statement::execute(String*, bool))[0x558ec977dda3]
|
sql/sql_prepare.cc:4206(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x558ec977c1ae]
|
sql/sql_prepare.cc:3206(mysql_stmt_execute_common)[0x558ec9779a33]
|
sql/sql_prepare.cc:3105(mysqld_stmt_execute(THD*, char*, unsigned int))[0x558ec97795d6]
|
sql/sql_parse.cc:1794(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558ec974d089]
|
sql/sql_parse.cc:1396(do_command(THD*))[0x558ec974be67]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x558ec98b62ce]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x558ec98b6052]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8184)[0x7fb714170184]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fb71367cffd]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fb70893e198): /* GenTest::Transform::ExecuteAsExcept */ ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_TRX` AS table1 INNER JOIN INFORMATION_SCHEMA.`SYSTEM_VARIABLES` AS table2 ON ( table2.`COMMAND_LINE_ARGUMENT` = table1.`trx_isolation_level` ) ) WHERE NOT table2.`VARIABLE_TYPE` <> '2033-01-14 04:44:26.050260' LIMIT 9 /* QNO 6927 CON_ID 15 */ ) EXCEPT ( SELECT * FROM (INFORMATION_SCHEMA.`INNODB_TRX` AS table1 INNER JOIN INFORMATION_SCHEMA.`SYSTEM_VARIABLES` AS table2 ON ( table2.`COMMAND_LINE_ARGUMENT` = table1.`trx_isolation_level` ) ) WHERE NOT table2.`VARIABLE_TYPE` <> '2033-01-14 04:44:26.050260' LIMIT 0 /* QNO 6927 CON_ID 15 */ ) /* TRANSFORM_OUTCOME_DISTINCT */ /* QNO 6930 CON_ID 15 */
|
Connection ID (thread ID): 15
|
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,condition_pushdown_for_subquery=on
|
|
elenst-mdev14046 1348571d03a3b335fe5d772cbbb27c13f24c62e0 |
perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1541528877 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/information_schema.yy --ps-protocol --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView
|
Not reproducible right away.
svoj said on slack:
1. this looks like a bug in I_S code
2. data structures should be fine, that is non-I_S code should be fine
3. most probably we need to protect something with `trx->mutex`
4. it is very likely that code was wrong from the beginning, but should be easier to reproduce with 10.3
Attachments
Issue Links
- relates to
-
MDEV-18058 [Draft] InnoDB: Assertion failure in file /home/travis/src/storage/innobase/trx/trx0i_s.cc line 1278
-
- Closed
-