IOS issue

[jondediego]

I am experiencing an issue using the last version of this plugin for an Ionic app at IOS platform (it doesn't happen on Android platform). The app executes a synchronizing process that makes intesive access to database. At some random point insert sql statement start failing with: "NOT NULL CONSTRAINT FAILED" error. If we start debugging our app using Safari, the error never happens. Could it be due to this issue mentioned at readme ?
"The iOS/macOS platform versions do not support certain rapidly repeated open-and-close or open-and-delete test scenarios due to how the implementation handles background processing"
Could you explain me this issue so I can understand if our app's error has something to due with it?
Thanks

[andreamaioli]

I think we got the same issue in a different version of this plugin, and we found a solution. The problem is related to background processing. It can alter the order of the commands because the runInBackground method uses a concurrent queue, not a serial one.

object-layer/cordova-sqlite-plugin#11

[jondediego]

In my case, I am using an Ionic app and it is true that I am doing background tasks so your comment makes sense. But the error happened to me building the app in debug mode, since I build my Ionic app for production it hasn't happened to me again.

[brody4hire]

SQLitePlugin.js uses a queueing mechanism that sends only one batch at a time to the native code for each open database. The JavaScript waits for the result before sending the next batch on the database.

I would really need a reproduction demo to treat this as a bug.