Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-15114

assoc_db_sqlite sometimes encounters "database is locked"

    Details

    • Templates:
    • Story Points:
      6
    • Team:
      Alert Production

      Description

      When running ap_pipe on hits2015 with slurm, several of the tasks ran into a problem with accessing the association database with sqlite3. It says "sqlite3.OperationalError: database is locked."

      After brief discussion with Chris Morrison, the problem likely stems from how the code creates temporary tables when querying for DIASources or DIAObjects. These temporary tables are joined into the main DIASource and DIAObject tables to enable queries. When run in parallel, however, it's possible for these temporary tables to be created and dropped in the wrong order.

      This ticket is to implement a fix in ap_association.

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  cmorrison Chris Morrison
                  Reporter:
                  mrawls Meredith Rawls
                  Reviewers:
                  John Parejko
                  Watchers:
                  Chris Morrison, John Parejko, Meredith Rawls
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Summary Panel