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

add pragma with timeout when database is locked

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • master
    • master, 4.6.0, 4.5.1
    • Pegasus Dashboard
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: