SQLite corrupt exception in Xamarin iOS app using HybridWebView

Question

SQLite corrupt exception in Xamarin iOS app using HybridWebView

Ritesh Singh 1

In our iOS application, we have provided the data Downloading feature from the API. Here we first delete the data from the local SQLite database and then insert the newly fetched data from the API into SQLite DB.
It works fine for the 1st and 2nd time when we install the app on an iOS device. But after that, if we try to download the data for 3rd time then we get a "database disk image is malformed" error.

The application works fine on Android devices but it is not working in iOS.

JarvanZhang 23,971 Reputation points

2021-06-21T03:29:24.027+00:00

Hi, @Ritesh Singh Could the sqlite database work if re-deploying the project on the ios device? And will the issue occur every time when downloading the data for 3rd time? Make sure that only one thread is trying to write to the database at a time.
Ritesh Singh 1 Reputation point

2021-06-21T05:25:12.007+00:00

Could the sqlite database work if re-deploying the project on the ios device?

> Yes, If we re-installed the app, it is working fine for 1st and 2nd time but for the 3rd time getting the same issue.
Ritesh Singh 1 Reputation point

2021-06-21T05:34:19.467+00:00

And will the issue occur every time when downloading the data for 3rd time?

> The app is no longer accessible once get the error. I have to re-install it every time after the error.
JarvanZhang 23,971 Reputation points

2021-06-21T09:18:51.747+00:00

Is the function achieved on each platform or on the shared project? Do you use the background process on iOS? Please post the related function code, it'll help to get the cause to the problem.