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

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.

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 :-/

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

On Friday, November 8, 2013 4:23:57 PM UTC-6, Nathan wrote:

On Friday, November 8, 2013 1:44:13 PM UTC-8, Steve Gabrilowitz wrote:

Just a wild thought, the number of bytes in a 2GB database is also the 32 bit maxint, could this be more than  a coincidence?

It could very well be, and it is the subject of a previous thread by me:

https://groups.google.com/forum/#!searchin/android-developers/Nathan$20sqlitedatabase|sort:date/android-developers/Gg3W0UjaC4g/vInIUekydH8J

However, there was no definite conclusion. I did tell the customer that files bigger than 2GB "might" be a problem.

Others on the topic:
https://groups.google.com/forum/#!searchin/android-developers/Nathan$20sqlitedatabase|sort:date/android-developers/gDREeuaWQtA/w7C54ZcjAPMJ

Nathan

--
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.