[MDEV-26116] Assertion failure in data0type.cc line 67 Created: 2021-07-08  Updated: 2021-09-08  Resolved: 2021-09-08

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5.10, 10.5.11
Fix Version/s: 10.4.22, 10.5.13, 10.6.5

Type: Bug Priority: Critical
Reporter: Andrew Baznikin Assignee: Eugene Kosov (Inactive)
Resolution: Duplicate Votes: 2
Labels: None
Environment:

CentOS Linux 7

Issue Links:
Duplicate
duplicates MDEV-25951 MariaDB crash after ALTER TABLE conve... Closed

 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)



 Comments   
Comment by Alex Grebenschikov [ 2021-07-17 ]

Hello,

Same is here 

[root@server etc]#
 
Jul 17 10:07:55 server mysqld[1234071]: 2021-07-17 10:07:55 0 [Note] /usr/sbin/mysqld (mysqld 10.5.11-MariaDB) starting as process 1234071 ...
 
Jul 17 10:07:59 server systemd-coredump[1234128]: Process 1234071 (mysqld) of user 990 dumped core.#012#012Stack trace of thread 1234071:#012#0  0x00007f092ffcfa41 __poll (libc.so.6)#012#1  0x000055e78e3d40ff _Z26handle_connections_socketsv (mariadbd)#012#2  0x000055e78e3d51a8 _Z11mysqld_mainiPPc (mariadbd)#012#3  0x00007f092ff01493 __libc_start_main (libc.so.6)#012#4  0x000055e78e3c960e _start (mariadbd)#012#012Stack trace of thread 1234078:#012#0  0x00007f0930bcc64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78eb8c860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x000055e78eb8cb7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012#3  0x000055e78eb8e11d _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#4  0x00007f09306e7ba3 execute_native_thread_routine (libstdc++.so.6)#012#5  0x00007f0930bc614a start_thread (libpthread.so.0)#012#6  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234077:#012#0  0x00007f0930bcc2fc pthread_cond_wait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78ead9928 _ZL22buf_flush_page_cleanerPv (mariadbd)#012#2  0x00007f0930bc614a start_thread (libpthread.so.0)#012#3  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234080:#012#0  0x00007f0930bcc64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78eb8c860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x000055e78eb8cb7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012#3  0x000055e78eb8e11d _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#4  0x00007f09306e7ba3 execute_native_thread_routine (libstdc++.so.6)#012#5  0x00007f0930bc614a start_thread (libpthread.so.0)#012#6  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234075:#012#0  0x00007f092ffd552d syscall (libc.so.6)#012#1  0x000055e78eb8fc59 _ZN5tpool9aio_linux23getevent_thread_routineEPS0_ (mariadbd)#012#2  0x00007f09306e7ba3 execute_native_thread_routine (libstdc++.so.6)#012#3  0x00007f0930bc614a start_thread (libpthread.so.0)#012#4  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234073:#012#0  0x00007f0930bcc64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78ec003e1 timer_handler (mariadbd)#012#2  0x00007f0930bc614a start_thread (libpthread.so.0)#012#3  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234081:#012#0  0x00007f0930bcc64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78eb8c860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x000055e78eb8cb7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012#3  0x000055e78eb8e11d _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#4  0x00007f09306e7ba3 execute_native_thread_routine (libstdc++.so.6)#012#5  0x00007f0930bc614a start_thread (libpthread.so.0)#012#6  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234074:#012#0  0x00007f0930bcc64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78e8457c9 my_service_thread_sleep (mariadbd)#012#2  0x000055e78e83dac9 ma_checkpoint_background (mariadbd)#012#3  0x00007f0930bc614a start_thread (libpthread.so.0)#012#4  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234082:#012#0  0x00007f0930bcffb0 __nanosleep (libpthread.so.0)#012#1  0x000055e78e9be8a0 _Z15os_thread_sleepm (mariadbd)#012#2  0x000055e78ead4848 _ZL8buf_loadv (mariadbd)#012#3  0x000055e78ead53b2 _ZL18buf_dump_load_funcPv (mariadbd)#012#4  0x000055e78eb8f4bb _ZN5tpool4task7executeEv (mariadbd)#012#5  0x000055e78eb8e10f _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#6  0x00007f09306e7ba3 execute_native_thread_routine (libstdc++.so.6)#012#7  0x00007f0930bc614a start_thread (libpthread.so.0)#012#8  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234087:#012#0  0x00007f0930bcc64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78eb8c860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x000055e78eb8cb7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012#3  0x000055e78eb8e11d _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#4  0x00007f09306e7ba3 execute_native_thread_routine (libstdc++.so.6)#012#5  0x00007f0930bc614a start_thread (libpthread.so.0)#012#6  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234092:#012#0  0x00007f092ff1537f raise (libc.so.6)#012#1  0x00007f092feffe7e abort (libc.so.6)#012#2  0x000055e78e36b78b _Z23ut_dbg_assertion_failedPKcS0_j (mariadbd)#012#3  0x000055e78e376684 _Z27dtype_get_at_most_n_mbcharsmmmmmPKc.cold.0 (mariadbd)#012#4  0x000055e78ea07093 _ZL17row_merge_buf_addP15row_merge_buf_tP12dict_index_tPK12dict_table_tS5_P11fts_psort_tP8dtuple_tPK9row_ext_tPmP16mem_block_info_tP7dberr_tPSF_P5TABLEP5trx_t.isra.110 (mariadbd)#012#5  0x000055e78ea0eb99 _ZL30row_merge_read_clustered_indexP5trx_tP5TABLEPK12dict_table_tPS3_bPP12dict_index_tS8_P11fts_psort_tP12merge_file_tPKmmPK8dtuple_tPK16dict_add_v_col_tSF_mR13ib_sequence_tPhbP13pfs_os_file_tP16ut_stage_alter_tdSO_S2_b (mariadbd)#012#6  0x000055e78ea10cbe _Z23row_merge_build_indexesP5trx_tP12dict_table_tS2_bPP12dict_index_tPKmmP5TABLEPK8dtuple_tS7_mR13ib_sequence_tbP16ut_stage_alter_tPK16dict_add_v_col_tS9_b (mariadbd)#012#7  0x000055e78e971b2e _ZN11ha_innobase19inplace_alter_tableEP5TABLEP18Alter_inplace_info (mariadbd)#012#8  0x000055e78e533a3b _Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderbb (mariadbd)#012#9  0x000055e78e58f9b0 _ZN19Sql_cmd_alter_table7executeEP3THD (mariadbd)#012#10 0x000055e78e49acef _Z21mysql_execute_commandP3THD (mariadbd)#012#11 0x000055e78e48be0e _Z11mysql_parseP3THDPcjP12Parser_statebb (mariadbd)#012#12 0x000055e78e497830 _Z16dispatch_command19enum_server_commandP3THDPcjbb (mariadbd)#012#13 0x000055e78e499001 _Z10do_commandP3THD (mariadbd)#012#14 0x000055e78e58afa1 _Z24do_handle_one_connectionP7CONNECTb (mariadbd)#012#15 0x000055e78e58b33d handle_one_connection (mariadbd)#012#16 0x000055e78e8aee2a pfs_spawn_thread (mariadbd)#012#17 0x00007f0930bc614a start_thread (libpthread.so.0)#012#18 0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234089:#012#0  0x00007f0930bcc2fc pthread_cond_wait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x000055e78e48a77b handle_manager (mariadbd)#012#2  0x000055e78e8aee2a pfs_spawn_thread (mariadbd)#012#3  0x00007f0930bc614a start_thread (libpthread.so.0)#012#4  0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234099:#012#0  0x00007f092ffcfa41 __poll (libc.so.6)#012#1  0x000055e78e80e4be vio_io_wait (mariadbd)#012#2  0x000055e78e80e630 vio_socket_io_wait (mariadbd)#012#3  0x000055e78e80e71d vio_read (mariadbd)#012#4  0x000055e78e7972b3 _ZL12my_real_readP6st_netPmc (mariadbd)#012#5  0x000055e78e798540 my_net_read_packet_reallen (mariadbd)#012#6  0x000055e78e79864d my_net_read_packet (mariadbd)#012#7  0x000055e78e498f62 _Z10do_commandP3THD (mariadbd)#012#8  0x000055e78e58afa1 _Z24do_handle_one_connectionP7CONNECTb (mariadbd)#012#9  0x000055e78e58b33d handle_one_connection (mariadbd)#012#10 0x000055e78e8aee2a pfs_spawn_thread (mariadbd)#012#11 0x00007f0930bc614a start_thread (libpthread.so.0)#012#12 0x00007f092ffdadc3 __clone (libc.so.6)#012#012Stack trace of thread 1234103:#012#0  0x00007f092ffcfa41 __poll (libc.so.6)#012#1  0x000055e78e80e4be vio_io_wait (mariadbd)#012#2  0x000055e78e80e630 vio_socket_io_wait (mariadbd)#012#3  0x000055e78e80e71d vio_read (mariadbd)#012#4  0x000055e78e7972b3 _ZL12my_real_readP6st_netPmc (mariadbd)#012#5  0x000055e78e798540 my_net_read_packet_reallen (mariadbd)#012#6  0x000055e78e79864d my_net_read_packet (mariadbd)#012
 
Jul 17 10:08:03 server mysqld[1234353]: 2021-07-17 10:08:03 0 [Note] /usr/sbin/mysqld (mysqld 10.5.11-MariaDB) starting as process 1234353 ...
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] /usr/sbin/mysqld (mysqld 10.5.11-MariaDB) starting as process 1240077 ...
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Uses event mutexes
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Number of pools: 1
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Using Linux native AIO
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Completed initialization of buffer pool
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Resizing redo log from 8589934592 to 100663296 bytes; LSN=510627338444
 
Jul 17 10:13:39 server mysqld[1240077]: 2021-07-17 10:13:39 0 [Note] InnoDB: Starting to delete and rewrite log file.
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: New log file created, LSN=510627338444
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: 128 rollback segments are active.
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: 10.5.11 started; log sequence number 510627338432; transaction id 124183397
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] Plugin 'FEEDBACK' is disabled.
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] Server socket created on IP: '::'.
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] Reading of all Master_info entries succeeded
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] Added new Master_info '' to hash table
 
Jul 17 10:13:40 server mysqld[1240077]: 2021-07-17 10:13:40 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Jul 17 10:13:40 server mysqld[1240077]: Version: '10.5.11-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
 
...
 
...
 
...
 
Jul 17 10:15:00 server mysqld[1240077]: 2021-07-17 10:15:00 0x7f4704118700  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 17 10:15:00 server mysqld[1240077]: InnoDB: Failing assertion: !(prefix_len % mbmaxlen)
 
Jul 17 10:15:00 server mysqld[1240077]: InnoDB: We intentionally generate a memory trap.
 
Jul 17 10:15:00 server mysqld[1240077]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
Jul 17 10:15:00 server mysqld[1240077]: InnoDB: If you get repeated assertion failures or crashes, even
 
Jul 17 10:15:00 server mysqld[1240077]: InnoDB: immediately after the mysqld startup, there may be
 
Jul 17 10:15:00 server mysqld[1240077]: InnoDB: corruption in the InnoDB tablespace. Please refer to
 
Jul 17 10:15:00 server mysqld[1240077]: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
 
Jul 17 10:15:00 server mysqld[1240077]: InnoDB: about forcing recovery.
 
Jul 17 10:15:00 server mysqld[1240077]: 210717 10:15:00 [ERROR] mysqld got signal 6 ;
 
Jul 17 10:15:00 server mysqld[1240077]: This could be because you hit a bug. It is also possible that this binary
 
Jul 17 10:15:00 server mysqld[1240077]: or one of the libraries it was linked against is corrupt, improperly built,
 
Jul 17 10:15:00 server mysqld[1240077]: or misconfigured. This error can also be caused by malfunctioning hardware.
 
Jul 17 10:15:00 server mysqld[1240077]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
 
Jul 17 10:15:00 server mysqld[1240077]: We will try our best to scrape up some info that will hopefully help
 
Jul 17 10:15:00 server mysqld[1240077]: diagnose the problem, but since we have already crashed,
 
Jul 17 10:15:00 server mysqld[1240077]: something is definitely wrong and this may fail.
 
Jul 17 10:15:00 server mysqld[1240077]: Server version: 10.5.11-MariaDB
 
Jul 17 10:15:00 server mysqld[1240077]: key_buffer_size=134217728
 
Jul 17 10:15:00 server mysqld[1240077]: read_buffer_size=131072
 
Jul 17 10:15:00 server mysqld[1240077]: max_used_connections=9
 
Jul 17 10:15:00 server mysqld[1240077]: max_threads=153
 
Jul 17 10:15:00 server mysqld[1240077]: thread_count=9
 
Jul 17 10:15:00 server mysqld[1240077]: It is possible that mysqld could use up to
 
Jul 17 10:15:00 server mysqld[1240077]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467873 K  bytes of memory
 
Jul 17 10:15:00 server mysqld[1240077]: Hope that's ok; if not, decrease some variables in the equation.
 
Jul 17 10:15:00 server mysqld[1240077]: Thread pointer: 0x7f46bc000c58
 
Jul 17 10:15:00 server mysqld[1240077]: Attempting backtrace. You can use the following information to find out
 
Jul 17 10:15:00 server mysqld[1240077]: where mysqld died. If you see no messages after this, something went
 
Jul 17 10:15:00 server mysqld[1240077]: terribly wrong...
 
Jul 17 10:15:00 server mysqld[1240077]: stack_bottom = 0x7f4704117bd8 thread_stack 0x49000
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(my_print_stacktrace)[0x558e9355231e]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(handle_fatal_signal)[0x558e92fe1f15]
 
Jul 17 10:15:00 server mysqld[1240077]: sigaction.c:0(__restore_rt)[0x7f471cbd3b20]
 
Jul 17 10:15:00 server mysqld[1240077]: :0(__GI_raise)[0x7f471bf1837f]
 
Jul 17 10:15:00 server mysqld[1240077]: :0(__GI_abort)[0x7f471bf02db5]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(Wsrep_server_service::log_dummy_write_set(wsrep::client_state&, wsrep::ws_meta const&))[0x558e92cc178b]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(Wsrep_server_service::log_dummy_write_set(wsrep::client_state&, wsrep::ws_meta const&))[0x558e92ccc684]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(void std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char*>(char*, char*, std::forward_iterator_tag))[0x558e9335d093]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(void std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char*>(char*, char*, std::forward_iterator_tag))[0x558e93364b99]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(void std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char*>(char*, char*, std::forward_iterator_tag))[0x558e93366cbe]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x558e932c7b2e]
 
Jul 17 10:15:00 server mysqld[1240077]: ??: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))[0x558e92e89a3b]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(Sql_cmd_alter_table::execute(THD*))[0x558e92ee59b0]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(mysql_execute_command(THD*))[0x558e92df0cef]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558e92de1e0e]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558e92ded830]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(do_command(THD*))[0x558e92def001]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(do_handle_one_connection(CONNECT*, bool))[0x558e92ee0fa1]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(handle_one_connection)[0x558e92ee133d]
 
Jul 17 10:15:00 server mysqld[1240077]: ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x558e93204e2a]
 
Jul 17 10:15:00 server mysqld[1240077]: pthread_create.c:0(start_thread)[0x7f471cbc914a]
 
Jul 17 10:15:01 server mysqld[1240077]: :0(__GI___clone)[0x7f471bfdddc3]
 
Jul 17 10:15:01 server mysqld[1240077]: Trying to get some variables.
 
Jul 17 10:15:01 server mysqld[1240077]: Some pointers may be invalid and cause the dump to abort.
 
Jul 17 10:15:01 server mysqld[1240077]: Query (0x7f46bc010460): ALTER TABLE `wp_postmeta` CONVERT TO CHARACTER SET `utf8mb4` COLLATE `utf8mb4_danish_ci`
 
Jul 17 10:15:01 server mysqld[1240077]: Connection ID (thread ID): 1004
 
Jul 17 10:15:01 server mysqld[1240077]: Status: NOT_KILLED
 
Jul 17 10:15:01 server mysqld[1240077]: 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 17 10:15:01 server mysqld[1240077]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
 
Jul 17 10:15:01 server mysqld[1240077]: information that should help you find out what is causing the crash.
 
Jul 17 10:15:01 server mysqld[1240077]: Writing a core file...
 
Jul 17 10:15:01 server mysqld[1240077]: Working directory at /var/lib/mysql
 
Jul 17 10:15:01 server mysqld[1240077]: Resource Limits:
 
Jul 17 10:15:01 server mysqld[1240077]: Limit                     Soft Limit           Hard Limit           Units
 
Jul 17 10:15:01 server mysqld[1240077]: Max cpu time              unlimited            unlimited            seconds
 
Jul 17 10:15:01 server mysqld[1240077]: Max file size             unlimited            unlimited            bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max data size             unlimited            unlimited            bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max stack size            8388608              unlimited            bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max core file size        unlimited            unlimited            bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max resident set          unlimited            unlimited            bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max processes             514211               514211               processes
 
Jul 17 10:15:01 server mysqld[1240077]: Max open files            655350               655350               files
 
Jul 17 10:15:01 server mysqld[1240077]: Max locked memory         65536                65536                bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max address space         unlimited            unlimited            bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max file locks            unlimited            unlimited            locks
 
Jul 17 10:15:01 server mysqld[1240077]: Max pending signals       514211               514211               signals
 
Jul 17 10:15:01 server mysqld[1240077]: Max msgqueue size         819200               819200               bytes
 
Jul 17 10:15:01 server mysqld[1240077]: Max nice priority         0                    0
 
Jul 17 10:15:01 server mysqld[1240077]: Max realtime priority     0                    0
 
Jul 17 10:15:01 server mysqld[1240077]: Max realtime timeout      unlimited            unlimited            us
 
Jul 17 10:15:01 server mysqld[1240077]: Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e
 
Jul 17 10:15:02 server systemd-coredump[1242428]: Process 1240077 (mysqld) of user 990 dumped core.#012#012Stack trace of thread 1240101:#012#0  0x00007f471bf1837f raise (libc.so.6)#012#1  0x00007f471bf02e7e abort (libc.so.6)#012#2  0x0000558e92cc178b _Z23ut_dbg_assertion_failedPKcS0_j (mariadbd)#012#3  0x0000558e92ccc684 _Z27dtype_get_at_most_n_mbcharsmmmmmPKc.cold.0 (mariadbd)#012#4  0x0000558e9335d093 _ZL17row_merge_buf_addP15row_merge_buf_tP12dict_index_tPK12dict_table_tS5_P11fts_psort_tP8dtuple_tPK9row_ext_tPmP16mem_block_info_tP7dberr_tPSF_P5TABLEP5trx_t.isra.110 (mariadbd)#012#5  0x0000558e93364b99 _ZL30row_merge_read_clustered_indexP5trx_tP5TABLEPK12dict_table_tPS3_bPP12dict_index_tS8_P11fts_psort_tP12merge_file_tPKmmPK8dtuple_tPK16dict_add_v_col_tSF_mR13ib_sequence_tPhbP13pfs_os_file_tP16ut_stage_alter_tdSO_S2_b (mariadbd)#012#6  0x0000558e93366cbe _Z23row_merge_build_indexesP5trx_tP12dict_table_tS2_bPP12dict_index_tPKmmP5TABLEPK8dtuple_tS7_mR13ib_sequence_tbP16ut_stage_alter_tPK16dict_add_v_col_tS9_b (mariadbd)#012#7  0x0000558e932c7b2e _ZN11ha_innobase19inplace_alter_tableEP5TABLEP18Alter_inplace_info (mariadbd)#012#8  0x0000558e92e89a3b _Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderbb (mariadbd)#012#9  0x0000558e92ee59b0 _ZN19Sql_cmd_alter_table7executeEP3THD (mariadbd)#012#10 0x0000558e92df0cef _Z21mysql_execute_commandP3THD (mariadbd)#012#11 0x0000558e92de1e0e _Z11mysql_parseP3THDPcjP12Parser_statebb (mariadbd)#012#12 0x0000558e92ded830 _Z16dispatch_command19enum_server_commandP3THDPcjbb (mariadbd)#012#13 0x0000558e92def001 _Z10do_commandP3THD (mariadbd)#012#14 0x0000558e92ee0fa1 _Z24do_handle_one_connectionP7CONNECTb (mariadbd)#012#15 0x0000558e92ee133d handle_one_connection (mariadbd)#012#16 0x0000558e93204e2a pfs_spawn_thread (mariadbd)#012#17 0x00007f471cbc914a start_thread (libpthread.so.0)#012#18 0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240082:#012#0  0x00007f471cbcf2fc pthread_cond_wait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e9342f928 _ZL22buf_flush_page_cleanerPv (mariadbd)#012#2  0x00007f471cbc914a start_thread (libpthread.so.0)#012#3  0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240109:#012#0  0x00007f471bfd2a41 __poll (libc.so.6)#012#1  0x0000558e931644be vio_io_wait (mariadbd)#012#2  0x0000558e93164630 vio_socket_io_wait (mariadbd)#012#3  0x0000558e9316471d vio_read (mariadbd)#012#4  0x0000558e930ed2b3 _ZL12my_real_readP6st_netPmc (mariadbd)#012#5  0x0000558e930ee540 my_net_read_packet_reallen (mariadbd)#012#6  0x0000558e930ee64d my_net_read_packet (mariadbd)#012#7  0x0000558e92deef62 _Z10do_commandP3THD (mariadbd)#012#8  0x0000558e92ee0fa1 _Z24do_handle_one_connectionP7CONNECTb (mariadbd)#012#9  0x0000558e92ee133d handle_one_connection (mariadbd)#012#10 0x0000558e93204e2a pfs_spawn_thread (mariadbd)#012#11 0x00007f471cbc914a start_thread (libpthread.so.0)#012#12 0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240079:#012#0  0x00007f471cbcf64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e935563e1 timer_handler (mariadbd)#012#2  0x00007f471cbc914a start_thread (libpthread.so.0)#012#3  0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240080:#012#0  0x00007f471cbcf64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e9319b7c9 my_service_thread_sleep (mariadbd)#012#2  0x0000558e93193ac9 ma_checkpoint_background (mariadbd)#012#3  0x00007f471cbc914a start_thread (libpthread.so.0)#012#4  0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240111:#012#0  0x00007f471bf65591 _int_malloc (libc.so.6)#012#1  0x00007f471bf66c72 malloc (libc.so.6)#012#2  0x0000558e9354e600 my_malloc (mariadbd)#012#3  0x0000558e93546933 alloc_root (mariadbd)#012#4  0x0000558e93177640 _ZL20maria_create_handlerP10handlertonP11TABLE_SHAREP11st_mem_root (mariadbd)#012#5  0x0000558e92fe4a4c _Z15get_new_handlerP11TABLE_SHAREP11st_mem_rootP10handlerton (mariadbd)#012#6  0x0000558e92e2f4b8 _ZN16Create_tmp_table8finalizeEP3THDP5TABLEP15TMP_TABLE_PARAMbb (mariadbd)#012#7  0x0000558e92e305dd _Z16create_tmp_tableP3THDP15TMP_TABLE_PARAMR4ListI4ItemEP8st_orderbbyyPK25st_mysql_const_lex_stringbb (mariadbd)#012#8  0x0000558e92e3c09a _ZN4JOIN26create_postjoin_aggr_tableEP13st_join_tableP4ListI4ItemEP8st_orderbbb (mariadbd)#012#9  0x0000558e92e3cc78 _ZN4JOIN21make_aggr_tables_infoEv (mariadbd)#012#10 0x0000558e92e464b8 _ZN4JOIN15optimize_stage2Ev (mariadbd)#012#11 0x0000558e92e48873 _ZN4JOIN14optimize_innerEv (mariadbd)#012#12 0x0000558e92e4a7e3 _ZN4JOIN8optimizeEv (mariadbd)#012#13 0x0000558e92e4a8a7 _Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex (mariadbd)#012#14 0x0000558e92e4b25b _Z13handle_selectP3THDP3LEXP13select_resultm (mariadbd)#012#15 0x0000558e92de6e83 _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST (mariadbd)#012#16 0x0000558e92df0c74 _Z21mysql_execute_commandP3THD (mariadbd)#012#17 0x0000558e92de1e0e _Z11mysql_parseP3THDPcjP12Parser_statebb (mariadbd)#012#18 0x0000558e92ded830 _Z16dispatch_command19enum_server_commandP3THDPcjbb (mariadbd)#012#19 0x0000558e92def001 _Z10do_commandP3THD (mariadbd)#012#20 0x0000558e92ee0fa1 _Z24do_handle_one_connectionP7CONNECTb (mariadbd)#012#21 0x0000558e92ee133d handle_one_connection (mariadbd)#012#22 0x0000558e93204e2a pfs_spawn_thread (mariadbd)#012#23 0x00007f471cbc914a start_thread (libpthread.so.0)#012#24 0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240115:#012#0  0x00007f471cbcf64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e934e2860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x0000558e934e2b7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012#3  0x0000558e934e411d _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#4  0x00007f471c6eaba3 execute_native_thread_routine (libstdc++.so.6)#012#5  0x00007f471cbc914a start_thread (libpthread.so.0)#012#6  0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240135:#012#0  0x00007f471cbcf64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e934e2860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x0000558e934e2b7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012#3  0x0000558e934e411d _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#4  0x00007f471c6eaba3 execute_native_thread_routine (libstdc++.so.6)#012#5  0x00007f471cbc914a start_thread (libpthread.so.0)#012#6  0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240092:#012#0  0x00007f471cbcf64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e934e2860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x0000558e934e2b7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012#3  0x0000558e934e411d _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd)#012#4  0x00007f471c6eaba3 execute_native_thread_routine (libstdc++.so.6)#012#5  0x00007f471cbc914a start_thread (libpthread.so.0)#012#6  0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240096:#012#0  0x00007f471cbcf2fc pthread_cond_wait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e92de077b handle_manager (mariadbd)#012#2  0x0000558e93204e2a pfs_spawn_thread (mariadbd)#012#3  0x00007f471cbc914a start_thread (libpthread.so.0)#012#4  0x00007f471bfdddc3 __clone (libc.so.6)#012#012Stack trace of thread 1240125:#012#0  0x00007f471cbcf64a pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0)#012#1  0x0000558e934e2860 _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd)#012#2  0x0000558e934e2b7d _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd)#012
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] /usr/sbin/mysqld (mysqld 10.5.11-MariaDB) starting as process 1242953 ...
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Uses event mutexes
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Number of pools: 1
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Using Linux native AIO
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Completed initialization of buffer pool
 
Jul 17 10:15:06 server mysqld[1242953]: 2021-07-17 10:15:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=510627338764,510627338764
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: Starting final batch to recover 859 pages from redo log.
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: 128 rollback segments are active.
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: 10.5.11 started; log sequence number 510632828486; transaction id 124211931
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] Plugin 'FEEDBACK' is disabled.
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] Server socket created on IP: '::'.
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] Reading of all Master_info entries succeeded
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] Added new Master_info '' to hash table
 
Jul 17 10:15:07 server mysqld[1242953]: 2021-07-17 10:15:07 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Jul 17 10:15:07 server mysqld[1242953]: Version: '10.5.11-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
 
Jul 17 10:15:08 server mysqld[1242953]: 2021-07-17 10:15:08 0 [Note] InnoDB: Buffer pool(s) load completed at 210717 10:15:08
 
[root@server etc]#

with a similar query:

ALTER TABLE `wp_postmeta` CONVERT TO CHARACTER SET `utf8mb4` COLLATE `utf8mb4_danish_ci`;

Kindly advise.

Regards,
Alex.

Comment by Eugene Kosov (Inactive) [ 2021-09-08 ]

I'm 99% sure this is a duplicate of an issue which was just fixed. 100% is not achievable because there is not enough information in description of an issue. Anyways, I suggest to try the next release.

Generated at Thu Feb 08 09:42:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.