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

SEGV on DROP SCHEMA if innodb_force_recovery=5

    Details

      Description

      ml_30-master.opt:
      --loose-innodb_force_recovery=5
       
      ml_30.test:
      --source include/have_innodb.inc
       
      CREATE SCHEMA DB1 ;
      DROP SCHEMA DB1;
       
      # Try to enforce that the crash gets detected.
      # The DDL itself is not required for the crash.
      CREATE TEMPORARY TABLE temp1 (col1 INT);
       
       
      Version: '10.2.25-MariaDB-debug-log'  socket: 'bld_debug/mysql-test/var/tmp/mysqld.1.sock'  port: 16000  Source distribution
      190524 15:17:08 [ERROR] mysqld got signal 11 ;
      ...
      Query (0x7fc5c8011920): DROP SCHEMA DB1
      Connection ID (thread ID): 5
      Status: NOT_KILLED
      ...
       
      Thread 1 (Thread 0x7fc5f6bf8700 (LWP 2449)):
      #0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x00005623ea97a037 in my_write_core (sig=11) at mysys/stacktrace.c:477
      #2  0x00005623ea2204f9 in handle_fatal_signal (sig=11) at sql/signal_handler.cc:343 
      #3  <signal handler called>
      #4  0x00005623ea627e8b in trx_assign_rseg_low () at storage/innobase/trx/trx0trx.cc:1001
      #5  0x00005623ea628777 in trx_start_low (trx=0x7fc5f77da148, read_write=true) at storage/innobase/trx/trx0trx.cc:1192
      #6  0x00005623ea62ce48 in trx_start_if_not_started_xa_low (trx=0x7fc5f77da148, read_write=true) at storage/innobase/trx/trx0trx.cc:2816
      #7  0x00005623ea574ede in row_drop_database_for_mysql (name=0x7fc5c81471e8 "DB1/", trx=0x7fc5f77da148, found=0x7fc5f6bf5de0) at storage/innobase/row/row0mysql.cc:3933
      #8  0x00005623ea43cc1e in innobase_drop_database (hton=0x5623eca041b8, path=0x7fc5f6bf6360 "./DB1/") at storage/innobase/handler/ha_innodb.cc:13343
      #9  0x00005623ea22287f in dropdb_handlerton (unused1=0x0, plugin=0x7fc5c8155068, path=0x7fc5f6bf6360) at sql/handler.cc:708
      #10 0x00005623e9fc13d3 in plugin_foreach_with_mask (thd=0x0, func=0x5623ea222826 <dropdb_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=8, arg=0x7fc5f6bf6360) at sql/sql_plugin.cc:2396
      #11 0x00005623ea2228b4 in ha_drop_database (path=0x7fc5f6bf6360 "./DB1/") at sql/handler.cc:715
      #12 0x00005623e9f71797 in mysql_rm_db_internal (thd=0x7fc5c8000ce8, db=0x7fc5c80119b0 "DB1", if_exists=false, silent=false) at sql/sql_db.cc:937
      #13 0x00005623e9f71e74 in mysql_rm_db (thd=0x7fc5c8000ce8, db=0x7fc5c80119b0 "DB1", if_exists=false) at sql/sql_db.cc:1071
      #14 0x00005623e9fa9f49 in mysql_execute_command (thd=0x7fc5c8000ce8) at sql/sql_parse.cc:4998
      #15 0x00005623e9fb37d0 in mysql_parse (thd=0x7fc5c8000ce8, rawbuf=0x7fc5c8011920 "DROP SCHEMA DB1", length=15, parser_state=0x7fc5f6bf71f0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8020
      #16 0x00005623e9fa1000 in dispatch_command (command=COM_QUERY, thd=0x7fc5c8000ce8, packet=0x7fc5c8189939 "DROP SCHEMA DB1", packet_length=15, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1832
      #17 0x00005623e9f9f956 in do_command (thd=0x7fc5c8000ce8) at sql/sql_parse.cc:1386
      #18 0x00005623ea0f2633 in do_handle_one_connection (connect=0x5623eceb7628) at sql/sql_connect.cc:1335
      #19 0x00005623ea0f23b3 in handle_one_connection (arg=0x5623eceb7628) at sql/sql_connect.cc:1241
      #20 0x00005623ea91f8e5 in pfs_spawn_thread (arg=0x5623ecec4478) at storage/perfschema/pfs.cc:1862
      #21 0x00007fc5fd2547fc in start_thread (arg=0x7fc5f6bf8700) at pthread_create.c:465
      #22 0x00007fc5fc68eb5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      innodb_force_recovery <= 4 does not end with crash.
       
      10.2 commit b90918dae33f8e3be4af2915984b5a4587e69f89 2019-05-21
      
      

        Attachments

          Activity

            People

            • Assignee:
              marko Marko Mäkelä
              Reporter:
              mleich Matthias Leich
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: