Teiid
  1. Teiid
  2. TEIID-2442

Blocking during with clause processing has adverse affects

    Details

    • Type: Bug Bug
    • Status: Closed Closed (View Workflow)
    • Priority: Blocker Blocker
    • Resolution: Done
    • Affects Version/s: 8.1
    • Fix Version/s: 8.4
    • Component/s: Query Engine
    • Labels:
      None
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      If the query is executed transactionally, source concurrency is set to 1, or the sources used by the with clause are non-forkable, then blocking will not occur.

      Show
      If the query is executed transactionally, source concurrency is set to 1, or the sources used by the with clause are non-forkable, then blocking will not occur.
    • Similar Issues:
      Show 10 results 

      Description

      A blocked exception, such that is typically thrown while waiting for results, that happens during the with clause load will cause the parent command to be rexecuted. This can lead to erroneous source queries and eventually exhaust connections.

        Activity

        Hide
        Steven Hawkins
        added a comment -

        The temptable datamanager will catch unexpected blocks and return a tuplesource that may throw blocked exceptions at a later time.

        Show
        Steven Hawkins
        added a comment - The temptable datamanager will catch unexpected blocks and return a tuplesource that may throw blocked exceptions at a later time.
        Hide
        Steven Hawkins
        added a comment -

        The workaround does not appear to be sufficient in situations where an expired timeslice exception is thrown. This issue should likely be added to the 8.3 patch set.

        Show
        Steven Hawkins
        added a comment - The workaround does not appear to be sufficient in situations where an expired timeslice exception is thrown. This issue should likely be added to the 8.3 patch set.

          People

          • Assignee:
            Steven Hawkins
            Reporter:
            Steven Hawkins
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: