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

[Draft] Server crashes in ha_delete_table / handler::print_error

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1
    • None
    • Server
    • None

    Description

      https://travis-ci.org/elenst/travis-tests/jobs/397126346

      10.1 c6392d52ee2e918a65b05c275286ff4d450eef2c

      180627  1:31:24 [ERROR] mysqld got signal 11 ;
       
      #3  <signal handler called>
      #4  0x000055c9b36de78d in handler::print_error (this=0x7f2fa8009090, error=188, errflag=0) at /home/travis/src/sql/handler.cc:3416
      #5  0x000055c9b36db8e8 in ha_delete_table (thd=0x55c9b6c7e060, table_type=0x55c9b67aa0f0, path=0x7f2fe8299670 "./transforms/where_updatedelete_23570", db=0x7f2fa8005680 "transforms", alias=0x7f2fa8005690 "where_updatedelete_23570", generate_warning=false) at /home/travis/src/sql/handler.cc:2405
      #6  0x000055c9b354ac32 in quick_rm_table (thd=0x55c9b6c7e060, base=0x55c9b67aa0f0, db=0x7f2fa8005680 "transforms", table_name=0x7f2fa8005690 "where_updatedelete_23570", flags=0, table_path=0x0) at /home/travis/src/sql/sql_table.cc:2740
      #7  0x000055c9b3428f67 in drop_open_table (thd=0x55c9b6c7e060, table=0x7f2fa80624c0, db_name=0x7f2fa8005680 "transforms", table_name=0x7f2fa8005690 "where_updatedelete_23570") at /home/travis/src/sql/sql_base.cc:1928
      #8  0x000055c9b347a78c in select_create::abort_result_set (this=0x7f2fa8006720) at /home/travis/src/sql/sql_insert.cc:4537
      #9  0x000055c9b34cd1be in handle_select (thd=0x55c9b6c7e060, lex=0x55c9b6c81ad0, result=0x7f2fa8006720, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:394
      #10 0x000055c9b349419f in mysql_execute_command (thd=0x55c9b6c7e060) at /home/travis/src/sql/sql_parse.cc:3454
      #11 0x000055c9b34a05b1 in mysql_parse (thd=0x55c9b6c7e060, rawbuf=0x7f2fa80054c8 "CREATE TABLE transforms.where_updatedelete_23570  SELECT BIT_COUNT( 6811412961421164544 ) AS field1 FROM `t3`  /* QNO 8918 CON_ID 12 */  /* QNO 8940 CON_ID 12 */", length=161, parser_state=0x7f2fe829a630) at /home/travis/src/sql/sql_parse.cc:7449
      #12 0x000055c9b348effd in dispatch_command (command=COM_QUERY, thd=0x55c9b6c7e060, packet=0x55c9b6c85541 "CREATE TABLE transforms.where_updatedelete_23570  SELECT BIT_COUNT( 6811412961421164544 ) AS field1 FROM `t3`  /* QNO 8918 CON_ID 12 */  /* QNO 8940 CON_ID 12 */ ", packet_length=162) at /home/travis/src/sql/sql_parse.cc:1492
      #13 0x000055c9b348dd7d in do_command (thd=0x55c9b6c7e060) at /home/travis/src/sql/sql_parse.cc:1121
      #14 0x000055c9b35c88e9 in do_handle_one_connection (thd_arg=0x55c9b6c7e060) at /home/travis/src/sql/sql_connect.cc:1330
      #15 0x000055c9b35c864d in handle_one_connection (arg=0x55c9b6c7e060) at /home/travis/src/sql/sql_connect.cc:1242
      #16 0x00007f2fffb40184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #17 0x00007f2fff262ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
       
      Query (0x7f2fa80054c8): CREATE TABLE transforms.where_updatedelete_23570  SELECT BIT_COUNT( 6811412961421164544 ) AS field1 FROM `t3`  /* QNO 8918 CON_ID 12 */  /* QNO 8940 CON_ID 12 */
      Connection ID (thread ID): 12
      Status: KILL_TIMEOUT
      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=off
      

      merge 8b07e28011e33305b40ddb441393bfccd7821213

      perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1530062746 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.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/mariadb/functions.yy --skip-gendata --gendata-advanced --vcols --transformers=ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice
      

      Not reproducible so far.
      All threads' stack traces are attached. Coredump, datadir, logs etc. are available.

      From another occurrence, same branches/revisions:

      merge 8b07e28011e33305b40ddb441393bfccd7821213

      perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1530063753 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.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/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --ps-protocol --transformers=ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsSPTwice
      

      Attachments

        1. threads
          44 kB
        2. threads_full
          140 kB

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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