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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • fts-rest 3.4.1
    • None
    • REST API
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • 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

            aalvarez Alejandro Alvarez Ayllon (Inactive)
            aalvarez Alejandro Alvarez Ayllon (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: