<div dir="ltr">Hi Jerry,<div><br></div><div>I haven't seen an up-to-date ER diagram for ArchivesSpace (there were some early architecture documents), but you can reverse engineer one using MySQL workbench.</div><div><br></div><div>Workbench: <a href="https://www.mysql.com/products/workbench/">https://www.mysql.com/products/workbench/</a></div><div>Directions:
<a href="https://medium.com/@tushar0618/how-to-create-er-diagram-of-a-database-in-mysql-workbench-209fbf63fd03">https://medium.com/@tushar0618/how-to-create-er-diagram-of-a-database-in-mysql-workbench-209fbf63fd03</a> </div><div><br></div><div>I'd recommend doing it on a fresh database rather than your production database.</div><div><br></div><div>--Rachel<br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><br></div>--<div><br></div><div><span style="font-size:x-small">The information contained in this e-mail message is confidential. If you are not the intended recipient, any dissemination or copying is strictly prohibited. If you think that you have received this e-mail message in error, please contact the sender.</span><br></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Dec 2, 2019 at 4:14 PM Boggio, Jerry <<a href="mailto:gboggio@mitre.org">gboggio@mitre.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_-4332951210706264731WordSection1">
<p class="MsoNormal">Hi ArchivesSpace Users;<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">It appears we have found the answer to our question on <a href="https://archivesspace.github.io/archivesspace/user/re-creating-indexes/" target="_blank">
https://archivesspace.github.io/archivesspace/user/re-creating-indexes/</a>. By rebuilding the index files all records are now found from the MySQL database. The issues seems to be related to refreshing the database in a test environment from production, but
the index files not picking up the new records. Rebuilding the index files also appears to address the issue we outlined in our eMail “Error browsing Resources in version 2.6”.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">One other observation we made when refreshing the database is that the script archivesspace/scripts/setup-database.sh does not appear to work on later refreshes. The firs time we ran the script, the beginning of the output was as follows:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">[scripts]$ ./setup-database.sh<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">Running migrations against jdbc:mysql://<a href="http://mysqldev-a.mitre.org:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true" target="_blank">mysqldev-a.mitre.org:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true</a><u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:24:53.944292 #48098] INFO -- : Begin applying migration version 98, direction: up<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.123838 #48098] INFO -- : Finished applying migration version 98, direction: up, took 0.179616 seconds<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.124897 #48098] INFO -- : Begin applying migration version 99, direction: up<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.290539 #48098] INFO -- : Finished applying migration version 99, direction: up, took 0.165550 seconds<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:24:54.291407 #48098] INFO -- : Begin applying migration version 100, direction: up<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:25:01.935442 #48098] INFO -- : Finished applying migration version 100, direction: up, took 7.643832 seconds<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:25:01.936657 #48098] INFO -- : Begin applying migration version 101, direction: up<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.357509 #48098] INFO -- : Finished applying migration version 101, direction: up, took 0.420813 seconds<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.358205 #48098] INFO -- : Begin applying migration version 102, direction: up<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.706000 #48098] INFO -- : Finished applying migration version 102, direction: up, took 0.347575 seconds<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:25:02.707015 #48098] INFO -- : Begin applying migration version 103, direction: up<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">Updating qaa-qtz to und<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">Deleting enumeration_id for qaa-qtz<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">I, [2019-10-18T13:25:03.059206 #48098] INFO -- : Finished applying migration version 103, direction: up, took 0.352167 seconds<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">:<u></u><u></u></span></p>
<p style="margin-right:0in;margin-left:27pt;margin-bottom:0.0001pt">
<span style="font-size:10pt;font-family:"Courier New"">:<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">After later refreshes, the output contained only these messages:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:10pt;font-family:"Courier New"">[logs]$ more setup-database.log_20191202_1504<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:10pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:10pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:10pt;font-family:"Courier New"">Loading ArchivesSpace configuration file from path: /apps/archivesspace/config/config.rb<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:10pt;font-family:"Courier New"">Running migrations against jdbc:mysql://<a href="http://mysqldev-a.mitre.org:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true" target="_blank">mysqldev-a.mitre.org:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true</a><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:10pt;font-family:"Courier New"">All done.<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:10pt;font-family:"Courier New"">[m91981@archspcdev1 logs]$<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Does something need to be “reset” in a file or someplace else to allow the database conversion to happen again?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We would also still be interested in seeing document that identifies the relationships between tables, if available.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Please advise.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thank you!<u></u><u></u></p>
<div>
<p class="MsoNormal"><b><span style="color:rgb(47,84,150)">Gerard (Jerry) Boggio</span></b> |
<b>MITRE Corporation</b> | R504 - <span style="color:rgb(17,17,19)">Collaboration & Info Management</span><span style="font-size:18.5pt;font-family:Arial,sans-serif;color:rgb(17,17,19)">
</span>| 781-271-2719 <span style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">
| </span>Bedford, MA | 2K132<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> Boggio, Jerry <<a href="mailto:gboggio@mitre.org" target="_blank">gboggio@mitre.org</a>> <br>
<b>Sent:</b> Wednesday, November 27, 2019 12:01 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> Accessions Query<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hi ArchivesSpace Users;<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We are seeing an issue in our Linux based installation of version 2.6 where we are not seeing all of my Accession records when selecting Browse > Accessions. Could you please provide the SQL query used to populate that page so that we may
see if there is selection criteria being applied? With that information we can compare to our SQL query going directly against the database to identify differences.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Is there also a document that identifies the relationships between tables in ArchivesSpace?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thank you!<u></u><u></u></p>
<p class="MsoNormal"><b><span style="color:rgb(47,84,150)">Gerard (Jerry) Boggio</span></b> |
<b>MITRE Corporation</b> | R504 - <span style="color:rgb(17,17,19)">Collaboration & Info Management</span><span style="font-size:18.5pt;font-family:Arial,sans-serif;color:rgb(17,17,19)">
</span>| 781-271-2719 <span style="font-size:9pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">
| </span>Bedford, MA | 2K132<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</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>