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

Assertion failure in data0type.cc line 67

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

            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.

            poralix Alex Grebenschikov added a comment - 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.

            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.

            kevg Eugene Kosov (Inactive) added a comment - 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.

            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.