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

innodb.innodb_sys_semaphore_waits and other tests fail

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.4.13
    • N/A
    • Tests
    • Wind River Linux LTS 18.44

    Description

      innodb.innodb_sys_semaphore_waits test fails when running on my intended appliance operating platform. I ran ./mtr innodb.innodb_sys_semaphore_waits in a clean test tree.

      var/log/innodb_sys_semaphore_waits.log contains:

      connect  con1,localhost,root,,;
      connect  con2,localhost,root,,;
      drop table if exists t1;
      connection con1;
      create table t1 (id integer, x integer) engine = InnoDB;
      insert into t1 values(0, 0);
      SET @saved_dbug = @@SESSION.debug_dbug;
      set DEBUG_DBUG='+d,fatal-semaphore-timeout';
      set autocommit=0;
      # Sending query on con1,
      # the session will hold lock table mutex and sleep
      SELECT * from t1 where id = 0 FOR UPDATE;
      connection con2;
      set autocommit=0;
      # Sending query on con2,
      # the session will be blocked on the lock table mutex and
      # thus be put into sync arry
      SELECT * from t1 where id = 0 FOR UPDATE;
      connection default;
      # Waitting for mysqld to crash
      

      A full test run, with --big-test --force --testcase-timeout=30 --suite-timeout=1000 --shutdown-timeout=20 eventually yielded:

      Completed: Failed 9/4997 tests, 99.82% were successful.
       
      Failing test(s): binlog_encryption.binlog_xa_recover binlog.binlog_xa_recover innodb.innodb_sys_semaphore_waits sys_vars.innodb_fatal_semaphore_wait_threshold main.failed_auth_unixsocket main.ssl_cipher unit.conc_charset unit.pcre_grep_test unit.pcre_test
       
      The log files in var/log may give you some hint of what went wrong.
       
      If you want to report this error, please read first the documentation
      at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
       
      Errors/warnings were found in logfiles during server shutdown after running the
      following sequence(s) of tests:
          innodb.innodb_sys_semaphore_waits
          sys_vars.innodb_fatal_semaphore_wait_threshold
      367 tests were skipped, 288 by the test itself.
      

      Please let me know if any of these are likely non-issues, or if there are other logs I can supply from this test run. I am especially concerned that there are semaphore tests that failed, as well as other "important-seeming" tests like main.ssl_cipher and a couple unit. tests.

      Attachments

        Activity

          People

            Unassigned Unassigned
            cross Chris Ross
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.