I have an SQLite database table with about 200,000 rows. I perform a
CREATE INDEX in this way:
db.beginTransaction();
try {
db.execSQL("CREATE INDEX idx1 ON mytable (_id ASC)")
db.setTransactionSuccessful();
}
finally {
db.endTransaction();
}
Note: The code isn't exactly this - if it was, then I wouldn't use the
begin/end transaction approach because its unnecessary.
However, I just released the app and one of my users (Tattoo) got this
error during the endTransaction call:
SQLiteDiskIOException: disk I/O error: COMMIT;
Any ideas why this might be happening? Disk space perhaps?
I think I also got this early during testing but can't be sure.
I read this post here:
http://groups.google.com/group/android-developers/browse_thread/thread/b1d11f8f1e36755c/23aafc0ce0bba89c
which mentions something about the size of the sqlite_stmt_journals
partition.
--
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
