Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2.14
-
None
Description
After upgrade from 10.1.25 to 10.2.14 (http://hasky.askmonty.org/archive/bb-10.2-compatibility/build-20620/ to be more specific) various statements end up with the assertion failure in the que_graph_free_recursive() function in /que0que.cc.
It can be ALTER, DROP TRIGGER etc, but even SELECT from I_S.TABLES crashes this way, as shown below:
2018-06-23 21:05:03 0x7f7619ee0700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/innobase/que/que0que.cc line 563
|
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.
|
180623 21:05:03 [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.2.14-MariaDB-log
|
key_buffer_size=67108864
|
read_buffer_size=131072
|
max_used_connections=207
|
max_threads=1002
|
thread_count=186
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2267691 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f76007d6a18
|
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 = 0x7f7619edfd40 thread_stack 0x40000
|
/usr/sbin/mysqld(my_print_stacktrace+0x38)[0x5606095e88bd]
|
/usr/sbin/mysqld(handle_fatal_signal+0x3d7)[0x56060901c0f2]
|
sigaction.c:0(__restore_rt)[0x7f79458ca680]
|
:0(__GI_raise)[0x7f7943dcf207]
|
:0(__GI_abort)[0x7f7943dd08f8]
|
/usr/sbin/mysqld(+0xc11b2e)[0x560609394b2e]
|
ut/ut0dbg.cc:62(__static_initialization_and_destruction_0)[0x5606092cfdca]
|
que/que0que.cc:561(que_graph_free_recursive(void*))[0x5606093049bc]
|
row/row0mysql.cc:986(row_prebuilt_free(row_prebuilt_t*, unsigned long))[0x56060921fdcd]
|
handler/ha_innodb.cc:6768(ha_innobase::close())[0x560609021883]
|
sql/handler.cc:2701(handler::ha_close())[0x560608e8dfe8]
|
sql/table.cc:3457(closefrm(TABLE*))[0x560608f755b2]
|
sql/table_cache.cc:223(intern_close_table)[0x560608f75733]
|
sql/table_cache.cc:261(tc_remove_table)[0x560608f75b86]
|
sql/table_cache.cc:384(tc_add_table(THD*, TABLE*))[0x560608d3b43e]
|
sql/sql_base.cc:1911(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x560608d3d749]
|
sql/sql_base.cc:3470(open_and_process_table)[0x560608d3e686]
|
sql/sql_base.cc:3990(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x560608d38969]
|
sql/sql_base.h:239(open_tables)[0x560608d3feb6]
|
sql/sql_base.cc:4904(open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int, unsigned int))[0x560608d3ffb8]
|
sql/sql_base.cc:4954(open_tables_only_view_structure(THD*, TABLE_LIST*, bool))[0x560608e2e46f]
|
sql/sql_show.cc:4483(fill_schema_table_by_open)[0x560608e2fb3c]
|
sql/sql_show.cc:5133(get_all_tables(THD*, TABLE_LIST*, Item*))[0x560608e3eee2]
|
sql/sql_show.cc:8612(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x560608de283e]
|
sql/sql_select.cc:3592(JOIN::exec_inner())[0x560608de200c]
|
sql/sql_select.cc:3425(JOIN::exec())[0x560608de2f5e]
|
sql/sql_select.cc:3826(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x560608dd8723]
|
sql/sql_select.cc:379(handle_select(THD*, LEX*, select_result*, unsigned long))[0x560608daf18f]
|
sql/sql_parse.cc:6511(execute_sqlcom_select)[0x560608da68e1]
|
sql/sql_parse.cc:3736(mysql_execute_command(THD*))[0x560608db248c]
|
sql/sql_parse.cc:7978(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x560608da1e2d]
|
sql/sql_parse.cc:1837(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x560608da0a79]
|
sql/sql_parse.cc:1383(do_command(THD*))[0x560608ec9860]
|
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x560608ec95c0]
|
pthread_create.c:0(start_thread)[0x7f79458c2dd5]
|
/lib64/libc.so.6(clone+0x6d)[0x7f7943e97b3d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f76007e0180): SELECT concat(current_date,'-',current_time) 'DateTime', table_schema 'Database_Name', Round(Sum(data_length + index_length) / 1024 / 1024, 1) 'Database_Size_MB' FROM information_schema.tables GROUP BY table_schema order by table_schema
|
Connection ID (thread ID): 2811
|
Status: NOT_KILLED
|
Crashes stop after downgrading back to 10.1.25.
See some what similar MDEV-15488 also.
Attachments
Issue Links
- includes
-
MDEV-17140 DB restarted due to InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2
- Closed
- relates to
-
MDEV-16122 [draft] Failing assertion: prebuilt->magic_n == ROW_PREBUILT_ALLOCATED
- Open
-
MDEV-16923 10.3.8 crashes
- Open
-
MDEV-20563 Server crash in row_upd_del_mark_clust_rec or in wsrep_row_upd_index_is_foreign or Assertion `update->n_fields < ulint(table->n_cols + table->n_v_cols)' failed upon DELETE from precise-versioned table
- Closed