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

Spider uninstall fails with "plugin busy"

    XMLWordPrintable

Details

    Description

      10.10 21822625aa675b36a5c2548f78e8d3d8cde8b7cd

      		 
      install soname 'ha_spider';
      		 
      create table t (c int) Engine=SPIDER;
      		 
      drop table t;
      		 
      uninstall soname 'ha_spider';

      The uninstall statement results in warning:

      Warnings:
      		 
      Warning	1620	Plugin is busy and will be uninstalled on shutdown

      Initial analysis shows this could be caused by a call to thd_set_ha_data(thd, spider_hton_ptr, trx) which increases the ref count to the plugin which later did not get decreased, from spider_get_trx() during the create table statement. See also kentoku's comment in MDEV-7914[1], whose commit is to blame for this call.

      [1] https://jira.mariadb.org/browse/MDEV-7914?focusedCommentId=109258&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-109258

      Trace:

      intern_plugin_lock > plugin_lock > ha_lock_engine > thd_set_ha_data > ha_spider::create > handler::ha_create > create_table_impl > mysql_create_table_no_lock > Sql_cmd_create_table_like::execute > mysql_parse > dispatch_command > do_command > handle_one_connection > pfs_spawn_thread

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32180 Spider does not clean up UDFs upon deinstallation

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33322 Check of testcase failed for random spider tests

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39175 spider/bugfix.mdev_34555 Plugin 'SPIDER' has ref_count=1 after deinitialization

          • Major - Major loss of function.
          • Open
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-7914 spider/bg.ha, spider/bg.ha_part crash server sporadically in buildbot

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39175 spider/bugfix.mdev_34555 Plugin 'SPIDER' has ref_count=1 after deinitialization

          • Major - Major loss of function.
          • Open

          Activity

            People

              ycp Yuchen Pei
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

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

                  Git Integration

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