Databases
StackOverflow2013
Postsdbo
POSQLiteException "cannot commit - no transaction is active" while inserting with CONFLICT_REPLACE
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQLiteException "cannot commit - no transaction is active" while inserting with CONFLICT_REPLACE
    primarykey
    data
    text
    <p>I have some trouble updating my database.</p> <p>This is the log:</p> <pre><code>12-02 16:18:57.502: D/Data Update(21218): Start updating databases 12-02 16:18:57.502: D/Data Update(21218): update size: 5 12-02 16:18:57.502: D/Data Update(21218): updating table cemeteries 12-02 14:28:51.877: I/SqliteDatabaseCpp(18826): sqlite returned: error code = 1802, msg = statement aborts at 13: [INSERT OR REPLACE INTO cemeteries(id,name) VALUES (?,?)] , db=/data/data/de.l_one.app.shaufelv14/databases/poidatabase 12-02 14:28:51.877: E/SQLiteStatementCpp(18826): native_execute (step): errno = 2, error message = No such file or directory, handle = 0xdc0b70 12-02 14:28:51.877: I/SqliteDatabaseCpp(18826): sqlite returned: error code = 1, msg = statement aborts at 2: [COMMIT;] cannot commit - no transaction is active, db=/data/data/de.l_one.app.shaufelv14/databases/poidatabase 12-02 14:28:51.887: E/Data Update(18826): Update failed 12-02 14:28:51.887: E/Data Update(18826): android.database.sqlite.SQLiteException: cannot commit - no transaction is active 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method) 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:90) 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:2006) 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1946) 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteDatabase.endTransaction(SQLiteDatabase.java:764) 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteStatement.releaseAndUnlock(SQLiteStatement.java:273) 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:115) 12-02 14:28:51.887: E/Data Update(18826): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1807) 12-02 14:28:51.887: E/Data Update(18826): at de.l_one.app.shaufelv14.DataUpdater.update(DataUpdater.java:102) 12-02 14:28:51.887: E/Data Update(18826): at de.l_one.app.shaufelv14.MainActivity$5.run(MainActivity.java:104) </code></pre> <p>This is the code I use to insert new Data:</p> <pre class="lang-java prettyprint-override"><code>int updateSize = 0; // cvs is an ArrayList&lt;ContentValues&gt; array with each entry holding // the new values for a certain table // I know I could use a Map but let's change one thing after another for(ArrayList&lt;ContentValues&gt; list : cvs) updateSize += list.size(); Log.d(DEBUG_TAG, "Start updating databases"); Log.d(DEBUG_TAG, "update size: "+updateSize); if(updateSize &gt; 0) { dbHelper = ShaufelDatabaseHelper.getInstance(context); connection = dbHelper.getWritableDatabase(); for(int i=0; i&lt;cvs.length; i++) { String table; switch(i) { case 0: table = "cemeteries"; break; case 1: table = "customers"; break; case 2: table = "graves"; break; case 3: table = "orders"; break; case 4: table = "plants"; break; case 5: table = "plantevents"; break; case 6: table = "services"; break; case 7: table = "serviceevents"; break; default: throw new RuntimeException("wtf"); } Log.d(DEBUG_TAG, "updating table "+table); for(ContentValues cv: cvs[i]) { // replace updated values, insert new ones connection.insertWithOnConflict(table, null, cv, SQLiteDatabase.CONFLICT_REPLACE); } } } </code></pre> <p>The strange thing about this is that the Exception is not thrown everytime. It's more like this:</p> <p>If you start the App and log in, the Update works. If you then log out and back in (without closing the app) the update happens again but this time with the Exception.<br> If you close the app (not just pressing home but forcing a close with the android system) it will work again until you log out and back in.<br> The updates all contain the same data (we are currently testing this stuff) and it's run by the same code and yet it works only half the time.</p> <p>This is run on Android 4.0.3 on a HTC Sensation.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGraham Borland
    1. USIchBinKeinBaum
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQLiteException "cannot commit - no transaction is active" while inserting with CONFLICT_REPLACE
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSQLiteException "cannot commit - no transaction is active" while inserting with CONFLICT_REPLACE
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload