Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.4(EOL), 10.5
-
None
Description
Test case from MDEV-20726 is still failing:
--source include/have_innodb.inc
|
|
CREATE TABLE `ratings_copy` ( |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`ctime` timestamp NOT NULL DEFAULT current_timestamp(), |
`order_id` int(10) unsigned NOT NULL, |
`client_id` int(10) unsigned DEFAULT NULL, |
`courier_id` int(10) unsigned DEFAULT NULL, |
`dispatcher_id` int(10) unsigned DEFAULT NULL, |
`point_id` int(10) unsigned DEFAULT NULL, |
`problem_id` int(10) unsigned DEFAULT NULL, |
`courier_rating` int(11) DEFAULT NULL COMMENT 'Оценка курьера клиентом', |
`courier_rating_comment` text CHARACTER SET utf8 DEFAULT NULL COMMENT 'Отзыв клиента', |
`actual_rating` int(11) DEFAULT NULL, |
`dispatcher_comment` text CHARACTER SET utf8 DEFAULT NULL COMMENT 'Комментарий диспетчера', |
PRIMARY KEY (`id`), |
UNIQUE KEY `problem_id` (`problem_id`), |
KEY `courier_id` (`courier_id`), |
KEY `order_id` (`order_id`), |
KEY `client_id` (`client_id`), |
KEY `idx_dispatcher_comment_courier_rating` (`dispatcher_comment`(1),`courier_rating`), |
KEY `idx_courier_rating_comment_courier_rating` (`courier_rating_comment`(1),`courier_rating`), |
KEY `idx_courier_rating` (`courier_rating`), |
KEY `courier_client` (`courier_id`,`client_id`), |
KEY `client_id_rating_ctime` (`client_id`,`courier_rating`,`ctime`) |
) ENGINE=InnoDB AUTO_INCREMENT=14807 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Оценка качества услуг клиентом'; |
INSERT INTO `ratings_copy` VALUES (14807,'0000-00-00 00:00:00',0,0,0,0,0,0,0,'\"courier_rating_comment\"',0,'\"dispatcher_comment\"'),(14808,'0000-00-00 00:00:00',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14809,'0000-00-00 00:00:00',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14810,'0000-00-00 00:00:00',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14811,'0000-00-00 00:00:00',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14812,'0000-00-00 00:00:00',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); |
ALTER TABLE `ratings_copy` MODIFY courier_rating_comment text DEFAULT NULL COMMENT 'Отзыв клиента'; |
|
10.4 9bdf35e90f36d9be8cc7591e2ed |
mysqld: /10.4/storage/innobase/dict/dict0dict.cc:1904: dberr_t dict_index_add_to_cache(dict_index_t*&, ulint, const dict_add_v_col_t*): Assertion `field->col->is_binary() || field->prefix_len % field->col->mbmaxlen == 0' failed.
|
200615 16:01:26 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.4.14-MariaDB-debug-log
|
|
linux/raise.c:51(__GI_raise)[0x7fe2df6f17bb]
|
stdlib/abort.c:81(__GI_abort)[0x7fe2df6dc535]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fe2df6dc40f]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7fe2df6ea102]
|
/10.4/sql/mysqld(+0x270c9b7)[0x55cd684c99b7]
|
dict/dict0dict.cc:1906(dict_index_add_to_cache(dict_index_t*&, unsigned long, dict_add_v_col_t const*))[0x55cd684adf41]
|
dict/dict0crea.cc:1249(dict_create_index_step(que_thr_t*))[0x55cd680ce563]
|
que/que0que.cc:1049(que_thr_step(que_thr_t*))[0x55cd680ce949]
|
que/que0que.cc:1101(que_run_threads_low(que_thr_t*))[0x55cd680ced8e]
|
que/que0que.cc:1143(que_run_threads(que_thr_t*))[0x55cd67ed9e1b]
|
handler/handler0alter.cc:6142(create_index_dict(trx_t*, dict_index_t*, dict_add_v_col_t const*))[0x55cd67ee38e0]
|
handler/handler0alter.cc:6968(prepare_inplace_alter_table_dict(Alter_inplace_info*, TABLE const*, TABLE const*, char const*, unsigned long, unsigned long, unsigned long, bool, bool))[0x55cd67eef726]
|
handler/handler0alter.cc:8248(ha_innobase::prepare_inplace_alter_table(TABLE*, Alter_inplace_info*))[0x55cd678ba236]
|
sql/handler.cc:4574(handler::ha_prepare_inplace_alter_table(TABLE*, Alter_inplace_info*))[0x55cd6732d9a0]
|
sql/sql_table.cc:7711(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, MDL_request*, Alter_table_ctx*))[0x55cd6733eb70]
|
sql/sql_table.cc:10151(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))[0x55cd674b7b69]
|
sql/sql_alter.cc:514(Sql_cmd_alter_table::execute(THD*))[0x55cd670e717c]
|
sql/sql_parse.cc:6101(mysql_execute_command(THD*))[0x55cd670f2aa5]
|
sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55cd670ca0f6]
|
sql/sql_parse.cc:1844(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55cd670c6b75]
|
sql/sql_parse.cc:1359(do_command(THD*))[0x55cd6749fca7]
|
sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x55cd6749f549]
|
sql/sql_connect.cc:1317(handle_one_connection)[0x55cd68ac6eb3]
|
nptl/pthread_create.c:487(start_thread)[0x7fe2e01acfa3]
|
x86_64/clone.S:97(clone)[0x7fe2df7b34cf]
|
|
Query (0x62b0000a1290): ALTER TABLE `ratings_copy` MODIFY courier_rating_comment text DEFAULT NULL COMMENT '
|
also on non-debug:
10.4 49ac606a75d2f4d2898d0d56 |
2020-06-15 16:08:32 0x7f56e6eb3700 InnoDB: Assertion failure in file /10.4/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.
|
200615 16:08:32 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.4.14-MariaDB-log
|
|
linux/raise.c:51(__GI_raise)[0x7f56f1d1d7bb]
|
stdlib/abort.c:81(__GI_abort)[0x7f56f1d08535]
|
/10.4/sql/mysqld(+0x59e795)[0x55c94f82a795]
|
ut/ut0rbt.cc:469(rbt_eject_node(ib_rbt_node_t*, ib_rbt_node_t*) [clone .cold.8])[0x55c94f835ea5]
|
data/data0type.cc:95(dtype_validate(dtype_t const*))[0x55c94fd1ef21]
|
include/data0data.ic:58(dfield_set_len)[0x55c94fd26733]
|
row/row0merge.cc:2360(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))[0x55c94fd291d2]
|
include/ut0stage.h:434(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))[0x55c94fc99e5e]
|
handler/handler0alter.cc:8482(ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*))[0x55c94f9ada78]
|
sql/sql_table.cc:7747(mysql_inplace_alter_table)[0x55c94f9fcfb0]
|
sql/sql_alter.cc:514(Sql_cmd_alter_table::execute(THD*))[0x55c94f91a9a9]
|
sql/sql_parse.cc:6101(mysql_execute_command(THD*))[0x55c94f921818]
|
sql/sql_parse.cc:7918(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c94f923a45]
|
sql/sql_parse.cc:1844(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c94f924f81]
|
sql/sql_parse.cc:1359(do_command(THD*))[0x55c94f9f8e34]
|
sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x55c94f9f8f24]
|
sql/sql_connect.cc:1318(handle_one_connection)[0x55c94ff4c45f]
|
nptl/pthread_create.c:487(start_thread)[0x7f56f27d6fa3]
|
x86_64/clone.S:97(clone)[0x7f56f1ddf4cf]
|
|
Query (0x7f5698010020): ALTER TABLE `ratings_copy` MODIFY courier_rating_comment text DEFAULT NULL COMMENT '
|
Attachments
Issue Links
- relates to
-
MDEV-20726 InnoDB: Assertion failure in file data0type.cc line 67
- Closed
-
MDEV-26379 Assertion `field->col->is_binary() || field->prefix_len % field->col->mbmaxlen == 0' failed in dict_index_add_to_cache
- Closed
-
MDEV-22898 SQL query always crashes on INSERT IGNORE
- Closed
-
MDEV-25951 MariaDB crash after ALTER TABLE convert to utf8mb4
- Closed