Details
Description
When an installed plugin can't be loaded at startup as its .so file can't be found anymore, e.g. after switching form MySQL to MariaDB with a MySQL-only plugin installed, or when having a deprecated plugin still installed and the .so removed due to a version upgrade, the error log will contain warnings about not being able to load the plugin, but the plugin can't be removed with UNINSTALL PLUGIN or UNINSTALL SONAME.
It can only be removed by deleting the related row in the mysql.plugin table direrctly with DELETE FROM mysql.plugin WHERE name='...'
It should be able to remove a plugin with UNINSTALL even if it couldn't initialize for whatever reason, including missing .so file
Attachments
Issue Links
- relates to
-
MDEV-22085 mysql_upgrade should check for unavailable plugin libraries
-
- Closed
-
- split to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.4 [ 22408 ] | |
| Assignee | Sergei Golubchik [ serg ] |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Link |
This issue relates to |
Same problem for DROP FUNCTION if the implementation .so is missing...
Should I add an extra MDEV for that, or is mentioning it here sufficient?
(Also I seem to remember some upcoming change to UDF loading anyway, away from CREATE/DROP FUNCTION towards INSTALL/UNINSTALL PLUGIN ... can't find any reference to this anymore though. Was that planned for 10.6?)
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
hholzgra Is it only 10.4 problem? (taking into account that you want to attach UDF here)
I see UNINSTALL PLUGIN even in 10.1, and doubts that there is no such problem...
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.5 [ 23123 ] |
Tking into account TTL of 10.1 I think it has no sens to fix it there.
Test suite for this bug:
--source include/not_windows.inc
|
--source include/not_embedded.inc
|
--source include/have_example_plugin.inc
|
let $PLUGIN_DIR=`select @@plugin_dir`;
|
|
|
# make copy of so file because other tests can use the so in parallel
|
--copy_file $PLUGIN_DIR/ha_example.so $PLUGIN_DIR/ha_example2.so
|
|
|
INSTALL PLUGIN example SONAME 'ha_example2';
|
|
|
--remove_file $PLUGIN_DIR/ha_example2.so
|
|
|
# restart server otherwise it uninstall plugin with no problem because it is
|
# loaded
|
--source include/restart_mysqld.inc
|
|
|
# check that we have the plugin installed
|
select * from mysql.plugin WHERE name='example';
|
|
|
# make attempt to uninstall the plugin
|
UNINSTALL PLUGIN example;
|
| Link |
This issue split to |
| Fix Version/s | 10.2.33 [ 24307 ] | |
| Fix Version/s | 10.3.24 [ 24306 ] | |
| Fix Version/s | 10.4.14 [ 24305 ] | |
| Fix Version/s | 10.5.5 [ 24423 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 101740 ] | MariaDB v4 [ 157072 ] |
| Zendesk Related Tickets | 193960 172155 120121 |
I agree that UINSTALL PLUGIN should work. Just like DROP TABLE works if the table is corrupted.