Details
Major Description
When an installed UDF can't be loaded at startup as its .so file can't be found anymore,, the error log will contain warnings about not being able to load the function
[ERROR] Can't open shared library 'udf_test.so' (errno: 0, cannot open shared object file: No such file or directory)
|
but the function can't be removed with DROP FUNCTION:
MariaDB [(none)]> drop function foo;
|
ERROR 1305 (42000): FUNCTION (UDF) foo does not exist
|
It can only be removed by deleting the related row in the mysql.func table directly with
DELETE FROM mysql.func WHERE name='...'
It should be able to remove a function with DROP even if it couldn't initialize for whatever reason, including missing .so file
Attachments
Issue Links
- split from
-
MDEV-21258 Can't uninstall plugin if the library file doesn't exist
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue split from |
| Assignee | Oleksandr Byelkin [ sanja ] |
Main problem with the case is that we remove UDF and SP with the same command.
commit 2792940391a17b6784f3d4dea2285a14356205ae (HEAD > bb-10.2MDEV-23327, origin/bb-10.2-MDEV-23327)
Author: Oleksandr Byelkin <sanja@mariadb.com>
Date: Wed Jul 29 21:54:24 2020 +0200
MDEV-23327 Can't uninstall UDF if the implementation library file doesn't exist
Made cleanup of DROP (udf) FUNCTION procedure and also check of mysql.func (not only loaded udf).
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Sergei Golubchik [ serg ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Description |
When an installed UDF can't be loaded at startup as its .so file can't be found anymore,, the error log will contain warnings about not being able to load the function
{{[ERROR] Can't open shared library 'udf_test.so' (errno: 0, cannot open shared object file: No such file or directory) }} but the function can't be removed with DROP FUNCTION: {noformat} MariaDB [(none)]> drop function foo; ERROR 1305 (42000): FUNCTION (UDF) foo does not exist {noformat} It can only be removed by deleting the related row in the mysql.func table directly with {{DELETE FROM mysql.func WHERE name='...'}} It should be able to remove a function with DROP even if it couldn't initialize for whatever reason, including missing .so file |
When an installed UDF can't be loaded at startup as its .so file can't be found anymore,, the error log will contain warnings about not being able to load the function
[ERROR] Can't open shared library 'udf_test.so' (errno: 0, cannot open shared object file: No such file or directory) but the function can't be removed with DROP FUNCTION: {noformat} MariaDB [(none)]> drop function foo; ERROR 1305 (42000): FUNCTION (UDF) foo does not exist {noformat} It can only be removed by deleting the related row in the mysql.func table directly with {{DELETE FROM mysql.func WHERE name='...'}} It should be able to remove a function with DROP even if it couldn't initialize for whatever reason, including missing .so file |
| Description |
When an installed UDF can't be loaded at startup as its .so file can't be found anymore,, the error log will contain warnings about not being able to load the function
[ERROR] Can't open shared library 'udf_test.so' (errno: 0, cannot open shared object file: No such file or directory) but the function can't be removed with DROP FUNCTION: {noformat} MariaDB [(none)]> drop function foo; ERROR 1305 (42000): FUNCTION (UDF) foo does not exist {noformat} It can only be removed by deleting the related row in the mysql.func table directly with {{DELETE FROM mysql.func WHERE name='...'}} It should be able to remove a function with DROP even if it couldn't initialize for whatever reason, including missing .so file |
When an installed UDF can't be loaded at startup as its .so file can't be found anymore,, the error log will contain warnings about not being able to load the function
{noformat}[ERROR] Can't open shared library 'udf_test.so' (errno: 0, cannot open shared object file: No such file or directory){noformat} but the function can't be removed with DROP FUNCTION: {noformat} MariaDB [(none)]> drop function foo; ERROR 1305 (42000): FUNCTION (UDF) foo does not exist {noformat} It can only be removed by deleting the related row in the mysql.func table directly with {{DELETE FROM mysql.func WHERE name='...'}} It should be able to remove a function with DROP even if it couldn't initialize for whatever reason, including missing .so file |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
commit 5b86139118d8fe32b90caeaa4282edc2879cfcb5 (HEAD > bb-10.2MDEV-23327, origin/bb-10.2-MDEV-23327)
Author: Oleksandr Byelkin <sanja@mariadb.com>
Date: Wed Jul 29 21:54:24 2020 +0200
MDEV-23327 Can't uninstall UDF if the implementation library file doesn't exist
Made cleanup of DROP (udf) FUNCTION procedure and also check of mysql.func (not only loaded udf).
| Assignee | Oleksandr Byelkin [ sanja ] | Sergei Golubchik [ serg ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Component/s | OTHER [ 10125 ] | |
| Fix Version/s | 10.2.35 [ 25022 ] | |
| Fix Version/s | 10.3.26 [ 25021 ] | |
| Fix Version/s | 10.4.16 [ 25020 ] | |
| Fix Version/s | 10.5.7 [ 25019 ] | |
| 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 | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 111781 ] | MariaDB v4 [ 158160 ] |
| Zendesk Related Tickets | 184036 |
There is minor security problem with UDF first we check presence of UDF and only then rights to delete