[Archivesspace_Users_Group] Database Migration Error on AS 2.6.0

[Schanz, Megan]

That should only happen when the setup-database script was run for a later version of ArchivesSpace. But if that isn't the case, you could try manually reverting the schema number in the database to see if that resolves your issue.

update schema_info set version = 120;

I've had to do that at one point in the past, but I can't recall what circumstances led to me having to do that.

- Megan

_____________________________________

Megan Schanz
Application Developer & Systems Administrator
Michigan State University Libraries
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Ludwig Possie <ludwigpossie at weber.edu>
Sent: Wednesday, May 12, 2021 7:56 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Database Migration Error on AS 2.6.0

I'm in the process of moving our current version of Archivesspace 2.6.0 to a new server running Ubuntu 20.04.  I've installed Java 1.8, MySQL 8.0.25 and mysql connector 8.0.25 on the new server.

I successfully got Archivesspace 2.6.0 running on MySQL (New blank database) on the new server.  When I import our current production database and run the setup-database.sh script I get no error and an 'All Done' message at the end.  However when I attempt to run archivesspace.sh I get a Database Migration Error, with the following recommendation, "The schema info version should be 120 for ArchivesSpace version v2.6.0.  However, your schema info version is set at 122
Please ensure your migrations have been run and completed by using the setup-database script."
I've ran the script various times but I keep getting the same results.  Has anyone experienced an issue like this?  Please advise.  Thank you.

--
Ludwig Possié
Systems Admin
Stewart Library
Weber State University
801-626-8093
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210513/a75a8bc5/attachment.html>