Unable to begin transaction: cannot start a transaction within a transaction. about cordova-sqlite-ext HOT 3 CLOSED

I am running in to a problem where I get this ERROR:

Unable to begin transaction: cannot start a transaction within a transaction.

It's really a bummer. 😞

From the past 4-5 years of supporting this plugin I have never seen such an error before. Given the level of testing we have done in the test suite, others (such as Nolan Lawson) have done with the PouchDB adapter, and number of users in the field I would be extremely surprised to see this as a bug in the CoffeeScript/JavaScript part.

Considering that this is a multi-page app, my theory is that this happens if the JavaScript part starts a transaction and then the app goes to another page before the transaction finishes.

In case of a multi-page app I think the safest workaround is to execute all SELECTs and changes using db.executeSql instead of using the standard transaction mechanism.

from cordova-sqlite-ext.

Dude. this is too wierd. I thought the answer was to use JS Promises - so I re-worked the code and the thing still happened (!?!)

frustrating.

So I ended up back here and tried the last paragraph in your response above - and I think that is the answer - so far it is working.

But why do I seem to think you have to use the standard transaction mechanism? Do you know? Is it a rule or standard for sqlite? Or what?

thanks

• Sandi

from cordova-sqlite-ext.

I would like to continue the discussion in storesafe/cordova-sqlite-storage#666 which I just opened on the main cordova-sqlite-storage version (sorry for the symbolism here).

from cordova-sqlite-ext.