[Archivesspace_Users_Group] Database schema mismatch

[Blake Carver]

"However, your schema info version is set at 153"

Not sure what happened there, but as far as I can tell, that's not a real version. V3.0.1 is supposed to be schema version 147. I don't see any release with schema number 147.
Maybe there was a failed upgrade in the past and that reset the number or someone manaully changed the number?

In any case, it's hard to know what's going on with that DB.
________________________________
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: Thursday, June 29, 2023 2:33 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Database schema mismatch

I downloaded AS v 3.0.1 in my test environment in order to get AS working like in production prior to attempting the upgrade.  The error is in the test environment, production is fine.  I ran the setup-database script in test, no errors.  I then tried to run AS in test, but I'm getting the wrong schema error.  The error states that the schema for the DB is at is 153, but I don't see that schema number on the list you provided, so I'm supposing perhaps I downloaded the wrong version of AS, but I'm not sure what version I should be using.

ArchivesSpace has encountered a problem with your database schema info version.

The schema info version should be 147 for ArchivesSpace version v3.0.1.
 However, your schema info version is set at 153
Please ensure your migrations have been run and completed by using the setup-database script.

On Thu, Jun 29, 2023 at 12:21 PM Blake Carver <blake.carver at lyrasis.org<mailto:blake.carver at lyrasis.org>> wrote:

 "The schema info version should be 147 for ArchivesSpace version v3.0.1."

I think you're missing part of the error, so I'm not sure if you're ahead or behind on that.
That error is from the test env?
You have 3.4 on the test env? Did you run the setup-database script? That's usually the problem.
Every release has a schema version:
https://github.com/archivesspace/tech-docs/blob/master/development/releases.md
(that's a bit behind the times I see)

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Ludwig Possie <ludwigpossie at weber.edu<mailto:ludwigpossie at weber.edu>>
Sent: Thursday, June 29, 2023 12:52 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] Database schema mismatch

I'm trying to upgrade our version of Archivesspace and I have created a test environment in a virtual machine.  When I import the database from production and I attempt to run AS, I get a database migration error, "The schema info version should be 147 for ArchivesSpace version v3.0.1."  I ran the database migration script "setup-database.sh" and it seems to have ran without issues, but I'm still getting the above-mentioned error when I attempt to run AS.  I was told that we are currently running AS v3.0.1.  I'm supposing that the DB schema differs from different versions of AS.  Am I missing a step or something?  I would appreciate any advice anyone can provide.  Thx.


--
Ludwig Possié
Systems Admin
Stewart Library
Weber State University
801-626-8093
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group


--
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/20230629/a8e27fdb/attachment.html>