I have recently started using Cellprofiler (v. 11515) in batch mode on a Windows 2008 server (32 bit). Previously, I’d output data to CSV file via ExportToSpreadsheet, but since Cellprofiler overwrites those files in batch mode, I have switched to using ExportToDatabase to export the data into a SQLite file. This works fine for most of the time; however, when several Cellprofiler instances are running simultaneously, it seems they sometimes block each other when trying to write data to the database. This results in Cellprofiler terminating during the ExportToDatabase module, reporting that the database was locked. The more instances I have running at the same time, the higher the likelihood of this occuring.
To remedy this, would it be possible to modify the ExportToDatabase module to something like this (in pseudo code) “while (database is locked) wait, try to write data again”.