drizzle-team / drizzle-team/drizzle-orm

[BUG]: Errors migrating

Open
#5,995 5 comments 2 reactions 0 assignees View on GitHub
bug
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

1.0.0-rc.4-5d5b77c

### What version of `drizzle-kit` are you using?

1.0.0-rc.4-ca0f029

### Other packages

_No response_

### Describe the Bug

using driver: d1-http and dialect sqlite
Running migration and obtaining the errors:

`[✗] Error during migration:
While upgrading your database migrations table we found 25 ([id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined], [id: undefined, created_at: undefined]) migrations in the database that do not match any local migration. This means that some migrations were applied to the database but are missing from the local environment`

Contributor guide

Open the contributing guide

Research direction

Reproduce a migration with the reported d1-http driver, SQLite dialect, and listed drizzle-orm and drizzle-kit versions, then trace the migration upgrade path and migrations table handling. No files or tests are named, and the expected corrected behavior is not specified; completion would require identifying why migration rows are reported with undefined fields and agreeing on the intended result.

Written by the indexing model from the issue text.

Assessment

Tech stack
sqlite, typescript
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.