Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
10.3 f3ff45f9 |
mysqld: /data/src/10.3/storage/innobase/row/row0merge.cc:2211: dberr_t row_merge_read_clustered_index(trx_t*, TABLE*, const dict_table_t*, dict_table_t*, bool, dict_index_t**, dict_index_t*, fts_psort_t*, merge_file_t*, const ulint*, ulint, const dtuple_t*, const dict_add_v_col_t*, const ulint*, ulint, ib_sequence_t&, row_merge_block_t*, bool, pfs_os_file_t*, ut_stage_alter_t*, double, row_merge_block_t*, TABLE*, bool): Assertion `row->fields[new_trx_id_col].type.mtype == 8' failed.
|
190329 17:20:18 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fd005ae7ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000056076f57e64d in row_merge_read_clustered_index (trx=0x7fcff01851c8, table=0x7fcf9803d6a0, old_table=0x7fcf98035d18, new_table=0x7fcf98051ff8, online=true, index=0x7fcf98051368, fts_sort_idx=0x0, psort_info=0x0, files=0x7fcf98057a80, key_numbers=0x7fcf98051390, n_index=5, defaults=0x0, add_v=0x0, col_map=0x7fcf98052c98, add_autoinc=18446744073709551615, sequence=..., block=0x7fcfd82dc000 <error: Cannot access memory at address 0x7fcfd82dc000>, skip_pk_sort=true, tmpfd=0x7fd0042b3730, stage=0x7fcf98054970, pct_cost=16.666666666666668, crypt_block=0x0, eval_table=0x7fcf9803d6a0, allow_not_null=false) at /data/src/10.3/storage/innobase/row/row0merge.cc:2211
|
#9 0x000056076f585d70 in row_merge_build_indexes (trx=0x7fcff01851c8, old_table=0x7fcf98035d18, new_table=0x7fcf98051ff8, online=true, indexes=0x7fcf98051368, key_numbers=0x7fcf98051390, n_indexes=5, table=0x7fcf9803d6a0, defaults=0x0, col_map=0x7fcf98052c98, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7fcf98054970, add_v=0x0, eval_table=0x7fcf9803d6a0, allow_not_null=false) at /data/src/10.3/storage/innobase/row/row0merge.cc:4749
|
#10 0x000056076f478590 in ha_innobase::inplace_alter_table (this=0x7fcf98023848, altered_table=0x7fcf9803d6a0, ha_alter_info=0x7fd0042b4570) at /data/src/10.3/storage/innobase/handler/handler0alter.cc:7251
|
#11 0x000056076eefdaed in handler::ha_inplace_alter_table (this=0x7fcf98023848, altered_table=0x7fcf9803d6a0, ha_alter_info=0x7fd0042b4570) at /data/src/10.3/sql/handler.h:4192
|
#12 0x000056076eef3291 in mysql_inplace_alter_table (thd=0x7fcf98000b00, table_list=0x7fcf980138f8, table=0x7fcf980227a0, altered_table=0x7fcf9803d6a0, ha_alter_info=0x7fd0042b4570, inplace_supported=HA_ALTER_INPLACE_COPY_NO_LOCK, target_mdl_request=0x7fd0042b4760, alter_ctx=0x7fd0042b4ec0) at /data/src/10.3/sql/sql_table.cc:7547
|
#13 0x000056076eef9639 in mysql_alter_table (thd=0x7fcf98000b00, new_db=0x56076f985970 <null_clex_str>, new_name=0x56076f985970 <null_clex_str>, create_info=0x7fd0042b5aa0, table_list=0x7fcf980138f8, alter_info=0x7fd0042b59e0, order_num=0, order=0x0, ignore=false) at /data/src/10.3/sql/sql_table.cc:9758
|
#14 0x000056076eefc788 in mysql_recreate_table (thd=0x7fcf98000b00, table_list=0x7fcf980138f8, table_copy=false) at /data/src/10.3/sql/sql_table.cc:10632
|
#15 0x000056076ef8a4be in admin_recreate_table (thd=0x7fcf98000b00, table_list=0x7fcf980138f8) at /data/src/10.3/sql/sql_admin.cc:59
|
#16 0x000056076ef8d7c2 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7fcf98000b00, tables=0x7fcf980138f8, check_opt=0x7fcf98005940, operator_name=0x56076f9c7200 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x56076f11e5e0 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.3/sql/sql_admin.cc:1025
|
#17 0x000056076ef8eb2b in Sql_cmd_optimize_table::execute (this=0x7fcf98013f40, thd=0x7fcf98000b00) at /data/src/10.3/sql/sql_admin.cc:1371
|
#18 0x000056076ee22510 in mysql_execute_command (thd=0x7fcf98000b00) at /data/src/10.3/sql/sql_parse.cc:6285
|
#19 0x000056076ee275b5 in mysql_parse (thd=0x7fcf98000b00, rawbuf=0x7fcf98013818 "OPTIMIZE TABLE test.t7", length=22, parser_state=0x7fd0042b7640, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091
|
#20 0x000056076ee14884 in dispatch_command (command=COM_QUERY, thd=0x7fcf98000b00, packet=0x7fcf9801ba41 "", packet_length=22, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1857
|
#21 0x000056076ee1326e in do_command (thd=0x7fcf98000b00) at /data/src/10.3/sql/sql_parse.cc:1403
|
#22 0x000056076ef7bdf5 in do_handle_one_connection (connect=0x5607721efcb0) at /data/src/10.3/sql/sql_connect.cc:1402
|
#23 0x000056076ef7bb79 in handle_one_connection (arg=0x5607721efcb0) at /data/src/10.3/sql/sql_connect.cc:1308
|
#24 0x00007fd0079d6494 in start_thread (arg=0x7fd0042b8700) at pthread_create.c:333
|
#25 0x00007fd005ba493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
10.2 8fcd9478 |
mysqld: /data/src/10.2/storage/innobase/row/row0merge.cc:721: ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, const dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, trx_t*): Assertion `!(col->prtype & 256U)' failed.
|
190329 17:31:42 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f503cba6ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005594c7a2f6e3 in row_merge_buf_add (buf=0x7f4fd40545d8, fts_index=0x0, old_table=0x7f4fd4033438, new_table=0x7f4fd404f538, psort_info=0x0, row=0x7f4fd44ef4c0, ext=0x0, doc_id=0x7f503c0f9490, conv_heap=0x0, err=0x7f503c0f946c, v_heap=0x7f503c0f9488, my_table=0x7f4fd403b130, trx=0x7f50273fe278) at /data/src/10.2/storage/innobase/row/row0merge.cc:721
|
#9 0x00005594c7a341da in row_merge_read_clustered_index (trx=0x7f50273fe278, table=0x7f4fd403b130, old_table=0x7f4fd4033438, new_table=0x7f4fd404f538, online=true, index=0x7f4fd404ead8, fts_sort_idx=0x0, psort_info=0x0, files=0x7f4fd4053990, key_numbers=0x7f4fd404eb00, n_index=5, add_cols=0x0, add_v=0x0, col_map=0x7f4fd404ff80, add_autoinc=18446744073709551615, sequence=..., block=0x7f501049d000 <error: Cannot access memory at address 0x7f501049d000>, skip_pk_sort=true, tmpfd=0x7f503c0f9f38, stage=0x7f4fd40528b0, pct_cost=16.666666666666668, crypt_block=0x0, eval_table=0x7f4fd403b130) at /data/src/10.2/storage/innobase/row/row0merge.cc:2240
|
#10 0x00005594c7a3a89f in row_merge_build_indexes (trx=0x7f50273fe278, old_table=0x7f4fd4033438, new_table=0x7f4fd404f538, online=true, indexes=0x7f4fd404ead8, key_numbers=0x7f4fd404eb00, n_indexes=5, table=0x7f4fd403b130, add_cols=0x0, col_map=0x7f4fd404ff80, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7f4fd40528b0, add_v=0x0, eval_table=0x7f4fd403b130) at /data/src/10.2/storage/innobase/row/row0merge.cc:4700
|
#11 0x00005594c7943d9d in ha_innobase::inplace_alter_table (this=0x7f4fd4020f78, altered_table=0x7f4fd403b130, ha_alter_info=0x7f503c0fa7b0) at /data/src/10.2/storage/innobase/handler/handler0alter.cc:6491
|
#12 0x00005594c7450b81 in handler::ha_inplace_alter_table (this=0x7f4fd4020f78, altered_table=0x7f4fd403b130, ha_alter_info=0x7f503c0fa7b0) at /data/src/10.2/sql/handler.h:3795
|
#13 0x00005594c74472ea in mysql_inplace_alter_table (thd=0x7f4fd4000b00, table_list=0x7f4fd4011068, table=0x7f4fd401ff10, altered_table=0x7f4fd403b130, ha_alter_info=0x7f503c0fa7b0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f503c0fa8e0, alter_ctx=0x7f503c0fb040) at /data/src/10.2/sql/sql_table.cc:7362
|
#14 0x00005594c744cc39 in mysql_alter_table (thd=0x7f4fd4000b00, new_db=0x0, new_name=0x0, create_info=0x7f503c0fbc40, table_list=0x7f4fd4011068, alter_info=0x7f503c0fbb90, order_num=0, order=0x0, ignore=false) at /data/src/10.2/sql/sql_table.cc:9452
|
#15 0x00005594c744f80f in mysql_recreate_table (thd=0x7f4fd4000b00, table_list=0x7f4fd4011068, table_copy=false) at /data/src/10.2/sql/sql_table.cc:10277
|
#16 0x00005594c74d30bd in admin_recreate_table (thd=0x7f4fd4000b00, table_list=0x7f4fd4011068) at /data/src/10.2/sql/sql_admin.cc:58
|
#17 0x00005594c74d6357 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f4fd4000b00, tables=0x7f4fd4011068, check_opt=0x7f4fd4005608, operator_name=0x5594c7e42108 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5594c75fb950 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.2/sql/sql_admin.cc:1022
|
#18 0x00005594c74d7699 in Sql_cmd_optimize_table::execute (this=0x7f4fd4011678, thd=0x7f4fd4000b00) at /data/src/10.2/sql/sql_admin.cc:1366
|
#19 0x00005594c737e550 in mysql_execute_command (thd=0x7f4fd4000b00) at /data/src/10.2/sql/sql_parse.cc:6226
|
#20 0x00005594c73833a1 in mysql_parse (thd=0x7f4fd4000b00, rawbuf=0x7f4fd4010f88 "OPTIMIZE TABLE test.t7", length=22, parser_state=0x7f503c0fd250, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8013
|
#21 0x00005594c7370e9e in dispatch_command (command=COM_QUERY, thd=0x7f4fd4000b00, packet=0x7f4fd40191b1 "", packet_length=22, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1832
|
#22 0x00005594c736f7bb in do_command (thd=0x7f4fd4000b00) at /data/src/10.2/sql/sql_parse.cc:1386
|
#23 0x00005594c74c2f69 in do_handle_one_connection (connect=0x5594ca334340) at /data/src/10.2/sql/sql_connect.cc:1335
|
#24 0x00005594c74c2cf6 in handle_one_connection (arg=0x5594ca334340) at /data/src/10.2/sql/sql_connect.cc:1241
|
#25 0x00007f503ea95494 in start_thread (arg=0x7f503c0fe700) at pthread_create.c:333
|
#26 0x00007f503cc6393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
10.4 a5ac029f |
mysqld: /data/src/10.4/storage/innobase/include/data0data.ic:433: dfield_t* dtuple_get_nth_field(const dtuple_t*, ulint): Assertion `n < tuple->n_fields' failed.
|
190329 17:33:46 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fe5baf05ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000555c06dfb139 in dtuple_get_nth_field (tuple=0x7fe54c4f9ed0, n=11936128518282651045) at /data/src/10.4/storage/innobase/include/data0data.ic:433
|
#9 0x0000555c06dffaac in row_build_low (type=2, index=0x7fe54c037dd8, rec=0x7fe5993163b9 "\200", offsets=0x7fe54c4f9df8, col_table=0x7fe54c052e88, defaults=0x0, add_v=0x0, col_map=0x7fe54c053aa8, ext=0x7fe5a5842b50, heap=0x7fe54c4f9d70) at /data/src/10.4/storage/innobase/row/row0row.cc:555
|
#10 0x0000555c06dffdd0 in row_build_w_add_vcol (type=2, index=0x7fe54c037dd8, rec=0x7fe5993163b9 "\200", offsets=0x7fe54c4f9df8, col_table=0x7fe54c052e88, defaults=0x0, add_v=0x0, col_map=0x7fe54c053aa8, ext=0x7fe5a5842b50, heap=0x7fe54c4f9d70) at /data/src/10.4/storage/innobase/row/row0row.cc:696
|
#11 0x0000555c06dc1daf in row_merge_read_clustered_index (trx=0x7fe5a58df268, table=0x7fe54c03e470, old_table=0x7fe54c036858, new_table=0x7fe54c052e88, online=true, index=0x7fe54c0521d8, fts_sort_idx=0x0, psort_info=0x0, files=0x7fe54c0552d0, key_numbers=0x7fe54c052200, n_index=5, defaults=0x0, add_v=0x0, col_map=0x7fe54c053aa8, add_autoinc=18446744073709551615, sequence=..., block=0x7fe5a54ff000 <error: Cannot access memory at address 0x7fe5a54ff000>, skip_pk_sort=true, tmpfd=0x7fe5a5843780, stage=0x7fe54c054be0, pct_cost=16.666666666666668, crypt_block=0x0, eval_table=0x7fe54c03e470, allow_not_null=false) at /data/src/10.4/storage/innobase/row/row0merge.cc:2173
|
#12 0x0000555c06dc9750 in row_merge_build_indexes (trx=0x7fe5a58df268, old_table=0x7fe54c036858, new_table=0x7fe54c052e88, online=true, indexes=0x7fe54c0521d8, key_numbers=0x7fe54c052200, n_indexes=5, table=0x7fe54c03e470, defaults=0x0, col_map=0x7fe54c053aa8, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7fe54c054be0, add_v=0x0, eval_table=0x7fe54c03e470, allow_not_null=false) at /data/src/10.4/storage/innobase/row/row0merge.cc:4748
|
#13 0x0000555c06cafe88 in ha_innobase::inplace_alter_table (this=0x7fe54c024378, altered_table=0x7fe54c03e470, ha_alter_info=0x7fe5a5844620) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:8335
|
#14 0x0000555c066d45df in handler::ha_inplace_alter_table (this=0x7fe54c024378, altered_table=0x7fe54c03e470, ha_alter_info=0x7fe5a5844620) at /data/src/10.4/sql/handler.h:4320
|
#15 0x0000555c066c95bf in mysql_inplace_alter_table (thd=0x7fe54c000b00, table_list=0x7fe54c0141f8, table=0x7fe54c0230b0, altered_table=0x7fe54c03e470, ha_alter_info=0x7fe5a5844620, inplace_supported=HA_ALTER_INPLACE_COPY_NO_LOCK, target_mdl_request=0x7fe5a5844810, alter_ctx=0x7fe5a5844f70) at /data/src/10.4/sql/sql_table.cc:7646
|
#16 0x0000555c066cfeac in mysql_alter_table (thd=0x7fe54c000b00, new_db=0x555c071ee580 <null_clex_str>, new_name=0x555c071ee580 <null_clex_str>, create_info=0x7fe5a5845b50, table_list=0x7fe54c0141f8, alter_info=0x7fe5a5845a90, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9934
|
#17 0x0000555c066d3043 in mysql_recreate_table (thd=0x7fe54c000b00, table_list=0x7fe54c0141f8, table_copy=false) at /data/src/10.4/sql/sql_table.cc:10818
|
#18 0x0000555c0676abc1 in admin_recreate_table (thd=0x7fe54c000b00, table_list=0x7fe54c0141f8) at /data/src/10.4/sql/sql_admin.cc:59
|
#19 0x0000555c0676dec7 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7fe54c000b00, tables=0x7fe54c0141f8, check_opt=0x7fe54c005ca8, operator_name=0x555c07237910 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x555c06935d14 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.4/sql/sql_admin.cc:1025
|
#20 0x0000555c0676f2ce in Sql_cmd_optimize_table::execute (this=0x7fe54c0148a0, thd=0x7fe54c000b00) at /data/src/10.4/sql/sql_admin.cc:1373
|
#21 0x0000555c065ef49e in mysql_execute_command (thd=0x7fe54c000b00) at /data/src/10.4/sql/sql_parse.cc:6344
|
#22 0x0000555c065f4642 in mysql_parse (thd=0x7fe54c000b00, rawbuf=0x7fe54c014128 "OPTIMIZE TABLE test.t7", length=22, parser_state=0x7fe5a58471d0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8154
|
#23 0x0000555c065dfdd2 in dispatch_command (command=COM_QUERY, thd=0x7fe54c000b00, packet=0x7fe54c01c351 "", packet_length=22, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1832
|
#24 0x0000555c065de5b8 in do_command (thd=0x7fe54c000b00) at /data/src/10.4/sql/sql_parse.cc:1365
|
#25 0x0000555c067583d5 in do_handle_one_connection (connect=0x555c09ec7730) at /data/src/10.4/sql/sql_connect.cc:1398
|
#26 0x0000555c06758146 in handle_one_connection (arg=0x555c09ec7730) at /data/src/10.4/sql/sql_connect.cc:1301
|
#27 0x00007fe5bcdf4494 in start_thread (arg=0x7fe5a5848700) at pthread_create.c:333
|
#28 0x00007fe5bafc293f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
To reproduce:
- download ftp://perro.askmonty.org/public/jira/mdev19085.tar.gz;
- extract (it creates the data folder);
- start the new server on it with
--innodb-compression-algorithm=zlib --innodb_log_compressed_pages=on
- run
CHECK TABLE test.t7 EXTENDED;
OPTIMIZE TABLE test.t7
The data directory was created on the latest 10.1 release, the server was shut down normally.
Attachments
Issue Links
- relates to
-
MDEV-19027 create_table_def fails when virtual column is present between stored columns
- Closed
-
MDEV-19066 AddressSanitizer: use-after-poison in innobase_build_col_map after upgrade from 10.1
- Closed