[Archivesspace_Users_Group] Database schema mismatch

[Ludwig Possie]

If I run AS v3.4.0 in my test environment and run the setup-database script
will it update the db to the correct version?

L

On Thu, Jun 29, 2023 at 1:25 PM Blake Carver <blake.carver at lyrasis.org>
wrote:

> "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>
> 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
> _______________________________________________
> 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/8a494969/attachment.html>