On Friday, November 8, 2013 3:31:50 PM UTC-8, Nobu Games wrote: > > The SQLite documentation <http://www.sqlite.org/limits.html>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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
