super-productivity/packages/super-sync-server/tests
Johannes Millan 5ed1f2c5d0
fix(supersync): prevent migrator advisory-lock leak on deploy timeout (#9126)
A timed-out `docker compose run` in deploy.sh SIGTERMs the compose CLI but
can leave the migrator container (and its DB connection) running detached,
which keeps Prisma's session-level migration advisory lock held and wedges
the next deploy with P1002.

- deploy.sh: run_migrator() names each one-off migrator container from a
  single MIGRATOR_NAME_PREFIX and force-removes it (inline + $$-scoped EXIT
  sweep) so a timed-out run can't orphan it and leak the lock; add timeout -k.
- migrate-deploy.sh: recognize P1002 advisory-lock timeouts and print
  copy-paste diagnosis + cleanup guidance instead of a generic exit 1; never
  auto-terminate a backend (an active CONCURRENTLY build legitimately holds it).
- tests: P1002 fake-npx case + non-vacuous recovery test; assert the
  name/sweep-filter prefix single-source-of-truth invariant.
- env.example: document the recommended higher MIGRATION_TIMEOUT and the new
  force-remove-on-timeout behavior.
2026-07-17 20:18:54 +02:00
..
integration fix(sync): retention pruning, misc→tasks alias boundary & WS local-win re-upload (#9028) 2026-07-15 13:12:04 +02:00
account-page-contrast.spec.ts fix(supersync): improve account badge contrast (#8186) 2026-06-09 00:13:33 +02:00
api.routes.spec.ts Pr 6741 (#6743) 2026-03-05 21:17:59 +01:00
auth-cache.spec.ts perf(sync): SuperSync server speed + correctness hardening (#7621) 2026-05-15 17:24:16 +02:00
auth-flows.spec.ts Pr 6741 (#6743) 2026-03-05 21:17:59 +01:00
cleanup.spec.ts fix(supersync): order cleanup reconcile stalest-first and add C1 regression tests 2026-05-12 22:25:18 +02:00
config.spec.ts feat(supersync): configure server bind host #7301 (#8108) 2026-06-08 12:12:49 +02:00
conflict-detection.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
conflict.spec.ts fix(sync): dedupe surgical-sync retries and keep the import author through pruning (#9089) 2026-07-17 00:46:01 +02:00
decompress-body.spec.ts Merge branch 'master' into feat/our-latest-super-sync-server-update 2026-05-12 20:40:26 +02:00
device.service.spec.ts refactor(sync): extract DeviceService and OperationDownloadService 2025-12-27 20:43:25 +01:00
duplicate-operation-precheck.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
email.spec.ts Fix super-sync server auth and snapshot safety 2025-12-12 20:48:13 +01:00
entity-ids-conflict.pglite.spec.ts test(sync): pin #8334 divergent-scalar conflict, fix PGlite SQL drift 2026-06-17 16:07:53 +02:00
gap-detection.spec.ts perf(sync): use indexed findFirst for op-download minSeq 2026-05-18 14:21:02 +02:00
issue-8334-detect-conflict.spec.ts fix(sync): conflict-check all entities of multi-entity ops (#8334) (#8377) 2026-06-13 15:40:10 +02:00
magic-link-registration.spec.ts fix(sync): harden passkey registration verification (#8985) 2026-07-13 22:58:37 +02:00
middleware.spec.ts Pr 6741 (#6743) 2026-03-05 21:17:59 +01:00
migrate-deploy-script.spec.ts fix(supersync): prevent migrator advisory-lock leak on deploy timeout (#9126) 2026-07-17 20:18:54 +02:00
migration-sql.spec.ts fix(supersync): prevent migrator advisory-lock leak on deploy timeout (#9126) 2026-07-17 20:18:54 +02:00
op-replay.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
operation-download.service.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
passkey.spec.ts fix(sync): harden passkey registration verification (#8985) 2026-07-13 22:58:37 +02:00
password-reset-api.spec.ts Revert "feat(sync): add rolling JWT token refresh on sync requests" 2026-02-02 17:15:13 +01:00
password-reset.spec.ts fix(security): address critical and high severity vulnerabilities 2025-12-31 12:15:56 +01:00
rate-limit.service.spec.ts refactor(sync): extract services from SyncService and migrate tests to Prisma 2025-12-27 20:38:26 +01:00
registration-api.spec.ts chore(sync-server): update npm scripts and expand legal docs 2025-12-15 13:47:42 +01:00
replace-token-expiry.spec.ts fix(sync): fix supersync server unit test failures 2026-03-22 10:10:19 +01:00
request-dedup-failure-caching.routes.spec.ts fix(supersync): isolate invalid upload operations 2026-07-10 22:10:52 +02:00
request-deduplication.service.spec.ts fix(sync): remediate multi-agent review findings 2026-07-10 16:39:37 +02:00
retention-config.spec.ts fix(supersync-server): op data-loss on retention/cleanup & auth-endpoint hardening (#8971) 2026-07-13 14:28:45 +02:00
security-fixes.spec.ts test: strengthen unit test assertions and revive disabled plugin specs (#7755) 2026-05-23 18:31:53 +02:00
server-security.spec.ts test: strengthen unit test assertions and revive disabled plugin specs (#7755) 2026-05-23 18:31:53 +02:00
server.error-log-level.spec.ts feat(supersync): configure server bind host #7301 (#8108) 2026-06-08 12:12:49 +02:00
setup.ts fix(sync): harden passkey registration verification (#8985) 2026-07-13 22:58:37 +02:00
snapshot-skip-optimization.spec.ts test(sync-server): add comprehensive edge case tests for snapshot skip 2025-12-17 11:42:32 +01:00
snapshot.service.spec.ts fix(sync): preserve multi-entity conflict recovery (#8990) 2026-07-14 14:10:52 +02:00
storage-quota-cleanup.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
storage-quota.service.spec.ts perf(sync): SuperSync server speed + correctness hardening (#7621) 2026-05-15 17:24:16 +02:00
sync-compressed-body.routes.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
sync-fixes.spec.ts fix(sync): remediate multi-agent review findings 2026-07-10 16:39:37 +02:00
sync-operations.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
sync-types.spec.ts test(sync): add vector clock pruning edge case tests (#6506) 2026-02-13 12:42:36 +01:00
sync-upload-rate-limit.routes.spec.ts fix(supersync): isolate invalid upload operations 2026-07-10 22:10:52 +02:00
sync.const.spec.ts fix(sync): measure op payload size limit in UTF-8 bytes, not UTF-16 units (#8368) 2026-06-13 14:29:00 +02:00
sync.routes.spec.ts refactor: retire GET /api/sync/snapshot, re-scope GET /api/sync/status as diagnostic (#8496) 2026-06-20 12:02:58 +02:00
sync.service.spec.ts fix(sync): dedupe surgical-sync retries and keep the import author through pruning (#9089) 2026-07-17 00:46:01 +02:00
sync.service.test-state.ts fix(sync): dedupe surgical-sync retries and keep the import author through pruning (#9089) 2026-07-17 00:46:01 +02:00
time-tracking-operations.spec.ts fix(sync): harden full-state operation recovery (#8973) 2026-07-13 22:58:17 +02:00
validation.service.spec.ts fix(sync): make task and time replay deterministic (#8979) 2026-07-13 21:53:46 +02:00
websocket-connection.service.spec.ts refactor(supersync): address round-2 review of WS reconnect cooldown fix 2026-05-20 15:57:00 +02:00
websocket.routes.spec.ts test(supersync): cover WS storm fixes with unit + integration tests 2026-05-20 15:57:00 +02:00