Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6784

uninstall rocksdb may core

    XMLWordPrintable

    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: