Uploaded image for project: 'Pegasus'
  1. Pegasus
  2. PM-943

add pragma with timeout when database is locked

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: master
    • Fix Version/s: master, 4.6.0, 4.5.1
    • Component/s: Pegasus Dashboard
    • Labels:
      None

      Description

      Hi Rajiv, Karan,

      Another bug with dashboard in 4.5.0. If the user tries to access a workflow database when it’s being written to, they get

      Internal Server Error
      The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

      The apache log shows

      [Thu Jun 11 08:13:23 2015] [error] OperationalError: (OperationalError) database is locked "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name" ()

      Please can you add a pragma with a reasonable time out, perhaps explaining to the user why they have to wait, with something like conn.execute("PRAGMA busy_timeout = 30000”), or display a more meaningful error message (or, better, figure out a way around the lock).

      Cheers,
      Duncan.

        Attachments

          Activity

            People

            • Assignee:
              rafsilva Rafael Ferreira Da Silva
              Reporter:
              dbrown Duncan Brown
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: