OI Shopping List: IllegalStateException in SQLiteClosable.acquireReference()

[GoogleCodeExporter]

Crash:
Exception class java.lang.IllegalStateException
Source method SQLiteClosable.acquireReference()

Platforms:
Nexus One, Droid

Stack traces:

v1.2.6
Jan 20, 2011 1:53:47 AM
1 reports/week 
1 reports 

java.lang.IllegalStateException: attempt to re-open an already-closed object: 
android.database.sqlite.SQLiteQuery (mSql = SELECT items._id, items.name FROM 
items WHERE (upper(name) like ?) ORDER BY name desc) 
at 
android.database.sqlite.SQLiteClosable.acquireReference(SQLiteClosable.java:34)
at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:64)
at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:283)
at android.database.sqlite.SQLiteCursor.onMove(SQLiteCursor.java:255)
at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:188)
at android.database.CursorWrapper.moveToPosition(CursorWrapper.java:187)
at android.widget.CursorAdapter.getItemId(CursorAdapter.java:155)
at android.widget.AdapterView.rememberSyncState(AdapterView.java:1125)
at 
android.widget.AdapterView$AdapterDataSetObserver.onChanged(AdapterView.java:787
)
at android.database.DataSetObservable.notifyChanged(DataSetObservable.java:31)
at android.widget.BaseAdapter.notifyDataSetChanged(BaseAdapter.java:50)
at android.widget.CursorAdapter.changeCursor(CursorAdapter.java:260)
at android.widget.SimpleCursorAdapter.changeCursor(SimpleCursorAdapter.java:321)
at android.widget.CursorFilter.publishResults(CursorFilter.java:67)
at android.widget.Filter$ResultsHandler.handleMessage(Filter.java:282)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:123)
at android.app.ActivityThread.main(ActivityThread.java:4627)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at 
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:878)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:636)
at dalvik.system.NativeStart.main(Native Method)

--------------------------------------------------------------------------------

v1.2.4, v1.2.6
Jan 16, 2011 8:28:39 AM
1 reports/week 
3 reports 

java.lang.IllegalStateException: attempt to re-open an already-closed object: 
android.database.sqlite.SQLiteQuery (mSql = SELECT items._id, items.name FROM 
items WHERE (upper(name) like ?) ORDER BY name desc) 
at 
android.database.sqlite.SQLiteClosable.acquireReference(SQLiteClosable.java:34)
at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:64)
at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:293)
at android.database.sqlite.SQLiteCursor.onMove(SQLiteCursor.java:257)
at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:188)
at android.database.CursorWrapper.moveToPosition(CursorWrapper.java:187)
at android.widget.CursorAdapter.getItemId(CursorAdapter.java:155)
at android.widget.AdapterView.rememberSyncState(AdapterView.java:1122)
at 
android.widget.AdapterView$AdapterDataSetObserver.onChanged(AdapterView.java:787
)
at android.database.DataSetObservable.notifyChanged(DataSetObservable.java:31)
at android.widget.BaseAdapter.notifyDataSetChanged(BaseAdapter.java:50)
at android.widget.CursorAdapter.changeCursor(CursorAdapter.java:260)
at android.widget.SimpleCursorAdapter.changeCursor(SimpleCursorAdapter.java:321)
at android.widget.CursorFilter.publishResults(CursorFilter.java:67)
at android.widget.Filter$ResultsHandler.handleMessage(Filter.java:282)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:123)
at android.app.ActivityThread.main(ActivityThread.java:4627)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:521)
at 
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:871)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:629)
at dalvik.system.NativeStart.main(Native Method)

Original issue reported on code.google.com by peli0...@googlemail.com on 21 Jan 2011 at 11:00

[GoogleCodeExporter]

This also happens in 1.3.0:

User comments:
* The app generates this error after I either go to the home page and try to go 
back or when I switch apps and try to go back. It must be in the 'on resume()' 
function. Great app otherwise.
* "stopped unexpectedly"
* scanning new barcode

--------------------------------------------------------------------------------
v1.3.0, 06.06.2011 21:44:33

java.lang.RuntimeException: Unable to resume activity 
{org.openintents.shopping/org.openintents.shopping.ShoppingActivity}: 
java.lang.IllegalStateException: trying to requery an already closed cursor
 at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2220)
 at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2248)
 at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1024)
 at android.os.Handler.dispatchMessage(Handler.java:99)
 at android.os.Looper.loop(Looper.java:126)
 at android.app.ActivityThread.main(ActivityThread.java:4002)
 at java.lang.reflect.Method.invokeNative(Native Method)
 at java.lang.reflect.Method.invoke(Method.java:491)
 at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:844)
 at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:602)
 at dalvik.system.NativeStart.main(Native Method)
Caused by: java.lang.IllegalStateException: trying to requery an already closed 
cursor
 at android.app.Activity.performRestart(Activity.java:4337)
 at android.app.Activity.performResume(Activity.java:4360)
 at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2210)

Original comment by peli0...@googlemail.com on 8 Jun 2011 at 5:15

[GoogleCodeExporter]

Did not happen with OI Shopping List 1.4 so far. Probably this issue was fixed. 
(can be re-opened if necessary).

Original comment by peli0...@googlemail.com on 25 Aug 2011 at 12:03

• Changed state: Fixed