Database is locked

Bug #720458 reported by pjv
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Collectionista
New
Medium
Unassigned
Alpha
New
Medium
Unassigned

Bug Description

02-17 00:58:29.251: ERROR/Database(30757): Error inserting modified=1297900705534 created=1297900708190 subtype=/items/cd/music name=Cesaria Evora - Cabo Verde
02-17 00:58:29.251: ERROR/Database(30757): android.database.sqlite.SQLiteException: error code 5: database is locked
02-17 00:58:29.251: ERROR/Database(30757): at android.database.sqlite.SQLiteStatement.native_execute(Native Method)
02-17 00:58:29.251: ERROR/Database(30757): at android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java:55)
02-17 00:58:29.251: ERROR/Database(30757): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549)
02-17 00:58:29.251: ERROR/Database(30757): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1410)
02-17 00:58:29.251: ERROR/Database(30757): at net.lp.collectionista.alpha.providers.ProductContentProvider.insert(ProductContentProvider.java:282)
02-17 00:58:29.251: ERROR/Database(30757): at android.content.ContentProvider$Transport.insert(ContentProvider.java:174)
02-17 00:58:29.251: ERROR/Database(30757): at android.content.ContentResolver.insert(ContentResolver.java:587)
02-17 00:58:29.251: ERROR/Database(30757): at net.lp.collectionista.alpha.providers.FacadeContentProvider.insert(FacadeContentProvider.java:454)
02-17 00:58:29.251: ERROR/Database(30757): at android.content.ContentProvider$Transport.insert(ContentProvider.java:174)
02-17 00:58:29.251: ERROR/Database(30757): at android.content.ContentResolver.insert(ContentResolver.java:587)
02-17 00:58:29.251: ERROR/Database(30757): at net.lp.collectionista.alpha.ui.activities.collections.cd.CDCollectionViewWindow$MusicCDItemScanAddTask.doInBackground(CDCollectionViewWindow.java:213)
02-17 00:58:29.251: ERROR/Database(30757): at net.lp.collectionista.alpha.ui.activities.collections.cd.CDCollectionViewWindow$MusicCDItemScanAddTask.doInBackground(CDCollectionViewWindow.java:1)
02-17 00:58:29.251: ERROR/Database(30757): at net.lp.collectionista.alpha.util.ScanAddTask.doInBackground(ScanAddTask.java:1)
02-17 00:58:29.251: ERROR/Database(30757): at android.os.AsyncTask$2.call(AsyncTask.java:185)
02-17 00:58:29.251: ERROR/Database(30757): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
02-17 00:58:29.251: ERROR/Database(30757): at java.util.concurrent.FutureTask.run(FutureTask.java:137)
02-17 00:58:29.251: ERROR/Database(30757): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1068)
02-17 00:58:29.251: ERROR/Database(30757): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:561)
02-17 00:58:29.251: ERROR/Database(30757): at java.lang.Thread.run(Thread.java:1096)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): FATAL EXCEPTION: AsyncTask #3
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): java.lang.RuntimeException: An error occured while executing doInBackground()
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at android.os.AsyncTask$3.done(AsyncTask.java:200)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.util.concurrent.FutureTask$Sync.innerSetException(FutureTask.java:273)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.util.concurrent.FutureTask.setException(FutureTask.java:124)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:307)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.util.concurrent.FutureTask.run(FutureTask.java:137)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1068)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:561)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.lang.Thread.run(Thread.java:1096)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): Caused by: android.database.SQLException: Failed to insert row into content://net.lp.collectionista.alpha.products.items/
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at net.lp.collectionista.alpha.providers.ProductContentProvider.insert(ProductContentProvider.java:289)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at android.content.ContentProvider$Transport.insert(ContentProvider.java:174)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at android.content.ContentResolver.insert(ContentResolver.java:587)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at net.lp.collectionista.alpha.providers.FacadeContentProvider.insert(FacadeContentProvider.java:454)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at android.content.ContentProvider$Transport.insert(ContentProvider.java:174)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at android.content.ContentResolver.insert(ContentResolver.java:587)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at net.lp.collectionista.alpha.ui.activities.collections.cd.CDCollectionViewWindow$MusicCDItemScanAddTask.doInBackground(CDCollectionViewWindow.java:213)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at net.lp.collectionista.alpha.ui.activities.collections.cd.CDCollectionViewWindow$MusicCDItemScanAddTask.doInBackground(CDCollectionViewWindow.java:1)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at net.lp.collectionista.alpha.util.ScanAddTask.doInBackground(ScanAddTask.java:1)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at android.os.AsyncTask$2.call(AsyncTask.java:185)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
02-17 00:58:32.671: ERROR/AndroidRuntime(30757): ... 4 more

pjv (pjv)
Changed in collectionista:
importance: Undecided → Medium
Revision history for this message
pjv (pjv) wrote :

Changed ABORT into ROLLBACK for triggers, to see if this fixes it.

Revision history for this message
pjv (pjv) wrote :
Revision history for this message
pjv (pjv) wrote :
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.