Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1062

High concurrency can lock up PrimProc

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.1.3
    • None
    • None
    • 2018-01, 2018-02

    Description

      On my 32vcore machine running 64 parallel queries has a high probability of completely locking up PrimProc.

      My theory is the threads are requesting access to the thread pool for BPP jobs but the thread pool is already maxed out. Causing a wait deadlock.

      Test is using:

      mysqlslap -c64 --number-of-queries=640 --query="select dt, count(*) from test.t1 group by dt" --user=root --socket=/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock"
      

      Test schema and data will be attached shortly.

      Attachments

        1. t.tbl.gz
          1.50 MB
        2. create_t1.sql
          0.1 kB

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              LinuxJedi Andrew Hutchings (Inactive)
              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.