Migration changed for WorkspaceDb

[Angelk90]

Check for existing issues

• Completed

Describe the bug / provide steps to reproduce it

Every time I run Zed latest code from repository I get code like this printed.

What can I do so that I don't get these types of messages anymore.

[2024-12-13T20:35:04+01:00 ERROR Users] Migration changed for WorkspaceDb at step 14

Stored migration:
CREATE TABLE breakpoints (
  workspace_id INTEGER NOT NULL,
  worktree_path BLOB NOT NULL,
  relative_path BLOB NOT NULL,
  breakpoint_location INTEGER NOT NULL,
  FOREIGN KEY (workspace_id) REFERENCES workspaces (workspace_id) ON DELETE CASCADE ON UPDATE CASCADE
) STRICT;

Proposed migration:
ALTER TABLE
  panes
ADD
  COLUMN pinned_count INTEGER DEFAULT 0;
[2024-12-13T20:35:04+01:00 ERROR editor] buffer has no file
[2024-12-13T20:35:05+01:00 ERROR Users] Migration changed for WorkspaceDb at step 14

Stored migration:
CREATE TABLE breakpoints (
  workspace_id INTEGER NOT NULL,
  worktree_path BLOB NOT NULL,
  relative_path BLOB NOT NULL,
  breakpoint_location INTEGER NOT NULL,
  FOREIGN KEY (workspace_id) REFERENCES workspaces (workspace_id) ON DELETE CASCADE ON UPDATE CASCADE
) STRICT;

Proposed migration:
ALTER TABLE
  panes
ADD
  COLUMN pinned_count INTEGER DEFAULT 0;
[2024-12-13T20:35:05+01:00 ERROR Users] Migration changed for WorkspaceDb at step 14

Stored migration:
CREATE TABLE breakpoints (
  workspace_id INTEGER NOT NULL,
  worktree_path BLOB NOT NULL,
  relative_path BLOB NOT NULL,
  breakpoint_location INTEGER NOT NULL,
  FOREIGN KEY (workspace_id) REFERENCES workspaces (workspace_id) ON DELETE CASCADE ON UPDATE CASCADE
) STRICT;

Proposed migration:
ALTER TABLE
  panes
ADD
  COLUMN pinned_count INTEGER DEFAULT 0;

Environment

Zed: v0.166.0 (Zed Preview)
OS: macOS 14.1.1
Memory: 16 GiB
Architecture: x86_64

If applicable, add screenshots or screencasts of the incorrect state / behavior

No response

If applicable, attach your Zed.log file to this issue.

Zed.log

[osiewicz]

rm -rf ~/Library/Application\ Support/Zed/db/0-dev
You've built Zed with debugger support and that interferes with the db layout that we have on latest main.

[Angelk90]

@osiewicz : Could you add the following suggestion here, I don't know based on the os used, that would be great.

zed/crates/sqlez/src/migrations.rs

Lines 72 to 80 in 9daa426

	return Err(anyhow!(formatdoc! {"
	Migration changed for {} at step {}
	Stored migration:
	{}
	Proposed migration:
	{}", domain, index, completed_migration, migration}));
	}