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

Server crashes in mysql_admin_table upon killing ANALYZE

    XMLWordPrintable

    Details

    • Sprint:
      10.2.5-1

      Description

      Important notes:

      • Do not add this test to the MTR suite! Create a proper one instead when the reason of the crash is known.
      • Run the test with --repeat=N
      • Do not run the test in shm, it's too fast, the chances of hitting the failure are less

      --source include/have_innodb.inc
       
      SET GLOBAL innodb_stats_persistent= ON; 
      SET GLOBAL use_stat_tables= PREFERABLY;
       
      --connect (con1,localhost,root,,)
      SET NAMES utf8;
      CREATE TABLE t1 (
      `id` int(10) unsigned NOT NULL auto_increment,
      `k` int(10) unsigned NOT NULL default '0',
      `c` char(120) NOT NULL default '',
      `pad` char(60) NOT NULL default '',
      KEY `k` (`k`),
      PRIMARY KEY (`id`)) ENGINE=InnoDB;
       
      BEGIN;
      INSERT INTO t1 VALUES (NULL,1,'foo','foo'),(NULL,2,'bar','bar');
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;
      COMMIT;
       
      CREATE TABLE t2 LIKE t1;
      INSERT INTO t2 SELECT * FROM t1;
      CREATE TABLE t3 LIKE t1;
      INSERT INTO t3 SELECT * FROM t1;
      CREATE TABLE t4 LIKE t1;
      INSERT INTO t4 SELECT * FROM t1;
      CREATE TABLE t5 LIKE t1;
      INSERT INTO t5 SELECT * FROM t1;
      CREATE TABLE t6 LIKE t1;
      INSERT INTO t6 SELECT * FROM t1;
      CREATE TABLE t7 LIKE t1;
      INSERT INTO t7 SELECT * FROM t1;
      CREATE TABLE t8 LIKE t1;
      INSERT INTO t8 SELECT * FROM t1;
      CREATE TABLE t9 LIKE t1;
      INSERT INTO t9 SELECT * FROM t1;
      CREATE TABLE t10 LIKE t1;
      INSERT INTO t10 SELECT * FROM t1;
      CREATE TABLE t11 LIKE t1;
      INSERT INTO t11 SELECT * FROM t1;
      CREATE TABLE t12 LIKE t1;
      INSERT INTO t12 SELECT * FROM t1;
      CREATE TABLE t13 LIKE t1;
      INSERT INTO t13 SELECT * FROM t1;
      CREATE TABLE t14 LIKE t1;
      INSERT INTO t14 SELECT * FROM t1;
      CREATE TABLE t15 LIKE t1;
      INSERT INTO t15 SELECT * FROM t1;
      CREATE TABLE t16 LIKE t1;
      INSERT INTO t16 SELECT * FROM t1;
      CREATE TABLE t17 LIKE t1;
      INSERT INTO t17 SELECT * FROM t1;
      CREATE TABLE t18 LIKE t1;
      INSERT INTO t18 SELECT * FROM t1;
      CREATE TABLE t19 LIKE t1;
      INSERT INTO t19 SELECT * FROM t1;
      CREATE TABLE t20 LIKE t1;
      INSERT INTO t20 SELECT * FROM t1;
      --disconnect con1
       
      --connect (con1,localhost,root,,)
      #SET max_statement_time= 1;
      --let $con_id= `SELECT CONNECTION_ID()`
      send ANALYZE TABLE t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20;
       
      --connection default
      sleep 0.5;
      eval KILL QUERY $con_id;
       
      --connection con1
      --reap
      

      10.2 f2fe65106f731df48072a16eea3cda0a903d7fe5

      #3  <signal handler called>
      #4  0x00007fb00c0b984a in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7fafe3816070, tables=0x7fafe3864200, check_opt=0x7fafe381aa08, operator_name=0x7fb00ca1ab57 "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x7fb00c1d68b8 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.2/sql/sql_admin.cc:811
      #5  0x00007fb00c0bb611 in Sql_cmd_analyze_table::execute (this=0x7fafe397ff80, thd=0x7fafe3816070) at /data/src/10.2/sql/sql_admin.cc:1284
      #6  0x00007fb00bf6e7a4 in mysql_execute_command (thd=0x7fafe3816070) at /data/src/10.2/sql/sql_parse.cc:6165
      #7  0x00007fb00bf73080 in mysql_parse (thd=0x7fafe3816070, rawbuf=0x7fafe3864088 "ANALYZE TABLE t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20", length=103, parser_state=0x7fb00d032dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7839
      #8  0x00007fb00bf60c46 in dispatch_command (command=COM_QUERY, thd=0x7fafe3816070, packet=0x7fafe3858071 "", packet_length=103, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1799
      #9  0x00007fb00bf5f620 in do_command (thd=0x7fafe3816070) at /data/src/10.2/sql/sql_parse.cc:1359
      #10 0x00007fb00c0a73d2 in do_handle_one_connection (connect=0x7fb008c72130) at /data/src/10.2/sql/sql_connect.cc:1354
      #11 0x00007fb00c0a715f in handle_one_connection (arg=0x7fb008c72130) at /data/src/10.2/sql/sql_connect.cc:1260
      #12 0x00007fb00c3e5d64 in pfs_spawn_thread (arg=0x7faff63edef0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #13 0x00007fb00b5930a4 in start_thread (arg=0x7fb00d034300) at pthread_create.c:309
      #14 0x00007fb00954087d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      The problem was apparently introduced by this commit:

      commit 86975e0492c03535271aea67e0b5e7e8fd0b1b78
      Author: Oleksandr Byelkin <sanja@mariadb.com>
      Date:   Mon Aug 1 19:24:55 2016 +0200
       
          MDEV-7901: re-implement analyze table for low impact
          
          Table before collecting engine independent statistics now is reopened in read mode,
          InnoDB allow write operations in this case.
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: