Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Won't Fix
    • Affects Version/s: 8.0.18-9, 5.7.x
    • Fix Version/s: None
    • Component/s: MyRocks

      Description

      When execute CREATE TABLE LIKE statement,  it cannot uninstall rocksdb, and it may core.

      How to repeat

      I do 2 test, the first below.

      First, unintall failed

       ./mtr  rocksdb.rocksdb --start

      connect to server, execute sql, it cannot uninstall rocksdb engine after CREATE TABLE LIKE

      mysql> create table t1 (c1 int) engine=rocksdb;
      Query OK, 0 rows affected (0.02 sec)

      mysql> create table t1_1 like t1;
      Query OK, 0 rows affected (0.07 sec)

      mysql> uninstall plugin rocksdb;
      Query OK, 0 rows affected, 1 warning (0.00 sec)

      mysql> show warnings;
      ---------------------------------------------------------------

      Level   Code Message                                           

      ---------------------------------------------------------------

      Warning 1620 Plugin is busy and will be uninstalled on shutdown

      ---------------------------------------------------------------
      1 row in set (0.01 sec)

      mysql> drop table t1,t1_1;
      ERROR 1286 (42000): Unknown storage engine 'ROCKSDB'

      Second, uninstall core

       

       ./mtr  rocksdb.rocksdb --start

      connect to server, execute CREATE TABLE LIKE, then DROP TABLE, after that, uninstall rocksdb engine core.

       

      mysql> create table t1 (c1 int) engine=rocksdb;
      Query OK, 0 rows affected (0.06 sec)

      mysql> create table t1_1 like t1;
      Query OK, 0 rows affected (0.02 sec)

      mysql> drop table t1,t1_1;
      Query OK, 0 rows affected (0.03 sec)

      mysql> uninstall plugin rocksdb;
      ERROR 2013 (HY000): Lost connection to MySQL server during query

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                zwfhit phoenix.zhang
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: