Function renameWithRetry

apps/local/src/db/v1-v2-migration.ts:1019–1035

(source: string, target: string)

// briefly lock the file). POSIX renames never hit this — retry with a short
// backoff, forcing handle release first, instead of failing the whole migration.
const renameWithRetry = async (source: string, target: string): Promise<void> => {
  // ~8s total. 1.9s was not enough on Windows: libSQL's native handle and
  // antivirus scans hold the freshly-written db past close() (observed as an
  // EBUSY boot crash in the v1.5.8 publish smoke run).
  const delaysMs = [50, 100, 250, 500, 1000, 2000, 4000];
  for (let attempt = 0; ; attempt++) {
    try {
      fs.renameSync(source, target);
      return;
    } catch (cause) {
      const code = (cause as NodeJS.ErrnoException).code;
      if ((code !== "EBUSY" && code !== "EPERM") || attempt >= delaysMs.length) throw cause;
      nudgeNativeHandleRelease();
      await new Promise((resolveDelay) => setTimeout(resolveDelay, delaysMs[attempt]));
    }
  }
};

// Same lingering-handle window as renameWithRetry: on Windows a libSQL file's
// native handle (and antivirus locks) can briefly outlive close(), so removing