Hi,

I have two datastores for my Xamarin Forms app, I have tried making these public static instances so they can be referenced from other classes that need them but it works very sporadically. That is, it will sometimes throw exceptions when trying to access these instances. Is there a performance penalty for using class level objects for the datastores?

Hi Vinay/Pranav,

Looks like the latest release 3.0.11 resolves these issues.

Thanks for your assistance!

Hi Michael,

Quick question: when you upgraded to using 3.0.9 to resolve the SQLite issue, did you also add a reference to `Mono.Data.Sqlite`, as per the Getting Started guide?  It is only after adding this reference that the SQLite fix will work.

Thanks,

Vinay

Kinvey

Hi Pranav,

Unfortunately I am still seeing this issue after updating to 3.0.9. Is there any other information you think I am missing?

Pranav,

I was the one who submitted that issue, so even with that workaround for the driver issue I am still seeing the issue.

1. The SyncAsync call is awaited so it should be completed before the following query.
2. There aren't any pending changes as I am only logging in and out without adding data to the collection.
3. I get the same error for the Cache datastore. 
4. SampleItem is configured correctly. If I restart the app after the failed Query and perform the same query a result is returned. Here is a video showing the issue. https://www.youtube.com/watch?v=xBIbX6I08dc&feature=youtu.be

It seems like even though I await the SyncAsync() call the SQLConnection has not properly completed. Could this be related to the SQLIte issue found here?

Pranav, the following sequence will always throw the exception on iOS and Android:

• Login User
• Sync Collections
• Query Collection (no Issue)
• Logout User
• Login User
• Sync Data
• Query Collection (Exception thrown here)

Hi Pranav, 

To be sepcific I can repeat this by doing the following, logout, login, do datastore sync() then perform a query. See below for code:

LoginPage.xaml.cs

 messageLabel.Text = "";
			var user = new User () {
				Username = usernameEntry.Text,
				Password = passwordEntry.Text
			};
            try
            {
                Kinvey.User kinveyUser = await Kinvey.User.LoginAsync(user.Username, user.Password);
                IsRunning = false;
				await Navigation.PushAsync(new HomePage());
            } catch (KinveyException ke)
            {
				messageLabel.Text = "Login failed: " + ke.Description;

            }

HomePage.xaml.cs
public partial class HomePage : ContentPage
    {
        DataStore<SampleItem> sampleDataStore = DataStore<SampleItem>.Collection("SampleItem", DataStoreType.SYNC);
        DataStore<AssetItem> assetDataStore = DataStore<AssetItem>.Collection("AssetItem", DataStoreType.SYNC);
        public HomePage()
        {
            InitializeComponent();
           syncDataAsync();
...

async void syncDataAsync()
        {
            await sampleDataStore.SyncAsync();
            await assetDataStore.SyncAsync();
            await DisplayAlert("Finsihed Sync", "Done Syncing", "OK");
            activityIndicator.IsVisible = false;
            activityIndicator.IsRunning = false;
        }
...
//Do Query
List<SampleItem> sampleByQuery = new List<SampleItem>();
            var query = sampleDataStore.Where(x => x.BottleBarcode.Equals(e.scannedItem));
            sampleByQuery = await sampleDataStore.FindAsync(query);

The following exception is thrown AFTER data has been synced when I try to perform the query "[ERROR] FATAL UNHANDLED EXCEPTION: Kinvey.KinveyException: An exception was thrown while trying to find entities in the cache.Error in the query expression used to find entities in the cache. ---> SQLite.Net.SQLiteException: no such table: SampleItem"

This seems odd as the datastore should be initialised as I await the syncasync() call. However if i restart the app without logging out then in again this problem does not occur.

Just to add to this, I have found some strange behaviour where if I logout and login I get an ERROR_DATASTORE_CACHE_FIND_QUERY  with the exception message "An exception was thrown while trying to find entities in the cache.Error in the query expression used to find entities in the cache." Does it simply mean that it can't find the entities or that the cache does not exist? I am also getting SQLite.Net.SQLiteException: Busy exceptions where these local instances are being created.