SQLiteException: file is not a database

[fgiacomelli]

Steps to reproduce

We was not able to reproduce the problem explicitly.

Actual behaviour

We have a lot of crashes logged in appcenter about the problem "file is not a database" and others with different messages, but I suspect that all the problems could be related to the lock mechanism.
Others sqlite related errors are:

• SQLite.SQLiteException: Could not open database file:

• SQLite.SQLiteException: Busy

• System.InvalidOperationException: Cannot begin a transaction while already in a transaction

we don't use async connection inside transactions, using a unique encrypted connection in the app, created with:

• OpenFlags: SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create | SQLiteOpenFlags.FullMutex

Configuration

Operating system:
Android, all versions from API 25 to API 29

Library Version:
1.7.335

.NET Version:
NETStandard.Library 2.0.3

StackTrace

020-05-11 07:58:17.5910|Trace|BugReportingManager - CurrentDomain_UnhandledException - line: 149 | ****** Current Domain Unhandled Exception ******
2020-05-11 07:58:17.5928|Error|BugReportingManager - PreparaCrashReport - line: 134 | SQLite.SQLiteException: file is not a database
at SQLite.SQLite3.Prepare2 (SQLitePCL.sqlite3 db, System.String query) [0x00021] in C:\Jenkins\workspace\1.0.76\sqlite-net\src\SQLite.cs:4530
at SQLite.SQLiteCommand.Prepare () [0x00011] in C:\Jenkins\workspace\1.0.76\sqlite-net\src\SQLite.cs:3219
at SQLite.SQLiteCommand+d__121[T].MoveNext () [0x00079] in C:\Jenkins\workspace\1.0.76\sqlite-net\src\SQLite.cs:3115 at System.Collections.Generic.List1[T].AddEnumerable (System.Collections.Generic.IEnumerable1[T] enumerable) [0x00059] in /Users/builder/jenkins/workspace/archive-mono/2019-10/android/release/external/corefx/src/Common/src/CoreLib/System/Collections/Generic/List.cs:1108 at System.Collections.Generic.List1[T]..ctor (System.Collections.Generic.IEnumerable1[T] collection) [0x00062] in /Users/builder/jenkins/workspace/archive-mono/2019-10/android/release/external/corefx/src/Common/src/CoreLib/System/Collections/Generic/List.cs:87 at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable1[T] source) [0x00018] in /Users/builder/jenkins/workspace/archive-mono/2019-10/android/release/external/corefx/src/System.Linq/src/System/Linq/ToCollection.cs:30
at SQLite.SQLiteCommand.ExecuteQuery[T] () [0x0001c] in C:\Jenkins\workspace\1.0.76\sqlite-net\src\SQLite.cs:3079
at SQLite.SQLiteConnection.Query[T] (System.String query, System.Object[] args) [0x00008] in C:\Jenkins\workspace\1.0.76\sqlite-net\src\SQLite.cs:1071

[MattePozzy]

Same problem here.
We have a encrypted DB and we use the sqlite-net-sqlcipher package.

[akuehntopf]

Happens here as well in our app.
We are using sqlite-net-sqlcipher.

Error:

Exception in async method.SQLite.SQLiteException: file is not a database
at SQLite.SQLite3.Prepare2 (SQLitePCL.sqlite3 db, System.String query) [0x0001b] in :0
at SQLite.SQLiteCommand.Prepare () [0x00011] in :0

Repro steps:

1. Install sqlite-net-sqlcipher 1.5.231
2. Start app so that it creates its database file
3. Upgrade to latest sqlite-net-sqlcipher 1.7.335
4. Start app. Exception is triggered

[juanmalm]

Same problem here on UWP

Same here on Windows 10 targeting .Net Framework 4.7.2

Nuget packages:

• sqlite-net-sqlcipher v1.7.335
• SQLItePCLRaw.bundle_sqlcipher v1.1.4

Stepping back to the previous stable sqlite-net-sqlcipher release (v1.6.292) works fine.

[xhashimks]

@Mcgeecorp
In 1.6292 - we get issue #865.

Hence, I tried 1.7-beta and it worked. But i am facing issue while running this in iOS14 beta. Throwing below exception

{SQLite.SQLiteException: Row
at SQLite.SQLiteCommand.ExecuteNonQuery () [0x000ca] in :0
at SQLite.SQLiteConnection.Execute (System.String query, System.Object[] args) [0x00039] in :0
at SQLite.SQLiteConnection.SetKey (System.String key) [0x00026] in :0
at SQLite.SQLiteConnection..ctor (SQLite.SQLiteConnectionString connectionString) [0x0011a] in :0
at SQLite.SQLiteConnectionWithLock..ctor (SQLite.SQLiteConnectionString connectionString) [0x0000b] in :0
at SQLite.SQLiteConnectionPool+Entry.Connect () [0x0001c] in :0
at SQLite.SQLiteConnectionPool.GetConnection (SQLite.SQLiteConnectionString connectionString) [0x00048] in :0
at SQLite.SQLiteAsyncConnection.GetConnection () [0x00005] in :0
at SQLite.SQLiteAsyncConnection+<>c__DisplayClass32_01[T].b__0 () [0x00000] in :0 at System.Threading.Tasks.Task1[TResult].InnerInvoke () [0x0000f] in /Library/Frameworks/Xamarin.iOS.framework/Versions/Current/src/Xamarin.iOS/external/corert/src/System.Private.CoreLib/src/System/Threading/Tasks/Future.cs:534
at System.Threading.Tasks.Task.Execute () [0x00000] in /Library/Frameworks/Xamarin.iOS.framework/Versions/Current/src/Xamarin.iOS/external/corert/src/System.Private.CoreLib/src/System/Threading/Tasks/Task.cs:2319 }

var sqlConnectionOptions = new SQLiteConnectionString(dbPath, true, "TestKey");
database = new SQLiteAsyncConnection(sqlConnectionOptions);
database.CreateTableAsync().Wait(); // Exception throwing in this line

public class UserData
{
[PrimaryKey]
public string UserId { get; set; }
public int RollNo { get; set; }
public string Created { get; set; }
public string Updated { get; set; }
public bool IsActive { get; set; }
}

[praeclarum]

Hi everyone, I'm looking at this now, sorry for the trouble.

@fgiacomelli are you also using an encrypted database as others?

[fgiacomelli]

Hi @praeclarum , yes I'm already using an encrypted database

[ericsink]

@praeclarum if this starts looking a problem down near SQLitePCLRaw, lemme know how I can help.

[xhashimks]

@praeclarum In my case, I am using an encrypted database created using Sqlite-net-pcl 1.5.231. Now I am using the sqlite-pcl-sqlcipher 1.7.335 as part of the iOS14 qualification. So while running the app, when this new plugin tries to access the already encrypted DB, I am getting the file is not a database exception.

[sjlombardo]

I believe that the SQLiteException: Row issue may be unrelated to the other problems. The SetKey methods in SQLite.cs should use ExecuteScalar instead of Execute to handle the "ok" result set that is returned from PRAGMA key as of SQLCipher 4.3.0.