Titanium JIRA Archive
Appcelerator Community (AC)

[AC-5481] [Android] Titanium Database disk I/O error on the latest SDK (7.0.1GA)

GitHub Issuen/a
TypeBug
Priorityn/a
StatusClosed
ResolutionNot Our Bug
Resolution Date2018-01-01T08:31:25.000+0000
Affected Version/sn/a
Fix Version/sn/a
Componentsn/a
Labelsn/a
ReporterKai Lu
AssigneeShak Hossain
Created2018-01-01T06:01:08.000+0000
Updated2018-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)

Comments

  1. Kai Lu 2018-01-01

    It turns out to be a bug in my code. Please ignore this ticket and close it.
  2. Carlos Henrique Zinato 2018-03-27

    Hi @Kai Lu, I'm also having this problem, can you tell me what did you fix to make it work again? Thanks!

JSON Source