Drizzle Team•3y ago

`no such table: main.__old_push_projects` after db push

Added the following to a table named serviceservice:

  (table) => ({
    name_project_idx: index("name_project_idx").on(table.name, table.projectId),
    name_project_unq: unique("name_project_unq").on(
      table.name,
      table.projectId,
    ),
  }),

  (table) => ({
    name_project_idx: index("name_project_idx").on(table.name, table.projectId),
    name_project_unq: unique("name_project_unq").on(
      table.name,
      table.projectId,
    ),
  }),

and ran pnpm drizzle-kit push:sqlitepnpm drizzle-kit push:sqlite

it warned:

[2;46m [2;37mWarning[0m[2;46m [0m [2;37mFound data-loss statements:
· You're about to delete [4;37m__old_push_projects[0m[2;37m table with 4 items

[2;31m[1;31mTHIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED[0m[2;31m[0m[2;37m

[0mDo you still want to push changes?[0m[2;37m
[[2;32m✓[0m[2;37m] Changes applied[0m

[2;46m [2;37mWarning[0m[2;46m [0m [2;37mFound data-loss statements:
· You're about to delete [4;37m__old_push_projects[0m[2;37m table with 4 items

[2;31m[1;31mTHIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED[0m[2;31m[0m[2;37m

[0mDo you still want to push changes?[0m[2;37m
[[2;32m✓[0m[2;37m] Changes applied[0m

__old_push_projects__old_push_projects is never mentioned in my codebase. I have a table named projectsprojects, and thats the closest thing.
now my server errors with:

"no such table: main.__old_push_projects"

What is this table supposed to be and how can I get it back?

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

 Warning  Found data-loss statements:
· You're about to delete __old_push_projects table with 4 items

THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

Do you still want to push changes?
[✓] Changes applied

 Warning  Found data-loss statements:
· You're about to delete __old_push_projects table with 4 items

THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

Do you still want to push changes?
[✓] Changes applied

  (table) => ({
    name_project_idx: index("name_project_idx").on(table.name, table.projectId),
    name_project_unq: unique("name_project_unq").on(
      table.name,
      table.projectId,
    ),
  }),

  (table) => ({
    name_project_idx: index("name_project_idx").on(table.name, table.projectId),
    name_project_unq: unique("name_project_unq").on(
      table.name,
      table.projectId,
    ),
  }),