[Archivesspace_Users_Group] Spreadsheet imports locking up database

Dear list users, The Cambridge University Library AS instance has recently been hit with severe performance issues while users were running spreadsheet imports to add archival objects, details are in https://github.com/archivesspace/archivesspace/issues/2275; the summary is that a DELETE query

Re: [Archivesspace_Users_Group] Spreadsheet imports locking up database

pace_Users_Group] Spreadsheet imports locking up database External Email - Exercise Caution Dear list users, The Cambridge University Library AS instance has recently been hit with severe performance issues while users were running spreadsheet imports to add archival objects, details are in ht

Re: [Archivesspace_Users_Group] Spreadsheet imports locking up database

On Behalf > Of Peter Heiner > Sent: Friday, June 4, 2021 11:20 AM > To: archivesspace_users_group@lyralists.lyrasis.org > <mailto:archivesspace_users_group@lyralists.lyrasis.org> > Subject: [Archivesspace_Users_Group] Spreadsheet imports locking up database > > Exte

Re: [Archivesspace_Users_Group] Spreadsheet imports locking up database

James Bullen wrote on 2021-06-06 11:35:03: > Bulk update operations usually run in database transactions. This is great > because it guarantees that the database will be in a consistent state when > the job completes - if it succeeds then all of the updates are applied, if it > fails then none

Re: [Archivesspace_Users_Group] Spreadsheet imports locking up database

Hi Peter, I’m not familiar with the spreadsheet importer, but it sounds like you’ve done the analysis to be in a position to fix it. :) Here’s a commit for the “run tonight” feature implemented in a plugin: https://gitlab.gaiaresources.com.au/qsa/as_runcorn/-/commit/8a2bd97

Re: [Archivesspace_Users_Group] Spreadsheet imports locking up database

...@lyralists.lyrasis.org on behalf of James Bullen Date: Sunday, June 6, 2021 at 5:26 AM To: Archivesspace Users Group Subject: Re: [Archivesspace_Users_Group] Spreadsheet imports locking up database Hi Peter, I’m not familiar with the spreadsheet importer, but it sounds like you’ve done the