[BUG] MissingMethodException when project build and deployed via Visual Studio 2022 about akavache HOT 29 CLOSED

@glennawatson sorry it's taken me a bit, but I created a dirt-simple sample project that demonstrates the error.
https://github.com/mgramley/Akavache.MissingMethodExceptionSample

GitHub

GitHub - mgramley/Akavache.MissingMethodExceptionSample: This sample shows an example of the MissingMethodException being thrown by Akavache

This sample shows an example of the MissingMethodException being thrown by Akavache - GitHub - mgramley/Akavache.MissingMethodExceptionSample: This sample shows an example of the MissingMethodExcep...

from akavache.

Might be worth making a sample if you can.

Other thing that can commonly cause this is a version mismatch with the nuget package

from akavache.

So I'll try to create a sample project with this when I can.

Which NuGet packages would be mismatched? I think I have the latest installed, unless you mean a mismatch with one of its dependencies?

Also thank you for the quick feedback :)

from akavache.

Thinking the sqlite package.

from akavache.

So I don't reference the sqlite package directly, I assume it just gets resolved since it's an Akavache dependency. I checked my other dependencies to see if any relied on sqlite, but they don't, so I'm not sure what it would be mismatching with.

Again, this works just fine when I build and deploy from VS 2019. It's only causing this issue when deployed from VS 2022. I would assume that a package mismatch issue would show up for both.

from akavache.

@mgramley did you find any solution? I am also facing the same issue while trying to use vS2022 .
Akavache version 7.3.1
akavache.sqlite3 7.3.1

from akavache.

same problem on await BlobCache.Secure.GetObjects<T>(keys)

System.MissingMemberException

Method not found: System.ReadOnlySpan1<byte> SQLitePCL.raw.sqlite3_column_blob(SQLitePCL.sqlite3_stmt,int)

at Akavache.Sqlite3.SqliteOperationQueue.MarshalCompletion[T] (System.Object completion, System.Func1[TResult] block, System.IObservable`1[T] commitResult) [0x00012] in D:\a\Akavache\Akavache\src\Akavache.Sqlite3\Queues\OperationQueue.cs:488
--- End of stack trace from previous location where exception was thrown ---

at System.Reactive.PlatformServices.ExceptionServicesImpl.Rethrow (System.Exception exception) [0x00000] in //Rx.NET/Source/src/System.Reactive/Internal/ExceptionServicesImpl.cs:19
at System.Reactive.ExceptionHelpers.Throw (System.Exception exception) [0x00000] in //Rx.NET/Source/src/System.Reactive/Internal/ExceptionServices.cs:16
at System.Reactive.Subjects.AsyncSubject1[T].GetResult () [0x00038] in /_/Rx.NET/Source/src/System.Reactive/Subjects/AsyncSubject.cs:430

Microsoft Visual Studio Community 2022 (64-bit) - Preview
Version 17.1.0 Preview 1.1

any solutions?

from akavache.

@mgramley did you find any solution? I am also facing the same issue while trying to use vS2022 . Akavache version 7.3.1 akavache.sqlite3 7.3.1

Sorry, I haven't found a solution, I've just reverted back to using 2019 for the time being.

from akavache.

@protokovich it's nice to know I'm not the only one seeing this issue. I haven't found any solutions yet though.

from akavache.

If it helps, I found the same issue with VS 2022 preview and recently installed VS 2019 16.11.6 where the issue also happens.

The previous version I had installed was 16.10.4 and it did not have this problem.

Also, just checked, and the version deployed to AppCenter thru Azure DevOps works fine too.

from akavache.

Will have a look over the weekend and see what I can find with VS2022.

Won't be in a position to get to it sooner. I suspect VS2022 for some reason is loading a different SQLitePCL

Also probably worth lodging an issue in the SQLiteRaw repository https://github.com/ericsink/SQLitePCL.raw/issues

GitHub

Issues · ericsink/SQLitePCL.raw

A Portable Class Library (PCL) for low-level (raw) access to SQLite - Issues · ericsink/SQLitePCL.raw

from akavache.

Might be worth adding a reference to the SQLitePCL.Raw.Core nuget package as well in your platform projects (Android/iOS) and see if that helps.

from akavache.

@glennawatson I'll try that and get back to you.

And you should consider look into VS 2019 at least version 16.11.6 as well. As I stated above, the problem also happens on this version after I updated the IDE

from akavache.

@glennawatson I should install the latest SQLitePCLRaw.bundle_e_sqlite3 or a specific version?

from akavache.

@glennawatson referencing SQLitePCLRaw.bundle_e_sqlite3 did not help. Tried versions 2.0.4 and 2.0.7

from akavache.

Same issue. The only resolution I found is setting everything to BlobCache.InMemory.

from akavache.

My workaround was to downgrade the VS 2019 version back to 16.10.4, last version that worked for me.

from akavache.

I've done a release that includes more up to date sqlite_lite_raw

Can anyone confirm if this helps with this problem?

Thanks

from akavache.

@glennawatson it did not help

on:
await BlobCache.Secure.GetObjects<T>(keys)

System.MissingMemberException

Method not found: System.ReadOnlySpan``1<byte> SQLitePCL.raw.sqlite3_column_blob(SQLitePCL.sqlite3_st…

  at Akavache.Sqlite3.SqliteOperationQueue.MarshalCompletion[T] (System.Object completion, System.Func`1[TResult] block, System.IObservable`1[T] commitResult) [0x00012] in D:\a\Akavache\Akavache\src\Akavache.Sqlite3\Queues\OperationQueue.cs:488 
--- End of stack trace from previous location where exception was thrown ---

  at System.Reactive.PlatformServices.ExceptionServicesImpl.Rethrow (System.Exception exception) [0x00000] in /_/Rx.NET/Source/src/System.Reactive/Internal/ExceptionServicesImpl.cs:19 
  at System.Reactive.ExceptionHelpers.Throw (System.Exception exception) [0x00000] in /_/Rx.NET/Source/src/System.Reactive/Internal/ExceptionServices.cs:16 
  at System.Reactive.Subjects.AsyncSubject`1[T].GetResult () [0x00038] in /_/Rx.NET/Source/src/System.Reactive/Subjects/AsyncSubject.cs:430 

from akavache.

I've added an issue in @ericsink SQLitePCL.raw GitHub repo, noticing this issue is happening in multiple libraries now that rely on it with Xamarin. I suspect it may be new restrictions on P/Invokes introduced in newer Xamarin versions.

Also reached out to Eric directly.

from akavache.

Has there been an update on this?

from akavache.

@mgramley No update yet. I'm still trying to figure this out. Any progress I make will appear over at ericsink/SQLitePCL.raw#462

from akavache.

I'm keeping this issue open so people can quickly see it's being worked on but it's not a Akavache issue but the dependency SQLitePCLRaw, so please monitor in the link Eric provided.

from akavache.

Can everyone update to Visual Studio 2022 17.0.3 and see if it resolves the issue

from akavache.

I'm facing this same exception but only when deploying Xamarin.iOS, not with Xamarin.Android

System.MissingMethodException: 'Method not found: System.ReadOnlySpan1<byte> SQLitePCL.raw.sqlite3_column_blob(SQLitePCL.sqlite3_stmt,int)'

Here is some background:

1. I was previously using VS2019 (16.11.8) and only developing Xamarin.Android - no issues.
2. Yesterday I decided to update VS2019 (16.11.8) to VS2022 (17.0.3) and for the first time ever I launched the same app on a physical iPhone device and faced this issue immediately. Android deployments are still working without issues with both VS2019 (16.11.8) and VS2022 (17.0.3).
3. I found this Github issue and re-installed VS2019 (16.11.8) to see if the problem would happen also with it when deploying Xamarin.iOS - yes it does

So I'm not sure if this is about VS2020 since I managed to reproduce it with VS2019 (16.11.8)

from akavache.

@CreamyMiracle it seems to be a visual studio bug at this time. Worth monitoring the issue above to the sqliteraw and also lodging a bug to the Microsoft bug contained within

from akavache.

The same issue in Android...

from akavache.

Follow ericsink/SQLitePCL.raw#462 for updates

from akavache.

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

from akavache.