Drizzle Team•6mo ago

Push doesn't work

Yesterday I defined an npm command "db:push": "npx drizzle-kit push --config=drizzle.config.ts" and it worked perfectly. But today when I execute that command again with changes in schema.ts file, it just show the loading state but no response. I am using Supabase as a backend

3 Replies

Sh (@cannnibaldev)OP•6mo ago

it only shows "Pulling schema from database..." for 15 minutes I don't know whats wrong

import { defineConfig } from 'drizzle-kit'
import { env } from './src/env'

export default defineConfig({
    dialect:"postgresql",
    verbose:true,
    strict:true,
    dbCredentials:{
        url: env.DATABASE_URL
    },
    out:"./drizzle",
    schema:"./src/db/schema.ts"
})

import { defineConfig } from 'drizzle-kit'
import { env } from './src/env'

export default defineConfig({
    dialect:"postgresql",
    verbose:true,
    strict:true,
    dbCredentials:{
        url: env.DATABASE_URL
    },
    out:"./drizzle",
    schema:"./src/db/schema.ts"
})

config file LGTM

TypeError: Cannot redefine property: query
    at Function.defineProperties (<anonymous>)
    at queryError (C:\Users\husey\Documents\VisualStudioCodeProjects\next-auction\node_modules\drizzle-kit\bin.cjs:71069:12)
    at Socket.error2 (C:\Users\husey\Documents\VisualStudioCodeProjects\next-auction\node_modules\drizzle-kit\bin.cjs:71061:7)
    at Socket.emit (node:events:518:28)
    at emitErrorNT (node:internal/streams/destroy:169:8)
    at emitErrorCloseNT (node:internal/streams/destroy:128:3)
    at process.processTicksAndRejections (node:internal/process/task_queues:82:21)

TypeError: Cannot redefine property: query
    at Function.defineProperties (<anonymous>)
    at queryError (C:\Users\husey\Documents\VisualStudioCodeProjects\next-auction\node_modules\drizzle-kit\bin.cjs:71069:12)
    at Socket.error2 (C:\Users\husey\Documents\VisualStudioCodeProjects\next-auction\node_modules\drizzle-kit\bin.cjs:71061:7)
    at Socket.emit (node:events:518:28)
    at emitErrorNT (node:internal/streams/destroy:169:8)
    at emitErrorCloseNT (node:internal/streams/destroy:128:3)
    at process.processTicksAndRejections (node:internal/process/task_queues:82:21)

$ npm run db:push

> next-auction@0.1.0 db:push
> npx drizzle-kit push --config=drizzle.config.ts

drizzle-kit: v0.21.4
drizzle-orm: v0.30.10

Custom config path was provided, using 'drizzle.config.ts'
Reading config file 'C:\x\y\z\z\next-auction\drizzle.config.ts'
Using 'postgres' driver for database querying
[⣽] Pulling schema from database...C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71069
    Object.defineProperties(err2, {
           ^

TypeError: Cannot redefine property: query
    at Function.defineProperties (<anonymous>)
    at queryError (C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71069:12)
    at errored (C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71066:17)
    at Socket.data (C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71013:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

Node.js v20.11.0

$ npm run db:push

> next-auction@0.1.0 db:push
> npx drizzle-kit push --config=drizzle.config.ts

drizzle-kit: v0.21.4
drizzle-orm: v0.30.10

Custom config path was provided, using 'drizzle.config.ts'
Reading config file 'C:\x\y\z\z\next-auction\drizzle.config.ts'
Using 'postgres' driver for database querying
[⣽] Pulling schema from database...C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71069
    Object.defineProperties(err2, {
           ^

TypeError: Cannot redefine property: query
    at Function.defineProperties (<anonymous>)
    at queryError (C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71069:12)
    at errored (C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71066:17)
    at Socket.data (C:\x\y\z\z\next-auction\node_modules\drizzle-kit\bin.cjs:71013:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

Node.js v20.11.0

every time I execute the command I run into this problem anybody knows how to debug?

Deleted_user_f8439ab4ed59•6mo ago

are you following a tutorial

Sh (@cannnibaldev)OP•6mo ago

no @mbe52are could you help?

Gaming

Programming

Push doesn't work