<div dir="ltr"><div><div><div><div>Just chiming in and backing up what Steve is saying. If you are just sync'ing the live DB with the test DB there's no need to run a backup. You really only need to have backups when you are upgrading to a new version of the software. <br><br></div>I would also start with a fresh index. For this I would stop the application, ingest the live DB dump into the test DB, drop the current index to force a complete re-index by using the following command:<br></div><br>rm -rf /path/to/archivesspace/data/*<br><br></div>And then restart the application. A re-index can take some time depending on how large your DB is. Ours typically runs 1-2 hours. <br><br></div>- Chelsea<br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><span style="color:rgb(128,128,128)"><em><span style="font-size:small">---------------</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small">Chelsea Lobdell</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small">Library Web Developer/ Swarthmore College</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small"><a href="mailto:clobdel1@swarthmore.edu" target="_blank">clobdel1@swarthmore.edu</a> / (610)690-6818</span></em></span></div></div></div></div>
<br><div class="gmail_quote">On Tue, May 1, 2018 at 11:10 AM, Majewski, Steven Dennis (sdm7g) <span dir="ltr"><<a href="mailto:sdm7g@virginia.edu" target="_blank">sdm7g@virginia.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><br></div><div>The mysqldump is sufficient to restore ArchivesSpace state. </div><div>It will rebuild the solr indexes. That will take a bit longer, but I prefer to do a complete clean reindex when cloning production to test. ( There are a number of glitches where the first bit of advice is usually to trigger a reindex. ) </div><div><br></div><div>The only other state information that isn’t in the mysql database is the log info for batch jobs, which is in the data/shared/job_files directories. If you’re going to want to access output from old batch processes, you need to copy those. </div><div>Typically, I retain those files when updating ArchivesSpace on production, but I don’t copy them when cloning production to test. </div><div><br></div><div>— Steve Majewski</div><div><br></div><div><br></div><br><div><blockquote type="cite"><div><div class="h5"><div>On May 1, 2018, at 10:39 AM, Neal, Rick <<a href="mailto:rneal@richmond.edu" target="_blank">rneal@richmond.edu</a>> wrote:</div><br class="m_6304854543585217673Apple-interchange-newline"></div></div><div><div><div class="h5"><div class="m_6304854543585217673WordSection1" style="font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Good morning,<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">I am having some ArchivesSpace issues and need some advice.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">I have a test instance and a production instance of ArchiveSpace.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">I use version 1.5.1 on both servers. I use mysql.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">I want to update the test server from the production server.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt 0.5in;font-size:11pt;font-family:Calibri,sans-serif"><span>A.<span style="font-style:normal;font-variant-caps:normal;font-weight:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman'"> <span class="m_6304854543585217673Apple-converted-space"> </span></span></span>I dumped the database with mysqld on the production server.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt 0.5in;font-size:11pt;font-family:Calibri,sans-serif"><span>B.<span style="font-style:normal;font-variant-caps:normal;font-weight:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman'"> <span class="m_6304854543585217673Apple-converted-space"> </span></span></span>I then ran backup.sh on the production server (thinking that I need the index) and got the<span class="m_6304854543585217673Apple-converted-space"> </span><span style="background-color:yellow;background-position:initial initial;background-repeat:initial initial">OUTPUT</span><span class="m_6304854543585217673Apple-converted-space"> </span>below at the bottom. I did<span class="m_6304854543585217673Apple-converted-space"> </span><u>not<span class="m_6304854543585217673Apple-converted-space"> </span></u>get a zip file created. I have no idea what happened but I am concerned now that the backup.sh file did something besides simply failing to create a zip file for me to take over to the test sever. I am concerned that if I restart the service ArchiveSpace will fail.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt 0.5in;font-size:11pt;font-family:Calibri,sans-serif"><span>C.<span style="font-style:normal;font-variant-caps:normal;font-weight:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman'"> <span class="m_6304854543585217673Apple-converted-space"> </span></span></span>I took the database dump and ingested it on the test server. I stopped and restarted the archivesspace service. ArchivesSpace doesn’t show up in the browser. I recovered from a VM backup and have no problems with the test server but of course it did not get updated.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Questions:<u></u><u></u></div><div style="margin:0in 0in 0.0001pt 0.5in;font-size:11pt;font-family:Calibri,sans-serif"><span>1.<span style="font-style:normal;font-variant-caps:normal;font-weight:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman'"> <span class="m_6304854543585217673Apple-converted-space"> </span></span></span>How concerned should I be about item B above? I took the database dump so I have that but I don’t know anything about whether the index is damaged or how to fix it if it is. Again I am concerned that ArchivesSpace will not come back up if I restart the service.<u></u><u></u></div><div style="margin:0in 0in 0.0001pt 0.5in;font-size:11pt;font-family:Calibri,sans-serif"><span>2.<span style="font-style:normal;font-variant-caps:normal;font-weight:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman'"> <span class="m_6304854543585217673Apple-converted-space"> </span></span></span>What is the proper process for updating a test instance?<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Thanks for your help<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Rick Neal<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">University of Richmond<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span style="background-color:yellow;background-position:initial initial;background-repeat:initial initial">OUTPUT</span><u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">[root@server scripts]# ./backup.sh --output /dir/backup-20180501.zip<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Loading ArchivesSpace configuration file from path: /dir1/archivesspace/config/<wbr>config.rb<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Loading ArchivesSpace configuration file from path: /dir1/archivesspace/config/<wbr>config.rb<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">2018-05-01 10:00:46 -0400: Writing backup to /dir/backup-20180501.zip<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">INFO: Previous snapshot status: {"startTime"=>"Tue May 01 10:00:00 EDT 2018", "fileCount"=>42, "status"=>"success", "snapshotCompletedAt"=>"Tue May 01 10:00:00 EDT 2018", "snapshotName"=>nil}; snapshot:<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">IOError: No such file or directory<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> create at /dir1/archivesspace/gems/gems/<wbr>jruby-jars-1.7.21/lib/jruby-<wbr>stdlib-1.7.21.jar!/META-INF/<wbr>jruby.home/lib/ruby/shared/<wbr>tmpdir.rb:0<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> initialize19 at org/jruby/ext/tempfile/<wbr>Tempfile.java:95<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> new at org/jruby/RubyIO.java:853<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> get_tempfile at /dir1/archivesspace/gems/gems/<wbr>rubyzip-1.0.0/lib/zip/file.rb:<wbr>410<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> on_success_replace at /dir1/archivesspace/gems/gems/<wbr>rubyzip-1.0.0/lib/zip/file.rb:<wbr>401<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> commit at /dir1/archivesspace/gems/gems/<wbr>rubyzip-1.0.0/lib/zip/file.rb:<wbr>294<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> close at /dir1/archivesspace/gems/gems/<wbr>rubyzip-1.0.0/lib/zip/file.rb:<wbr>322<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> open at /dir1/archivesspace/gems/gems/<wbr>rubyzip-1.0.0/lib/zip/file.rb:<wbr>100<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> __ensure__ at ../launcher/backup/lib/backup.<wbr>rb:115<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> backup at ../launcher/backup/lib/backup.<wbr>rb:111<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> main at ../launcher/backup/lib/backup.<wbr>rb:150<u></u><u></u></div><div style="margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> (root) at ../launcher/backup/lib/backup.<wbr>rb:154<u></u><u></u></div></div></div></div><span style="font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">______________________________<wbr>_________________</span><br style="font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">Archivesspace_Users_Group mailing list</span><br style="font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="color:rgb(149,79,114);text-decoration:underline;font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" target="_blank">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br style="font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" style="color:rgb(149,79,114);text-decoration:underline;font-family:Menlo-Regular;font-size:14px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a></div></blockquote></div><br></div><br>______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
<br></blockquote></div><br></div>