Re: [android-developers] Re: Strange SQLite error, possibly in native code?

bizarre... seems like you should file a bug report.

On Monday, September 30, 2013 12:02:31 PM UTC+3, Kostya Vasilyev wrote:

Just to follow up: building the query myself didn't help.

android.database.sqlite.SQLiteException: no such table: me (code 1): , while compiling: SELECT _id, generation, [snip], op_hide, misc_flags FROM me  age WHERE folder_id = ? AND [condition here]  

The query string is built in my Java code, and then passed to db.rawQuery.

The "FROM me  age WHERE" reads "FROM message WHERE" at that time, then apparently gets corrupted inside system code, again, just in a slightly different place.

I still don't know what makes this one query more special than the others, oh well.

-- K

2013/9/29 Kostya Vasilyev <kman...@gmail.com>

Yes, that's what just did in a dev build, will see it helps.

Curiously enough, the framework's SQLiteQueryBuilder uses a StringBuilder that is initially 120 chars long, and the corruption happens at 112'th character.

I've long anticipated an Android device with firmware that calculates 2+2 as 5... this is not quite it, but comes pretty close.

-- K

2013/9/29 Piren <gpi...@gmail.com>

never came across such a report, but if it's isolated to that specific query maybe try replacing it with a rawQuery instead and see if it makes a difference. 

On Sunday, September 29, 2013 1:05:26 AM UTC+3, Kostya Vasilyev wrote:

Hello,

One of my users reports a crash like this:

android.database.sqlite.SQLiteException: no such column: _id (code 1): , while compiling: SELECT _id, generation, flags, numeric_uid, body_main_size, body_main_fetched_size, body_alt_size, body_alt_fetc¤       , search_token, op_flags, op_move_to_folder, op_hide, misc_flags FROM message WHERE folder_id = ? AND numeric_uid >= ? AND numeric_uid < ?  	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)  	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:886)  	at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:835)  	at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)  	at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)  	at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:158)  	at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:148)  	at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:197)  	at android.database.AbstractCursor.moveToNext(AbstractCursor.java:245)  	at <my code here>

Note the weird character in the middle of:

"body_alt_fetc >>right here>>¤<<<<< , search_token".

There are supposed to be a few more characters where this weird one is.

My code here calls SQLiteDatabase.query with a String[] projection, a table name, a simple selection and its arguments, etc. All very basic stuff.

The crash happens "once in a while", even though this query runs literally all the time. It's always this query, too, even though there are dozens more, for same table, and in same source file.

It looks to me like a memory overwrite, presumably in native code ('cause it's pretty hard to overwrite something by accident on the Java side of things).

Has anyone ran into this or a similar query corruption?

The device is a Zopo 980, if that means anything.

Thanks,

-- K

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-d...@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
---
You received this message because you are subscribed to the Google Groups "Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
---
You received this message because you are subscribed to the Google Groups "Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.