Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.5.10, 10.5.11
-
None
-
CentOS Linux 7
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
- duplicates
-
MDEV-25951 MariaDB crash after ALTER TABLE convert to utf8mb4
- Closed