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

Server hangs when using --init-file which loads Spider and creates a Spider table

Details

    Description

      This issue is high priority as it affects Spider testing.

      # mysqld options required for replay:  --init-file=${PWD}/in.sql
      		 
       
      		 
      $ cat in.sql
      		 
      INSTALL PLUGIN spider SONAME 'ha_spider.so';
      		 
      USE test;
      		 
      CREATE TABLE t (c INT) ENGINE=SPIDER;

      Will make the server hang on startup. Attempted CLI connects will also hang. Removing either the INSTALL PLUGIN or the USE test from the testcase will make the server start correctly.

      Bug confirmed present in:
      MariaDB: 10.4.23 (dbg), 10.4.23 (opt), 10.5.14 (dbg), 10.5.14 (opt), 10.6.6 (dbg), 10.6.6 (opt), 10.7.2 (dbg), 10.7.2 (opt), 10.8.0 (dbg), 10.8.0 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.42 (dbg), 10.2.42 (opt), 10.3.33 (dbg), 10.3.33 (opt)

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-27253 Reorganize Spider plugin variables regarding table/index stats

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27575 Spider: UBSAN member access within null pointer of type 'struct st_plugin_int and SIGSEGV in intern_plugin_lock on SHUTDOWN when setting Spider as default storage engine (temporary or global)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29870 Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29904 SPIDER plugin initialization fails upon startup

          • Major - Major loss of function.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22979 "mysqld --bootstrap" / mysql_install_db hangs when Spider is installed

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20179 Server hangs on shutdown during installation of Spider

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19842 Crash while creating statistics for Spider table

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27095 Simplify spider init queries

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27103 mariadb-upgrade fails with 'System table spider_tables is different version' => Can't create database 'performance_schema'

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27614 SQL service crashes on some queries sent by SPIDER engine.

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29870 Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27575 Spider: UBSAN member access within null pointer of type 'struct st_plugin_int and SIGSEGV in intern_plugin_lock on SHUTDOWN when setting Spider as default storage engine (temporary or global)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30370 mariadbd hangs when running with --wsrep-recover and --plugin-load-add=ha_spider.so

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 25 older comments
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - - edited

            I've extracted the 10.4-10.6 part to another issue. It will be handled by MDEV-29870.

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - - edited I've extracted the 10.4-10.6 part to another issue. It will be handled by MDEV-29870 .
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment -

            The fix has been reverted due to MDEV-29904. Thus, I reopened the issue.

            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - The fix has been reverted due to MDEV-29904 . Thus, I reopened the issue.
            Roel Roel Van de Paar added a comment - - edited

            Also reminder to add the extra MTR testcase mentioned here as part of a patch for this bug. Thank you

            Roel Roel Van de Paar added a comment - - edited Also reminder to add the extra MTR testcase mentioned here as part of a patch for this bug. Thank you
            ycp Yuchen Pei added a comment - - edited

            > Also reminder to add the extra MTR testcase mentioned here as part of a patch for this bug. Thank you

            Thanks for the reminder. Already done as part of MDEV-30581 I should have probably marked that as related to MDEV-29904 - will do that.

            ycp Yuchen Pei added a comment - - edited > Also reminder to add the extra MTR testcase mentioned here as part of a patch for this bug. Thank you Thanks for the reminder. Already done as part of MDEV-30581 I should have probably marked that as related to MDEV-29904 - will do that.
            ycp Yuchen Pei added a comment -

            MDEV-22979, once pushed, will fix this bug.

            ycp Yuchen Pei added a comment - MDEV-22979 , once pushed, will fix this bug.

            People

              ycp Yuchen Pei
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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