Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17665

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

    XMLWordPrintable

Details

    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

          Bug - A problem which impairs or prevents the functions of the product. 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

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. 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

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. 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

          • Major - Major loss of function.
          • Closed

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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