[MDEV-4887] Sequence plugin is always busy? Created: 2013-08-11  Updated: 2013-08-11  Resolved: 2013-08-11

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Federico Razzoli Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

WinXP


 Description   

If I try to uninstall sequence engine I always get the following warning:

MariaDB [test]> UNINSTALL SONAME 'ha_sequence';
 
Query OK, 0 rows affected, 1 warning (0.00 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)

It doesn't happen with other engines.

I don't know if it's a bug or if it's really a problem... I report it just because you may want to know.

 Comments   
Comment by Sergei Golubchik [ 2013-08-11 ]

It's not a bug. A storage engine plugin is "busy" as long as any table of this engine is still open, even if unused.

Perhaps you have some instances of Sequence tables in the table definition cache. Run FLUSH TABLES — they'll go away and the plugin will be unloaded, there is no need to wait till shutdown.

Generated at Thu Feb 08 06:59:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.