[Archivesspace_Users_Group] Spreadsheet imports locking up database

[Peter Heiner]

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 with a dependent subquery running for every line of the 
spreadsheet input seems to make concurrent database access near impossible.

Has anyone else experienced anything similar? Us using MariaDB instead of MySQL 
might well be the cause, but I'd like confirmation before work is scheduled to 
migrate the database that this will indeed help. If you're using spreadsheet 
imports, we'd be grateful if you could let us know either on or off list 
whether you use MySQL or MariaDB and if you had any problems with the migration 
queries hogging the database.

Thanks,
p
___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

[Archivesspace_Users_Group] ArchivesSpace 3.0.1 now available

[Christine Di Bella]

Hello ArchivesSpace members,

ArchivesSpace 3.0.1 is now available. It corrects an issue with the migration 
of agent contact notes that was present in 3.0.0. When you choose to upgrade 
past 2.8.1 you should use this version. We have pulled the download file for 
3.0.0 to hopefully avoid confusion as much as possible.

Otherwise, everything that was true about 3.0.0 is true about 3.0.1. More 
information about what's in the release and the link to download it are at 
https://github.com/archivesspace/archivesspace/releases. Information on 
upgrading to a new version of ArchivesSpace is available at 
https://archivesspace.github.io/tech-docs/administration/upgrading.html.

If you have questions or need any assistance, please let us know. I apologize 
for the inconvenience but I'm very glad we were able to catch and rectify the 
issue so soon after the original release. We expect to put out a more typical 
release with the usual complement of new infrastructure improvements, bug 
fixes, and feature enhancements in the late summer.

Christine

Christine Di Bella
ArchivesSpace Program Manager
christine.dibe...@lyrasis.org
800.999.8558 x2905
678-235-2905


[ASpaceOrgHomeMedium]

___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Re: [Archivesspace_Users_Group] Spreadsheet imports locking up database

[Kennedy, Nancy]

Hi Peter -
We also see issues with concurrent database access.  If one user initiates a 
large delete or import, other users can experience long delays and timeouts.  
We've also noticed that Edit save times are especially long when there is a 
language subrecord. (An archival_object with a lang_material can take 30 
seconds to save, whereas records without a lang_material save much more 
quickly).

We are in v 2.71 and we also use MariaDB. We see the same issue in our test 
2.8.1 instance. I'd be very interested to hear if MySQL offers a better 
experience for Cambridge,

Thanks,
Nancy

kenne...@si.edu
Nancy Kennedy
Smithsonian Institution



From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Peter 
Heiner
Sent: Friday, June 4, 2021 11:20 AM
To: archivesspace_users_group@lyralists.lyrasis.org
Subject: [Archivesspace_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 
https://github.com/archivesspace/archivesspace/issues/2275;
 the summary is that a DELETE query with a dependent subquery running for every 
line of the spreadsheet input seems to make concurrent database access near 
impossible.

Has anyone else experienced anything similar? Us using MariaDB instead of MySQL 
might well be the cause, but I'd like confirmation before work is scheduled to 
migrate the database that this will indeed help. If you're using spreadsheet 
imports, we'd be grateful if you could let us know either on or off list 
whether you use MySQL or MariaDB and if you had any problems with the migration 
queries hogging the database.

Thanks,
p
___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group