prisma migrate reset wiping database and NOT reconstructing?

[gcb]

Question

db push creates the slqite DB just fine. But migrate reset wipes it and only creates an empty migrations table before trying to run the seed, which fails as there's no table anywhere.

original:
Why I'm now (might be 6.6.0 regression... still working on validating older versions) getting this error when using .findUnique() or .findFirst()?

When the referenced 1:0-1 relation is missing, I get a new error, which seems to imply i'm using executeRaw()...

const user = await prisma.user.findUnique({
  where: {
    id: Number.parseInt(id),
  },
  include: {
    profile: true,
  },
});

 ⨯ Error [PrismaClientKnownRequestError]: 
Invalid `prisma.user.findFirst()` invocation:


The column `main.Profile.dateOfBirth` does not exist in the current database.
    at zn.handleRequestError (lib/generated_prisma/runtime/library.js:121:7458)
    at zn.handleAndLogRequestError (lib/generated_prisma/runtime/library.js:121:6783)
    at zn.request (lib/generated_prisma/runtime/library.js:121:6490)
    at async l (lib/generated_prisma/runtime/library.js:130:9777)
    at async User (app/user-profile/user/[id]/page.tsx:19:14)
  119 |
  120 | More Information: https://pris.ly/d/execute-raw

this error goes away if i either: remove the include:{ profile: true} or create an entry on the profile to match the 1:0-1 relation.

How to reproduce (optional)

my schema have an optional 1:1 (1:0-1?)

User {
  id @id ...
  profile Profile?
  ...
}
Profile {
  id @id
  user            User     @relation(fields: [userId], references: [id])
  userId          Int      @unique
  dateOfBirth     DateTime?
  ...
}

Expected behavior (optional)

query succeeds with user.profile being null?

Information about Prisma Schema, Client Queries and Environment (optional)

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

generator client {
  provider = "prisma-client-js"
  output   = "../lib/generated_prisma"
}

Prisma schema loaded from prisma/schema.prisma
prisma                  : 6.6.0
@prisma/client          : 6.6.0
Computed binaryTarget   : debian-openssl-3.0.x
Operating System        : linux
Architecture            : x64
Node.js                 : v23.9.0
TypeScript              : 5.8.2
Query Engine (Node-API) : libquery-engine f676762280b54cd07c770017ed3711ddde35f37a (at node_modules/@prisma/engines/libquery_engine-debian-openssl-3.0.x.so.node)
Schema Engine           : schema-engine-cli f676762280b54cd07c770017ed3711ddde35f37a (at node_modules/@prisma/engines/schema-engine-debian-openssl-3.0.x)
Schema Wasm             : @prisma/prisma-schema-wasm 6.6.0-53.f676762280b54cd07c770017ed3711ddde35f37a
Default Engines Hash    : f676762280b54cd07c770017ed3711ddde35f37a
Studio                  : 0.511.0

[gcb]

getting errors when i open the User entity on prisma studio too.

Here's the "error details" it shows.

Message: Error in Prisma Client request: 


Invalid `STUDIO_EMBED_BUILD<"u"&&STUDIO_EMBED_BUILD?Tbt():require(`${l.prismaClient}/runtime/${u}`),O=e,k=(0,wye.createHash)("sha256").update()` invocation in
/home/gcb/code/my-me/tech/node_modules/prisma/build/index.js:4907:10856

  4904 - If they want to connect to an existing database, they should go to console.prisma.io and copy the connection string
  4905 - If they want to upgrade their plan, they should go to console.prisma.io and upgrade their plan in order to be able to create more databases
  4906 - If they want to delete a database they no longer need, they should go to console.prisma.io and delete the database project`,{name:Y.string(),region:Y.string(),projectCWD:Y.string()},async({name:a,region:c,projectCWD:u})=>({content:[{type:"text",text:await zw({cwd:u,args:["init","--db","--name",a,"--region",c,"--non-interactive"]})}]})),i.tool("Prisma-Login","Login or create an account in order to be able to use Prisma Postgres.",{projectCWD:Y.string()},async({projectCWD:a})=>({content:[{type:"text",text:await zw({cwd:a,args:["platform","auth","login","--early-access"]})}]})),i.tool("Prisma-Studio",`Open Prisma Studio to view data in your database in a pleasing visual ui.
→ 4907 Provide the current working directory of the users project. This should be the top level directory of the project.`,{projectCWD:Y.string()},async({projectCWD:a})=>({content:[{type:"text",text:await zw({cwd:a,args:["studio"]})}]}));let o=new V7;return await i.connect(o),""}};p7();ar();var jbt=require("@prisma/engines");Ie();var xdt=require("buffer");function bdt(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var vdt={};bdt(vdt,"serializeRPCMessage",()=>vge);bdt(vdt,"deserializeRPCMessage",()=>wge);var xge="PrismaBigInt::",bge="PrismaBytes::";function vge(e){return JSON.stringify(e,(r,n)=>typeof n=="bigint"?xge+n:n?.type==="Buffer"&&Array.isArray(n?.data)?bge+xdt.Buffer.from(n.data).toString("base64"):n)}function wge(e){return JSON.parse(e,(r,n)=>typeof n=="string"&&n.startsWith(xge)?BigInt(n.substr(xge.length)):typeof n=="string"&&n.startsWith(bge)?n.substr(bge.length):n)}var Ibt=U(Cdt()),QU=U(M0t()),Rbt=U(require("http")),kbt=U(L0t()),Mbt=require("zlib");var bx=require("path");Ie();var wye=require("crypto"),Cbt=require("fs/promises"),Abt=U(_0e());function bye(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var Pbt=globalThis,yye={},ZU={},sE=Pbt.parcelRequire94c2;sE==null&&(sE=function(e){if(e in yye)return yye[e].exports;if(e in ZU){var r=ZU[e];delete ZU[e];var n={id:e,exports:{}};return yye[e]=n,r.call(n.exports,n,n.exports),n.exports}var i=new Error("Cannot find module '"+e+"'");throw i.code="MODULE_NOT_FOUND",i},sE.register=function(r,n){ZU[r]=n},Pbt.parcelRequire94c2=sE);var Obt=sE.register;Obt("9lTzd",function(module,exports){bye(module.exports,"guessEnginePaths",()=>guessEnginePaths),bye(module.exports,"guessPrismaClientPath",()=>guessPrismaClientPath);var $5COlq=sE("5COlq");async function guessEnginePaths({forceBinary,forceLibrary,resolveOverrides}){let queryEngineName,queryEngineType;if(forceLibrary?(queryEngineName=await(0,$5COlq.prismaEngineName)("query-engine","library"),queryEngineType="library"):forceBinary?(queryEngineName=await(0,$5COlq.prismaEngineName)("query-engine","binary"),queryEngineType="binary"):(queryEngineName=void 0,queryEngineType=void 0),!queryEngineName||!queryEngineType)return{queryEngine:void 0};let queryEnginePath;if(resolveOverrides[".prisma/client"])queryEnginePath=(0,bx.resolve)(resolveOverrides[".prisma/client"],`../${queryEngineName}`);else if(resolveOverrides["@prisma/engines"])queryEnginePath=(0,bx.resolve)(resolveOverrides["@prisma/engines"],`../../${queryEngineName}`);else{let atPrismaEnginesPath;try{atPrismaEnginesPath=eval("require.resolve('@prisma/engines')")}catch(e){throw new Error("Unable to resolve Prisma engine paths. This is a bug.")}queryEnginePath=(0,bx.resolve)(atPrismaEnginesPath`../../${queryEngineName}`)}return{queryEngine:{type:queryEngineType,path:queryEnginePath}}}function guessPrismaClientPath({resolveOverrides}){let prismaClientPath=resolveOverrides["@prisma/client"]||eval("require.resolve('@prisma/client')");return(0,bx.resolve)(prismaClientPath,"../")}});Obt("5COlq",function(e,r){bye(e.exports,"prismaEngineName",()=>n);async function n(i,o){let a=await Ro(),c=a==="windows"?".exe":"";if(o==="library")return fc(a,"fs");if(o==="binary")return`${i}-${a}${c}`;throw new Error(`Unknown engine type: ${o}`)}});function VMr(e){return{models:xye(e.models),enums:xye(e.enums),types:xye(e.types)}}function xye(e){let r={};for(let{name:n,...i}of e)r[n]=i;return r}var WR=(0,Abt.debug)("prisma:studio-pcw"),zMr=/^\s*datasource\s+([^\s]+)\s*{/m,KMr=/url *= *env\("(.*)"\)/,JMr=/url *= *"(.*)"/;async function YMr({schema:e,schemaPath:r,dmmf:n,adapter:i,datasourceProvider:o,previewFeatures:a,datasources:c,engineType:u,paths:l,directUrl:p,versions:f}){let g=e.match(zMr)?.[1]??"",x=e.match(KMr)?.[1]??null,b=e.match(JMr)?.[1]??null,{getPrismaClient:v,PrismaClientKnownRequestError:E,PrismaClientRustPanicError:_,PrismaClientInitializationError:C,PrismaClientValidationError:F}=typeof STUDIO_EMBED_BUILD<"u"&&STUDIO_EMBED_BUILD?Tbt():require(`${l.prismaClient}/runtime/${u}`),O=e,k=(0,wye.createHash)("sha256").update(
The column `main.Profile.dateOfBirth` does not exist in the current database.
  
Query:
{
  "modelName": "User",
  "operation": "findMany",
  "args": {
    "take": 100,
    "skip": 0,
    "select": {
      "id": true,
      "clerkId": true,
      "userEmail": {
        "select": {
          "id": true
        }
      },
      "realname": true,
      "role": true,
      "profile": true,
      "incare": {
        "select": {
          "id": true
        }
      },
      "caring": {
        "select": {
          "id": true
        }
      },
      "createdAt": true,
      "updatedAt": true,
      "doctor": {
        "select": {
          "id": true
        }
      },
      "history": {
        "select": {
          "id": true
        }
      },
      "historyTags": {
        "select": {
          "id": true
        }
      }
    }
  }
}

this led me to delete all db and migration and "start over"...

rm -fr prisma/dev.db
rm -fr prisma/migrations
npx prisma push
npx prisma migrate reset

and now both the seed script and studio fails on any empty table.

seed.ts:

$ npx prisma migrate reset
Prisma schema loaded from prisma/schema.prisma
Datasource "db": SQLite database "dev.db" at "file:./dev.db"

SQLite database dev.db created at file:./dev.db

✔ Are you sure you want to reset your database? All data will be lost. … yes

Database reset successful


✔ Generated Prisma Client (v6.6.0) to ./lib/generated_prisma in 126ms

Invalid `prisma.user.findMany()` invocation:

The table `main.User` does not exist in the current database.

An error occurred while running the seed command:
Error: Command failed with exit code 1: ts-node prisma/seed.ts

studio with the error above.

[gcb]

can't explain what is going on...

$ rm prisma/dev.db
$ npx prisma push
...all ok...
$ $ sqlite3 prisma/dev.db 
SQLite version 3.49.1 2025-02-18 13:38:58
Enter ".help" for usage hints.
sqlite> SELECT name FROM sqlite_master WHERE type='table';
_prisma_migrations
User
...and all other tables I expect

but then:
$ npx prisma migrate reset
Prisma schema loaded from prisma/schema.prisma
Datasource "db": SQLite database "dev.db" at "file:./dev.db"

✔ Are you sure you want to reset your database? All data will be lost. … yes

Database reset successful


Running generate... (Use --skip-generate to skip the generators)
✔ Generated Prisma Client (v6.6.0) to ./lib/generated_prisma in 125ms

Running seed command `ts-node prisma/seed.ts` ...
Invalid `prisma.user.findMany()` invocation:


The table `main.User` does not exist in the current database.⁀

An error occurred while running the seed command:
Error: Command failed with exit code 1: ts-node prisma/seed.ts

$ sqlite3 prisma/dev.db 
SQLite version 3.49.1 2025-02-18 13:38:58
Enter ".help" for usage hints.
sqlite> SELECT name FROM sqlite_master WHERE type='table';
_prisma_migrations
sqlite> 

(note, seed.ts only adds missing entries, doesn't delete anything, there's only calls to findMany() and entities.create())

[gcb]

with an empty seed.ts file:

npx prisma migrate reset
Prisma schema loaded from prisma/schema.prisma
Datasource "db": SQLite database "dev.db" at "file:./dev.db"

✔ Are you sure you want to reset your database? All data will be lost. … yes

Database reset successful


✔ Generated Prisma Client (v6.6.0) to ./lib/generated_prisma in 122ms

Running seed command `ts-node prisma/seed.ts` ...

🌱  The seed command has been executed.


$ sqlite3 prisma/dev.db 
SQLite version 3.49.1 2025-02-18 13:38:58
Enter ".help" for usage hints.
sqlite> SELECT name FROM sqlite_master WHERE type='table';
_prisma_migrations
sqlite> 

[gcb]

apparently the migrate reset doesn't create the tables but tries to run the seeder? doesn't make much sense.

but worked around this mess with:

• remove all files (db, migration)
• migrate reset and let seed fail (or use an empty file)
• migrate dev to let it create the initial migration
• db seed to seed it.

[justin-hackin]

Especially when you consider that, when your database drifts, it says you should reset your database, you'd think it would re-add the tables 😕