Skip to main content

Error updating SQLCipher

We recently encountered a bug when migrating an android application from Eclipse to Android Studio. As a part of this migration the reference to SQLCipher version was updated from a really old (several years old) version to 3.5.4. After the migration, for existing users, the application was falling over and using the log (below) we identified it was failing when trying to use the new version of SQLCipher to open a database that had been created / encrypted using the older legacy version.

E/Database: file is encrypted or is not a database: , while compiling: select count(*) from sqlite_master;
   net.sqlcipher.database.SQLiteException: file is encrypted or is not a database: , while compiling: select count(*) from sqlite_master;
      at net.sqlcipher.database.SQLiteCompiledSql.native_compile(Native Method)
      at net.sqlcipher.database.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91)
      at net.sqlcipher.database.SQLiteCompiledSql.(SQLiteCompiledSql.java:64)
      at net.sqlcipher.database.SQLiteProgram.(SQLiteProgram.java:83)
      at net.sqlcipher.database.SQLiteQuery.(SQLiteQuery.java:49)
      at net.sqlcipher.database.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
      at net.sqlcipher.database.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1787)
      at net.sqlcipher.database.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1752)
      at net.sqlcipher.database.SQLiteDatabase.keyDatabase(SQLiteDatabase.java:2427)
      at net.sqlcipher.database.SQLiteDatabase.openDatabaseInternal(SQLiteDatabase.java:2356)
      at net.sqlcipher.database.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1116)
      at net.sqlcipher.database.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1179)
      at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:162)
      at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:129)
      ...
      at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1024)
      at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4947)
      at android.app.ActivityThread.access$1500(ActivityThread.java:144)
      at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1424)
      at android.os.Handler.dispatchMessage(Handler.java:102)
      at android.os.Looper.loop(Looper.java:155)
      at android.app.ActivityThread.main(ActivityThread.java:5696)
      at java.lang.reflect.Method.invoke(Native Method)
      at java.lang.reflect.Method.invoke(Method.java:372)
      at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1028)
      at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:823)
E/AndroidRuntime: FATAL EXCEPTION: main
   Process: com.schoolcomms.sga, PID: 20424
   java.lang.RuntimeException: Unable to create application ...: net.sqlcipher.database.SQLiteException: file is encrypted or is not a database: , while compiling: select count(*) from sqlite_master;
      at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4950)
      at android.app.ActivityThread.access$1500(ActivityThread.java:144)
      at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1424)
      at android.os.Handler.dispatchMessage(Handler.java:102)
      at android.os.Looper.loop(Looper.java:155)
      at android.app.ActivityThread.main(ActivityThread.java:5696)
      at java.lang.reflect.Method.invoke(Native Method)
      at java.lang.reflect.Method.invoke(Method.java:372)
      at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1028)
      at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:823)
   Caused by: net.sqlcipher.database.SQLiteException: file is encrypted or is not a database: , while compiling: select count(*) from sqlite_master;
      at net.sqlcipher.database.SQLiteCompiledSql.native_compile(Native Method)
      at net.sqlcipher.database.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91)
      at net.sqlcipher.database.SQLiteCompiledSql.(SQLiteCompiledSql.java:64)
      at net.sqlcipher.database.SQLiteProgram.(SQLiteProgram.java:83)
      at net.sqlcipher.database.SQLiteQuery.(SQLiteQuery.java:49)
      at net.sqlcipher.database.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
      at net.sqlcipher.database.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1787)
      at net.sqlcipher.database.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1752)
      at net.sqlcipher.database.SQLiteDatabase.keyDatabase(SQLiteDatabase.java:2427)
      at net.sqlcipher.database.SQLiteDatabase.openDatabaseInternal(SQLiteDatabase.java:2356)
      at net.sqlcipher.database.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1116)
      at net.sqlcipher.database.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1179)
      at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:162)
      at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:129)
      ...
      at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1024)
      at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4947)
      at android.app.ActivityThread.access$1500(ActivityThread.java:144) 
      at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1424) 
      at android.os.Handler.dispatchMessage(Handler.java:102) 
      at android.os.Looper.loop(Looper.java:155) 
      at android.app.ActivityThread.main(ActivityThread.java:5696) 
      at java.lang.reflect.Method.invoke(Native Method) 
      at java.lang.reflect.Method.invoke(Method.java:372) 
      at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1028) 
      at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:823) 
E/ActivityManager: App crashed!

After a fair amount of digging around online one of my team managed to find solution, it was quite easy to find what we needed to add but it was much harder to find out where that needed to be added!  To potentially save anyone else the same issue (more on this later) I've recorded both the error and full solution in a single location.  It is as simple as extending the 'SQLiteDatabaseHook' class and adding a migrate command in the 'postKey' method.

public class MigrateDatabaseHook implements SQLiteDatabaseHook 
{
   @Override
   public void preKey(SQLiteDatabase sqLiteDatabase) 
   {
   }

   @Override
   public void postKey(SQLiteDatabase sqLiteDatabase) 
   {
      sqLiteDatabase.rawExecSQL("PRAGMA cipher_migrate;");
   }
}

As is usually the case, once you've got all of the answer it's pretty easy to understand what you should have been 'Googling' in the first place.  As I'm working with some of my team to convince them of the benefits of blogging,  I've created this blog post as a bit of an experiment to see what traffic it gets.  It would be fantastic if you let me know in the comments if it has helped you.

Comments

Popular posts from this blog

Why do my Android Notification only appear in the status bar?

I'm definitely getting back into Android development, I'm remembering that feeling of 'Surely this should be easier than this!'. All I wanted to do was to schedule a local notification which behaved similar to a push notification pop-up. That is, as well as showing the small icon in the status bar I wanted it to pop up on screen to notify the end user. All seems fairly easily, I found this code for how to schedule a notification. That all worked perfectly, apart from the notification would only appear in the status bar. Searching around I found loads of different answers / solutions, mostly all saying the same thing:It only worked if you used 'NotificationCompat.Builder' in place of 'Notification.Builder', orYou had to set the priority to 'NotificationCompat.PRIORITY_HIGH'As usually happens, none of these solutions worked for me until I added in the missing piece of the jigsaw:- '.setDefaults(Notification.DEFAULT_ALL)'. For me this…

Do "Task Hours" add anything in Scrum (Agile)?

What do task hours add to the overall process in scrum?This was a question that has arisen from all team members in both instances that I've helped teams switch over to scrum. The benefits of artifacts like the comparative story point estimation, the 2 week sprints, stand-ups and the end of sprint demo have been self evident to the team, but as one I think every team member has expressed dismay when it comes to task planning and estimating each task in hours. Left unchecked there is a natural tendency for people to actually begin to dread the start of each sprint purely due to the task planning session.In my current role we've been lucky to investigate this further as a team.The team sat down to discuss the problems it was experiencing with estimating tasks in hours and the following common themes appeared:It is hard: Maybe it shouldn't be, but time estimation is hard! Story points are comparative and abstracted making them easier to determine, but time estimate is gen…

IPhone hangs when running from XCode

I've had this happen a couple of times now and the first time was a little worrying that I'd bricked my iPhone. Basically I was running an application on my phone via XCode and when rebuilding an updated version it failed with a "busy" error message. Stopping XCode and unconnecting my phone had no effect, the phone was stuck displaying the loading screen of the application and wouldn't respond to any key commands. To fix you have to hard reboot, holding the power and home button until the phone reboots - doesn't lose any of the data you have on your phone (a concern the first time I did it).