DT
Drizzle Team•11mo ago
Startup Spells 🪄 Newsletter Guy

SQLite Error: Database is locked with Docker + Next.js + Drizzle

My docker-compose.yml is: 
version: '3'

services:
  docker-production:
    build:
      context: .
      dockerfile: Dockerfile
    image: docker-production
    env_file:
      - .env.production
    ports:
      - '3001:3000'
    volumes:
      - ./data:/data
version: '3'

services:
  docker-production:
    build:
      context: .
      dockerfile: Dockerfile
    image: docker-production
    env_file:
      - .env.production
    ports:
      - '3001:3000'
    volumes:
      - ./data:/data
my Dockerfile is huge but the relevant bits are: 
RUN mkdir -p /data
RUN npm run db:generate
RUN npm run db:migrate:vps
RUN npm run build
RUN mkdir -p /data
RUN npm run db:generate
RUN npm run db:migrate:vps
RUN npm run build
i do it in production just like i do it in development. i don't think i need migrate at all in production so i sometimes comment it out. i probably need to copy migrations folder into production i guess. can someone correct me here? anyhow, i get database locked error at the npm run build command that next.js needs to build production builds. i've detailed my question on stackoverflow as discord doesn't allow long-form code without going over character limit. https://stackoverflow.com/q/77986435/6141587 please take a look if you got sqlite + drizzle working on docker? there are few resources on this. many are complicated af.
Stack Overflow
SqliteError: database is locked while trying to run Docker Containe...
I have a Next.js application that I'm trying to dockerize. My stack is Next.js (Node.js framework) + Docker + Drizzle ORM + better-sqlite3 It currently works in development without docker using pnp...
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?