Uploaded image for project: 'FTS'
  1. FTS
  2. FTS-443

Make sure transactions are closed when the session falls out of scope

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: fts-rest 3.4.1
    • Component/s: REST API
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • Labels:
      None

      Description

      Python DB API issues an implicit BEGIN on the first query of a connection. The BEGIN is implicit, but the closing (rollback or commit) is not.
      Combined with the default isolation level 'REPEATABLE-READ', causes trouble, since jobs that do exists are not yet seen by other connections since they remain in an open transaction.

      It seems base.py:36 is either not being executed, or it is not rolling back implicit begins.

        Attachments

          Activity

            People

            • Assignee:
              aalvarez Alejandro Alvarez Ayllon
              Reporter:
              aalvarez Alejandro Alvarez Ayllon
              Component Watchers:
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: