SQLite error in Apptentive DB about apptentive-ios HOT 4 CLOSED

Hi @eaceto. We're sorry this is happening! We have one other report of this, and are trying to narrow down how it happens.

Some questions that will help us figure this out:

• Was the app upgraded from a previous version? Which version of apptentive-ios did the previous version have?
• Which iOS versions does this happen on?
• Do you have any other third party libraries in the app? Which ones?
• Do you use Core Data yourself in the app at all?
• Are you able to reproduce this yourself?

If you can reproduce this yourself, I'd love to get a copy of the files of the app from the device you can reproduce the problem on.

At this point, it seems like the problem is resolved if users delete and reinstall the app. We're working hard to figure out a fix and will get it out as soon as we can!

from apptentive-ios.

We think this was caused by SQLite on iOS 7 now using write ahead logging (WAL) by default, which is similar to the issue here:

http://pablin.org/2013/05/24/problems-with-core-data-migration-manager-and-journal-mode-wal/

We have a candidate fix available here:

https://github.com/apptentive/apptentive-ios/tree/MigrationFix

This fix does two things, it switches our Core Data database from WAL to the previous default (DELETE mode) on migration. So, any databases that get migrated from here on out won't use WAL. (I haven't been able to reliably move a database from WAL to DELETE without a migration.)

It also performs a sanity check on the database at startup and tries to detect the corruption we're seeing. If so, it deletes our database and starts over.

If this looks good, you may want to use it for your fix release. If you see any issues with it, please let me know. We're going to continue pounding on it on our end.

from apptentive-ios.

By the way, @eaceto, is this happening in a live app? If so, email me: [email protected] and we can use some over-the-air measures to reduce the likelyhood of this crash in your current live app.

from apptentive-ios.

We've just released v1.2.3, which we believe fixes these problems:

https://github.com/apptentive/apptentive-ios/releases/tag/v1.2.3

If it doesn't fix them for you, please let us know!

from apptentive-ios.