Drizzle Team•2mo ago

Drizzle TypeError: Cannot read properties of undefined (reading 'Symbol(drizzle:Name)')

I'm experiencing 2 errors, one with Drizzle Studio and one with Drizzle Push and I'm not sure if they're related or not. The first error is a type error in Drizzle Studio (bug report attached):

TypeError: Cannot read properties of undefined (reading 'Symbol(drizzle:Name)')
    at HJ (https://local.drizzle.studio/index.js:339:40228)
    at ZDt (https://local.drizzle.studio/index.js:12610:8589)
    at hDt (https://local.drizzle.studio/index.js:12610:13858)
    at QRl (https://local.drizzle.studio/index.js:12885:11486)

TypeError: Cannot read properties of undefined (reading 'Symbol(drizzle:Name)')
    at HJ (https://local.drizzle.studio/index.js:339:40228)
    at ZDt (https://local.drizzle.studio/index.js:12610:8589)
    at hDt (https://local.drizzle.studio/index.js:12610:13858)
    at QRl (https://local.drizzle.studio/index.js:12885:11486)

The second error is an error with Drizzle Push (screenshot attached):

npm run db:push --verbose --strict

> ixirsii.tech@0.1.0 db:push /Users/ryan/Programs/ixirsii.tech
> drizzle-kit push "--verbose" "--strict"

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/ryan/Programs/ixirsii.tech/drizzle.config.ts'
Using 'pg' driver for database querying
[‚úì] Pulling schema from database...

 Warning  You are about to execute current statements:

DROP SEQUENCE "public"."ixirsii.tech_link_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_post_tag_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_post_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_tag_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_user_id_seq";

error: cannot drop sequence "ixirsii.tech_link_id_seq" because other objects depend on it
    at /Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/pg-pool@3.6.2_pg@8.12.0/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Object.query (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:71752:26)
    at async pgPush (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:74692:13)
    at async Object.handler (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:83070:9)
    at async rawCli (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:81459:5)
    at async run (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:81467:5) {
  length: 316,
  severity: 'ERROR',
  code: '2BP01',
  detail: 'default value for column id of table "ixirsii.tech_link" depends on sequence "ixirsii.tech_link_id_seq"',
  hint: 'Use DROP ... CASCADE to drop the dependent objects too.',
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'dependency.c',
  line: '1204',
  routine: 'reportDependentObjects'
}

npm run db:push --verbose --strict

> ixirsii.tech@0.1.0 db:push /Users/ryan/Programs/ixirsii.tech
> drizzle-kit push "--verbose" "--strict"

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/ryan/Programs/ixirsii.tech/drizzle.config.ts'
Using 'pg' driver for database querying
[‚úì] Pulling schema from database...

 Warning  You are about to execute current statements:

DROP SEQUENCE "public"."ixirsii.tech_link_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_post_tag_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_post_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_tag_id_seq";
DROP SEQUENCE "public"."ixirsii.tech_user_id_seq";

error: cannot drop sequence "ixirsii.tech_link_id_seq" because other objects depend on it
    at /Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/pg-pool@3.6.2_pg@8.12.0/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Object.query (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:71752:26)
    at async pgPush (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:74692:13)
    at async Object.handler (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:83070:9)
    at async rawCli (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:81459:5)
    at async run (/Users/ryan/Programs/ixirsii.tech/node_modules/.pnpm/drizzle-kit@0.23.2/node_modules/drizzle-kit/bin.cjs:81467:5) {
  length: 316,
  severity: 'ERROR',
  code: '2BP01',
  detail: 'default value for column id of table "ixirsii.tech_link" depends on sequence "ixirsii.tech_link_id_seq"',
  hint: 'Use DROP ... CASCADE to drop the dependent objects too.',
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'dependency.c',
  line: '1204',
  routine: 'reportDependentObjects'
}

Drizzle versions:

    "drizzle-orm": "^0.32.2",
    "drizzle-kit": "0.23.2",

    "drizzle-orm": "^0.32.2",
    "drizzle-kit": "0.23.2",

I found this GitHub issue (https://github.com/drizzle-team/drizzle-kit-mirror/issues/504) but using drizzle-kit@seq_fix version gives me the exact same errors. Any help is appreciated.

bug-report.zip

9 Replies

rocity•2mo ago

getting the same issues

JuaniS•2mo ago

same here

rphlmr ⚡•2mo ago

Did you all use the latest drizzle orm (0.33) and kit (0.24)? cc @Andrew Sherman

Andrii Sherman•2mo ago

it won't be fixed in 0.24.0, I suppose something with pgTableCreator and pulling a schema from it I would need to check it

JuaniS•2mo ago

Indeed. Previously I got an infinite loading screen, updated drizzle dependencies and started to get that error instead

DEOXY•2mo ago

@immortal

Avinash•2mo ago

is there a stable version of it? @Andrew Sherman im using orm 0.33 and latest kit 0.24

⚡Z.E.U.S⚡•4w ago

@Ixirsii Hey! Are you still having this error in Drizzle Studio?

Ixirsii•4w ago

No, when I tried just now Drizzle studio worked fine.

Gaming

Programming

Drizzle TypeError: Cannot read properties of undefined (reading 'Symbol(drizzle:Name)')