paperclipai/paperclip · error

Migration journal/file count mismatch: journal has

Error message

Migration journal/file count mismatch: journal has ${journalFiles.length}, files have ${migrationFiles.length}

What it means

Error "Migration journal/file count mismatch: journal has ${journalFiles.length}, files have ${migrationFiles.length}" thrown in paperclipai/paperclip.

Solutions

1. Regenerate the migration journal so it matches the migration files on disk.
2. Add or remove migration files so the count matches the journal.

When it happens

Trigger: Thrown at packages/db/src/check-migration-numbering.ts:50 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of paperclipai/paperclip@120ae5428f (2026-08-18). Data as JSON: /api/errors/9248b07775e36cd9. Report an issue: GitHub.

Appendix: source

Thrown at packages/db/src/check-migration-numbering.ts:50

  }
}

function ensureStrictlyOrdered(values: string[], label: string) {
  const sorted = [...values].sort();
  for (let index = 0; index < values.length; index += 1) {
    if (values[index] !== sorted[index]) {
      throw new Error(
        `${label} are out of order at position ${index}: expected ${sorted[index]}, found ${values[index]}`,
      );
    }
  }
}

function ensureJournalMatchesFiles(migrationFiles: string[], journalTags: string[]) {
  const journalFiles = journalTags.map((tag) => `${tag}.sql`);

  if (journalFiles.length !== migrationFiles.length) {
    throw new Error(
      `Migration journal/file count mismatch: journal has ${journalFiles.length}, files have ${migrationFiles.length}`,
    );
  }

  for (let index = 0; index < migrationFiles.length; index += 1) {
    const migrationFile = migrationFiles[index];
    const journalFile = journalFiles[index];
    if (migrationFile !== journalFile) {
      throw new Error(
        `Migration journal/file order mismatch at position ${index}: journal has ${journalFile}, files have ${migrationFile}`,
      );
    }
  }
}

async function main() {
  const migrationFiles = (await readdir(migrationsDir))
    .filter((entry) => entry.endsWith(".sql"))

View on GitHub (pinned to 120ae5428f)