[Archivesspace_Users_Group] Database schema mismatch

[Ludwig Possie]

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>
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 <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of
> Ludwig Possie <ludwigpossie at weber.edu>
> *Sent:* Thursday, June 29, 2023 12:52 PM
> *To:* Archivesspace Users Group <
> 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
> 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/d0fa634f/attachment.html>