Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (a INT, b INT NOT NULL) ENGINE=InnoDB; |
INSERT INTO t1 VALUES |
(0,9),(2,7),(3,1),(3,4),(8,4),(3,7),(6,1),(3,8),(1,2),(4,1),(0,8),(5,3),
|
(1,3),(1,6),(2,1),(8,7),(6,0),(1,9),(9,4),(0,6),(9,3),(0,9),(9,4),(2,4),
|
(2,7),(7,8),(8,2),(2,5),(6,1),(4,5),(5,3),(6,8),(4,9),(5,7),(7,5),(5,1),
|
(8,8),(5,7),(3,8),(0,1),(8,4),(8,3),(9,7),(4,8),(1,1),(0,4),(2,6),(8,5),
|
(8,8),(8,7),(6,7),(1,7),(9,6),(3,6),(1,9),(0,3),(5,3),(2,4),(0,6),(2,0),
|
(6,5),(1,6),(2,4),(9,1),(3,0),(6,4),(1,3),(0,8),(3,5),(3,1),(8,9),(9,9),
|
(7,9),(4,5),(2,2),(3,8),(0,8),(7,1),(2,0),(1,5),(7,3),(4,4),(3,9),(7,2),
|
(6,2),(0,4),(2,0),(1,5),(5,7),(4,5),(3,7),(6,0),(2,1),(5,0),(1,0),(2,0),
|
(8,4),(5,7),(3,5),(0,5),(7,6),(5,9),(1,2),(4,2),(8,5),(8,7),(2,8),(1,8),
|
(4,3),(1,6),(7,8),(3,7),(4,6),(1,1),(3,0),(1,6),(2,0),(3,4),(4,8),(3,9),
|
(8,0),(4,9),(4,0),(3,9),(6,4),(7,4),(5,8),(4,7),(7,3),(5,9),(2,3),(7,3),
|
(0,4),(5,9),(9,8),(4,2),(3,6),(2,6),(1,8),(7,0),(0,0),(2,3),(1,2),(3,3),
|
(2,7),(6,0),(9,0),(6,9),(4,6),(9,8),(0,7),(9,1),(9,6),(4,3),(7,7),(7,7),
|
(4,1),(4,7),(7,3),(2,8),(5,8),(8,9),(3,9),(7,7),(0,8),(4,9),(3,2),(5,0),
|
(1,7),(0,3),(2,9),(9,7),(7,5),(6,9),(8,5),(3,6),(1,1),(2,8),(7,9),(4,9),
|
(6,6),(5,9),(5,3),(9,8),(3,3),(5,6),(0,9),(3,9),(7,9),(7,3),(5,2),(1,4),
|
(4,4),(8,2),(2,2),(8,3),(9,1),(4,9),(9,8),(1,8),(1,8),(9,1),(1,1),(3,0),
|
(4,6),(9,3),(3,3),(5,2),(0,1),(3,4),(3,2),(1,3),(4,4),(7,0),(4,6),(7,2),
|
(4,5),(8,7),(7,8),(8,1),(3,5),(0,6),(3,5),(2,1),(4,4),(3,4),(2,1),(4,1);
|
INSERT INTO t1 SELECT * FROM t1; |
ALTER TABLE t1 DROP a; |
|
--source include/restart_mysqld.inc
|
|
DROP TABLE t1; |
10.4 4edb29380c |
mysqld: /data/src/10.4/storage/innobase/rem/rem0rec.cc:615: void rec_init_offsets(const rec_t*, const dict_index_t*, bool, ulint*): Assertion `index->n_core_null_bytes <= ((
|
(index->n_nullable) + 7) / 8)' failed.
|
190118 15:14:24 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f18f24d2ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000564785a7d495 in rec_init_offsets (rec=0x7f18e7c9807e "", index=0x7f18c0014eb8, leaf=false, offsets=0x7f18ce7f9f10) at /data/src/10.4/storage/innobase/rem/rem0rec.cc:615
|
#9 0x0000564785a7e474 in rec_get_offsets_func (rec=0x7f18e7c9807e "", index=0x7f18c0014eb8, offsets=0x7f18ce7f9f10, leaf=false, n_fields=18446744073709551615, file=0x5647861b97d0 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", line=2759, heap=0x7f18ce7f9818) at /data/src/10.4/storage/innobase/rem/rem0rec.cc:927
|
#10 0x0000564785bbfae6 in btr_cur_open_at_index_side_func (from_left=true, index=0x7f18c0014eb8, latch_mode=1, cursor=0x7f18ce7fa300, level=0, file=0x5647861b97d0 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", line=426, mtr=0x7f18ce7fa540) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:2759
|
#11 0x0000564785bb8d7c in btr_cur_instant_init_low (index=0x7f18c0014eb8, mtr=0x7f18ce7fa540) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:425
|
#12 0x0000564785bb9870 in btr_cur_instant_init (table=0x7f18c0013898) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:616
|
#13 0x0000564785c6205a in dict_load_table_one (name=..., cached=true, ignore_err=DICT_ERR_IGNORE_NONE, fk_tables=std::deque with 0 elements) at /data/src/10.4/storage/innobase/dict/dict0load.cc:3014
|
#14 0x0000564785c6116c in dict_load_table (name=0x7f18c000b5b8 "test/t1", cached=true, ignore_err=DICT_ERR_IGNORE_NONE) at /data/src/10.4/storage/innobase/dict/dict0load.cc:2766
|
#15 0x0000564785c62914 in dict_load_table_on_id (table_id=20, ignore_err=DICT_ERR_IGNORE_NONE) at /data/src/10.4/storage/innobase/dict/dict0load.cc:3178
|
#16 0x0000564785c40e0a in dict_table_open_on_id_low (table_id=20, ignore_err=DICT_ERR_IGNORE_NONE, cached_only=false) at /data/src/10.4/storage/innobase/dict/dict0dict.cc:424
|
#17 0x0000564785c424d8 in dict_table_open_on_id (table_id=20, dict_locked=0, table_op=DICT_TABLE_OP_NORMAL) at /data/src/10.4/storage/innobase/dict/dict0dict.cc:1010
|
#18 0x0000564785aef78a in row_purge_parse_undo_rec (node=0x564787da8798, undo_rec=0x7f18b8015808 "", updated_extern=0x7f18ce7fbdce, thr=0x564787da82f0) at /data/src/10.4/storage/innobase/row/row0purge.cc:1080
|
#19 0x0000564785af0105 in row_purge (node=0x564787da8798, undo_rec=0x7f18b8015808 "", thr=0x564787da82f0) at /data/src/10.4/storage/innobase/row/row0purge.cc:1258
|
#20 0x0000564785af03cf in row_purge_step (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/row/row0purge.cc:1347
|
#21 0x0000564785a720b6 in que_thr_step (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/que/que0que.cc:1042
|
#22 0x0000564785a722e9 in que_run_threads_low (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/que/que0que.cc:1104
|
#23 0x0000564785a724da in que_run_threads (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/que/que0que.cc:1144
|
#24 0x0000564785b2fa37 in srv_task_execute () at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2443
|
#25 0x0000564785b2fbed in srv_worker_thread (arg=0x0) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2491
|
#26 0x00007f18f41a9494 in start_thread (arg=0x7f18ce7fc700) at pthread_create.c:333
|
#27 0x00007f18f258f93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible on 10.3.
Attachments
Issue Links
- relates to
-
MDEV-19030 Assertion `index->n_core_null_bytes <= (((index->n_nullable) + 7) / 8) || (! leaf && index->n_core_fields != index->n_fields)' failed in rec_init_offsets
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Fix Version/s | 10.4 [ 22408 ] | |
Assignee | Elena Stepanova [ elenst ] | Marko Mäkelä [ marko ] |
Description |
https://travis-ci.org/elenst/travis-tests/jobs/478606045
{noformat:title=10.4 301bd62b253 ASAN} mysqld: /home/travis/src/storage/innobase/rem/rem0rec.cc:615: void rec_init_offsets(const rec_t*, const dict_index_t*, bool, ulint*): Assertion `index->n_core_null_bytes <= (((index->n_nullable) + 7) / 8)' failed. 190112 7:30:41 [ERROR] mysqld got signal 6 ; /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f6ed63fdc82] /home/travis/server/bin/mysqld(+0x1efa717)[0x562575e36717] rem/rem0rec.cc:616(rec_init_offsets(unsigned char const*, dict_index_t const*, bool, unsigned long*))[0x562575e3854d] rem/rem0rec.cc:929(rec_get_offsets_func(unsigned char const*, dict_index_t const*, unsigned long*, bool, unsigned long, char const*, unsigned int, mem_block_info_t**))[0x562576082f9f] btr/btr0cur.cc:2759(btr_cur_open_at_index_side_func(bool, dict_index_t*, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*))[0x5625760783f0] btr/btr0cur.cc:425(btr_cur_instant_init_low(dict_index_t*, mtr_t*))[0x5625760798af] btr/btr0cur.cc:616(btr_cur_instant_init(dict_table_t*))[0x5625761a4647] dict/dict0load.cc:3014(dict_load_table_one(table_name_t&, bool, dict_err_ignore_t, std::deque<char const*, ut_allocator<char const*, true> >&))[0x5625761a2d69] dict/dict0load.cc:2766(dict_load_table(char const*, bool, dict_err_ignore_t))[0x5625761a52c8] dict/dict0load.cc:3178(dict_load_table_on_id(unsigned long, dict_err_ignore_t))[0x562576167fb9] dict/dict0dict.cc:424(dict_table_open_on_id_low(unsigned long, dict_err_ignore_t, bool))[0x56257616a895] dict/dict0dict.cc:1028(dict_table_open_on_id(unsigned long, unsigned long, dict_table_op_t))[0x562575f0c236] row/row0purge.cc:1079(row_purge_parse_undo_rec(purge_node_t*, unsigned char*, bool*, que_thr_t*))[0x562575f0d71d] row/row0purge.cc:1258(row_purge(purge_node_t*, unsigned char*, que_thr_t*))[0x562575f0df11] row/row0purge.cc:1349(row_purge_step(que_thr_t*))[0x562575e22ca7] que/que0que.cc:1042(que_thr_step(que_thr_t*))[0x562575e230a6] que/que0que.cc:1104(que_run_threads_low(que_thr_t*))[0x562575e233ed] que/que0que.cc:1146(que_run_threads(que_thr_t*))[0x562575f81f87] srv/srv0srv.cc:2443(srv_task_execute())[0x562575f821c1] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f6ed70426ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f6ed64d741d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x0): Connection ID (thread ID): 2 Status: NOT_KILLED 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=off,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 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains {noformat} (no good stack trace available, because it was an ASAN build). {noformat:title=elenst-dev 662a6c5c Toolbox: 72830f51} perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1547278069 --short-column-names --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUpdateDelete --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff --mysqld=--log_output=FILE --mysqld=--max-statement-time=15 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --scenario=Restart {noformat} Not reproducible so far. |
{code:sql}
--source include/have_innodb.inc CREATE TABLE t1 (a INT, b INT NOT NULL) ENGINE=InnoDB; INSERT INTO t1 VALUES (0,9),(2,7),(3,1),(3,4),(8,4),(3,7),(6,1),(3,8),(1,2),(4,1),(0,8),(5,3), (1,3),(1,6),(2,1),(8,7),(6,0),(1,9),(9,4),(0,6),(9,3),(0,9),(9,4),(2,4), (2,7),(7,8),(8,2),(2,5),(6,1),(4,5),(5,3),(6,8),(4,9),(5,7),(7,5),(5,1), (8,8),(5,7),(3,8),(0,1),(8,4),(8,3),(9,7),(4,8),(1,1),(0,4),(2,6),(8,5), (8,8),(8,7),(6,7),(1,7),(9,6),(3,6),(1,9),(0,3),(5,3),(2,4),(0,6),(2,0), (6,5),(1,6),(2,4),(9,1),(3,0),(6,4),(1,3),(0,8),(3,5),(3,1),(8,9),(9,9), (7,9),(4,5),(2,2),(3,8),(0,8),(7,1),(2,0),(1,5),(7,3),(4,4),(3,9),(7,2), (6,2),(0,4),(2,0),(1,5),(5,7),(4,5),(3,7),(6,0),(2,1),(5,0),(1,0),(2,0), (8,4),(5,7),(3,5),(0,5),(7,6),(5,9),(1,2),(4,2),(8,5),(8,7),(2,8),(1,8), (4,3),(1,6),(7,8),(3,7),(4,6),(1,1),(3,0),(1,6),(2,0),(3,4),(4,8),(3,9), (8,0),(4,9),(4,0),(3,9),(6,4),(7,4),(5,8),(4,7),(7,3),(5,9),(2,3),(7,3), (0,4),(5,9),(9,8),(4,2),(3,6),(2,6),(1,8),(7,0),(0,0),(2,3),(1,2),(3,3), (2,7),(6,0),(9,0),(6,9),(4,6),(9,8),(0,7),(9,1),(9,6),(4,3),(7,7),(7,7), (4,1),(4,7),(7,3),(2,8),(5,8),(8,9),(3,9),(7,7),(0,8),(4,9),(3,2),(5,0), (1,7),(0,3),(2,9),(9,7),(7,5),(6,9),(8,5),(3,6),(1,1),(2,8),(7,9),(4,9), (6,6),(5,9),(5,3),(9,8),(3,3),(5,6),(0,9),(3,9),(7,9),(7,3),(5,2),(1,4), (4,4),(8,2),(2,2),(8,3),(9,1),(4,9),(9,8),(1,8),(1,8),(9,1),(1,1),(3,0), (4,6),(9,3),(3,3),(5,2),(0,1),(3,4),(3,2),(1,3),(4,4),(7,0),(4,6),(7,2), (4,5),(8,7),(7,8),(8,1),(3,5),(0,6),(3,5),(2,1),(4,4),(3,4),(2,1),(4,1); INSERT INTO t1 SELECT * FROM t1; ALTER TABLE t1 DROP a; --source include/restart_mysqld.inc DROP TABLE t1; {code} {noformat:title=10.4 4edb29380c} mysqld: /data/src/10.4/storage/innobase/rem/rem0rec.cc:615: void rec_init_offsets(const rec_t*, const dict_index_t*, bool, ulint*): Assertion `index->n_core_null_bytes <= (( (index->n_nullable) + 7) / 8)' failed. 190118 15:14:24 [ERROR] mysqld got signal 6 ; #7 0x00007f18f24d2ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x0000564785a7d495 in rec_init_offsets (rec=0x7f18e7c9807e "", index=0x7f18c0014eb8, leaf=false, offsets=0x7f18ce7f9f10) at /data/src/10.4/storage/innobase/rem/rem0rec.cc:615 #9 0x0000564785a7e474 in rec_get_offsets_func (rec=0x7f18e7c9807e "", index=0x7f18c0014eb8, offsets=0x7f18ce7f9f10, leaf=false, n_fields=18446744073709551615, file=0x5647861b97d0 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", line=2759, heap=0x7f18ce7f9818) at /data/src/10.4/storage/innobase/rem/rem0rec.cc:927 #10 0x0000564785bbfae6 in btr_cur_open_at_index_side_func (from_left=true, index=0x7f18c0014eb8, latch_mode=1, cursor=0x7f18ce7fa300, level=0, file=0x5647861b97d0 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", line=426, mtr=0x7f18ce7fa540) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:2759 #11 0x0000564785bb8d7c in btr_cur_instant_init_low (index=0x7f18c0014eb8, mtr=0x7f18ce7fa540) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:425 #12 0x0000564785bb9870 in btr_cur_instant_init (table=0x7f18c0013898) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:616 #13 0x0000564785c6205a in dict_load_table_one (name=..., cached=true, ignore_err=DICT_ERR_IGNORE_NONE, fk_tables=std::deque with 0 elements) at /data/src/10.4/storage/innobase/dict/dict0load.cc:3014 #14 0x0000564785c6116c in dict_load_table (name=0x7f18c000b5b8 "test/t1", cached=true, ignore_err=DICT_ERR_IGNORE_NONE) at /data/src/10.4/storage/innobase/dict/dict0load.cc:2766 #15 0x0000564785c62914 in dict_load_table_on_id (table_id=20, ignore_err=DICT_ERR_IGNORE_NONE) at /data/src/10.4/storage/innobase/dict/dict0load.cc:3178 #16 0x0000564785c40e0a in dict_table_open_on_id_low (table_id=20, ignore_err=DICT_ERR_IGNORE_NONE, cached_only=false) at /data/src/10.4/storage/innobase/dict/dict0dict.cc:424 #17 0x0000564785c424d8 in dict_table_open_on_id (table_id=20, dict_locked=0, table_op=DICT_TABLE_OP_NORMAL) at /data/src/10.4/storage/innobase/dict/dict0dict.cc:1010 #18 0x0000564785aef78a in row_purge_parse_undo_rec (node=0x564787da8798, undo_rec=0x7f18b8015808 "", updated_extern=0x7f18ce7fbdce, thr=0x564787da82f0) at /data/src/10.4/storage/innobase/row/row0purge.cc:1080 #19 0x0000564785af0105 in row_purge (node=0x564787da8798, undo_rec=0x7f18b8015808 "", thr=0x564787da82f0) at /data/src/10.4/storage/innobase/row/row0purge.cc:1258 #20 0x0000564785af03cf in row_purge_step (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/row/row0purge.cc:1347 #21 0x0000564785a720b6 in que_thr_step (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/que/que0que.cc:1042 #22 0x0000564785a722e9 in que_run_threads_low (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/que/que0que.cc:1104 #23 0x0000564785a724da in que_run_threads (thr=0x564787da82f0) at /data/src/10.4/storage/innobase/que/que0que.cc:1144 #24 0x0000564785b2fa37 in srv_task_execute () at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2443 #25 0x0000564785b2fbed in srv_worker_thread (arg=0x0) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2491 #26 0x00007f18f41a9494 in start_thread (arg=0x7f18ce7fc700) at pthread_create.c:333 #27 0x00007f18f258f93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Not reproducible on 10.3. |
Summary | [Draft] Assertion `index->n_core_null_bytes <= (((index->n_nullable) + 7) / 8)' failed in rec_init_offsets | Assertion `index->n_core_null_bytes <= (((index->n_nullable) + 7) / 8)' failed in rec_init_offsets |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
issue.field.resolutiondate | 2019-02-08 17:27:23.0 | 2019-02-08 17:27:23.681 |
Fix Version/s | 10.4.3 [ 23230 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | Confirmed [ 10101 ] | Closed [ 6 ] |
Link |
This issue relates to |
Workflow | MariaDB v3 [ 91661 ] | MariaDB v4 [ 155499 ] |
New occurrence on 10.4: https://travis-ci.org/elenst/travis-tests/jobs/478904041