<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Hopefully? I'm not sure how it got in that state and it's hard to know what's been done.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
You can certainly try 3.4 and see how it goes. </div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Ludwig Possie
<ludwigpossie@weber.edu><br>
<b>Sent:</b> Thursday, June 29, 2023 3:28 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Database schema mismatch</font>
<div> </div>
</div>
<div>
<div dir="auto">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?</div>
<div dir="auto"><br>
</div>
<div dir="auto">L</div>
<div><br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Thu, Jun 29, 2023 at 1:25 PM Blake Carver <<a href="mailto:blake.carver@lyrasis.org">blake.carver@lyrasis.org</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left-width:1px; border-left-style:solid; padding-left:1ex; border-left-color:rgb(204,204,204)">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">"However, your schema info version is set at 153"</span><br>
</div>
<div>
<div id="x_m_4839686999405874434Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
</div>
<div></div>
<div></div>
<div id="x_m_4839686999405874434divtagdefaultwrapper" dir="ltr" style="background-color:rgb(255,255,255); color:rgb(0,0,0)">
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<br>
</div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
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.</div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
Maybe there was a failed upgrade in the past and that reset the number or someone manaully changed the number?</div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<br>
</div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
In any case, it's hard to know what's going on with that DB. </div>
</div>
</div>
</div>
</div>
<div id="x_m_4839686999405874434appendonsend"></div>
<hr style="display:inline-block; width:98%">
<div id="x_m_4839686999405874434divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(0,0,0)"><b style="font-family:Calibri,sans-serif">From:</b>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" style="font-family:Calibri,sans-serif">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" style="font-family:Calibri,sans-serif">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf
of Ludwig Possie <<a href="mailto:ludwigpossie@weber.edu" target="_blank" style="font-family:Calibri,sans-serif">ludwigpossie@weber.edu</a>><br>
<b style="font-family:Calibri,sans-serif">Sent:</b> Thursday, June 29, 2023 2:33 PM<br>
<b style="font-family:Calibri,sans-serif">To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank" style="font-family:Calibri,sans-serif">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b style="font-family:Calibri,sans-serif">Subject:</b> Re: [Archivesspace_Users_Group] Database schema mismatch</font>
<div> </div>
</div>
</div>
<div dir="ltr">
<div>
<div dir="ltr">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.
<div><br>
</div>
<font face="monospace" style="font-family:monospace; color:rgb(0,0,0)">ArchivesSpace has encountered a problem with your database schema info version.<br>
<br>
The schema info version should be 147 for ArchivesSpace version v3.0.1.<br>
However, your schema info version is set at 153<br>
Please ensure your migrations have been run and completed by using the setup-database script.</font></div>
<br>
<div>
<div dir="ltr">On Thu, Jun 29, 2023 at 12:21 PM Blake Carver <<a href="mailto:blake.carver@lyrasis.org" target="_blank">blake.carver@lyrasis.org</a>> wrote:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left-width:1px; border-left-style:solid; padding-left:1ex; border-left-color:rgb(204,204,204)">
<div>
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
"The schema info version should be 147 for ArchivesSpace version v3.0.1."</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I think you're missing part of the error, so I'm not sure if you're ahead or behind on that. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
That error is from the test env?</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
You have 3.4 on the test env? Did you run the setup-database script? That's usually the problem.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Every release has a schema version:</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<a href="https://github.com/archivesspace/tech-docs/blob/master/development/releases.md" target="_blank" style="font-family:Calibri,Arial,Helvetica,sans-serif">https://github.com/archivesspace/tech-docs/blob/master/development/releases.md</a><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
(that's a bit behind the times I see)</div>
<div id="x_m_4839686999405874434x_m_7693719265912522410Signature">
<div>
<div id="x_m_4839686999405874434x_m_7693719265912522410divtagdefaultwrapper" dir="ltr" style="background-color:rgb(255,255,255); color:rgb(0,0,0)">
<div name="x_x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" style="font-family:Calibri,Arial,Helvetica,sans-serif; color:black"><span dir="ltr" style="font-size:12pt; font-family:Calibri,Arial,Helvetica,sans-serif; background-color:white"><font size="2" style="font-family:Calibri,Arial,Helvetica,sans-serif; color:rgb(0,0,0)"><span style="font-size:11pt; font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</span></font></span></font></div>
</div>
</div>
</div>
</div>
<div id="x_m_4839686999405874434x_m_7693719265912522410appendonsend"></div>
<hr style="display:inline-block; width:98%">
<div id="x_m_4839686999405874434x_m_7693719265912522410divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt; font-family:Calibri,sans-serif; color:rgb(0,0,0)"><b style="font-family:Calibri,sans-serif">From:</b>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" style="font-family:Calibri,sans-serif">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" style="font-family:Calibri,sans-serif">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf
of Ludwig Possie <<a href="mailto:ludwigpossie@weber.edu" target="_blank" style="font-family:Calibri,sans-serif">ludwigpossie@weber.edu</a>><br>
<b style="font-family:Calibri,sans-serif">Sent:</b> Thursday, June 29, 2023 12:52 PM<br>
<b style="font-family:Calibri,sans-serif">To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank" style="font-family:Calibri,sans-serif">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b style="font-family:Calibri,sans-serif">Subject:</b> [Archivesspace_Users_Group] Database schema mismatch</font>
<div> </div>
</div>
<div>
<div dir="ltr">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.
<div><br>
</div>
<div><br>
<div><span>-- </span><br>
<div dir="ltr">
<div dir="ltr">Ludwig Possié
<div><font size="1" style="color:rgb(0,0,0)">Systems Admin</font></div>
<div><font size="1" style="color:rgb(0,0,0)">Stewart Library</font></div>
<div><font size="1" style="color:rgb(0,0,0)">Weber State University</font></div>
<div><font size="1" style="color:rgb(0,0,0)">801-626-8093</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
<span>-- </span><br>
<div dir="ltr">
<div dir="ltr">Ludwig Possié
<div><font size="1" style="color:rgb(0,0,0)">Systems Admin</font></div>
<div><font size="1" style="color:rgb(0,0,0)">Stewart Library</font></div>
<div><font size="1" style="color:rgb(0,0,0)">Weber State University</font></div>
<div><font size="1" style="color:rgb(0,0,0)">801-626-8093</font></div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote>
</div>
</div>
<span class="x_gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="x_gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">Ludwig Possié
<div><font size="1">Systems Admin</font></div>
<div><font size="1">Stewart Library</font></div>
<div><font size="1">Weber State University</font></div>
<div><font size="1">801-626-8093</font></div>
</div>
</div>
</div>
</body>
</html>