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

Temporary Table Synchronisation

    XMLWordPrintable

Details

    Description

      I'm having this issue in my production system where it appears that only 1 query can execute with a temporary table at a time, and all other queries that require a temporary table are getting stuck in a "waiting for metadata lock" state.

      This is causing an issue when the executing query is taking a considerable time to execute, and bots/crons then consume all available connections until the system crashes, I log into the system and kill the stalled query and all other queries just execute.

      Is there a setting that I can use to allow multiple temporary tables at the same time? Or is this a known problem where the creation of temporary table is not releasing the metadata lock until the deletion of the temporary table?

      Attachments

        1. innodb status.txt
          29 kB
        2. innodb status 2.txt
          37 kB
        3. process list.txt
          24 kB
        4. full process list.txt
          197 kB

        Activity

          People

            wlad Vladislav Vaintroub
            4dallasc Dallas Clarke
            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.