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

Server crashes in ha_maria::end_bulk_insert

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
    • 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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15572 view.test, server crash with --big-tables=1

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            alice Alice Sherepa made changes -
            Field Original Value New Value
            Status Open [ 1 ] Confirmed [ 10101 ]
            alice Alice Sherepa made changes -
            Summary [Draft] Server crashes in ha_maria::end_bulk_insert Server crashes in ha_maria::end_bulk_insert
            alice Alice Sherepa made changes -
            Affects Version/s 5.5 [ 15800 ]
            Affects Version/s 10.0 [ 16000 ]
            Affects Version/s 10.1 [ 16100 ]
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            alice Alice Sherepa made changes -
            Fix Version/s 5.5 [ 15800 ]
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            elenst Elena Stepanova made changes -
            Description https://travis-ci.org/elenst/travis-tests/jobs/475398165
            {noformat:title=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
            {noformat}
            {noformat:title=elenst-dev b65d4a39, mariadb-toolbox 0acf1236}
            perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1546703311 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/optimizer/updateable_views.yy --mysqld=--init-file=$RQG_HOME/conf/optimizer/updateable_views.init --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice --redefine=conf/mariadb/versioning.yy --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff
            {noformat}

            Not reproducible right away -- by re-running the test, I'm hitting MDEV-18121 instead.             		{noformat:title=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
            {noformat}

            See the test case in [~alice]'s [comment|https://jira.mariadb.org/browse/MDEV-18148?focusedCommentId=122659&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-122659]
            elenst Elena Stepanova made changes -
            Comment [ New occurrence: https://travis-ci.org/elenst/travis-tests/jobs/479996245 ]
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Michael Widenius [ monty ]
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 5.5 [ 15800 ]
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Duplicate [ 3 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 91507 ] MariaDB v4 [ 155451 ]

            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.