[BUG]: TypeError: movedTables is not iterable about drizzle-orm HOT 16 OPEN

This issue is reproducible for me in drizzle-kit version 0.23.0, 0.23.0-03c18d1 and 0.23.0-21045a0 but does not occur in version 0.22.8 or 0.22.9-92953ac. So downgrading the version is a temporary workaround.
In all my tests drizzle-orm is on version 0.32.0 (i guess drizzle-orm is not used in this process?).

from drizzle-orm.

drizzle-kit: v0.23.0
drizzle-orm: v0.32.0

No config path provided, using default path
Reading config file '/Users/cristonmascarenhas/Documents/projects/trail-backend/drizzle.config.ts'
Pulling from ['public'] list of schemas

Using 'pg' driver for database querying
[✓] 19 tables fetched
[✓] 109 columns fetched
[✓] 2 enums fetched
[✓] 0 indexes fetched
[✓] 14 foreign keys fetched

TypeError: movedTables is not iterable
at applyPgSnapshotsDiff (/Users/cristonmascarenhas/Documents/projects/trail-backend/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:29346:22)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async introspectPostgres (/Users/cristonmascarenhas/Documents/projects/trail-backend/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:126156:42)
at async _Command. (/Users/cristonmascarenhas/Documents/projects/trail-backend/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:131714:7)

from drizzle-orm.

This issue is reproducible for me in drizzle-kit version 0.23.0, 0.23.0-03c18d1 and 0.23.0-21045a0 but does not occur in version 0.22.8 or 0.22.9-92953ac. So downgrading the version is a temporary workaround. In all my tests drizzle-orm is on version 0.32.0 (i guess drizzle-orm is not used in this process?).

this fixed it for me too

from drizzle-orm.

I'm having the same issue

❯ npx drizzle-kit introspect
drizzle-kit: v0.23.0
drizzle-orm: v0.32.0

No config path provided, using default path
Reading config file '/Users/redacted/Documents/workspace/redacted/drizzle.config.ts'
Pulling from ['public'] list of schemas

Using 'pg' driver for database querying
[✓] 8  tables fetched
[✓] 46 columns fetched
[✓] 0  enums fetched
[✓] 0  indexes fetched
[✓] 11 foreign keys fetched

TypeError: movedTables is not iterable
    at applyPgSnapshotsDiff (/Users/redacted/Documents/workspace/redacted/node_modules/drizzle-kit/bin.cjs:29346:22)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async introspectPostgres (/Users/redacted/Documents/workspace/redacted/node_modules/drizzle-kit/bin.cjs:126156:42)
    at async _Command.<anonymous> (/Users/redacted/Documents/workspace/redacted/node_modules/drizzle-kit/bin.cjs:131714:7)

I did notice that the drizzle/relations.ts, drizzle/schema.ts and meta/_journal.json were created and appear to be correct however.

from drizzle-orm.

I also having the same issue

$ npx drizzle-kit introspect
drizzle-kit: v0.23.0
drizzle-orm: v0.32.0

No config path provided, using default path
Reading config file 'C:\Users\Admin\Desktop\Evitamin\am484\evitstool_full\drizzle.config.ts'
Pulling from ['public'] list of schemas

Using 'pg' driver for database querying
[✓] 339 tables fetched
[✓] 13792 columns fetched
[✓] 16 enums fetched
[✓] 68 indexes fetched
[✓] 1586579 foreign keys fetched

TypeError: movedTables is not iterable
at applyPgSnapshotsDiff (C:\Users\Admin\Desktop\Evitamin\am484\evitstool_full\node_modules.pnpm\[email protected]\node_modules\drizzle-kit\bin.cjs:29346:22)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async introspectPostgres (C:\Users\Admin\Desktop\Evitamin\am484\evitstool_full\node_modules.pnpm\[email protected]\node_modules\drizzle-kit\bin.cjs:126156:42)
at async _Command. (C:\Users\Admin\Desktop\Evitamin\am484\evitstool_full\node_modules.pnpm\[email protected]\node_modules\drizzle-kit\bin.cjs:131714:7)

from drizzle-orm.

Same error with drizzle-kit introspect with the latest version.

This is one of the first steps when we migrate from Prisma to Drizzle.

from drizzle-orm.

Same problem here

from drizzle-orm.

I run the same problem after upgrading the drizzle-orm version.
I fixed it by manually updating themigrations/meta/_journal.json file from

{
  "version": "5",
  "dialect": "pg",
  ...
}

to

{
  "version": "7",
  "dialect": "postgresql",
  ...
}

Maybe the command drizzle-kit up can help

from drizzle-orm.

Same error with drizzle-kit introspect with the latest version.

This is one of the first steps when we migrate from Prisma to Drizzle.

Same here. I want to generate a schema.ts file using introspect.

from drizzle-orm.

Same issue on latest version of drizzle/drizzle-kit

from drizzle-orm.

Even I am facing the same error.

from drizzle-orm.

Having the same issue

from drizzle-orm.

Ditto here

from drizzle-orm.

Same here

from drizzle-orm.

Same

from drizzle-orm.

I directly edited bin.cjs inside my node_modules to check if movedTables is declared.

OBS: I don't know if this is right, but I was able to generate the schema based on the schemas that were already present in my Postgres.

Code:

from drizzle-orm.