Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2442

Blocking during with clause processing has adverse affects

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: 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.

      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.

        Gliffy Diagrams

          Activity

          Hide
          shawkins 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
          shawkins 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
          shawkins 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
          shawkins 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:
              shawkins Steven Hawkins
              Reporter:
              shawkins Steven Hawkins
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development