Android not saving the inserts [workaround needed]

[chintanop]

@brodybits Seems like a bunch of folks are facing this issue: on Android: https://groups.google.com/forum/#!topic/Cordova-SQLitePlugin/oq8wMDSH4M4

Cordova: 3.5.0
Android API Level: 19

Any idea?

[brody4hire]

It sounds like an issue introduced by recent updates to the Android sqlite classes. SQLite itself should never do this: https://www.sqlite.org/transactional.html

[brody4hire]

From December 2014:

On Tue, Dec 16, 2014 at 1:48 PM, mladenpetrovic88@gmail.com wrote:

I have been using this plugin for some time now, and recently i noticed that
sometimes plugin just doesn't insert anything in database. From the several
things that need to be initialized on app start, nothing is inserted, and of
course my whole app breaks.
I noticed this after updates to android support jar, cordova and few other
things.
I can't think of any reason why something like this would occur so please
any tips would be helpful.
Thank you

On Wed, Dec 17, 2014 at 1:59 PM, mladenpetrovic88@gmail.com wrote:

After hours of trying to figure out why/when does db fails i finally figured
it out.
When i start the app then exit it (not close/swipe it) and return back to
app sqlite plugin notifies me again in console that database is opened
again

SQLitePlugin openargs: {"name":"insideoutdb","bgType":1}
I am using cordova 4.0.0, Ionic 1.2.8 and sqlite 3.8.6 on lollipop and
kitkat.
My understanding is that database isn't closed until you explicitly close
the app ( or android kills it ) so when i come back to my app it tries to
open already opened db and it overwrites it or crash.

From February 2015:

On Sun, Feb 15, 2015 at 12:48 AM, Cesar Fernandes cesar.fa@gmail.com wrote:

I have the same problem.... I am working with latest versions of cordova
and plugin...

I manage 3 sqlite tables. I make some inserts in one of the tables, and when
i close the app and come back, the inserts get lost... then for some reason
that i can not find out, i populate the second table with lots of entries
from one web service, and this one does not get lost.... i already tried
lots of things to solve this problem, but i am almost givin up...

I alway get messages that database is locked , or database was closed bu
remained 1 without closing....

On Sun, Mar 1, 2015 at 1:54 AM, COP chintan@trialx.com wrote:

Hi, I'm also having the same problem on Android

The inserts work fine till the APP is on, i.e. you can insert and select the
data.

Once, you KILL the app. All the inserts are gone! Works fine in iOS - the
Android is not working.

[brody4hire]

What I am suspecting now is the following commit in the Android database classes: aosp-mirror/platform_external_sqlite@d4f30d0

It references the following sqlite fossil commit: http://www.sqlite.org/src/info/6c4c2b7dba

[brody4hire]

I made a possible workaround in the branch xb-android-lock-workaround. Can you please let us know if this will solve the problem?

[chintanop]

@brodybits Thanks a lot for quick turn-around! this worked!

[brody4hire]

Happy that it solves your problem. But it points to an issue with the Android sqlite library. My idea is to make this workaround an option for those who need it.