{"action":"created","issue":{"url":"https://api.github.com/repos/googlecodelabs/android-workmanager/issues/8","repository_url":"https://api.github.com/repos/googlecodelabs/android-workmanager","labels_url":"https://api.github.com/repos/googlecodelabs/android-workmanager/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/googlecodelabs/android-workmanager/issues/8/comments","events_url":"https://api.github.com/repos/googlecodelabs/android-workmanager/issues/8/events","html_url":"https://github.com/googlecodelabs/android-workmanager/issues/8","id":324496084,"number":8,"title":"Crash when language is Arabic","user":{"login":"Yrlec","id":1666135,"avatar_url":"https://avatars3.githubusercontent.com/u/1666135?v=4","gravatar_id":"","url":"https://api.github.com/users/Yrlec","html_url":"https://github.com/Yrlec","followers_url":"https://api.github.com/users/Yrlec/followers","following_url":"https://api.github.com/users/Yrlec/following{/other_user}","gists_url":"https://api.github.com/users/Yrlec/gists{/gist_id}","starred_url":"https://api.github.com/users/Yrlec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Yrlec/subscriptions","organizations_url":"https://api.github.com/users/Yrlec/orgs","repos_url":"https://api.github.com/users/Yrlec/repos","events_url":"https://api.github.com/users/Yrlec/events{/privacy}","received_events_url":"https://api.github.com/users/Yrlec/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-18T17:41:51Z","updated_at":"2018-05-18T18:40:14Z","closed_at":null,"author_association":"NONE","body":"While running the pre-launch report for our app we ran into a crash which looks to be caused by WorkManager.\r\n\r\n`FATAL EXCEPTION: pool-3-thread-1\r\nProcess: com.degoo.android, PID: 14486\r\nandroid.database.sqlite.SQLiteException: no such column: ١٥٢٦٠٨٥٧٤٨٩٠١(Sqlite code 1): , while compiling: DELETE FROM workspec WHERE state IN (2, 3, 5) AND (period_start_time + minimum_retention_duration) < ١٥٢٦٠٨٥٧٤٨٩٠١ AND(SELECT COUNT(*)=0 FROM dependency WHERE     prerequisite_id=id AND     work_spec_id NOT IN         (SELECT id FROM workspec WHERE state IN (2, 3, 5))),(OS error - 2:No such file or directory)\r\n\tat android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)\r\n\tat android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)\r\n\tat android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)\r\n\tat android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)\r\n\tat android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)\r\n\tat android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)\r\n\tat android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1724)\r\n\tat android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1650)\r\n\tat android.arch.persistence.db.framework.a.c(S:240)\r\n\tat androidx.work.impl.WorkDatabase$1.a(S:114)\r\n\tat androidx.work.impl.WorkDatabase_Impl$1.c(S:82)\r\n\tat android.arch.persistence.room.f.b(S:101)\r\n\tat android.arch.persistence.db.framework.b$a.onOpen(S:133)\r\n\tat android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:266)\r\n\tat android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)\r\n\tat android.arch.persistence.db.framework.b$a.a(S:93)\r\n\tat android.arch.persistence.db.framework.b.a(S:54)\r\n\tat android.arch.persistence.room.e.a(S:204)\r\n\tat android.arch.persistence.room.h.c(S:65)\r\n\tat android.arch.persistence.room.h.b(S:1072)\r\n\tat androidx.work.impl.b.l.a(S:326)\r\n\tat androidx.work.impl.f.c(S:393)\r\n\tat androidx.work.impl.c.c.run(S:66)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWo`\r\n\r\nI'm guessing the problem is caused by private static String getPruneSQL() using the default locale of the device instead of English. "},"comment":{"url":"https://api.github.com/repos/googlecodelabs/android-workmanager/issues/comments/390296519","html_url":"https://github.com/googlecodelabs/android-workmanager/issues/8#issuecomment-390296519","issue_url":"https://api.github.com/repos/googlecodelabs/android-workmanager/issues/8","id":390296519,"user":{"login":"Yrlec","id":1666135,"avatar_url":"https://avatars3.githubusercontent.com/u/1666135?v=4","gravatar_id":"","url":"https://api.github.com/users/Yrlec","html_url":"https://github.com/Yrlec","followers_url":"https://api.github.com/users/Yrlec/followers","following_url":"https://api.github.com/users/Yrlec/following{/other_user}","gists_url":"https://api.github.com/users/Yrlec/gists{/gist_id}","starred_url":"https://api.github.com/users/Yrlec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Yrlec/subscriptions","organizations_url":"https://api.github.com/users/Yrlec/orgs","repos_url":"https://api.github.com/users/Yrlec/repos","events_url":"https://api.github.com/users/Yrlec/events{/privacy}","received_events_url":"https://api.github.com/users/Yrlec/received_events","type":"User","site_admin":false},"created_at":"2018-05-18T18:40:14Z","updated_at":"2018-05-18T18:40:14Z","author_association":"NONE","body":"١٥٢٦٠٨٥٧٤٨٩٠١ is 1526085748901 in Arabic numerals. So if you just change Locale.getDefault() to Locale.ENGLISH it should work."}}
{"actor":{"display_login":"Yrlec"}}