PreparedSqlLiteInsertCommand ExecuteNonQuery error

[erossini]

HI guys,
yesterday for the first time I received this error, apparently, when the app starts:

PreparedSqlLiteInsertCommand.ExecuteNonQuery (System.Object[] source) /Users/fak/Dropbox/Projects/sqlite-net/src/SQLite.cs:2507
SQLiteConnection.Insert (System.Object obj, System.String extra, System.Type objType) /Users/fak/Dropbox/Projects/sqlite-net/src/SQLite.cs:1381
ExceptionDispatchInfo.Throw () /Library/Frameworks/Xamarin.iOS.framework/Versions/10.4.0.128/src/mono/mcs/class/referencesource/mscorlib/system/runtime/exceptionservices/exceptionservicescommon.cs:143
AsyncMethodBuilderCore.m__0 (System.Object state) /Library/Frameworks/Xamarin.iOS.framework/Versions/10.4.0.128/src/mono/mcs/class/referencesource/mscorlib/system/runtime/compilerservices/AsyncMethodBuilder.cs:1018
UIKitSynchronizationContext+c__AnonStorey0.<>m__0 () /Users/builder/data/lanes/3985/ba11e481/source/xamarin-macios/src/UIKit/UIKitSynchronizationContext.cs:24
NSAsyncActionDispatcher.Apply () /Users/builder/data/lanes/3985/ba11e481/source/xamarin-macios/src/Foundation/NSAction.cs:163
(wrapper managed-to-native) UIKit.UIApplication:UIApplicationMain (int,string[],intptr,intptr)
UIApplication.Main (System.String[] args, System.IntPtr principal, System.IntPtr delegate) /Users/builder/data/lanes/3985/ba11e481/source/xamarin-macios/src/UIKit/UIApplication.cs:79
UIApplication.Main (System.String[] args, System.String principalClassName, System.String delegateClassName) /Users/builder/data/lanes/3985/ba11e481/source/xamarin-macios/src/UIKit/UIApplication.cs:63
Application.Main (System.String[] args) /Users/enricorossini/Projects/myapp/myapp/myapp.iOS/Main.cs:17

[praeclarum]

What error did you get? You posted the stack trace but forgot the error.

[aizefler]

Hello @praeclarum,

I have a similar problem, the error message follows:

{SQLite.SQLiteException: Full
at SQLite.PreparedSqlLiteInsertCommand.ExecuteNonQuery (System.Object[] source) [0x00132] in <9de4e78befac41be9b6c4887487b1037>:0
at SQLite.SQLiteConnection.Insert (System.Object obj, System.String extra, System.Type objType) [0x000ef] in <9de4e78befac41be9b6c4887487b1037>:0
at SQLite.SQLiteConnection.InsertOrReplace (System.Object obj) [0x00012] in <9de4e78befac41be9b6c4887487b1037>:0
at MRV.Obras.Mobile.Forms.OrdemServico.Repositories.Data.ConfiguracaoServicoApropriadoRepository+<>c__DisplayClass2_0.b__0 () [0x00022] in C:\Jobs\obras\src\dev\Mobile\Shared\MRV.Obras.Mobile.Forms.OrdemServico\Repositories\Data\ConfiguracaoServicoApropriadoRepository.cs:73
at SQLite.SQLiteConnection.RunInTransaction (System.Action action) [0x0001d] in <9de4e78befac41be9b6c4887487b1037>:0
at MRV.Obras.Mobile.Forms.OrdemServico.Repositories.Data.ConfiguracaoServicoApropriadoRepository.Sincronizar (System.Collections.Generic.List`1[T] items) [0x0000f] in C:\Jobs\obras\src\dev\Mobile\Shared\MRV.Obras.Mobile.Forms.OrdemServico\Repositories\Data\ConfiguracaoServicoApropriadoRepository.cs:65 }

The code that performs the data insertion is, are approximately 200,000 lines:

            ContextDb.Instance.Connection.RunInTransaction(() => {

                foreach (var item in items)
                {
                    var results = 0;

                    var entity = Mapper.Map<ConfiguracaoServicoApropriadoMap>(item);

                    results = ContextDb.Instance.Connection.InsertOrReplace(entity);

                    if (results != 1)
                    {
                        var error = $"Não foi possivel sincronizar a Configuracao Servico Apropriado {item.Id}";
                        Debug.WriteLine(error);
                        throw new DataBaseException(error);
                    }
                }
            });

[Kipotlov]

Hi,
I have the same problem! It crash because the member variable "Connection" is null, on this line :
if (Connection.Trace)
Please note that it happends during multithread access.

Here is the call stack in your code :
SQLite-net.dll!SQLite.PreparedSqlLiteInsertCommand.ExecuteNonQuery(object[] source) Line 2989
SQLite-net.dll!SQLite.SQLiteConnection.Insert(object obj, string extra, System.Type objType) Line 1667
SQLite-net.dll!SQLite.SQLiteConnection.InsertOrReplace(object obj, System.Type objType) Line 1596

[Kipotlov]

I think i found the bug. Take a look at my comment on #761.

[aliyailina]

Looks like issue still exists. We have some crashes in Crashlytics with same StackTrace:

Non-fatal Exception: SQLiteException - Full
unable to open database file
0x0 SQLite.PreparedSqlLiteInsertCommand.ExecuteNonQuery(System.Object[] source) (<unknown>)
0x0 SQLite.SQLiteConnection.Insert(System.Object obj, System.String extra, System.Type objType) (<unknown>)
0x0 SQLite.SQLiteConnection.InsertOrReplace(System.Object obj) (<unknown>)
0x0 SQLite.SQLiteAsyncConnection+<>c__DisplayClass54_0.<InsertOrReplaceAsync>b__0(SQLite.SQLiteConnectionWithLock conn) (<unknown>)
0x0 SQLite.SQLiteAsyncConnection+<>c__DisplayClass33_0`1[System.Int32].<WriteAsync>b__0() (<unknown>)