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

Follow up on vTpch22.sql hanging

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.4.2
    • 1.4.3
    • ExeMgr
    • None
    • Centos 7
    • 2020-2

    Description

      Validating the merge for the next 1.4 release. vTpch22.sql keeps hanging for me. Looks to me like there is a joblist abort problem. I think the joblist threadpool in exemgr happens to run out of threads at this query. The queries themselves run successfully after a restart.

      Attachments

        1. aCreateViews.sql
          7 kB
        2. mcol-3776-backtraces.txt
          201 kB
        3. vTpch22.sql
          0.8 kB

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4957 Functions on TIMESTAMP columns in projection, e.g. year(timestamp_col) slows down SELECT 50x.

          • Major - Major loss of function.
          • Closed
          split to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3792 All queries share a timezone

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            pleblanc Patrick LeBlanc (Inactive) created issue -
            pleblanc Patrick LeBlanc (Inactive) made changes -
            Field Original Value New Value
            Attachment mcol-3776-backtraces.txt [ 50455 ]
            pleblanc Patrick LeBlanc (Inactive) added a comment -

            the link with mcol-3716 was a series of coincidences it seems. I've reproduced it in dev-1.4 @ commit 4b4198608, which doesn't include 3716.

            Reproduced by running vTpch22.sql in a loop on a clean installation.

            pleblanc Patrick LeBlanc (Inactive) added a comment - the link with mcol-3716 was a series of coincidences it seems. I've reproduced it in dev-1.4 @ commit 4b4198608, which doesn't include 3716. Reproduced by running vTpch22.sql in a loop on a clean installation.
            pleblanc Patrick LeBlanc (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            pleblanc Patrick LeBlanc (Inactive) made changes -
            pleblanc Patrick LeBlanc (Inactive) made changes -
            Assignee Patrick LeBlanc [ pleblanc ] Gagan Goel [ tntnatbry ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            pleblanc Patrick LeBlanc (Inactive) added a comment -

            Found & fixed the problem. The timezone var in the Functor class is read & written concurrently, but which had no sync. Added sync to prevent the crashes. Created MCOL-3792 to followup on other repercussions of that being a var shared between queries.

            pleblanc Patrick LeBlanc (Inactive) added a comment - Found & fixed the problem. The timezone var in the Functor class is read & written concurrently, but which had no sync. Added sync to prevent the crashes. Created MCOL-3792 to followup on other repercussions of that being a var shared between queries.
            tntnatbry Gagan Goel (Inactive) made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            tntnatbry Gagan Goel (Inactive) made changes -
            Assignee Gagan Goel [ tntnatbry ] Daniel Lee [ dleeyh ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            pleblanc Patrick LeBlanc (Inactive) made changes -
            Attachment aCreateViews.sql [ 50509 ]
            pleblanc Patrick LeBlanc (Inactive) made changes -
            Attachment vTpch22.sql [ 50510 ]
            pleblanc Patrick LeBlanc (Inactive) added a comment -

            i attached the files i was using to reproduce it. run aCreateViews.sql, then run vTpch22.sql in a loop 100x.

            For me, I was able to reproduce the crash in < 10 iterations. Will be different for everybody.

            pleblanc Patrick LeBlanc (Inactive) added a comment - i attached the files i was using to reproduce it. run aCreateViews.sql, then run vTpch22.sql in a loop 100x. For me, I was able to reproduce the crash in < 10 iterations. Will be different for everybody.
            dleeyh Daniel Lee (Inactive) added a comment -

            Build verified: 1.4.3-1 BB nightly

            engine commit:
            1a65d34

            1.4.2-1
            executed vTpch.sql in a loop of 100. primproc failed after 9 runs.

            1.4.3-1
            ran to completion of 100 iterations.

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.4.3-1 BB nightly engine commit: 1a65d34 1.4.2-1 executed vTpch.sql in a loop of 100. primproc failed after 9 runs. 1.4.3-1 ran to completion of 100 iterations.
            dleeyh Daniel Lee (Inactive) made changes -
            issue.field.resolutiondate 2020-02-18 22:45:52.0 2020-02-18 22:45:52.3
            dleeyh Daniel Lee (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Team ColumnStore Team
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            drrtuy Roman made changes -

            People

              dleeyh Daniel Lee (Inactive)
              pleblanc Patrick LeBlanc (Inactive)
              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.