7 Replies Latest reply on Dec 5, 2015 2:54 AM by gdurniak

    Four hours to recover a 50mb file??

    dbail22@comcast.net

      Title

      Four hours to recover a 50mb file??

      Post

           I thought a recover process was hung up but walked away and 4 hours later a beep told me it had completed.  The log shows over 68,000 lines like the very small sample below.  What in the world could be taking 4 hours and create such a huge log.  The file has over 68,000 records with four text fields and an external referenced container.  What choice/option could I make to have it recover in less than 4 hours??

           David

            

           2014-08-12 20:29:40.388 -0700    AO Scans.fmp12    0      Recovering: library '' (67837)
           2014-08-12 20:29:40.388 -0700    AO Scans.fmp12    0      Recovering: library '' (67838)
           2014-08-12 20:29:40.389 -0700    AO Scans.fmp12    0      Recovering: library '' (67839)
           2014-08-12 20:29:40.389 -0700    AO Scans.fmp12    0      Recovering: library '' (67840)
           2014-08-12 20:29:40.389 -0700    AO Scans.fmp12    0      Recovering: library '' (67841)
           2014-08-12 20:29:40.389 -0700    AO Scans.fmp12    0      Recovering: library '' (67842)
           2014-08-12 20:29:40.389 -0700    AO Scans.fmp12    0      Recovering: library '' (67843)
           2014-08-12 20:29:40.389 -0700    AO Scans.fmp12    0      Recovering: library '' (67844)
           2014-08-12 20:29:40.390 -0700    AO Scans.fmp12    0      Recovering: library '' (67845)
           2014-08-12 20:29:40.390 -0700    AO Scans.fmp12    0      Recovering: library '' (67846)
           2014-08-12 20:29:40.390 -0700    AO Scans.fmp12    0      Recovering: library '' (67847)
           2014-08-12 20:29:40.390 -0700    AO Scans.fmp12    0      Recovering: library '' (67848)
           2014-08-12 20:29:40.390 -0700    AO Scans.fmp12    0      Recovering: library '' (67849

        • 1. Re: Four hours to recover a 50mb file??
          BruceRobertson

               The more important question is what practices led to the need to recover the file in the first place.

               It just isn't something you should need to do, ever.

          • 2. Re: Four hours to recover a 50mb file??
            dbail22@comcast.net

                 Files showing abnormal behavior in any way should always be examined for ways to recover them. The recover process is an option to repair internal problems to maintain the use of the file.  I will have to disagree with never having to do that ever.... If you have worked with Filemaker for 10 years and never seen a file that needs recovery you are indeed lucky and unique...

            • 3. Re: Four hours to recover a 50mb file??
              philmodjunk

                   Things to keep in mind about Recover:

                   While Recover almost always detects and fully corrects any problems with your file...

                     
              1.           The recovered copy may behave differently even if recover reports "no problems found".
              2.      
              3.           Recover does not detect all problems
              4.      
              5.           Recover doesn't always fix all problems correctly
              6.      
              7.           Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.

                    

                   And here's a knowledgebase article that you may find useful: What to do when your file is corrupt (KB5421).

              • 4. Re: Four hours to recover a 50mb file??
                WBSimon

                     Did you file contain images? Just guessing from the name of the file.

                • 5. Re: Four hours to recover a 50mb file??
                  philmodjunk

                       To speak to the original question.

                       The internal structure of a FileMaker Database is a "black box" to us users.

                       The precise way that Recover scans and "fixes" a file for us is yet another "black box" into which we cannot see.

                       So, short of contacting a FileMaker tech and discussing this directly with them, there's not much any of us can offer to explain why it took so long.

                  • 6. Re: Four hours to recover a 50mb file??
                    dbail22@comcast.net

                         While I do not have to recover files on any regular basis I begin with a compacted copy. If that works to gain access to the troubled data then I clone the file and import into the clone.  When it does not, I recover the file.  I then examine the relationships, menus, functions etc and make any necessary changes.  Then it is time to clone and import.  I had hoped for a look into the black box since the recovery was so abnormal.  I once had to do this twice for a file until we discovered a bad hard drive.  It never failed again.

                    • 7. Re: Four hours to recover a 50mb file??
                      gdurniak

                      Sorry for the late reply

                       

                      My guess is that while the db file itself was very small,  the external storage file ( or files ) may have been huge ( many GB )

                       

                      Otherwise, please report this to Filemaker, as a possible bug

                       

                      greg

                       

                       

                      > The log shows over 68,000 lines ... What in the world could be taking 4 hours and create such a huge log. 

                      The file has over 68,000 records with four text fields and an external referenced container. 

                      What choice/option could I make to have it recover in less than 4 hours ?