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

Server with WSREP hangs after INSERT, wrong usage of mutex 'LOCK_thd_data' and 'share->intern_lock' / 'lock->mutex'

    XMLWordPrintable

Details

    Description

      --source include/galera_cluster.inc
       
      CREATE TABLE t1 (a INT);
       
      --connect (con1,localhost,root,,test)
      --let $con1= `SELECT CONNECTION_ID()`
      INSERT INTO t1 VALUES (1),(2),(3),(4);
       
      --connection default
      --error ER_TARGET_NOT_EXPLAINABLE
      eval SHOW EXPLAIN FOR $con1;
       
      --connection con1
      INSERT INTO t1 VALUES (5),(6),(7),(8);
       
      # Cleanup
      --disconnect con1
      --connection default
      --reap
      DROP TABLE t1;
      

      The test hangs upon 2nd INSERT, seemingly forever.
      The process list shows this:

      10.4 7f03a933

      +----+-------------+-----------------+------+---------+------+--------------------------+-----------------------+----------+
      | Id | User        | Host            | db   | Command | Time | State                    | Info                  | Progress |
      +----+-------------+-----------------+------+---------+------+--------------------------+-----------------------+----------+
      |  1 | system user |                 | NULL | Sleep   |   83 | wsrep aborter idle       | NULL                  |    0.000 |
      |  2 | system user |                 | NULL | Sleep   |   83 |                          | NULL                  |    0.000 |
      |  4 | system user |                 | NULL | Daemon  | NULL | InnoDB purge worker      | NULL                  |    0.000 |
      |  5 | system user |                 | NULL | Daemon  | NULL | InnoDB purge worker      | NULL                  |    0.000 |
      |  6 | system user |                 | NULL | Daemon  | NULL | InnoDB purge worker      | NULL                  |    0.000 |
      |  3 | system user |                 | NULL | Daemon  | NULL | InnoDB purge coordinator | NULL                  |    0.000 |
      |  7 | system user |                 | NULL | Daemon  | NULL | InnoDB shutdown handler  | NULL                  |    0.000 |
      | 17 | root        | localhost       | test | Sleep   |   73 |                          | NULL                  |    0.000 |
      | 18 | root        | localhost:39086 | test | Sleep   |   73 |                          | NULL                  |    0.000 |
      | 19 | root        | localhost       |      | Busy    |   73 | Init                     | NULL                  |    0.000 |
      | 20 | root        | localhost:39096 | NULL | Query   |    0 | Init                     | show full processlist |    0.000 |
      +----+-------------+-----------------+------+---------+------+--------------------------+-----------------------+----------+
      

      All threads' stack trace is attached as hang_all_threads.txt.

      Reproducible on 10.4 and 10.5, debug and non-debug builds alike, with a cluster (e.g. inside the galera suite) as well as with one node with wsrep enabled, with InnoDB and MyISAM.

      Couldn't reproduce on 10.3.
      Couldn't reproduce without wsrep_on.

      Occasionally, while hanging the same way, some builds also produce a mutex error in the log:

      safe_mutex: Found wrong usage of mutex 'LOCK_thd_data' and 'share->intern_lock'
      Mutex currently locked (in reverse order):
      share->intern_lock                /data/src/10.5e/storage/myisam/mi_locking.c  line 57
      LOCK_thd_data                     /data/src/10.5e/sql/sql_parse.cc  line 9096
      safe_mutex: Found wrong usage of mutex 'LOCK_thd_data' and 'lock->mutex'
      Mutex currently locked (in reverse order):
      lock->mutex                       /data/src/10.5e/mysys/thr_lock.c  line 763
      LOCK_thd_data                     /data/src/10.5e/sql/sql_parse.cc  line 9096
      

      The error appears in the log sporadically. I assume it is related.

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.