SQLiteDiskIOException happens when querying 4000 rows data with order by japanese kanji

by James Wang » Wed, 10 Feb 2010 12:43:00 GMT


Sponsored Links
 his 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):



Other Threads

1. Tracking revenue on the Android Market

Hey All,
I'd like to share an application that I recently open-sourced.

It has two main functions:
*Plot revenue across apps over time
*Notify the developer of low-rated Market comments

I had it listed as a paid application for a while, but with only a few
sales, I decided I'd rather have as many devs make use of it as
possible.

Here's a link to the Google Code project (with screenshots):
http://code.google.com/p/chartdroid/wiki/DeveloperRevenueAnalysis

That page has a QR code and direct link to download from the Android
market.

The app is called "Developer Revenue Analysis".  It makes use of the
ChartDroid library (also open source) to display graphs.

Karl

-- 

2. The proliferation of Android markets.

I just got an email saying Toshiba are launching yet another app store
with Handster (whoever they are). This means that there is now (or
will be) at least:

The offficial Google market
Verizon "V Cast" market
Toshiba/Handster market
Vodafone 360 store
Getjar
and lots of other smaller ones.

None of these seem to offer anything particularly new, and all, afaik,
use 70/30 revenue sharing. As a developer I don't want to have to
upload my app a million times, and I don't want users to have to
search many app stores for apps. Finally, I don't really want Google
to lose their leverage over Android to the likes of Verizon and
Vodafone. Therefore I'm not going to upload my app to anywhere other
than the Android Marketplace.

Discuss.

-- 

3. Cross Promotion of app

4. application crashes when trying to play media in res/raw

5. Can an Update.zip be installed through ADB Shell?

6. Send SMS from Widget

7. GPS-Driver: Permission denied