[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]#
|
Hello,
Same is here
...
...
...
with a similar query:
ALTER TABLE `wp_postmeta` CONVERT TO CHARACTER SET `utf8mb4` COLLATE `utf8mb4_danish_ci`;
Kindly advise.
Regards,
Alex.