This topic is moved from plateform. Below is stack trace:
E/DatabaseUtils( 260): Writing exception to parcel E/DatabaseUtils( 260): android.database.sqlite.SQLiteDiskIOException: disk I/O error E/DatabaseUtils( 260): at android.database.sqlite.SQLiteQuery.native_fill_window(Native Method) E/DatabaseUtils( 260): at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:75) E/DatabaseUtils( 260): at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:288) E/DatabaseUtils( 260): at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:269) E/DatabaseUtils( 260): at android.database.CursorToBulkCursorAdaptor.count(CursorToBulkCursorAdaptor.java: 132) E/DatabaseUtils( 260): at android.database.BulkCursorNative.onTransact(BulkCursorNative.java:79) E/DatabaseUtils( 260): at android.os.Binder.execTransact(Binder.java: 287) E/DatabaseUtils( 260): at dalvik.system.NativeStart.run(Native Method) D/AndroidRuntime( 253): Shutting down VM W/dalvikvm( 253): threadid=3: thread exiting with uncaught exception (group=0x4001aa38) E/AndroidRuntime( 253): Uncaught handler: thread main exiting due to uncaught exception E/AndroidRuntime( 253): android.database.sqlite.SQLiteDiskIOException: disk I/O error E/AndroidRuntime( 253): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java: 141) E/AndroidRuntime( 253): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java: 111) E/AndroidRuntime( 253): at android.database.BulkCursorProxy.count(BulkCursorNative.java:255) E/AndroidRuntime( 253): at android.database.BulkCursorToCursorAdaptor.set(BulkCursorToCursorAdaptor.java: 44) E/AndroidRuntime( 253): at android.content.ContentProviderProxy.query(ContentProviderNative.java: 304) E/AndroidRuntime( 253): at android.content.ContentResolver.query(ContentResolver.java:152) E/AndroidRuntime( 253): at com.mycompany.test.MainActivity $1.onClick(MainActivity.java:39) E/AndroidRuntime( 253): at android.view.View.performClick(View.java: 2344) E/AndroidRuntime( 253): at android.view.View.onTouchEvent(View.java: 4133) E/AndroidRuntime( 253): at android.widget.TextView.onTouchEvent(TextView.java:6504) E/AndroidRuntime( 253): at android.view.View.dispatchTouchEvent(View.java:3672) E/AndroidRuntime( 253): at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:882) E/AndroidRuntime( 253): at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:882) E/AndroidRuntime( 253): at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:882) E/AndroidRuntime( 253): at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:882) E/AndroidRuntime( 253): at com.android.internal.policy.impl.PhoneWindow $DecorView.superDispatchTouchEvent(PhoneWindow.java:1712) E/AndroidRuntime( 253): at com.android.internal.policy.impl.PhoneWindow.superDispatchTouchEvent(PhoneWindow.java: 1202) E/AndroidRuntime( 253): at android.app.Activity.dispatchTouchEvent(Activity.java:2018) E/AndroidRuntime( 253): at com.android.internal.policy.impl.PhoneWindow $DecorView.dispatchTouchEvent(PhoneWindow.java:1696) E/AndroidRuntime( 253): at android.view.ViewRoot.handleMessage(ViewRoot.java:1658) E/AndroidRuntime( 253): at android.os.Handler.dispatchMessage(Handler.java:99) E/AndroidRuntime( 253): at android.os.Looper.loop(Looper.java:123) E/AndroidRuntime( 253): at android.app.ActivityThread.main(ActivityThread.java:4203) E/AndroidRuntime( 253): at java.lang.reflect.Method.invokeNative(Native Method) E/AndroidRuntime( 253): at java.lang.reflect.Method.invoke(Method.java:521) E/AndroidRuntime( 253): at com.android.internal.os.ZygoteInit $MethodAndArgsCaller.run(ZygoteInit.java:791) E/AndroidRuntime( 253): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:549) E/AndroidRuntime( 253): at dalvik.system.NativeStart.main(Native Method) we are using such sql "select column1,column2 from table order by kanji asc" to select 4000 rows data from our table and got above error. we did reproduce this error by executing above sql by command "adb shell sqlite3". If we select only one column, no error happens. I guess android imposes size limit on sqlite3's cache or something else. I have two question: 1. Is this a android's bug? 2. How can we avoid it? -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
