Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32180

Spider does not clean up UDFs upon deinstallation

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4(EOL), 10.5(EOL), 10.6, 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • 10.6, 10.11
    • 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
      

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 2h 41m
                  2h 41m

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.