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

Temporary Table Synchronisation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3.18
    • Fix Version/s: 10.3
    • Component/s: Locking
    • Labels:
      None

      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

            Assignee:
            svoj Sergey Vojtovich
            Reporter:
            4dallasc Dallas Clarke
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: