[MDEV-21214] Crash with ALTER TABLE .. CONVERT TO CHARACTER SET utf8mb4 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Duplicate
Affects Version/s: 10.4.10, 10.4(EOL)
Fix Version/s: N/A
Component/s: N/A
Labels:
None

Description

CREATE TABLE `test` (

  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,

  `meta_key` varchar(255) DEFAULT NULL,

  `meta_value` longtext DEFAULT NULL,

  PRIMARY KEY (`umeta_id`),

  KEY `user_id` (`user_id`),

  KEY `meta_key` (`meta_key`(191))

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `test` VALUES (1,1,'first_name','Zone');

ALTER TABLE `test` CONVERT TO CHARACTER SET utf8mb4;

ERROR 2013 (HY000): Lost connection to MySQL server during query

Log:

Dec  4 11:31:33 uvn-234-24 mysqld: Version: '10.4.10-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

Dec  4 11:31:33 uvn-234-24 systemd: Started MariaDB 10.4.10 database server.

Dec  4 11:31:36 uvn-234-24 mysqld: 2019-12-04 11:31:36 0x7fe158b7e700  InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.10/storage/innobase/data/data0type.cc line 67

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: Failing assertion: !(prefix_len % mbmaxlen)

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: We intentionally generate a memory trap.

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: If you get repeated assertion failures or crashes, even

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: immediately after the mysqld startup, there may be

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/

Dec  4 11:31:36 uvn-234-24 mysqld: InnoDB: about forcing recovery.

Dec  4 11:31:36 uvn-234-24 mysqld: 191204 11:31:36 [ERROR] mysqld got signal 6 ;

Dec  4 11:31:36 uvn-234-24 mysqld: This could be because you hit a bug. It is also possible that this binary

Dec  4 11:31:36 uvn-234-24 mysqld: or one of the libraries it was linked against is corrupt, improperly built,

Dec  4 11:31:36 uvn-234-24 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.

Dec  4 11:31:36 uvn-234-24 mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Dec  4 11:31:36 uvn-234-24 mysqld: We will try our best to scrape up some info that will hopefully help

Dec  4 11:31:36 uvn-234-24 mysqld: diagnose the problem, but since we have already crashed,

Dec  4 11:31:36 uvn-234-24 mysqld: something is definitely wrong and this may fail.

Dec  4 11:31:36 uvn-234-24 mysqld: Server version: 10.4.10-MariaDB

Dec  4 11:31:36 uvn-234-24 mysqld: key_buffer_size=134217728

Dec  4 11:31:36 uvn-234-24 mysqld: read_buffer_size=131072

Dec  4 11:31:36 uvn-234-24 mysqld: max_used_connections=1

Dec  4 11:31:36 uvn-234-24 mysqld: max_threads=153

Dec  4 11:31:36 uvn-234-24 mysqld: thread_count=7

Dec  4 11:31:36 uvn-234-24 mysqld: It is possible that mysqld could use up to

Dec  4 11:31:36 uvn-234-24 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467738 K  bytes of memory

Dec  4 11:31:36 uvn-234-24 mysqld: Hope that's ok; if not, decrease some variables in the equation.

Dec  4 11:31:36 uvn-234-24 mysqld: Thread pointer: 0x7fe173d087c8

Dec  4 11:31:36 uvn-234-24 mysqld: Attempting backtrace. You can use the following information to find out

Dec  4 11:31:36 uvn-234-24 mysqld: where mysqld died. If you see no messages after this, something went

Dec  4 11:31:36 uvn-234-24 mysqld: terribly wrong...

Dec  4 11:31:36 uvn-234-24 mysqld: stack_bottom = 0x7fe158b7dcf0 thread_stack 0x49000

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fe171ecff2e]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x7fe1719663af]

Dec  4 11:31:36 uvn-234-24 mysqld: sigaction.c:0(__restore_rt)[0x7fe170c8e5d0]

Dec  4 11:31:36 uvn-234-24 mysqld: :0(__GI_raise)[0x7fe16ef612c7]

Dec  4 11:31:36 uvn-234-24 mysqld: :0(__GI_abort)[0x7fe16ef629b8]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(+0x5a1f92)[0x7fe171660f92]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(+0xbfdc4c)[0x7fe171cbcc4c]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(+0xb0aef0)[0x7fe171bc9ef0]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(+0xb1085e)[0x7fe171bcf85e]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(+0xb13857)[0x7fe171bd2857]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(+0xa6a620)[0x7fe171b29620]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderb+0x3228)[0x7fe1717ef9d8]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3ff)[0x7fe17184519f]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x19c8)[0x7fe171759098]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x24b)[0x7fe171760aeb]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1b5e)[0x7fe1717638ee]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x7fe17176507c]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1fa)[0x7fe171840afa]

Dec  4 11:31:36 uvn-234-24 mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x7fe171840bdd]

Dec  4 11:31:36 uvn-234-24 mysqld: pthread_create.c:0(start_thread)[0x7fe170c86dd5]

Dec  4 11:31:36 uvn-234-24 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7fe16f02902d]

Dec  4 11:31:36 uvn-234-24 mysqld: Trying to get some variables.

Dec  4 11:31:36 uvn-234-24 mysqld: Some pointers may be invalid and cause the dump to abort.

Dec  4 11:31:36 uvn-234-24 mysqld: Query (0x7fe173d16a90): ALTER TABLE `test` CONVERT TO CHARACTER SET utf8mb4

Dec  4 11:31:36 uvn-234-24 mysqld: Connection ID (thread ID): 8

Dec  4 11:31:36 uvn-234-24 mysqld: Status: NOT_KILLED

Dec  4 11:31:36 uvn-234-24 mysqld: 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

Dec  4 11:31:36 uvn-234-24 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

Dec  4 11:31:36 uvn-234-24 mysqld: information that should help you find out what is causing the crash.

Dec  4 11:31:36 uvn-234-24 mysqld: Writing a core file...

Dec  4 11:31:36 uvn-234-24 mysqld: Working directory at /var/lib/mysql

Dec  4 11:31:36 uvn-234-24 mysqld: Resource Limits:

Dec  4 11:31:36 uvn-234-24 mysqld: Limit                     Soft Limit           Hard Limit           Units

Dec  4 11:31:36 uvn-234-24 mysqld: Max cpu time              unlimited            unlimited            seconds

Dec  4 11:31:36 uvn-234-24 mysqld: Max file size             unlimited            unlimited            bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max data size             unlimited            unlimited            bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max stack size            8388608              unlimited            bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max core file size        0                    unlimited            bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max resident set          unlimited            unlimited            bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max processes             3882                 3882                 processes

Dec  4 11:31:36 uvn-234-24 mysqld: Max open files            16364                16364                files

Dec  4 11:31:36 uvn-234-24 mysqld: Max locked memory         65536                65536                bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max address space         unlimited            unlimited            bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max file locks            unlimited            unlimited            locks

Dec  4 11:31:36 uvn-234-24 mysqld: Max pending signals       3882                 3882                 signals

Dec  4 11:31:36 uvn-234-24 mysqld: Max msgqueue size         819200               819200               bytes

Dec  4 11:31:36 uvn-234-24 mysqld: Max nice priority         0                    0

Dec  4 11:31:36 uvn-234-24 mysqld: Max realtime priority     0                    0

Dec  4 11:31:36 uvn-234-24 mysqld: Max realtime timeout      unlimited            unlimited            us

Dec  4 11:31:36 uvn-234-24 mysqld: Core pattern: core

Dec  4 11:31:37 uvn-234-24 systemd: mariadb.service: main process exited, code=killed, status=6/ABRT

Dec  4 11:31:37 uvn-234-24 systemd: Unit mariadb.service entered failed state.

Dec  4 11:31:37 uvn-234-24 systemd: mariadb.service failed.

Dec  4 11:31:42 uvn-234-24 systemd: mariadb.service holdoff time over, scheduling restart.

Dec  4 11:31:42 uvn-234-24 systemd: Stopped MariaDB 10.4.10 database server.

Attachments

Issue Links

duplicates

MDEV-20726 InnoDB: Assertion failure in file data0type.cc line 67

Closed

Activity

Ascending order - Click to sort in descending order

Alice Sherepa added a comment - 2019-12-04 12:46

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

Alice Sherepa added a comment - 2019-12-04 12:46 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

Silver Asu added a comment - 2019-12-04 12:53

Can we add more pririty for this? This is default Wordpress query while wordpress upgrades itself.

Silver Asu added a comment - 2019-12-04 12:53 Can we add more pririty for this? This is default Wordpress query while wordpress upgrades itself.

People

Assignee:: Unassigned

Reporter:: Silver Asu

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2019-12-04 09:33

Updated:: 2019-12-10 12:58

Resolved:: 2019-12-04 12:47

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.