FM 10 advanced crashed. Is this file damaged?

[Bruce Herbach]

My apologies, this may be a bit long. The short question is, is this file damaged? Here is what happened.

This morning FileMaker 10 advanced reported that the file I was working on had become corrupt and then crashed.

The database itself was being served by FileMaker 11 advanced server. I checked the server logs and the only thing listed was a warning saying that my session had become inactive and had been disconnected.

I had the server verify the file. The verify passed.

I had the server make a backup of the file and then used the recovery tools in FM 11 advanced to check the file. The consistency check reported 0 bad blocks.

I then did a recover on the backup and came up with the following:

2010-06-28 08:50:29.303 -0400 Quotes.fp7 8495 WARNING: problems were detected while recovering the database. The recovered file should NOT be used going forward; copy only the most recent work from it into a backup copy of the original file.

2010-06-28 08:50:29.304 -0400 Quotes.fp7 0 File blocks: scanned and rebuilt 2247 block(s), dropped 0 invalid data block(s)

2010-06-28 08:50:29.304 -0400 Quotes.fp7 0 Schema: scanned fields and tables; some problems were found...

2010-06-28 08:50:29.305 -0400 Quotes.fp7 0 fields created to match record data: 0

2010-06-28 08:50:29.306 -0400 Quotes.fp7 0 field values deleted due to invalid ID or repetition: 0

2010-06-28 08:50:29.306 -0400 Quotes.fp7 0 records deleted due to invalid ID: 0

2010-06-28 08:50:29.307 -0400 Quotes.fp7 0 Structure: scanned; 7 item(s) modified

2010-06-28 08:50:29.308 -0400 Quotes.fp7 0 File size after recovery is 9232384 bytes

2010-06-28 08:50:29.308 -0400 Quotes.fp7 0 *** Completed recovery to 'Quotes Recovered.fp7'

In going through the logs, I found a listing for 4 stranded library objects, a Reset table view and a rebuilt group with 9 objects.

So after all of this, I took the backup file and opened it locally in FM11 advanced. This opened and FM 11 didn't report any issues. My work from this morning seems to be there.

So is the original file on the server ok? Do I need to go back to the last backup.

Last thing, I think the cause of the crash was my network connection. My computer was running both wired and wireless at the time. When working at my desk, I connect the network cable so I have a gigibit connection. I forgot to turn the Wifi off. I believe that I saw a forum post a while back that indicated that two connections at the desktop like this could cause problems. I don't know if this is the actual problem to expect.

Thanks very much for help with this.

Bruce Herbach

[jamesducker]

Yes. It is damaged enough not to trust it. Revert to the backup.

J

Edited June 29, 2010 by Guest