Assertion `!share || share->page_type == PAGECACHE_LSN_PAGE', `type != PAGECACHE_READ_UNKNOWN_PAGE' and similar ones upon concurrent Aria operations

--source include/have_sequence.inc

CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, KEY(a)) ENGINE=Aria;

ALTER TABLE t1 DISABLE KEYS;

INSERT INTO t1 SELECT seq, seq FROM seq_1_to_100;

--connect (con1,localhost,root,,test)

--connect (con2,localhost,root,,test)

--send

  INSERT INTO t1 SELECT seq, seq FROM seq_1_to_100;

--connection con1

--send

  FLUSH TABLES;

--connection default

--error ER_WRONG_VALUE_COUNT_ON_ROW

INSERT INTO t1 SELECT 1;

# Cleanup

--connection con2

--error ER_DUP_ENTRY

--reap

--disconnect con2

--connection con1

--reap

--disconnect con1

--connection default

DROP TABLE t1;

mysqld: /data/src/10.2/storage/maria/ma_pagecrc.c:374: maria_flush_log_for_page: Assertion `!share || share->page_type == PAGECACHE_LSN_PAGE' failed.

200727 14:33:53 [ERROR] mysqld got signal 6 ;

#7  0x00007fbc0af17f12 in __GI___assert_fail (assertion=0x56072ce36c30 "!share || share->page_type == PAGECACHE_LSN_PAGE", file=0x56072ce36a30 "/data/src/10.2/storage/maria/ma_pagecrc.c", line=374, function=0x56072ce36cd0 <__PRETTY_FUNCTION__.15412> "maria_flush_log_for_page") at assert.c:101

#8  0x000056072c96a8a2 in maria_flush_log_for_page (args=0x7fbc051f9a50) at /data/src/10.2/storage/maria/ma_pagecrc.c:374

#9  0x000056072c953be0 in pagecache_fwrite (pagecache=0x56072df42e00 <maria_pagecache_var>, filedesc=0x7fbc05d76558, buffer=0x7fbc05daf080 "\001", pageno=1, type=PAGECACHE_PLAIN_PAGE, flags=36) at /data/src/10.2/storage/maria/ma_pagecache.c:660

#10 0x000056072c95d547 in flush_cached_blocks (pagecache=0x56072df42e00 <maria_pagecache_var>, file=0x7fbbe80262d0, cache=0x7fbc051f9c28, end=0x7fbc051f9c30, type=FLUSH_RELEASE, first_errno=0x7fbc051f9b84) at /data/src/10.2/storage/maria/ma_pagecache.c:4419

#11 0x000056072c95defb in flush_pagecache_blocks_int (pagecache=0x56072df42e00 <maria_pagecache_var>, file=0x7fbbe80262d0, type=FLUSH_RELEASE, filter=0x0, filter_arg=0x0) at /data/src/10.2/storage/maria/ma_pagecache.c:4715

#12 0x000056072c95e31c in flush_pagecache_blocks_with_filter (pagecache=0x56072df42e00 <maria_pagecache_var>, file=0x7fbbe80262d0, type=FLUSH_RELEASE, filter=0x0, filter_arg=0x0) at /data/src/10.2/storage/maria/ma_pagecache.c:4832

#13 0x000056072c979047 in _ma_flush_table_files (info=0x7fbbe8025e90, flush_data_or_index=3, flush_type_for_data=FLUSH_RELEASE, flush_type_for_index=FLUSH_RELEASE) at /data/src/10.2/storage/maria/ma_extra.c:644

#14 0x000056072c9c1fdb in _ma_flush_table_files_before_swap (param=0x7fbbe8033b28, info=0x7fbbe8025e90) at /data/src/10.2/storage/maria/ma_check.c:3063

#15 0x000056072c9c4dcd in maria_repair_by_sort (param=0x7fbbe8033b28, info=0x7fbbe8025e90, name=0x7fbc051ff610 "./test/table0_aria_int", rep_quick=1 '\001') at /data/src/10.2/storage/maria/ma_check.c:3941

#16 0x000056072c932049 in ha_maria::repair (this=0x7fbbe801a6b8, thd=0x7fbbe8000af0, param=0x7fbbe8033b28, do_optimize=false) at /data/src/10.2/storage/maria/ha_maria.cc:1680

#17 0x000056072c932f28 in ha_maria::enable_indexes (this=0x7fbbe801a6b8, mode=2) at /data/src/10.2/storage/maria/ha_maria.cc:2038

#18 0x000056072c9336ed in ha_maria::end_bulk_insert (this=0x7fbbe801a6b8) at /data/src/10.2/storage/maria/ha_maria.cc:2239

#19 0x000056072c3a91c5 in handler::ha_end_bulk_insert (this=0x7fbbe801a6b8) at /data/src/10.2/sql/handler.cc:4177

#20 0x000056072c109723 in select_insert::abort_result_set (this=0x7fbbe8012298) at /data/src/10.2/sql/sql_insert.cc:4016

#21 0x000056072c163a8a in handle_select (thd=0x7fbbe8000af0, lex=0x7fbbe8004628, result=0x7fbbe8012298, setup_tables_done_option=1073741824) at /data/src/10.2/sql/sql_select.cc:379

#22 0x000056072c12817c in mysql_execute_command (thd=0x7fbbe8000af0) at /data/src/10.2/sql/sql_parse.cc:4275

#23 0x000056072c1331a9 in mysql_parse (thd=0x7fbbe8000af0, rawbuf=0x7fbbe80112d8 "INSERT /* QNO 2001 CON_ID 13 */ INTO `table0_aria_int` SELECT * FROM `alt_t6`", length=77, parser_state=0x7fbc05200610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733

#24 0x000056072c1214d5 in dispatch_command (command=COM_QUERY, thd=0x7fbbe8000af0, packet=0x7fbbe80088b1 "INSERT /* QNO 2001 CON_ID 13 */ INTO `table0_aria_int` SELECT * FROM `alt_t6`", packet_length=77, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824

#25 0x000056072c11ff50 in do_command (thd=0x7fbbe8000af0) at /data/src/10.2/sql/sql_parse.cc:1377

#26 0x000056072c275fb1 in do_handle_one_connection (connect=0x56072f1e0080) at /data/src/10.2/sql/sql_connect.cc:1336

#27 0x000056072c275d1c in handle_one_connection (arg=0x56072f1e0080) at /data/src/10.2/sql/sql_connect.cc:1241

#28 0x000056072ca8c048 in pfs_spawn_thread (arg=0x56072f184570) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#29 0x00007fbc0cea04a4 in start_thread (arg=0x7fbc05201700) at pthread_create.c:456

#30 0x00007fbc0afd4d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

mysqld: /data/src/10.2/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.

200727 14:43:27 [ERROR] mysqld got signal 6 ;

#7  0x00007f1c70d91f12 in __GI___assert_fail (assertion=0x5556946935d8 "block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE", file=0x5556946920d8 "/data/src/10.2/storage/maria/ma_pagecache.c", line=3420, function=0x5556946942b8 <__PRETTY_FUNCTION__.16121> "pagecache_read") at assert.c:101

#8  0x00005556941badd3 in pagecache_read (pagecache=0x5556957a2e00 <maria_pagecache_var>, file=0x7f1c480235c0, pageno=1, level=0, buff=0x0, type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_WRITE, page_link=0x7f1c66fc11b0) at /data/src/10.2/storage/maria/ma_pagecache.c:3416

#9  0x00005556941f712a in delete_head_or_tail (info=0x7f1c48023180, page=1, record_number=1, head=1 '\001', from_update=0 '\000') at /data/src/10.2/storage/maria/ma_blockrec.c:4178

#10 0x00005556941f5bab in _ma_write_abort_block_record (info=0x7f1c48023180) at /data/src/10.2/storage/maria/ma_blockrec.c:3648

#11 0x0000555694207bad in maria_write (info=0x7f1c48023180, record=0x7f1c480189b8 "\375") at /data/src/10.2/storage/maria/ma_write.c:394

#12 0x00005556941907ab in ha_maria::write_row (this=0x7f1c4801bce8, buf=0x7f1c480189b8 "\375") at /data/src/10.2/storage/maria/ha_maria.cc:1293

#13 0x0000555693c0dbc2 in handler::ha_write_row (this=0x7f1c4801bce8, buf=0x7f1c480189b8 "\375") at /data/src/10.2/sql/handler.cc:6108

#14 0x0000555693963731 in write_record (thd=0x7f1c4c000af0, table=0x7f1c4801b0e0, info=0x7f1c4c012128) at /data/src/10.2/sql/sql_insert.cc:1941

#15 0x0000555693968c94 in select_insert::send_data (this=0x7f1c4c0120e8, values=...) at /data/src/10.2/sql/sql_insert.cc:3834

#16 0x00005556939f8e04 in end_send (join=0x7f1c4c012190, join_tab=0x7f1c4c013ab0, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:20045

#17 0x00005556939f68a3 in evaluate_join_record (join=0x7f1c4c012190, join_tab=0x7f1c4c013700, error=0) at /data/src/10.2/sql/sql_select.cc:19093

#18 0x00005556939f618f in sub_select (join=0x7f1c4c012190, join_tab=0x7f1c4c013700, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18873

#19 0x00005556939f5716 in do_select (join=0x7f1c4c012190, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18417

#20 0x00005556939cf1d7 in JOIN::exec_inner (this=0x7f1c4c012190) at /data/src/10.2/sql/sql_select.cc:3638

#21 0x00005556939ce692 in JOIN::exec (this=0x7f1c4c012190) at /data/src/10.2/sql/sql_select.cc:3433

#22 0x00005556939cf848 in mysql_select (thd=0x7f1c4c000af0, tables=0x7f1c4c011a30, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7f1c4c0120e8, unit=0x7f1c4c0046e8, select_lex=0x7f1c4c004e28) at /data/src/10.2/sql/sql_select.cc:3833

#23 0x00005556939c3a06 in handle_select (thd=0x7f1c4c000af0, lex=0x7f1c4c004628, result=0x7f1c4c0120e8, setup_tables_done_option=1073741824) at /data/src/10.2/sql/sql_select.cc:361

#24 0x000055569398817c in mysql_execute_command (thd=0x7f1c4c000af0) at /data/src/10.2/sql/sql_parse.cc:4275

#25 0x00005556939931a9 in mysql_parse (thd=0x7f1c4c000af0, rawbuf=0x7f1c4c011098 "INSERT /* QNO 2115 CON_ID 15 */ INTO `table0_aria_int` SELECT * FROM `table10_myisam_int_autoinc`", length=97, parser_state=0x7f1c66fc2610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733

#26 0x00005556939814d5 in dispatch_command (command=COM_QUERY, thd=0x7f1c4c000af0, packet=0x7f1c4c0088b1 "INSERT /* QNO 2115 CON_ID 15 */ INTO `table0_aria_int` SELECT * FROM `table10_myisam_int_autoinc`", packet_length=97, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824

#27 0x000055569397ff50 in do_command (thd=0x7f1c4c000af0) at /data/src/10.2/sql/sql_parse.cc:1377

#28 0x0000555693ad5fb1 in do_handle_one_connection (connect=0x55569787a090) at /data/src/10.2/sql/sql_connect.cc:1336

#29 0x0000555693ad5d1c in handle_one_connection (arg=0x55569787a090) at /data/src/10.2/sql/sql_connect.cc:1241

#30 0x00005556942ec048 in pfs_spawn_thread (arg=0x555697885360) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#31 0x00007f1c72d1a4a4 in start_thread (arg=0x7f1c66fc3700) at pthread_create.c:456

#32 0x00007f1c70e4ed0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

bug2.pagecache2                          [ fail ]

        Test ended at 2020-07-27 16:00:09

CURRENT_TEST: bug2.pagecache2

mysqltest: At line 18: query 'INSERT INTO t1 SELECT 1' succeeded - should have failed with errno 1136...

--source include/have_sequence.inc

CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, KEY(a)) ENGINE=Aria;

ALTER TABLE t1 DISABLE KEYS;

INSERT INTO t1 SELECT seq, seq FROM seq_1_to_1000;

--connect (con1,localhost,root,,test)

--connect (con2,localhost,root,,test)

--send

  INSERT INTO t1 SELECT seq, seq FROM seq_1_to_1000;

--connection con1

--send

  FLUSH TABLES;

--connection default

--error ER_WRONG_VALUE_COUNT_ON_ROW

INSERT INTO t1 SELECT 1;

# Cleanup

--connection con2

--error ER_DUP_ENTRY

--reap

--disconnect con2

--connection con1

--reap

--disconnect con1

--connection default

DROP TABLE t1;

mysqld: /data/src/10.2/storage/maria/ma_pagecache.c:632: pagecache_fwrite: Assertion `type != PAGECACHE_READ_UNKNOWN_PAGE' failed.

200727 14:37:40 [ERROR] mysqld got signal 6 ;

#7  0x00007ff4984c5f12 in __GI___assert_fail (assertion=0x55e63757b118 "type != PAGECACHE_READ_UNKNOWN_PAGE", file=0x55e63757b0d8 "/data/src/10.2/storage/maria/ma_pagecache.c", line=632, function=0x55e63757d040 <__PRETTY_FUNCTION__.15738> "pagecache_fwrite") at assert.c:101

#8  0x000055e63709cbb3 in pagecache_fwrite (pagecache=0x55e63868be00 <maria_pagecache_var>, filedesc=0x7ff493324558, buffer=0x7ff49335d080 "\001", pageno=1, type=PAGECACHE_READ_UNKNOWN_PAGE, flags=36) at /data/src/10.2/storage/maria/ma_pagecache.c:632

#9  0x000055e6370a6547 in flush_cached_blocks (pagecache=0x55e63868be00 <maria_pagecache_var>, file=0x7ff4740262d0, cache=0x7ff4927a7c28, end=0x7ff4927a7c30, type=FLUSH_RELEASE, first_errno=0x7ff4927a7b84) at /data/src/10.2/storage/maria/ma_pagecache.c:4419

#10 0x000055e6370a6efb in flush_pagecache_blocks_int (pagecache=0x55e63868be00 <maria_pagecache_var>, file=0x7ff4740262d0, type=FLUSH_RELEASE, filter=0x0, filter_arg=0x0) at /data/src/10.2/storage/maria/ma_pagecache.c:4715

#11 0x000055e6370a731c in flush_pagecache_blocks_with_filter (pagecache=0x55e63868be00 <maria_pagecache_var>, file=0x7ff4740262d0, type=FLUSH_RELEASE, filter=0x0, filter_arg=0x0) at /data/src/10.2/storage/maria/ma_pagecache.c:4832

#12 0x000055e6370c2047 in _ma_flush_table_files (info=0x7ff474025e90, flush_data_or_index=3, flush_type_for_data=FLUSH_RELEASE, flush_type_for_index=FLUSH_RELEASE) at /data/src/10.2/storage/maria/ma_extra.c:644

#13 0x000055e63710afdb in _ma_flush_table_files_before_swap (param=0x7ff474033b28, info=0x7ff474025e90) at /data/src/10.2/storage/maria/ma_check.c:3063

#14 0x000055e63710ddcd in maria_repair_by_sort (param=0x7ff474033b28, info=0x7ff474025e90, name=0x7ff4927ad610 "./test/table0_aria_int", rep_quick=1 '\001') at /data/src/10.2/storage/maria/ma_check.c:3941

#15 0x000055e63707b049 in ha_maria::repair (this=0x7ff47401a6b8, thd=0x7ff474000af0, param=0x7ff474033b28, do_optimize=false) at /data/src/10.2/storage/maria/ha_maria.cc:1680

#16 0x000055e63707bf28 in ha_maria::enable_indexes (this=0x7ff47401a6b8, mode=2) at /data/src/10.2/storage/maria/ha_maria.cc:2038

#17 0x000055e63707c6ed in ha_maria::end_bulk_insert (this=0x7ff47401a6b8) at /data/src/10.2/storage/maria/ha_maria.cc:2239

#18 0x000055e636af21c5 in handler::ha_end_bulk_insert (this=0x7ff47401a6b8) at /data/src/10.2/sql/handler.cc:4177

#19 0x000055e636852723 in select_insert::abort_result_set (this=0x7ff474012298) at /data/src/10.2/sql/sql_insert.cc:4016

#20 0x000055e6368aca8a in handle_select (thd=0x7ff474000af0, lex=0x7ff474004628, result=0x7ff474012298, setup_tables_done_option=1073741824) at /data/src/10.2/sql/sql_select.cc:379

#21 0x000055e63687117c in mysql_execute_command (thd=0x7ff474000af0) at /data/src/10.2/sql/sql_parse.cc:4275

#22 0x000055e63687c1a9 in mysql_parse (thd=0x7ff474000af0, rawbuf=0x7ff4740112d8 "INSERT /* QNO 2001 CON_ID 13 */ INTO `table0_aria_int` SELECT * FROM `alt_t6`", length=77, parser_state=0x7ff4927ae610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733

#23 0x000055e63686a4d5 in dispatch_command (command=COM_QUERY, thd=0x7ff474000af0, packet=0x7ff4740088b1 "INSERT /* QNO 2001 CON_ID 13 */ INTO `table0_aria_int` SELECT * FROM `alt_t6`", packet_length=77, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824

#24 0x000055e636868f50 in do_command (thd=0x7ff474000af0) at /data/src/10.2/sql/sql_parse.cc:1377

#25 0x000055e6369befb1 in do_handle_one_connection (connect=0x55e63a7e0090) at /data/src/10.2/sql/sql_connect.cc:1336

#26 0x000055e6369bed1c in handle_one_connection (arg=0x55e63a7e0090) at /data/src/10.2/sql/sql_connect.cc:1241

#27 0x000055e6371d5048 in pfs_spawn_thread (arg=0x55e63a784580) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#28 0x00007ff49a44e4a4 in start_thread (arg=0x7ff4927af700) at pthread_create.c:456

#29 0x00007ff498582d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

mysqld: /data/src/10.2/storage/maria/ma_pagecache.c:5046: pagecache_file_no_dirty_page: Assertion `0' failed.

200727 14:39:28 [ERROR] mysqld got signal 6 ;

#7  0x00007f3d8660df12 in __GI___assert_fail (assertion=0x55a2e318dfdd "0", file=0x55a2e318d0d8 "/data/src/10.2/storage/maria/ma_pagecache.c", line=5046, function=0x55a2e318f450 <__PRETTY_FUNCTION__.16369> "pagecache_file_no_dirty_page") at assert.c:101

#8  0x000055a2e2cb9c6c in pagecache_file_no_dirty_page (pagecache=0x55a2e429de00 <maria_pagecache_var>, file=0x7f3d64025ff0) at /data/src/10.2/storage/maria/ma_pagecache.c:5046

#9  0x000055a2e2cc4a39 in _ma_reenable_logging_for_table (info=0x7f3d64025bb0, flush_pages=0 '\000') at /data/src/10.2/storage/maria/ma_recovery.c:3681

#10 0x000055a2e2d2083f in maria_repair_by_sort (param=0x7f3d64033848, info=0x7f3d64025bb0, name=0x7f3d808f5610 "./test/table0_aria_int", rep_quick=1 '\001') at /data/src/10.2/storage/maria/ma_check.c:4135

#11 0x000055a2e2c8d049 in ha_maria::repair (this=0x7f3d6401a328, thd=0x7f3d64000af0, param=0x7f3d64033848, do_optimize=false) at /data/src/10.2/storage/maria/ha_maria.cc:1680

#12 0x000055a2e2c8df28 in ha_maria::enable_indexes (this=0x7f3d6401a328, mode=2) at /data/src/10.2/storage/maria/ha_maria.cc:2038

#13 0x000055a2e2c8e6ed in ha_maria::end_bulk_insert (this=0x7f3d6401a328) at /data/src/10.2/storage/maria/ha_maria.cc:2239

#14 0x000055a2e27041c5 in handler::ha_end_bulk_insert (this=0x7f3d6401a328) at /data/src/10.2/sql/handler.cc:4177

#15 0x000055a2e2464723 in select_insert::abort_result_set (this=0x7f3d64012058) at /data/src/10.2/sql/sql_insert.cc:4016

#16 0x000055a2e24bea8a in handle_select (thd=0x7f3d64000af0, lex=0x7f3d64004628, result=0x7f3d64012058, setup_tables_done_option=1073741824) at /data/src/10.2/sql/sql_select.cc:379

#17 0x000055a2e248317c in mysql_execute_command (thd=0x7f3d64000af0) at /data/src/10.2/sql/sql_parse.cc:4275

#18 0x000055a2e248e1a9 in mysql_parse (thd=0x7f3d64000af0, rawbuf=0x7f3d64011098 "INSERT /* QNO 2001 CON_ID 13 */ INTO `table0_aria_int` SELECT * FROM `alt_t6`", length=77, parser_state=0x7f3d808f6610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7733

#19 0x000055a2e247c4d5 in dispatch_command (command=COM_QUERY, thd=0x7f3d64000af0, packet=0x7f3d640088b1 "INSERT /* QNO 2001 CON_ID 13 */ INTO `table0_aria_int` SELECT * FROM `alt_t6`", packet_length=77, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824

#20 0x000055a2e247af50 in do_command (thd=0x7f3d64000af0) at /data/src/10.2/sql/sql_parse.cc:1377

#21 0x000055a2e25d0fb1 in do_handle_one_connection (connect=0x55a2e5cf6080) at /data/src/10.2/sql/sql_connect.cc:1336

#22 0x000055a2e25d0d1c in handle_one_connection (arg=0x55a2e5cf6080) at /data/src/10.2/sql/sql_connect.cc:1241

#23 0x000055a2e2de7048 in pfs_spawn_thread (arg=0x55a2e5d00e70) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#24 0x00007f3d885964a4 in start_thread (arg=0x7f3d808f7700) at pthread_create.c:456

#25 0x00007f3d866cad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

mysqld: /data/src/10.2/storage/maria/ma_state.c:63: _ma_setup_live_state: Assertion `share->lock_key_trees' failed.

200727 14:51:56 [ERROR] mysqld got signal 6 ;