Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
Note: the test case is suspiciously similar to MDEV-15878, although the assertion failure, stack trace and non-debug results are different.
CREATE TABLE t1 (f INT) ENGINE=Aria; |
INSERT INTO t1 VALUES (1),(2); |
--error ER_BAD_FIELD_ERROR
|
ALTER TABLE t1 ORDER BY unknown_column; |
CREATE TABLE t2 SELECT * FROM t1; |
|
|
# Cleanup
|
DROP TABLE t1, t2; |
|
10.0 400a8eb60f83 |
mysqld: /data/src/10.0/storage/maria/ma_pagecache.c:3426: pagecache_read: Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed.
|
180416 14:20:35 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f304e33fee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000000000a12f23 in pagecache_read (pagecache=0x202ffc0 <maria_pagecache_var>, file=0x7f3046b5c4a0, pageno=1, level=0, buff=0x7f304694a070 '\245' <repeats 200 times>..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7f305040e5f8) at /data/src/10.0/storage/maria/ma_pagecache.c:3422
|
#9 0x0000000000a4e4cc in _ma_scan_block_record (info=0x7f3046b5c070, record=0x7f3046827a88 "\377", record_pos=0, skip_deleted=1 '\001') at /data/src/10.0/storage/maria/ma_blockrec.c:5462
|
#10 0x0000000000a3c4a5 in maria_scan (info=0x7f3046b5c070, record=0x7f3046827a88 "\377") at /data/src/10.0/storage/maria/ma_scan.c:54
|
#11 0x00000000009ed794 in ha_maria::rnd_next (this=0x7f304687d888, buf=0x7f3046827a88 "\377") at /data/src/10.0/storage/maria/ha_maria.cc:2459
|
#12 0x000000000083f7be in handler::ha_rnd_next (this=0x7f304687d888, buf=0x7f3046827a88 "\377") at /data/src/10.0/sql/handler.cc:2625
|
#13 0x00000000009701f9 in rr_sequential (info=0x7f304694dc28) at /data/src/10.0/sql/records.cc:470
|
#14 0x00000000006af8cd in join_init_read_record (tab=0x7f304694db80) at /data/src/10.0/sql/sql_select.cc:18877
|
#15 0x00000000006ad7eb in sub_select (join=0x7f30468fb148, join_tab=0x7f304694db80, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17971
|
#16 0x00000000006ad0c0 in do_select (join=0x7f30468fb148, fields=0x7f30482a6210, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17636
|
#17 0x0000000000689e4b in JOIN::exec_inner (this=0x7f30468fb148) at /data/src/10.0/sql/sql_select.cc:3108
|
#18 0x0000000000687308 in JOIN::exec (this=0x7f30468fb148) at /data/src/10.0/sql/sql_select.cc:2394
|
#19 0x000000000068a6aa in mysql_select (thd=0x7f30482a2070, rref_pointer_array=0x7f30482a63a0, tables=0x7f30468fa8b0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f30468fb068, unit=0x7f30482a5a08, select_lex=0x7f30482a60f8) at /data/src/10.0/sql/sql_select.cc:3333
|
#20 0x0000000000680908 in handle_select (thd=0x7f30482a2070, lex=0x7f30482a5940, result=0x7f30468fb068, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:377
|
#21 0x000000000064e6c7 in mysql_execute_command (thd=0x7f30482a2070) at /data/src/10.0/sql/sql_parse.cc:3008
|
#22 0x0000000000657d16 in mysql_parse (thd=0x7f30482a2070, rawbuf=0x7f30468fa088 "CREATE TABLE t2 SELECT * FROM t1", length=32, parser_state=0x7f305040f640) at /data/src/10.0/sql/sql_parse.cc:6569
|
#23 0x000000000064a855 in dispatch_command (command=COM_QUERY, thd=0x7f30482a2070, packet=0x7f30497e5071 "CREATE TABLE t2 SELECT * FROM t1", packet_length=32) at /data/src/10.0/sql/sql_parse.cc:1296
|
#24 0x0000000000649b55 in do_command (thd=0x7f30482a2070) at /data/src/10.0/sql/sql_parse.cc:999
|
#25 0x0000000000769e24 in do_handle_one_connection (thd_arg=0x7f30482a2070) at /data/src/10.0/sql/sql_connect.cc:1377
|
#26 0x0000000000769b96 in handle_one_connection (arg=0x7f30482a2070) at /data/src/10.0/sql/sql_connect.cc:1292
|
#27 0x0000000000aca772 in pfs_spawn_thread (arg=0x7f30481a2370) at /data/src/10.0/storage/perfschema/pfs.cc:1861
|
#28 0x00007f3050043494 in start_thread (arg=0x7f3050410700) at pthread_create.c:333
|
#29 0x00007f304e3fc93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Reproducible on 10.0-10.3. Not reproducible on 5.5.
No visible effect on a non-debug build.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue relates to MDEV-15878 [ MDEV-15878 ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | N/A [ 14700 ] | |
| Description |
https://api.travis-ci.org/v3/job/328180147/log.txt
{noformat:title=bb-10.3-temporal 755367d6b43fb60705d21c7435f2f1cdebab81c8} 2018-01-14 7:55:04 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: ALTER TABLE v ORDER BY `col_int_nokey` /* QNO 12134 CON_ID 16 */ /* QNO 12136 CON_ID 16 */ 2018-01-14 7:56:55 18 [ERROR] InnoDB: Unable to rename statistics from test.n#P#p1#SP#p1sp0 to test.#mysql50##sql2-5f78-12#P#p1#SP#p1sp0 in mysql.innodb_table_stats: Operation interrupted. They can be renamed later using UPDATE mysql.innodb_table_stats SET database_name = 'test', table_name = '#mysql50##sql2-5f78-12#P#p1#SP#p1sp0' WHERE database_name = 'test' AND table_name = 'n#P#p1#SP#p1sp0'; 2018-01-14 7:56:56 16 [Warning] Sort aborted, host: localhost, user: rqg, thread: 16, query: ALTER TABLE q ORDER BY `col_int_nokey` /* QNO 21250 CON_ID 16 */ /* QNO 21252 CON_ID 16 */ mysqld: /home/travis/src/storage/maria/ma_pagecache.c:3420: pagecache_read: Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed. 180114 7:56:56 [ERROR] mysqld got signal 6 ; Query (0x7faf5001e168): SELECT * from `E` WHERE row_end IN (SELECT row_start FROM `D`) /* QNO 21209 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 21219 CON_ID 19 */ Connection ID (thread ID): 19 Status: NOT_KILLED {noformat} {noformat} #6 0x00007fafa0ae1bf6 in __assert_fail_base (fmt=0x7fafa0c36018 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x558b96426378 "block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE", file=file@entry=0x558b96424e78 "/home/travis/src/storage/maria/ma_pagecache.c", line=line@entry=3420, function=function@entry=0x558b96427018 <__PRETTY_FUNCTION__.15950> "pagecache_read") at assert.c:92 #7 0x00007fafa0ae1ca2 in __GI___assert_fail (assertion=0x558b96426378 "block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE", file=0x558b96424e78 "/home/travis/src/storage/maria/ma_pagecache.c", line=3420, function=0x558b96427018 <__PRETTY_FUNCTION__.15950> "pagecache_read") at assert.c:101 #8 0x0000558b95ecc395 in pagecache_read (pagecache=0x558b975704a0 <maria_pagecache_var>, file=0x7faf6024bab0, pageno=1, level=0, buff=0x7faf501fb490 '\245' <repeats 200 times>..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7faf8818ddc0) at /home/travis/src/storage/maria/ma_pagecache.c:3416 #9 0x0000558b95f0d703 in _ma_scan_block_record (info=0x7faf6024b680, record=0x7faf602096c8 "\377\377", record_pos=0, skip_deleted=1 '\001') at /home/travis/src/storage/maria/ma_blockrec.c:5499 #10 0x0000558b95efa017 in maria_scan (info=0x7faf6024b680, record=0x7faf602096c8 "\377\377") at /home/travis/src/storage/maria/ma_scan.c:54 #11 0x0000558b95ea3a1e in ha_maria::rnd_next (this=0x7faf60283b08, buf=0x7faf602096c8 "\377\377") at /home/travis/src/storage/maria/ha_maria.cc:2468 #12 0x0000558b95888d3e in handler::ha_rnd_next (this=0x7faf60283b08, buf=0x7faf602096c8 "\377\377") at /home/travis/src/sql/handler.cc:2757 #13 0x0000558b96021cce in ha_partition::rnd_next (this=0x7faf60282358, buf=0x7faf602096c8 "\377\377") at /home/travis/src/sql/ha_partition.cc:5024 #14 0x0000558b95888d3e in handler::ha_rnd_next (this=0x7faf60282358, buf=0x7faf602096c8 "\377\377") at /home/travis/src/sql/handler.cc:2757 #15 0x0000558b95a05b48 in rr_sequential (info=0x7faf50061020) at /home/travis/src/sql/records.cc:485 #16 0x0000558b95509389 in READ_RECORD::read_record (this=0x7faf50061020) at /home/travis/src/sql/records.h:73 #17 0x0000558b9560c531 in join_init_read_record (tab=0x7faf50060f58) at /home/travis/src/sql/sql_select.cc:20155 #18 0x0000558b9560a2ef in sub_select (join=0x7faf50022208, join_tab=0x7faf50060f58, end_of_records=false) at /home/travis/src/sql/sql_select.cc:19229 #19 0x0000558b956098bd in do_select (join=0x7faf50022208, procedure=0x0) at /home/travis/src/sql/sql_select.cc:18772 #20 0x0000558b955e2dbd in JOIN::exec_inner (this=0x7faf50022208) at /home/travis/src/sql/sql_select.cc:4051 #21 0x0000558b955e202a in JOIN::exec (this=0x7faf50022208) at /home/travis/src/sql/sql_select.cc:3834 #22 0x0000558b9595ca5d in subselect_single_select_engine::exec (this=0x7faf500200e0) at /home/travis/src/sql/item_subselect.cc:3864 #23 0x0000558b95951182 in Item_subselect::exec (this=0x7faf5001fee0) at /home/travis/src/sql/item_subselect.cc:723 #24 0x0000558b959517cc in Item_in_subselect::exec (this=0x7faf5001fee0) at /home/travis/src/sql/item_subselect.cc:903 #25 0x0000558b9595458a in Item_in_subselect::val_bool (this=0x7faf5001fee0) at /home/travis/src/sql/item_subselect.cc:1746 #26 0x0000558b954bbf15 in Item::val_bool_result (this=0x7faf5001fee0) at /home/travis/src/sql/item.h:1189 #27 0x0000558b958c7d1f in Item_in_optimizer::val_int (this=0x7faf50022fd0) at /home/travis/src/sql/item_cmpfunc.cc:1628 #28 0x0000558b95782c61 in Type_handler_int_result::Item_val_bool (this=0x558b96d04160 <type_handler_long>, item=0x7faf50022fd0) at /home/travis/src/sql/sql_type.cc:3199 #29 0x0000558b954bbd78 in Item::val_bool (this=0x7faf50022fd0) at /home/travis/src/sql/item.h:1122 #30 0x0000558b958d2750 in Item_cond_and::val_int (this=0x7faf5005eec8) at /home/travis/src/sql/item_cmpfunc.cc:5014 #31 0x0000558b9560a710 in evaluate_join_record (join=0x7faf50020258, join_tab=0x7faf5005e4e8, error=0) at /home/travis/src/sql/sql_select.cc:19327 #32 0x0000558b9560a4de in sub_select (join=0x7faf50020258, join_tab=0x7faf5005e4e8, end_of_records=false) at /home/travis/src/sql/sql_select.cc:19271 #33 0x0000558b956098bd in do_select (join=0x7faf50020258, procedure=0x0) at /home/travis/src/sql/sql_select.cc:18772 #34 0x0000558b955e2dbd in JOIN::exec_inner (this=0x7faf50020258) at /home/travis/src/sql/sql_select.cc:4051 #35 0x0000558b955e202a in JOIN::exec (this=0x7faf50020258) at /home/travis/src/sql/sql_select.cc:3834 #36 0x0000558b955e34e0 in mysql_select (thd=0x7faf5000b470, tables=0x7faf5001e470, wild_num=1, fields=..., conds=0x7faf5001fee0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7faf50020238, unit=0x7faf5000f200, select_lex=0x7faf5000f958) at /home/travis/src/sql/sql_select.cc:4250 #37 0x0000558b955d5432 in handle_select (thd=0x7faf5000b470, lex=0x7faf5000f138, result=0x7faf50020238, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:379 #38 0x0000558b955a0532 in execute_sqlcom_select (thd=0x7faf5000b470, all_tables=0x7faf5001e470) at /home/travis/src/sql/sql_parse.cc:6536 #39 0x0000558b95596b5a in mysql_execute_command (thd=0x7faf5000b470) at /home/travis/src/sql/sql_parse.cc:3750 #40 0x0000558b955a3e53 in mysql_parse (thd=0x7faf5000b470, rawbuf=0x7faf5001e168 "SELECT * from `E` WHERE row_end IN (SELECT row_start FROM `D`) /* QNO 21209 CON_ID 19 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 21219 CON_ID 19 */", length=155, parser_state=0x7faf88190600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7993 #41 0x0000558b95591627 in dispatch_command (command=COM_QUERY, thd=0x7faf5000b470, packet=0x7faf501b7d11 "", packet_length=156, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1826 #42 0x0000558b95590067 in do_command (thd=0x7faf5000b470) at /home/travis/src/sql/sql_parse.cc:1370 #43 0x0000558b956f7f24 in do_handle_one_connection (connect=0x558b99f1e640) at /home/travis/src/sql/sql_connect.cc:1401 #44 0x0000558b956f7cb1 in handle_one_connection (arg=0x558b99f1e640) at /home/travis/src/sql/sql_connect.cc:1307 #45 0x00007fafa16a3184 in start_thread (arg=0x7faf88191700) at pthread_create.c:312 #46 0x00007fafa0bafffd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111 {noformat} {noformat:title=experimental ca750c313df92ab38a8f6a26d5dc865675851719} perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1515916358 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --debug --grammar=conf/partitioning/partitions.yy --engine=Aria --mysqld=--default-storage-engine=Aria --vardir=/home/travis/logs/vardir1_4 {noformat} Not easily reproducible. |
_Note: the test case is suspiciously similar to MDEV-15878, although the assertion failure, stack trace and non-debug results are different._
{code:sql} CREATE TABLE t1 (f INT) ENGINE=Aria; INSERT INTO t1 VALUES (1),(2); --error ER_BAD_FIELD_ERROR ALTER TABLE t1 ORDER BY unknown_column; CREATE TABLE t2 SELECT * FROM t1; # Cleanup DROP TABLE t1, t2; {code} {noformat:title=10.0 400a8eb60f83} mysqld: /data/src/10.0/storage/maria/ma_pagecache.c:3426: pagecache_read: Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed. 180416 14:20:35 [ERROR] mysqld got signal 6 ; #7 0x00007f304e33fee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x0000000000a12f23 in pagecache_read (pagecache=0x202ffc0 <maria_pagecache_var>, file=0x7f3046b5c4a0, pageno=1, level=0, buff=0x7f304694a070 '\245' <repeats 200 times>..., type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, page_link=0x7f305040e5f8) at /data/src/10.0/storage/maria/ma_pagecache.c:3422 #9 0x0000000000a4e4cc in _ma_scan_block_record (info=0x7f3046b5c070, record=0x7f3046827a88 "\377", record_pos=0, skip_deleted=1 '\001') at /data/src/10.0/storage/maria/ma_blockrec.c:5462 #10 0x0000000000a3c4a5 in maria_scan (info=0x7f3046b5c070, record=0x7f3046827a88 "\377") at /data/src/10.0/storage/maria/ma_scan.c:54 #11 0x00000000009ed794 in ha_maria::rnd_next (this=0x7f304687d888, buf=0x7f3046827a88 "\377") at /data/src/10.0/storage/maria/ha_maria.cc:2459 #12 0x000000000083f7be in handler::ha_rnd_next (this=0x7f304687d888, buf=0x7f3046827a88 "\377") at /data/src/10.0/sql/handler.cc:2625 #13 0x00000000009701f9 in rr_sequential (info=0x7f304694dc28) at /data/src/10.0/sql/records.cc:470 #14 0x00000000006af8cd in join_init_read_record (tab=0x7f304694db80) at /data/src/10.0/sql/sql_select.cc:18877 #15 0x00000000006ad7eb in sub_select (join=0x7f30468fb148, join_tab=0x7f304694db80, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17971 #16 0x00000000006ad0c0 in do_select (join=0x7f30468fb148, fields=0x7f30482a6210, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17636 #17 0x0000000000689e4b in JOIN::exec_inner (this=0x7f30468fb148) at /data/src/10.0/sql/sql_select.cc:3108 #18 0x0000000000687308 in JOIN::exec (this=0x7f30468fb148) at /data/src/10.0/sql/sql_select.cc:2394 #19 0x000000000068a6aa in mysql_select (thd=0x7f30482a2070, rref_pointer_array=0x7f30482a63a0, tables=0x7f30468fa8b0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f30468fb068, unit=0x7f30482a5a08, select_lex=0x7f30482a60f8) at /data/src/10.0/sql/sql_select.cc:3333 #20 0x0000000000680908 in handle_select (thd=0x7f30482a2070, lex=0x7f30482a5940, result=0x7f30468fb068, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:377 #21 0x000000000064e6c7 in mysql_execute_command (thd=0x7f30482a2070) at /data/src/10.0/sql/sql_parse.cc:3008 #22 0x0000000000657d16 in mysql_parse (thd=0x7f30482a2070, rawbuf=0x7f30468fa088 "CREATE TABLE t2 SELECT * FROM t1", length=32, parser_state=0x7f305040f640) at /data/src/10.0/sql/sql_parse.cc:6569 #23 0x000000000064a855 in dispatch_command (command=COM_QUERY, thd=0x7f30482a2070, packet=0x7f30497e5071 "CREATE TABLE t2 SELECT * FROM t1", packet_length=32) at /data/src/10.0/sql/sql_parse.cc:1296 #24 0x0000000000649b55 in do_command (thd=0x7f30482a2070) at /data/src/10.0/sql/sql_parse.cc:999 #25 0x0000000000769e24 in do_handle_one_connection (thd_arg=0x7f30482a2070) at /data/src/10.0/sql/sql_connect.cc:1377 #26 0x0000000000769b96 in handle_one_connection (arg=0x7f30482a2070) at /data/src/10.0/sql/sql_connect.cc:1292 #27 0x0000000000aca772 in pfs_spawn_thread (arg=0x7f30481a2370) at /data/src/10.0/storage/perfschema/pfs.cc:1861 #28 0x00007f3050043494 in start_thread (arg=0x7f3050410700) at pthread_create.c:333 #29 0x00007f304e3fc93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Reproducible on 10.0-10.3. Not reproducible on 5.5. No visible effect on a non-debug build. |
| Summary | [Draft] Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed in pagecache_read | Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed in pagecache_read upon CREATE ... SELECT from Aria table |
| Assignee | Elena Stepanova [ elenst ] | Michael Widenius [ monty ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Problem was that if copy_data_between_tables() didn't do proper
clean up in case of failures:
- copy object was not properly freed
- end_bulk_insert() was not called
- mysql_trans_prepare_alter_copy_data() set THD->transaction.on to
false which was not properly restored
The last part caused a crash in Aria as Aria depends on that THD
is correct.
| Fix Version/s | 10.0.36 [ 22916 ] | |
| Fix Version/s | 10.1.34 [ 23100 ] | |
| Fix Version/s | 10.2.15 [ 23006 ] | |
| Fix Version/s | 10.3.7 [ 23005 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link | This issue relates to MDEV-15878 [ MDEV-15878 ] |
| Workflow | MariaDB v3 [ 84863 ] | MariaDB v4 [ 153559 ] |
Occurrence on bb-10.2-compatibility: https://api.travis-ci.org/v3/job/360334979/log.txt