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

Assertion failure in data0type.cc line 67

    XMLWordPrintable

Details

    Description

      Doing Phabricator storage adjustment I got MariaDB crash in midflight. Checked with 10.5.10 and 10.5.11

      It looks very similar to MDEV-24802 and MDEV-20726

      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: 2021-07-09 02:03:24 0x7ff934621700  InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.5.11/storage/innobase/data/data0type.cc line 67
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: Failing assertion: !(prefix_len % mbmaxlen)
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: We intentionally generate a memory trap.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: If you get repeated assertion failures or crashes, even
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: immediately after the mysqld startup, there may be
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: corruption in the InnoDB tablespace. Please refer to
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: InnoDB: about forcing recovery.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: 210709  2:03:24 [ERROR] mysqld got signal 6 ;
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: This could be because you hit a bug. It is also possible that this binary
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: or one of the libraries it was linked against is corrupt, improperly built,
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: We will try our best to scrape up some info that will hopefully help
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: diagnose the problem, but since we have already crashed,
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: something is definitely wrong and this may fail.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Server version: 10.5.11-MariaDB
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: key_buffer_size=134217728
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: read_buffer_size=131072
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: max_used_connections=8
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: max_threads=132
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: thread_count=8
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: It is possible that mysqld could use up to
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 421642 K  bytes of memory
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Hope that's ok; if not, decrease some variables in the equation.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Thread pointer: 0x7ff874028798
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Attempting backtrace. You can use the following information to find out
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: where mysqld died. If you see no messages after this, something went
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: terribly wrong...
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: stack_bottom = 0x7ff934620c90 thread_stack 0x49000
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(my_print_stacktrace)[0x55eeb3e0f79e]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(handle_fatal_signal)[0x55eeb3814457]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: sigaction.c:0(__restore_rt)[0x7ff93e995630]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: :0(__GI_raise)[0x7ff93dde0387]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: :0(__GI_abort)[0x7ff93dde1a78]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: /usr/sbin/mariadbd(+0x6536cb)[0x55eeb34ea6cb]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(std::pair<std::_Rb_tree_iterator<unsigned int>, bool> std::_Rb_tree<unsigned int, unsigned int, std::_Identity<unsigned int>, std::less<unsigned int>, std::allocator<unsigned int> >::_M_insert_unique<unsigned int const&>(unsigned int const&))[0x55eeb3cc3bcc]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(void std::__introsort_loop<unsigned char**, long>(unsigned char**, unsigned char**, long))[0x55eeb3bc6937]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(void std::__introsort_loop<unsigned char**, long>(unsigned char**, unsigned char**, long))[0x55eeb3bccd6e]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(void std::__introsort_loop<unsigned char**, long>(unsigned char**, unsigned char**, long))[0x55eeb3bcf604]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x55eeb3b1e0fc]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool, bool))[0x55eeb36ab7a1]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(Sql_cmd_alter_table::execute(THD*))[0x55eeb370885e]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(mysql_execute_command(THD*))[0x55eeb36112be]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55eeb36151c5]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55eeb3617891]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(do_command(THD*))[0x55eeb361903f]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(do_handle_one_connection(CONNECT*, bool))[0x55eeb3703b52]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(handle_one_connection)[0x55eeb3703e14]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x55eeb3a6156d]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: pthread_create.c:0(start_thread)[0x7ff93e98dea5]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: ??:0(__clone)[0x7ff93dea89fd]
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Trying to get some variables.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Some pointers may be invalid and cause the dump to abort.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Query (0x7ff874036e20): ALTER TABLE `phabricator_herald`.`herald_rule` MODIFY `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Connection ID (thread ID): 8
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Status: NOT_KILLED
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: 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=on,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,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: information that should help you find out what is causing the crash.
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Writing a core file...
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Working directory at /var/lib/mysql
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Resource Limits:
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Limit                     Soft Limit           Hard Limit           Units
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max cpu time              unlimited            unlimited            seconds
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max file size             unlimited            unlimited            bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max data size             unlimited            unlimited            bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max stack size            8388608              unlimited            bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max core file size        0                    unlimited            bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max resident set          unlimited            unlimited            bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max processes             23128                23128                processes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max open files            32768                32768                files
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max locked memory         65536                65536                bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max address space         unlimited            unlimited            bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max file locks            unlimited            unlimited            locks
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max pending signals       23128                23128                signals
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max msgqueue size         819200               819200               bytes
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max nice priority         0                    0
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max realtime priority     0                    0
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Max realtime timeout      unlimited            unlimited            us
      Jul 09 02:03:24 phab-db.core.kran mariadbd[4645]: Core pattern: core
      

      Query:

      ALTER TABLE `phabricator_herald`.`herald_rule` MODIFY `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
      

      Table:

      > describe `phabricator_herald`.`herald_rule`;
      +-------------------+------------------+------+-----+---------+----------------+
      | Field             | Type             | Null | Key | Default | Extra          |
      +-------------------+------------------+------+-----+---------+----------------+
      | id                | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
      | name              | varchar(255)     | NO   | MUL | NULL    |                |
      | authorPHID        | varbinary(64)    | NO   | MUL | NULL    |                |
      | contentType       | varbinary(255)   | NO   |     | NULL    |                |
      | mustMatchAll      | tinyint(1)       | NO   |     | NULL    |                |
      | configVersion     | int(10) unsigned | NO   |     | 1       |                |
      | dateCreated       | int(10) unsigned | NO   |     | NULL    |                |
      | dateModified      | int(10) unsigned | NO   |     | NULL    |                |
      | repetitionPolicy  | varbinary(32)    | NO   |     | NULL    |                |
      | ruleType          | varbinary(32)    | NO   | MUL | NULL    |                |
      | phid              | varbinary(64)    | NO   | UNI | NULL    |                |
      | isDisabled        | int(10) unsigned | NO   |     | 0       |                |
      | triggerObjectPHID | varbinary(64)    | YES  | MUL | NULL    |                |
      +-------------------+------------------+------+-----+---------+----------------+
      13 rows in set (0.001 sec)
      

      Attachments

        Issue Links

          Activity

            People

              kevg Eugene Kosov (Inactive)
              dikiyobraz Andrew Baznikin
              Votes:
              2 Vote for this issue
              Watchers:
              4 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.