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. Cara ilangin suara macam-macam kaya suara camera, dll dari music playe

as subjek gimana caranya bro and sis? seingatku dah pernah liat ada
yang kasi tau tapi lupa dimana. cari2 ga ketemu. tolong ya... thanks
banget: )

-- 
"Indonesian Android Community [id-android]" 

2. OOM exception with custom imageadapter

Hi

I have a gallery in wich I show a row of images, the images can both
be from the Camera gallery or from the internet as a web url. My
getView() method makes an exception when I put to many images from the
gallery inside it. Should i down sample the images before attaching
them to the view? and how is that done ? heres my getView method:

public View getView(int position, View convertView, ViewGroup parent)
    {


        Controller co = Controller.GetInstance();

        ImageView imageView = new ImageView(context);

 
if(co.server.currRecord.image.get(position).containsKey("data"))
        {
                // we have a content URI and assign it to the gallery
 
imageView.setImageURI((Uri)co.server.currRecord.image.get(position).get("data"));
        }
        else
        {
                //we have a web url and need our ImageOperation method to
fetch and decode the drawable.
 
imageView.setImageDrawable(FileConvert.ImageOperations(context,
Controller.GetInstance().server.currRecord.image.get(position).get("url").toString()));
        }

        imageView.setScaleType(ImageView.ScaleType.FIT_XY);
        imageView.setLayoutParams(new Gallery.LayoutParams(150, 120));
        imageView.setBackgroundResource(itemBackground);

        return imageView;
    }

 - Lars

-- 

3. Service.startForeground() messes with scheduling?

4. How to overlay a GLSurfaceview on a surfaceview?

5. OOT: WTI : HP Purchases Palm for $1.2 Billion

6. Does any boby know how can control multitouch ???

7. Generate timer tick