[MDEV-32180] Spider does not clean up UDFs upon deinstallation Created: 2023-09-15  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.4, 10.5, 10.6, 10.10, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Upon installation, Spider creates several UDFs

10.4 1adfdfbd

+------------------------------+-----+--------------+-----------+
| name                         | ret | dl           | type      |
+------------------------------+-----+--------------+-----------+
| spider_direct_sql            |   2 | ha_spider.so | function  |
| spider_bg_direct_sql         |   2 | ha_spider.so | aggregate |
| spider_ping_table            |   2 | ha_spider.so | function  |
| spider_copy_tables           |   2 | ha_spider.so | function  |
| spider_flush_table_mon_cache |   2 | ha_spider.so | function  |
+------------------------------+-----+--------------+-----------+

When the engine is uninstalled, the functions remain in mysql.func table.

In case of package installation it means that if the package is uninstalled, the library is removed and all consequent server startups throw errors

2023-09-15 18:18:55 0 [Note] Server socket created on IP: '::'.
2023-09-15 18:18:55 0 [ERROR] Can't open shared library 'ha_spider.so' (errno: 2, cannot open shared object file: No such file or directory)
2023-09-15 18:18:55 0 [ERROR] Can't open shared library 'ha_spider.so' (errno: 2, cannot open shared object file: No such file or directory)
2023-09-15 18:18:55 0 [ERROR] Can't open shared library 'ha_spider.so' (errno: 2, cannot open shared object file: No such file or directory)
2023-09-15 18:18:55 0 [ERROR] Can't open shared library 'ha_spider.so' (errno: 2, cannot open shared object file: No such file or directory)
2023-09-15 18:18:55 0 [ERROR] Can't open shared library 'ha_spider.so' (errno: 2, cannot open shared object file: No such file or directory)
2023-09-15 18:18:55 0 [Note] Reading of all Master_info entries succeeded


Generated at Thu Feb 08 10:29:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.