[AC-5481] [Android] Titanium Database disk I/O error on the latest SDK (7.0.1GA)
GitHub Issue | n/a |
---|---|
Type | Bug |
Priority | n/a |
Status | Closed |
Resolution | Not Our Bug |
Resolution Date | 2018-01-01T08:31:25.000+0000 |
Affected Version/s | n/a |
Fix Version/s | n/a |
Components | n/a |
Labels | n/a |
Reporter | Kai Lu |
Assignee | Shak Hossain |
Created | 2018-01-01T06:01:08.000+0000 |
Updated | 2018-03-27T12:15:24.000+0000 |
Description
The app successfully built on the android but failed to run the database create table sql statements and the error is: disk I/O error. The same code works fine on the iOS.
I use Genymotion for the android emulator.
Here is the log:
[ERROR] : SQLiteLog: (1802) os_unix.c:32281: (2) stat(/data/user/0/com.capps.tradies/databases/tradies_db) -
[ERROR] : SQLiteLog: (1802) statement aborts at 1: [BEGIN EXCLUSIVE;] disk I/O error
[ERROR] : TiDB: (KrollRuntimeThread) [196,196] Error executing sql: disk I/O error (code 1802)
[ERROR] : TiDB: android.database.sqlite.SQLiteDiskIOException: disk I/O error (code 1802)
[ERROR] : TiDB: at android.database.sqlite.SQLiteConnection.nativeExecute(Native Method)
[ERROR] : TiDB: at android.database.sqlite.SQLiteConnection.execute(SQLiteConnection.java:555)
[ERROR] : TiDB: at android.database.sqlite.SQLiteSession.beginTransactionUnchecked(SQLiteSession.java:323)
[ERROR] : TiDB: at android.database.sqlite.SQLiteSession.beginTransaction(SQLiteSession.java:298)
[ERROR] : TiDB: at android.database.sqlite.SQLiteSession.executeSpecial(SQLiteSession.java:874)
[ERROR] : TiDB: at android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:748)
[ERROR] : TiDB: at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:64)
[ERROR] : TiDB: at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)
[ERROR] : TiDB: at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1656)
[ERROR] : TiDB: at ti.modules.titanium.database.TiDatabaseProxy.execute(TiDatabaseProxy.java:141)
[ERROR] : TiDB: at org.appcelerator.kroll.runtime.v8.V8Runtime.nativeRunModule(Native Method)
[ERROR] : TiDB: at org.appcelerator.kroll.runtime.v8.V8Runtime.doRunModule(V8Runtime.java:196)
[ERROR] : TiDB: at org.appcelerator.kroll.KrollRuntime.handleMessage(KrollRuntime.java:321)
[ERROR] : TiDB: at android.os.Handler.dispatchMessage(Handler.java:98)
[ERROR] : TiDB: at android.os.Looper.loop(Looper.java:154)
[ERROR] : TiDB: at org.appcelerator.kroll.KrollRuntime$KrollRuntimeThread.run(KrollRuntime.java:118)
[WARN] : W/System.err: android.database.sqlite.SQLiteDiskIOException: disk I/O error (code 1802)
[WARN] : W/System.err: at android.database.sqlite.SQLiteConnection.nativeExecute(Native Method)
[WARN] : W/System.err: at android.database.sqlite.SQLiteConnection.execute(SQLiteConnection.java:555)
[WARN] : W/System.err: at android.database.sqlite.SQLiteSession.beginTransactionUnchecked(SQLiteSession.java:323)
[WARN] : W/System.err: at android.database.sqlite.SQLiteSession.beginTransaction(SQLiteSession.java:298)
[WARN] : W/System.err: at android.database.sqlite.SQLiteSession.executeSpecial(SQLiteSession.java:874)
[WARN] : W/System.err: at android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:748)
[WARN] : W/System.err: at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:64)
[WARN] : W/System.err: at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)
[WARN] : W/System.err: at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1656)
[WARN] : W/System.err: at ti.modules.titanium.database.TiDatabaseProxy.execute(TiDatabaseProxy.java:141)
[WARN] : W/System.err: at org.appcelerator.kroll.runtime.v8.V8Runtime.nativeRunModule(Native Method)
[WARN] : W/System.err: at org.appcelerator.kroll.runtime.v8.V8Runtime.doRunModule(V8Runtime.java:196)
[WARN] : W/System.err: at org.appcelerator.kroll.KrollRuntime.handleMessage(KrollRuntime.java:321)
[WARN] : W/System.err: at android.os.Handler.dispatchMessage(Handler.java:98)
[WARN] : W/System.err: at android.os.Looper.loop(Looper.java:154)
[WARN] : W/System.err: at org.appcelerator.kroll.KrollRuntime$KrollRuntimeThread.run(KrollRuntime.java:118)
[INFO] : [1 Jan 2018, 12:53:03 am -05:00] db -> execute error: disk I/O error (code 1802)
It turns out to be a bug in my code. Please ignore this ticket and close it.
Hi @Kai Lu, I'm also having this problem, can you tell me what did you fix to make it work again? Thanks!