UNIQUE constraint failed: sqlite database : android

My mistake was, I tried to fill `ID` column though it was already defined as `INTEGER PRIMARY KEY AUTOINCREMENT`

*For Kotlin model classes*

If you're assigning a **default value** to the primary key like this:

```kotlin
data class MyModel(
@PrimaryKey(autoGenerate = true) val id: Int = defaultValue
)
```

**Make sure default value is `0` for `Long` and `Int` types.**

---

From the `autoGenerate` comment:

> If the field type is `long` or `int` (or its TypeConverter converts it to a `long` or `int`), `Insert` methods treat `0` as **not-set** while inserting the item.

In my case, I used `-1` as the defaultValue and this error was occurring.

Guys i had the same problem and i cleared my local database from android settings and a clear run the app, that is work for me. Maybe you made a little change in db and you forgot.

I solved it by didn't insert the primary key manually when it is autoGenerate, this means that instead of putting value in the insert method for id, try to create an instance of entity class and use it in the insert method