[MDEV-18691] Failing assertion: page_is_comp(next_page) == page_is_comp(page) in btr0pcur.cc Created: 2019-02-22  Updated: 2019-04-28  Resolved: 2019-04-28

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Sascha Greuel Assignee: Marko Mäkelä
Resolution: Incomplete Votes: 0
Labels: assertion, crash, innodb, need_feedback
Environment:

Debian GNU/Linux buster/sid


Issue Links:
Relates
relates to MDEV-13542 Crashing on a corrupted page is unhel... Closed

 Description   

MariaDB/MySQL keeps constantly crashing. I am currently trying to rescue a database using MySQL dump 10.17, but

mysqldump: Got error: 2013: "Lost connection to MySQL server during query" when using LOCK TABLES

Full log:

2019-02-22 10:14:02 0x7f104844c700  InnoDB: Assertion failure in file /build/mariadb-10.3-L3F6cy/mariadb-10.3-10.3.12/storage/innobase/btr/btr0pcur.cc line 459
InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page)
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/innodb-recovery-modes/
InnoDB: about forcing recovery.
190222 10:14:02 [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.3.12-MariaDB-2
key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=1
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 = 352701 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x55aa81d57cb8
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 = 0x7f104844bdd8 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55aa7e6736be]
/usr/sbin/mysqld(handle_fatal_signal+0x505)[0x55aa7e1e5935]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x126e0)[0x7f105ab316e0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x10b)[0x7f1059da08bb]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x121)[0x7f1059d8b535]
/usr/sbin/mysqld(+0x4bc2d9)[0x55aa7df332d9]
/usr/sbin/mysqld(+0x4bfc88)[0x55aa7df36c88]
/usr/sbin/mysqld(+0x99c530)[0x55aa7e413530]
/usr/sbin/mysqld(+0x99dcbb)[0x55aa7e414cbb]
/usr/sbin/mysqld(+0x95d0e8)[0x55aa7e3d40e8]
/usr/sbin/mysqld(+0x95de79)[0x55aa7e3d4e79]
/usr/sbin/mysqld(+0xa72afa)[0x55aa7e4e9afa]
/usr/sbin/mysqld(+0x8e58d1)[0x55aa7e35c8d1]
/usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x4a)[0x55aa7e1e9ffa]
/usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPK25st_mysql_const_lex_stringjjjP5TABLEbP4ListI6StringE+0x979)[0x55aa7e0c9989]
/usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xae3)[0x55aa7dfc1083]
/usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xc52)[0x55aa7dfc4102]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x7229)[0x55aa7e01e679]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x246)[0x55aa7e01f986]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ef0)[0x55aa7e022680]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x170)[0x55aa7e0232c0]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x20a)[0x55aa7e0f14ea]
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55aa7e0f168d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7f105ab26fa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f1059e6280f]
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x55aa81d67aa0): LOCK TABLES `mcps1_log_download` READ /*!32311 LOCAL */,`mcps1_log_upload` READ /*!32311 LOCAL */,`mcps1_login` READ /*!32311 LOCAL */,`mcps1_match` READ /*!32311 LOCAL */,`mcps1_package` READ /*!32311 LOCAL */,`mcps1_package_file` READ /*!32311 LOCAL */,`mcps1_package_file_to_server` READ /*!32311 LOCAL */,`mcps1_server` READ /*!32311 LOCAL */,`shop1_account` READ /*!32311 LOCAL */,`shop1_address` READ /*!32311 LOCAL */,`shop1_currency` READ /*!32311 LOCAL */,`shop1_function` READ /*!32311 LOCAL */,`shop1_function_to_product` READ /*!32311 LOCAL */,`shop1_help` READ /*!32311 LOCAL */,`shop1_legal` READ /*!32311 LOCAL */,`shop1_license` READ /*!32311 LOCAL */,`shop1_license_extension` READ /*!32311 LOCAL */,`shop1_license_log` READ /*!32311 LOCAL */,`shop1_license_transfer` READ /*!32311 LOCAL */,`shop1_location_cache` READ /*!32311 LOCAL */,`shop1_mail` READ /*!32311 LOCAL */,`shop1_mail_attachment` READ /*!32311 LOCAL */,`shop1_membership` READ /*!32311 LOCAL */,`shop1_membership_subscription` READ /*!32311 LOCAL */,`shop1_notification` READ /*!32311 LOCAL */,`shop1_order` READ /*!32311 LOCAL */,`shop1_order_discount` READ /*!32311 LOCAL */,`shop1_order_file` READ /*!32311 LOCAL */,`shop1_order_log` READ /*!32311 LOCAL */,`shop1_order_modifier` READ /*!32311 LOCAL */,`shop1_order_option` READ /*!32311 LOCAL */,`shop1_order_option_value` READ /*!32311 LOCAL */,`shop1_order_product` READ /*!32311 LOCAL */,`shop1_order_rollback` READ /*!32311 LOCAL */,`shop1_payment_notification_log` READ /*!32311 LOCAL */,`shop1_product` READ /*!32311 LOCAL */,`shop1_product_code` READ /*!32311 LOCAL */,`shop1_product_option` READ /*!32311 LOCAL */,`shop1_product_page` READ /*!32311 LOCAL */,`shop1_product_review` READ /*!32311 LOCAL */,`shop1_product_review_rating` READ /*!32311 LOCAL */,`shop1_product_to_category` READ /*!32311 LOCAL */,`shop1_serial` READ /*!32311 LOCAL */,`shop1_shipping` READ /*!32311 LOCAL */,`shop1_storage` READ /*!32311 LOCAL */,`shop1_storage_log` READ /*!32311 LOCAL */,`shop1_support` READ /*!32311 LOCAL */,`shop1_tax_category` READ /*!32311 LOCAL */,`shop1_voucher` READ /*!32311 LOCAL */,`shop1_wcf_package` READ /*!32311 LOCAL */,`shop1_wcf_package_version` READ /*!32311 LOCAL */,`shop1_wcf_package_version_to_server` READ /*!32311 LOCAL */,`shop1_wcf_server` READ /*!32311 LOCAL */,`wbb1_board` READ /*!32311 LOCAL */,`wbb1_board_last_post` READ /*!32311 LOCAL */,`wbb1_post` READ /*!32311 LOCAL */,`wbb1_post_search_index` READ /*!32311 LOCAL */,`wbb1_rss_feed` READ /*!32311 LOCAL */,`wbb1_rss_feed_log` READ /*!32311 LOCAL */,`wbb1_thread` READ /*!32311 LOCAL */,`wbb1_thread_announcement` READ /*!32311 LOCAL */,`wbb1_thread_copy` READ /*!32311 LOCAL */,`wbb1_thread_similar` READ /*!32311 LOCAL */,`wcf1_acl_option` READ /*!32311 LOCAL */,`wcf1_acl_option_category` READ /*!32311 LOCAL */,`wcf1_acl_option_to_group` READ /*!32311 LOCAL */,`wcf1_acl_option_to_user` READ /*!32311 LOCAL */,`wcf1_acl_simple_to_group` READ /*!32311 LOCAL */,`wcf1_acl_simple_to_user` READ /*!32311 LOCAL */,`wcf1_acp_menu_item` READ /*!32311 LOCAL */,`wcf1_acp_search_provider` READ /*!32311 LOCAL */,`wcf1_acp_session` READ /*!32311 LOCAL */,`wcf1_acp_session_access_log` READ /*!32311 LOCAL */,`wcf1_acp_session_log` READ /*!32311 LOCAL */,`wcf1_acp_session_virtual` READ /*!32311 LOCAL */,`wcf1_acp_template` READ /*!32311 LOCAL */,`wcf1_ad` READ /*!32311 LOCAL */,`wcf1_amazon_ses_log` READ /*!32311 LOCAL */,`wcf1_amazon_sns_log` READ /*!32311 LOCAL */,`wcf1_application` READ /*!32311 LOCAL */,`wcf1_article` READ /*!32311 LOCAL */,`wcf1_article_content` READ /*!32311 LOCAL */,`wcf1_article_search_index` READ /*!32311 LOCAL */,`wcf1_article_version` READ /*!32311 LOCAL */,`wcf1_attachment` READ /*!32311 LOCAL */,`wcf1_background_job` READ /*!32311 LOCAL */,`wcf1_bbcode` READ /*!32311 LOCAL */,`wcf1_bbcode_attribute` READ /*!32311 LOCAL */,`wcf1_bbcode_image_whitelist` READ /*!32311 LOCAL */,`wcf1_bbcode_media_provider` READ /*!32311 LOCAL */,`wcf1_bbcode_media_whitelist` READ /*!32311 LOCAL */,`wcf1_box` READ /*!32311 LOCAL */,`wcf1_box_content` READ /*!32311 LOCAL */,`wcf1_box_to_page` READ /*!32311 LOCAL */,`wcf1_box_version` READ /*!32311 LOCAL */,`wcf1_captcha_question` READ /*!32311 LOCAL */,`wcf1_category` READ /*!32311 LOCAL */,`wcf1_cli_history` READ /*!32311 LOCAL */,`wcf1_clipboard_action` READ /*!32311 LOCAL */,`wcf1_clipboard_item` READ /*!32311 LOCAL */,`wcf1_clipboard_page` READ /*!32311 LOCAL */,`wcf1_comment` READ /*!32311 LOCAL */,`wcf1_comment_response` READ /*!32311 LOCAL */,`wcf1_condition` READ /*!32311 LOCAL */,`wcf1_contact_option` READ /*!32311 LOCAL */,`wcf1_contact_recipient` READ /*!32311 LOCAL */,`wcf1_conversation` READ /*!32311 LOCAL */,`wcf1_conversation_label` READ /*!32311 LOCAL */,`wcf1_conversation_label_to_object` READ /*!32311 LOCAL */,`wcf1_conversation_message` READ /*!32311 LOCAL */,`wcf1_conversation_message_search_index` READ /*!32311 LOCAL */,`wcf1_conversation_to_user` READ /*!32311 LOCAL */,`wcf1_core_object` READ /*!32311 LOCAL */,`wcf1_cronjob` READ /*!32311 LOCAL */,`wcf1_cronjob_log` READ /*!32311 LOCAL */,`wcf1_devtools_project` READ /*!32311 LOCAL */,`wcf1_disposable_email_domain` READ /*!32311 LOCAL */,`wcf1_edit_history_entry` READ /*!32311 LOCAL */,`wcf1_event_listener` READ /*!32311 LOCAL */,`wcf1_gdpr_export_log` READ /*!32311 LOCAL */,`wcf1_import_mapping` READ /*!32311 LOCAL */,`wcf1_infraction_suspension` READ /*!32311 LOCAL */,`wcf1_infraction_warning` READ /*!32311 LOCAL */,`wcf1_label` READ /*!32311 LOCAL */,`wcf1_label_group` READ /*!32311 LOCAL */,`wcf1_label_group_to_object` READ /*!32311 LOCAL */,`wcf1_label_object` READ /*!32311 LOCAL */,`wcf1_language` READ /*!32311 LOCAL */,`wcf1_language_category` READ /*!32311 LOCAL */,`wcf1_language_item` READ /*!32311 LOCAL */,`wcf1_like` READ /*!32311 LOCAL */,`wcf1_like_object` READ /*!32311 LOCAL */,`wcf1_media` READ /*!32311 LOCAL */,`wcf1_media_content` READ /*!32311 LOCAL */,`wcf1_menu` READ /*!32311 LOCAL */,`wcf1_menu_item` READ /*!32311 LOCAL */,`wcf1_message_embedded_object` READ /*!32311 LOCAL */,`wcf1_moderation_queue` READ /*!32311 LOCAL */,`wcf1_moderation_queue_to_user` READ /*!32311 LOCAL */,`wcf1_modification_log` READ /*!32311 LOCAL */,`wcf1_notice` READ /*!32311 LOCAL */,`wcf1_notice_dismissed` READ /*!32311 LOCAL */,`wcf1_object_type` READ /*!32311 LOCAL */,`wcf1_object_type_definition` READ /*!32311 LOCAL */,`wcf1_option` READ /*!32311 LOCAL */,`wcf1_option_category` READ /*!32311 LOCAL */,`wcf1_package` READ /*!32311 LOCAL */,`wcf1_package_compatibility` READ /*!32311 LOCAL */,`wcf1_package_exclusion` READ /*!32311 LOCAL */,`wcf1_package_installation_file_log` READ /*!32311 LOCAL */,`wcf1_package_installation_form` READ /*!32311 LOCAL */,`wcf1_package_installation_node` READ /*!32311 LOCAL */,`wcf1_package_installation_plugin` READ /*!32311 LOCAL */,`wcf1_package_installation_queue` READ /*!32311 LOCAL */,`wcf1_package_installation_sql_log` READ /*!32311 LOCAL */,`wcf1_package_requirement` READ /*!32311 LOCAL */,`wcf1_package_update` READ /*!32311 LOCAL */,`wcf1_package_update_compatibility` READ /*!32311 LOCAL */,`wcf1_package_update_exclusion` READ /*!32311 LOCAL */,`wcf1_package_update_fromversion` READ /*!32311 LOCAL */,`wcf1_package_update_optional` READ /*!32311 LOCAL */,`wcf1_package_update_requirement` READ /*!32311 LOCAL */,`wcf1_package_update_server` READ /*!32311 LOCAL */,`wcf1_package_update_version` READ /*!32311 LOCAL */,`wcf1_page` READ /*!32311 LOCAL */,`wcf1_page_box_order` READ /*!32311 LOCAL */,`wcf1_page_content` READ /*!32311 LOCAL */,`wcf1_page_search_index` READ /*!32311 LOCAL */,`wcf1_page_sort` READ /*!32311 LOCAL */,`wcf1_page_version` READ /*!32311 LOCAL */,`wcf1_paid_subscription` READ /*!32311 LOCAL */,`wcf1_paid_subscription_transaction_log` READ /*!32311 LOCAL */,`wcf1_paid_subscription_user` READ /*!32311 LOCAL */,`wcf1_plugin_store_file` READ /*!32311 LOCAL */,`wcf1_poll` READ /*!32311 LOCAL */,`wcf1_poll_option` READ /*!32311 LOCAL */,`wcf1_poll_option_vote` READ /*!32311 LOCAL */,`wcf1_registry` READ /*!32311 LOCAL */,`wcf1_search` READ /*!32311 LOCAL */,`wcf1_search_index_4be2a611` READ /*!32311 LOCAL */,`wcf1_search_index_b699e43b` READ /*!32311 LOCAL */,`wcf1_search_keyword` READ /*!32311 LOCAL */,`wcf1_session` READ /*!32311 LOCAL */,`wcf1_session_virtual` READ /*!32311 LOCAL */,`wcf1_smiley` READ /*!32311 LOCAL */,`wcf1_spider` READ /*!32311 LOCAL */,`wcf1_stat_daily` READ /*!32311 LOCAL */,`wcf1_steam_id` READ /*!32311 LOCAL */,`wcf1_style` READ /*!32311 LOCAL */,`wcf1_style_google_font` READ /*!32311 LOCAL */,`wcf1_style_variable` READ /*!32311 LOCAL */,`wcf1_style_variable_value` READ /*!32311 LOCAL */,`wcf1_tag` READ /*!32311 LOCAL */,`wcf1_tag_to_object` READ /*!32311 LOCAL */,`wcf1_template` READ /*!32311 LOCAL */,`wcf1_template_group` READ /*!32311 LOCAL */,`wcf1_template_listener` READ /*!32311 LOCAL */,`wcf1_tracked_visit` READ /*!32311 LOCAL */,`wcf1_tracked_visit_type` READ /*!32311 LOCAL */,`wcf1_trophy` READ /*!32311 LOCAL */,`wcf1_user` READ /*!32311 LOCAL */,`wcf1_user_activity_event` READ /*!32311 LOCAL */,`wcf1_user_activity_point` READ /*!32311 LOCAL */,`wcf1_user_authentication_failure` READ /*!32311 LOCAL */,`wcf1_user_avatar` READ /*!32311 LOCAL */,`wcf1_user_collapsible_content` READ /*!32311 LOCAL */,`wcf1_user_follow` READ /*!32311 LOCAL */,`wcf1_user_group` READ /*!32311 LOCAL */,`wcf1_user_group_application` READ /*!32311 LOCAL */,`wcf1_user_group_assignment` READ /*!32311 LOCAL */,`wcf1_user_group_leader` READ /*!32311 LOCAL */,`wcf1_user_group_option` READ /*!32311 LOCAL */,`wcf1_user_group_option_category` READ /*!32311 LOCAL */,`wcf1_user_group_option_value` READ /*!32311 LOCAL */,`wcf1_user_ignore` READ /*!32311 LOCAL */,`wcf1_user_infraction_suspension` READ /*!32311 LOCAL */,`wcf1_user_infraction_warning` READ /*!32311 LOCAL */,`wcf1_user_menu_item` READ /*!32311 LOCAL */,`wcf1_user_notification` READ /*!32311 LOCAL */,`wcf1_user_notification_author` READ /*!32311 LOCAL */,`wcf1_user_notification_event` READ /*!32311 LOCAL */,`wcf1_user_notification_event_to_user` READ /*!32311 LOCAL */,`wcf1_user_notification_to_user` READ /*!32311 LOCAL */,`wcf1_user_object_watch` READ /*!32311 LOCAL */,`wcf1_user_option` READ /*!32311 LOCAL */,`wcf1_user_option_category` READ /*!32311 LOCAL */,`wcf1_user_option_value` READ /*!32311 LOCAL */,`wcf1_user_otu_blacklist_entry` READ /*!32311 LOCAL */,`wcf1_user_profile_menu_item` READ /*!32311 LOCAL */,`wcf1_user_profile_visitor` READ /*!32311 LOCAL */,`wcf1_user_rank` READ /*!32311 LOCAL */,`wcf1_user_special_trophy` READ /*!32311 LOCAL */,`wcf1_user_storage` READ /*!32311 LOCAL */,`wcf1_user_to_group` READ /*!32311 LOCAL */,`wcf1_user_to_language` READ /*!32311 LOCAL */,`wcf1_user_trophy` READ /*!32311 LOCAL */,`wcf1_wsc_connect_login_attempts` READ /*!32311 LOCAL */,`wcf1_wsc_connect_notifications` READ /*!32311 LOCAL */
Connection ID (thread ID): 36
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
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.



 Comments   
Comment by Sascha Greuel [ 2019-02-22 ]

Follow up:

~ # mysqlcheck -u root -p`cat /root/.mysql_shadow` --all-databases
 
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... '

Log:

190222 10:55:18 [ERROR] mysqld got signal 11 ;
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.3.12-MariaDB-2
key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=1
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 = 352701 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x55697cb29428
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 = 0x7f0f4d2f0dd8 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x556979a7d6be]
/usr/sbin/mysqld(handle_fatal_signal+0x505)[0x5569795ef935]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x126e0)[0x7f0f51f116e0]
/usr/sbin/mysqld(+0x96122b)[0x5569797e222b]
/usr/sbin/mysqld(+0xa0b205)[0x55697988c205]
/usr/sbin/mysqld(+0xa6ce57)[0x5569798ede57]
/usr/sbin/mysqld(+0xa72751)[0x5569798f3751]
/usr/sbin/mysqld(+0x8e58d1)[0x5569797668d1]
/usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x4a)[0x5569795f3ffa]
/usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPK25st_mysql_const_lex_stringjjjP5TABLEbP4ListI6StringE+0x979)[0x5569794d3989]
/usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xae3)[0x5569793cb083]
/usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xc52)[0x5569793ce102]
/usr/sbin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x3d)[0x5569793ce87d]
/usr/sbin/mysqld(+0x6833c8)[0x5569795043c8]
/usr/sbin/mysqld(+0x684482)[0x556979505482]
/usr/sbin/mysqld(_ZN19Sql_cmd_check_table7executeEP3THD+0x7b)[0x55697950729b]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x114f)[0x55697942259f]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x246)[0x556979429986]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ef0)[0x55697942c680]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x170)[0x55697942d2c0]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x20a)[0x5569794fb4ea]
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x5569794fb68d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7f0f51f06fa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f0f5124280f]
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x55697cb38e00): CHECK TABLE `innodb_index_stats`
Connection ID (thread ID): 36
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
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

Comment by Marko Mäkelä [ 2019-03-26 ]

I am afraid that this is how InnoDB handles corruption. Without a repeatable test case, there is nothing that we can do about this. MDEV-13542 has been filed to handle corruption more gracefully.

I have seen cases where an InnoDB b-tree page is full of zero bytes. Sometimes users copy files without using mariabackup while the server is running. Or the redo log is removed while it contains outstanding changes. Or, it could also be caused by a hardware failure. Or some bug in InnoDB, such as MDEV-14126.

If you can provide a repeatable test case for corrupting the table, then we can try to do something about it.

Generated at Thu Feb 08 08:46:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.