LP #1528972: Audit plugin cannot be reinstalled
Description
Environment
Smart Checklist
Activity
Laurynas Biveinis March 26, 2019 at 9:35 AM
@Iván Groenewold, please file a new issue. Thanks!
Iván Groenewold March 25, 2019 at 2:41 PM
I am running into the same issue with 5.7.24-27. Can this be reopened?
mysql> UNINSTALL PLUGIN audit_log;
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.00 sec)
mysql> INSTALL PLUGIN audit_log SONAME 'audit_log.so'
-> ;
ERROR 1125 (HY000): Function 'audit_log' already exists
mysql> SELECT * FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME='audit_log'\G
*************************** 1. row ***************************
PLUGIN_NAME: audit_log
PLUGIN_VERSION: 0.2
PLUGIN_STATUS: DELETED
PLUGIN_TYPE: AUDIT
PLUGIN_TYPE_VERSION: 4.1
PLUGIN_LIBRARY: audit_log.so
PLUGIN_LIBRARY_VERSION: 1.7
PLUGIN_AUTHOR: Percona LLC and/or its affiliates.
PLUGIN_DESCRIPTION: Audit log
PLUGIN_LICENSE: GPL
LOAD_OPTION: ON
1 row in set (0.00 sec)lpjirasync January 24, 2018 at 8:50 AM
**Comment from Launchpad by: monty solomon on: 23-09-2016 04:00:22
When uninstall a audit plugin, there is a warning info which is not correct
https://bugs.mysql.com/bug.php?id=72217
lpjirasync January 24, 2018 at 8:50 AM
**Comment from Launchpad by: Launchpad Janitor on: 03-09-2016 04:17:30
[Expired for Percona Server because there has been no activity for 60 days.]
lpjirasync January 24, 2018 at 8:50 AM
**Comment from Launchpad by: Sveta Smirnova on: 04-07-2016 11:43:46
Thank you for the feedback.
I cannot repeat described re-install failure with latest versions 5.6.30 and 5.5.49. However warning "Warning (Code 1620): Plugin is busy and will be uninstalled on shutdown" still printed. Please check these versions and inform us if it still affects you.
Details
Details
Assignee
Reporter
Labels
Priority
LowSmart Checklist
Open Smart Checklist
Smart Checklist
**Reported in Launchpad by Yaning last update 23-09-2016 04:00:23
On Percona Server, after installing and uninstalling the plugin with:
INSTALL PLUGIN audit_log SONAME 'audit_log.so';
UNINSTALL PLUGIN audit_log;
The plugin cannot be installed again. Attempting to run the install statement again would lead to error:
"Function 'audit_log' already exists"
However running "SELECT * FROM mysql.proc" does not yield such function. What's going on?