SQLite NOT NULL failed SQL Origin: Data OSI layer 7 · Application Last updated 14 Oct 2026

sqlite3.IntegrityError: NOT NULL constraint failed: table.column

A NULL went into a NOT NULL column in SQLite.

Exact message you may see NOT NULL constraint failed
Seen on: SQL

Meaning

Often an ORM model field not set, or a new NOT NULL column without a default in a Django/Rails migration.

Common causes

  • Required field missing
  • Migration added NOT NULL without default
  • Explicit None/null

⚡ Quick fix

  1. Provide the value or a default
  2. Make the column nullable if appropriate

Detailed fix by platform

SQL

  1. ALTER TABLE users ADD COLUMN status TEXT NOT NULL DEFAULT 'active';

How to diagnose

  1. Column — Which one?
  2. Input — Why null?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

23502 — ERROR: null value in column "x" of relation "y" violates not-null constraint (PostgreSQL)235022627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627515 — SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls (SQL)515ALREADY_EXISTS — API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409) (API)ALREADY_EXISTSAutopilot — GKE Autopilot rejected the workload: resources adjusted / violates Autopilot constraints (Google Cloud / Firebase)Autopilotdatatype mismatch — SQLite: datatype mismatch (SQLITE_MISMATCH) (SQL)datatype mismatchDbUpdateException — DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. (.NET)DbUpdateExceptionforeign key order — Foreign key violation caused by insert order or circular references (SQL)foreign key orderSQLite NO…

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.