Audit plugin cannot be reinstalled
Description
Environment
Centos 6.5
AFFECTED CS IDs
Attachments
Smart Checklist
Activity
Julia Vural March 4, 2025 at 9:02 PM
It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.
Przemyslaw Malkowski October 9, 2020 at 3:17 PM
Actually the problem is with the UNINSTALL part, as for some reason is it leaving the plugin in 'DELETED' status, while it keeps auditing queries:
At this point I can see it is still logging queries. Surprisingly, another INSTALL attempt clears it:
After it stops working and also allows to re-install later.
Lalit Choudhary June 27, 2019 at 7:30 AM
Hello
Thank you for the reproduciable steps. Verified as described with using the above steps.
Iván Groenewold June 26, 2019 at 11:04 AM
Hi Lalit, I validated the issue is not related to the upgrade itself as I tested it also on a fresh 5.7 box. In your test case I see your are bouncing mysql after uninstall, please try without doing that. I think it is related to other sessions still using the plugin. Can you try the following:
1. Start the db and install the plugin
2. Start two independent sessions (keep them open)
3. Uninstall plugin
4. Install plugin (without bouncing the server)
That should be enough to reproduce.
Thanks
Lalit Choudhary April 9, 2019 at 9:06 AM
Also tested on CentOS 6, still not reproduciable.
[root@localhost ~]# cat /etc/redhat-release
CentOS release 6.10 (Final)
On Percona Server 5.7.22-22, after installing and uninstalling the plugin with:
The plugin cannot be installed again. Attempting to run the install statement again would lead to error: