Re: [android-developers] Re: .db files being renamed to .back

On Friday, November 8, 2013 3:31:50 PM UTC-8, Nobu Games wrote:

The SQLite documentation says that the maximum database file size is 2,147,483,646 pages

A single page can range from 512 to 65,536 bytes. So the minimum page size configuration would yield a maximum database file size of 1 TB. So something else is going wrong here.

Well, that definitely wouldn't fly if most cards are FAT32 formatted and couldn't do more than 4GB. But previous threads point to problems in the Android implementation of SQLite, possibly using a signed int32 as a file offset pointer.

It looked like there was a fix in the Android source code, but it was ambiguous to me.
 

Out of curiosity I checked the vanilla SQLite C source code for occurrences of ".back" and could not find anything. Just a vague guess: it looks to me like some odd kind of data corruption recovery handling. In older versions of Android the strategy was just deleting the corrupted database file and starting from scratch. It could be a vendor-specific customization or maybe a different firmware like CyanogenMod.

But I think it's more likely that your customers who report that problem are to blame. Probably by misusing some file manager or backup software as gjs already mentioned :-/

Yes, but it is not at all unusual that they don't know. It could be the manufacturer or network that put that stuff on there. 

 

Could they recover their data by renaming these ".back" files to ".db"?

That didn't work when the customer last tried it.
 

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
---
You received this message because you are subscribed to the Google Groups "Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.