Hi Joel, regarding the behavior you mentioned earlier, where not all of your resources loaded because the server froze up:
What happened was you maxed-out the 1gb of RAM that your t2.micro instance has. I've described this before in this thread <https://groups.google.com/forum/#!searchin/archesproject/memory/archesproject/stAP_egXcZk/b6j9hE-wDwAJ>. Because you're using AWS, next time you have to load a big .arches file I'd recommend temporarily upgrading your instance to a type that has a lot more memory. You will be required to shut down your current instance each time you change the type, but with more memory you can load a big file without having to break it up. (The cost will be negligible, as long as you switch back to a micro instance when you've finished.) This would be necessary if you are including resource-to-resource relationships in the .relations file. Just be sure to make an image of your instance for backup, just in case something goes wrong. Adam On Mon, Jan 4, 2016 at 7:19 PM, Joel Aldor <joel.al...@gmail.com> wrote: > Thank you Ryan. I have a table of all the dates and times of my .arches > file uploads, so I believe that should be easy. > > Regards, > > Joel > > On Tue, Jan 5, 2016 at 9:16 AM, Ryan Anderson <rander...@fargeo.com> > wrote: > >> Joel, >> >> Check the data.edit_log table of your arches database. This is where >> arches keeps the load_id and edit information for resources. You can find >> the load_id in the 'note' column of this table. It's probable that even >> though your initial load did not finish the load_id of the initial load is >> still preserved in this table. The load id is the exact time the arches >> load began in YYYY-MM-DD-HH-MM-SSSSSS format (with 'LOADID:' prepended), >> you may have to do some searching to find the load_id that corresponds with >> the time of your initial load. >> >> Hope this helps. >> >> Ryan >> >> On Sunday, January 3, 2016 at 8:18:58 PM UTC-8, Joel Aldor wrote: >>> >>> Good day, >>> >>> I am loading a big .arches file that contains 684 resources, but the >>> server just froze for an hour and nothing happened, so I need to restart it >>> (I only use a t2.micro instance on AWS for now) When I checked the map it >>> was able to only load the first 409 resources, so I traced back my .arches >>> file and split the file into two, where the 2nd file contains those that >>> weren't loaded. All the resources were loaded eventually. >>> >>> However I wasn't able to get the reverse load command for the first >>> .arches file. I always log the load_id of all .arches files that I upload, >>> in case there we need to clean the whole database at some point. Is there a >>> way for me to extract the load_id? >>> >>> Thanks, >>> >>> Joel >>> >> -- >> -- To post, send email to archesproject@googlegroups.com. To >> unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. >> For more information, visit >> https://groups.google.com/d/forum/archesproject?hl=en >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "Arches Project" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/archesproject/YTNaD5IPPzY/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> archesproject+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > -- To post, send email to archesproject@googlegroups.com. To unsubscribe, > send email to archesproject+unsubscr...@googlegroups.com. For more > information, visit https://groups.google.com/d/forum/archesproject?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Arches Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to archesproject+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- -- To post, send email to archesproject@googlegroups.com. To unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to archesproject+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
