[
https://issues.apache.org/jira/browse/CB-684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273880#comment-13273880
]
Neil Harding commented on CB-684:
---------------------------------
Awesome, thanks for looking at this so quickly. Doing this in a background task
sounds ideal, I'm sure it should complete well within 10 mins. Looking forward
to Cordova 1.8!
> WebKit database restore on iOS5.1 corrupts large databases (not enough time
> for background execution)
> -----------------------------------------------------------------------------------------------------
>
> Key: CB-684
> URL: https://issues.apache.org/jira/browse/CB-684
> Project: Apache Cordova
> Issue Type: Bug
> Components: iOS
> Affects Versions: 1.6.1
> Environment: iOS5.1
> Reporter: Neil Harding
> Assignee: Shazron Abdullah
> Priority: Critical
> Labels: database, ios, sqlite, webkit
> Fix For: 1.8.0
>
>
> The backup and restore process for WebKit databases on iOS5.1 to copy
> databases from the /library/caches folder to /documents/backup is corrupting
> large databases.
> I have a 1Gb sqllite databases, this is is because there will be a lot of
> data in the app and to get around the 5mb quota limit for Websql databases on
> iOS a large pre populated .db file is copied over to /library/caches on app
> start up in didFinishLaunchingWithOptions if it doesn't already exist. This
> 'reserves' the footprint of the database as sqlite doesn't unallocated space
> when deleting rows, the data is cleared out and the app can start off without
> any quota errors.
> When the app terminates and the backup process runs to copy the .db file to
> /documents/backup it doesn't complete the process successfully (possibly
> killed by iOS before the file is fully written?) and the resulting file .db
> is much smaller (~200mb) and corrupt.
> When the app runs next time the .db is copied from /documents/backup to
> /library/caches ok, but the damage is already done.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
