Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11916

TxnHandler.getOpenTxnsInfo() and getOpenTxns() may produce inconsistent result

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.0.1
    • 1.3.0
    • Transactions
    • None

    Description

      both run at READ_COMMITTED isolation level and each runs 2 queries.
      Thus it's possible for a new txn to start/commit after hight water mark is recored by these methods. So the returned list may have txns above the HWM.

      This can be fixed by adding "WHERE TXN_ID < hwm" clause to 2nd query in each case

      Attachments

        1. HIVE-11916.patch
          3 kB
          Eugene Koifman

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            ekoifman Eugene Koifman Assign to me
            ekoifman Eugene Koifman
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment