<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="gmail_quote"><div dir="ltr" class="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="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="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="m_4839686999405874434divtagdefaultwrapper" dir="ltr" style="background-color:rgb(255,255,255);color:rgb(0,0,0)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;margin:0px">
<br>
</div>
<div name="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="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="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;margin:0px">
<br>
</div>
<div name="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="m_4839686999405874434appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="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="m_4839686999405874434x_m_7693719265912522410Signature">
<div>
<div id="m_4839686999405874434x_m_7693719265912522410divtagdefaultwrapper" 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">
<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="m_4839686999405874434x_m_7693719265912522410appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="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="gmail_signature_prefix">-- </span><br><div dir="ltr" class="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>