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

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.4.16, 10.5.7
Component/s: Storage Engine - Aria
Labels:
None

Description

Note: The test case is non-deterministic, run with a high value of --repeat=N. It usually fails for me one or another way withing 100 attempts (they are very fast, it takes less than a minute to run 100), but it can vary a lot on different machines and builds. You can also try to change the number of inserted values in the test case, it may affect the outcome as well.

--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;

10.2 5f1ec5cb
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

10.2 5f1ec5cb
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

Non-debug build doesn't crash, but it has been seen to fail on the provided test case in an odd way:

10.2 non-debug 5f1ec5cb
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...

Which of course shouldn't be happening.

A similar test case, only differs from the previous one in the number of inserted rows. More readily fails on a different assertion:

--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;

10.2 5f1ec5cb
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

Other failures observed with similar test cases, but not as well reproducible because the ones above usually happen first:

10.2 5f1ec5cb
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

10.2 5f1ec5cb
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 ;

Attachments

Issue Links

relates to

MDEV-17622 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 or ER_CRASHED_ON_USAGE

Closed

Closed

MDEV-23296 Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == type || (block->type == PAGECACHE_PLAIN_PAGE && type == PAGECACHE_LSN_PAGE)' with aria_max_sort_file_size

Closed

Activity

Ascending order - Click to sort in descending order

Michael Widenius added a comment - 2020-09-17 15:01

The bug was that the can_enable_index variable in MyISAM and Aria was not properly set and reset for bulk insert.
Because of this, insert...select was trying to recreate indexes while another thread was using it, causing crashes in page cache.

Michael Widenius added a comment - 2020-09-17 15:01 The bug was that the can_enable_index variable in MyISAM and Aria was not properly set and reset for bulk insert. Because of this, insert...select was trying to recreate indexes while another thread was using it, causing crashes in page cache.

Michael Widenius added a comment - 2020-09-25 14:17

Review, testing and pushing

Michael Widenius added a comment - 2020-09-25 14:17 Review, testing and pushing

People

Assignee:: Michael Widenius

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-11-11 14:04

Updated:: 2021-04-26 18:17

Resolved:: 2020-09-25 14:17

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server