[Archivesspace_Users_Group] Database Migration Error on AS 2.6.0

[Blake Carver]

I wouldn't recommend changing the schema_info, this can put you in a really bad place.

Your error:
""The schema info version should be 120 for ArchivesSpace version v2.6.0.  However, your schema info version is set at 122"

Every release of ArchivesSpace has a  schema number . All recent releases have the  schema number  listed on the release notes. So the latest version 3.0 is  147, and the previous release 2.8.1 is 138 and so on down the line. Those numbers are important and are set by the code. That's what the ArchivesSpace code looks at to know that the MySQL Database lines up with what it expects. Each version expects certain tables/rows/columns to be there and in a certain format. As ArchivesSpace starts each time it checks that shema_info number, and if it's wrong, it fails. So ArchivesSpace 3.0 starts up and says "Hey MySQL what ya got there?" and MySQL says "147" and ArchivesSpace says "Groovy, that's what I need to run" and then they high five and start getting down to business. If ArchivesSpace starts up and says "Hey MySQL, what ya got there?" and it says "122" and ArchivesSpace was expecting 120, ArchivesSpace says "That ain't right, I can't work with that" and starts telling you all about it in archivesspace.out.

So your version of ArchivesSpace is expecting schema_info to be 120 but it's actually 122, which is larger number and therefore a newer release.

Looking back at the old releases, schema_info on 2.7 is 126 and the release before that is 120 is 2.6.0, which means 122 is... I don't know what.

I'm not sure what to recommend here. From what I can see there is not any release that should have a schema version of 122, so I don't know how that got set like that.

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Schanz, Megan <schanzme at msu.edu>
Sent: Thursday, May 13, 2021 9:35 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Database Migration Error on AS 2.6.0

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/20210514/fea9dfda/attachment.html>