android.database.sqlite.SQLiteConstraintException

column context_id is not unique (code 19)

Samebug tips1

activity.OnCreate is executed every time the app launches or the screen is rotated, so, putting your DB initialization inside it will cause the DB to be called too many times causing the exception. Try to use the MyDatabase.onCreate method for this.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web305

  • via embarcadero.com by Unknown author, 10 months ago
    column context_id is not unique (code 19)
  • via GitHub by mrkam
    , 1 year ago
    column context_id is not unique (code 19)
  • column context_id is not unique (code 19)
  • Stack trace

    • android.database.sqlite.SQLiteConstraintException: column context_id is not unique (code 19) at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:972) at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1603) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1473) at com.google.android.contextmanager.q.al.a(SourceFile:408) at com.google.android.contextmanager.q.al.b(SourceFile:383) at com.google.android.contextmanager.q.al.a(SourceFile:349) at com.google.android.contextmanager.q.al.b(SourceFile:376) at com.google.android.contextmanager.g.a.j.a(SourceFile:58) at com.google.android.contextmanager.g.a.a.run(SourceFile:52) at com.google.android.contextmanager.g.i.handleMessage(SourceFile:215) at android.os.Handler.dispatchMessage(Handler.java:102) at android.os.Looper.loop(Looper.java:146) at android.os.HandlerThread.run(HandlerThread.java:61)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    124 times, 1 year ago
    3 times, 1 year ago
    6 times, 1 year ago
    358 times, 1 year ago
    68 more bugmates