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.