|
Thanks for the report! This is the same problem as MDEV-20726:
on 10.4.10:
2019-12-04 13:06:56 0x7fd8a8344700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/data/data0type.cc line 67
|
InnoDB: Failing assertion: !(prefix_len % mbmaxlen)
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
|
InnoDB: about forcing recovery.
|
191204 13:06:56 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.4.10-MariaDB
|
mysys/stacktrace.c:270(my_print_stacktrace)[0x559f4c86bc87]
|
linux/raise.c:54(__GI_raise)[0x7fd8ab8b6428]
|
stdlib/abort.c:91(__GI_abort)[0x7fd8ab8b802a]
|
data/data0type.cc:67(dtype_get_at_most_n_mbchars(unsigned long, unsigned long, unsigned long, unsigned long, unsigned long, char const*))[0x559f4cae0416]
|
row/row0merge.cc:2362(row_merge_read_clustered_index(trx_t*, TABLE*, dict_table_t const*, dict_table_t*, bool, dict_index_t**, dict_index_t*, fts_psort_t*, merge_file_t*, unsigned long const*, unsigned long, dtuple_t const*, dict_add_v_col_t const*, unsigned long const*, unsigned long, ib_sequence_t&, unsigned char*, bool, pfs_os_file_t*, ut_stage_alter_t*, double, unsigned char*, TABLE*, bool))[0x559f4cae6feb]
|
row/row0merge.cc:4720(row_merge_build_indexes(trx_t*, dict_table_t*, dict_table_t*, bool, dict_index_t**, unsigned long const*, unsigned long, TABLE*, dtuple_t const*, unsigned long const*, unsigned long, ib_sequence_t&, bool, ut_stage_alter_t*, dict_add_v_col_t const*, TABLE*, bool))[0x559f4ca40330]
|
handler/handler0alter.cc:8386(ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*))[0x559f4c5838dd]
|
sql/sql_table.cc:7731(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*) [clone .isra.261])[0x559f4c70e2f9]
|
sql/sql_table.cc:10098(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))[0x559f4c75d4ce]
|
sql/sql_alter.cc:508(Sql_cmd_alter_table::execute(THD*))[0x559f4c6800d1]
|
sql/sql_parse.cc:6099(mysql_execute_command(THD*))[0x559f4c685e11]
|
sql/sql_parse.cc:10314(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x559f4c68756b]
|
sql/sql_lex.h:4700(Parser_state::reset(char*, unsigned int))[0x559f4c688d51]
|
sql/sql_parse.cc:1360(do_command(THD*))[0x559f4c7589e2]
|
sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x559f4c758ac4]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd8acb236ba]
|
x86_64/clone.S:111(clone)[0x7fd8ab98841d]
|
|
Query (0x7fd83c031200): ALTER TABLE `test` CONVERT TO CHARACTER SET utf8mb4
|
|
10.4 aab6cefe8dc132ec6a1
|
|
#5 0x00007f3239ccc02a in __GI_abort () at abort.c:89
|
#6 0x00007f3239cc2bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x56473aa92f30 "!mbmaxlen || !(prefix_len % mbmaxlen)", file=file@entry=0x56473aa92ee0 "/10.4/storage/innobase/data/data0type.cc", line=line@entry=64, function=function@entry=0x56473aa93180 <dtype_get_at_most_n_mbchars(unsigned long, unsigned long, unsigned long, unsigned long, unsigned long, char const*)::__PRETTY_FUNCTION__> "ulint dtype_get_at_most_n_mbchars(ulint, ulint, ulint, ulint, ulint, const char*)") at assert.c:92
|
#7 0x00007f3239cc2c82 in __GI___assert_fail (assertion=0x56473aa92f30 "!mbmaxlen || !(prefix_len % mbmaxlen)", file=0x56473aa92ee0 "/10.4/storage/innobase/data/data0type.cc", line=64, function=0x56473aa93180 <dtype_get_at_most_n_mbchars(unsigned long, unsigned long, unsigned long, unsigned long, unsigned long, char const*)::__PRETTY_FUNCTION__> "ulint dtype_get_at_most_n_mbchars(ulint, ulint, ulint, ulint, ulint, const char*)") at assert.c:101
|
#8 0x000056473a4a6613 in dtype_get_at_most_n_mbchars (prtype=2166799, mbminlen=1, mbmaxlen=3, prefix_len=764, data_len=10, str=0x7f322e98809d "first_nameZone") at /10.4/storage/innobase/data/data0type.cc:64
|
#9 0x000056473a2e60bd in row_merge_buf_add (buf=0x7f31e4078c98, fts_index=0x0, old_table=0x7f31e419e9b8, new_table=0x7f31e419e9b8, psort_info=0x0, row=0x7f31e43c2f60, ext=0x0, doc_id=0x7f322e207ad0, conv_heap=0x0, err=0x7f322e207aa4, v_heap=0x7f322e207ac8, my_table=0x7f322e209680, trx=0x7f322ec5a140) at /10.4/storage/innobase/row/row0merge.cc:743
|
#10 0x000056473a2ed007 in row_merge_read_clustered_index (trx=0x7f322ec5a140, table=0x7f322e209680, old_table=0x7f31e419e9b8, new_table=0x7f31e419e9b8, online=true, index=0x7f31e4078308, fts_sort_idx=0x0, psort_info=0x0, files=0x7f31e40bd020, key_numbers=0x7f31e4078310, n_index=1, defaults=0x0, add_v=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., block=0x7f32242f4000 <error: Cannot access memory at address 0x7f32242f4000>, skip_pk_sort=false, tmpfd=0x7f322e208780, stage=0x7f31e4078bb0, pct_cost=50, crypt_block=0x0, eval_table=0x7f322e209680, allow_not_null=false) at /10.4/storage/innobase/row/row0merge.cc:2362
|
#11 0x000056473a2f4860 in row_merge_build_indexes (trx=0x7f322ec5a140, old_table=0x7f31e419e9b8, new_table=0x7f31e419e9b8, online=true, indexes=0x7f31e4078308, key_numbers=0x7f31e4078310, n_indexes=1, table=0x7f322e209680, defaults=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=false, stage=0x7f31e4078bb0, add_v=0x0, eval_table=0x7f322e209680, allow_not_null=false) at /10.4/storage/innobase/row/row0merge.cc:4718
|
#12 0x000056473a1a8550 in ha_innobase::inplace_alter_table (this=0x7f31e418a0e8, altered_table=0x7f322e209680, ha_alter_info=0x7f322e2095f0) at /10.4/storage/innobase/handler/handler0alter.cc:8352
|
#13 0x0000564739b6056f in handler::ha_inplace_alter_table (this=0x7f31e418a0e8, altered_table=0x7f322e209680, ha_alter_info=0x7f322e2095f0) at /10.4/sql/handler.h:4361
|
#14 0x0000564739b547aa in mysql_inplace_alter_table (thd=0x7f31e4000af0, table_list=0x7f31e4013280, table=0x7f31e400ade0, altered_table=0x7f322e209680, ha_alter_info=0x7f322e2095f0, inplace_supported=HA_ALTER_INPLACE_NOCOPY_NO_LOCK, target_mdl_request=0x7f322e20a450, alter_ctx=0x7f322e20af80) at /10.4/sql/sql_table.cc:7704
|
#15 0x0000564739b5b4a2 in mysql_alter_table (thd=0x7f31e4000af0, new_db=0x7f31e40052b8, new_name=0x7f31e40056c0, create_info=0x7f322e20bb70, table_list=0x7f31e4013280, alter_info=0x7f322e20bab0, order_num=0, order=0x0, ignore=false) at /10.4/sql/sql_table.cc:10069
|
#16 0x0000564739bf3e5d in Sql_cmd_alter_table::execute (this=0x7f31e4013950, thd=0x7f31e4000af0) at /10.4/sql/sql_alter.cc:508
|
#17 0x0000564739a7195a in mysql_execute_command (thd=0x7f31e4000af0) at /10.4/sql/sql_parse.cc:6102
|
#18 0x0000564739a77049 in mysql_parse (thd=0x7f31e4000af0, rawbuf=0x7f31e4013158 "ALTER TABLE `test` CONVERT TO CHARACTER SET utf8mb4", length=51, parser_state=0x7f322e20cfe0, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:7901
|
#19 0x0000564739a621f6 in dispatch_command (command=COM_QUERY, thd=0x7f31e4000af0, packet=0x7f31e41361a1 "ALTER TABLE `test` CONVERT TO CHARACTER SET utf8mb4", packet_length=51, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1842
|
#20 0x0000564739a60857 in do_command (thd=0x7f31e4000af0) at /10.4/sql/sql_parse.cc:1360
|
#21 0x0000564739bea621 in do_handle_one_connection (connect=0x56473d65b890) at /10.4/sql/sql_connect.cc:1412
|
#22 0x0000564739bea34a in handle_one_connection (arg=0x56473d65b890) at /10.4/sql/sql_connect.cc:1316
|
#23 0x000056473a5ef8d3 in pfs_spawn_thread (arg=0x56473d5d95a0) at /10.4/storage/perfschema/pfs.cc:1862
|
#24 0x00007f323b1b96ba in start_thread (arg=0x7f322e20e700) at pthread_create.c:333
|
#25 0x00007f3239d9c41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|