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

SEQUENCE doesn't work after UNINSTALL + INSTALL PLUGIN

    XMLWordPrintable

Details

    Description

      Suppose I have Sequence installed and I use it. If I uninstall it, I get a warning (plugin is busy, will be uninstalled on shutdown). Then I change my mind and I reinstall it. No warnings. But I am not able to access any Sequence table, except for the ones I used before.

      MariaDB [test]> SELECT seq FROM seq_2_to_3;
      +-----+
      | seq |
      +-----+
      |   2 |
      |   3 |
      +-----+
      2 rows in set (0.01 sec)
       
      MariaDB [test]> UNINSTALL SONAME 'ha_sequence';
      Query OK, 0 rows affected, 1 warning (0.04 sec)
       
      MariaDB [test]> SHOW WARNINGS;
      +---------+------+----------------------------------------------------+
      | Level   | Code | Message                                            |
      +---------+------+----------------------------------------------------+
      | Warning | 1620 | Plugin is busy and will be uninstalled on shutdown |
      +---------+------+----------------------------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> INSTALL SONAME 'ha_sequence';
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> SELECT seq FROM seq_2_to_3;
      +-----+
      | seq |
      +-----+
      |   2 |
      |   3 |
      +-----+
      2 rows in set (0.00 sec)
       
      MariaDB [test]> SELECT seq FROM seq_22_to_33;
      ERROR 1146 (42S02): Table 'test.seq_22_to_33' doesn't exist

      Attachments

        Activity

          People

            serg Sergei Golubchik
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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