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

Server crashes in ha_maria::end_bulk_insert

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
    • N/A
    • Storage Engine - Aria
    • None

    Description

      10.4 2465d3e00b2f18c7d4967f9bb10438883682787d

      #3  <signal handler called>
      #4  0x00005569c8469094 in ha_maria::end_bulk_insert (this=0x7fa484647f18) at /home/travis/src/storage/maria/ha_maria.cc:2278
      #5  0x00005569c7b2767f in handler::ha_end_bulk_insert (this=0x7fa484647f18) at /home/travis/src/sql/handler.h:3174
      #6  0x00005569c7b24dfa in select_insert::abort_result_set (this=0x7fa4845c3810) at /home/travis/src/sql/sql_insert.cc:4054
      #7  0x00005569c7b9f7f9 in handle_select (thd=0x7fa4841d58a0, lex=0x7fa4841d9698, result=0x7fa4845c3810, setup_tables_done_option=1073741824) at /home/travis/src/sql/sql_select.cc:391
      #8  0x00005569c7b62ee0 in mysql_execute_command (thd=0x7fa4841d58a0) at /home/travis/src/sql/sql_parse.cc:4837
      #9  0x00005569c7b6d6f4 in mysql_parse (thd=0x7fa4841d58a0, rawbuf=0x7fa4841e3808 "REPLACE INTO view5 ( field1, field2, field3, field4 ) SELECT a1.field1 AS field1, a2.field2 AS field2, a1.field3 AS field3, a1.field4 AS field4 FROM table_multipart AS a1, table_virtual AS a2 WHERE a1"..., length=314, parser_state=0x7fa46a210650, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8104
      #10 0x00005569c7b5a5de in dispatch_command (command=COM_QUERY, thd=0x7fa4841d58a0, packet=0x7fa4841db6d1 "REPLACE INTO view5 ( field1, field2, field3, field4 ) SELECT a1.field1 AS field1, a2.field2 AS field2, a1.field3 AS field3, a1.field4 AS field4 FROM table_multipart AS a1, table_virtual AS a2 WHERE a1"..., packet_length=315, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1851
      #11 0x00005569c7b58ffb in do_command (thd=0x7fa4841d58a0) at /home/travis/src/sql/sql_parse.cc:1396
      #12 0x00005569c7cc4f58 in do_handle_one_connection (connect=0x5569cba4bf00) at /home/travis/src/sql/sql_connect.cc:1402
      #13 0x00005569c7cc4ca9 in handle_one_connection (arg=0x5569cba4bf00) at /home/travis/src/sql/sql_connect.cc:1308
      #14 0x00007fa48acf26ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #15 0x00007fa48a18741d in clone () from /lib/x86_64-linux-gnu/libc.so.6
       
      Query (0x7fa4841e3808): REPLACE INTO view5 ( field1, field2, field3, field4 ) SELECT a1.field1 AS field1, a2.field2 AS field2, a1.field3 AS field3, a1.field4 AS field4 FROM table_multipart AS a1, table_virtual AS a2 WHERE a1.field1 = a2.field1 AND a1.field2 <> 'l' ORDER BY field1, field2, field3, field4 LIMIT 2  /* QNO 6268 CON_ID 16 */
      Connection ID (thread ID): 16
      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
      

      See the test case in alice's comment

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.