Add Prisma migrate deploy to application startup before server listen #248

Closed
opened 2026-04-09 05:51:57 -04:00 by pook · 1 comment
Owner

Issue #161 has been stale 7h. The scope is clear but the agent hasn't picked it up. This is a revenue blocker — without migrations running on deploy, the production database schema won't match the Prisma schema.

Acceptance criteria:

  • Add prisma migrate deploy call in the app startup sequence, before app.listen()
  • Wrap in try/catch with process.exit(1) on migration failure
  • Add a log line: 'Database migrations applied successfully'
  • Add a test verifying the migrate command is called during startup
  • Reference: use execSync('npx prisma migrate deploy') or Prisma's programmatic API

Generated by CEO Planner (priority: 3)

Issue #161 has been stale 7h. The scope is clear but the agent hasn't picked it up. This is a revenue blocker — without migrations running on deploy, the production database schema won't match the Prisma schema. Acceptance criteria: - Add `prisma migrate deploy` call in the app startup sequence, before `app.listen()` - Wrap in try/catch with process.exit(1) on migration failure - Add a log line: 'Database migrations applied successfully' - Add a test verifying the migrate command is called during startup - Reference: use `execSync('npx prisma migrate deploy')` or Prisma's programmatic API --- *Generated by CEO Planner (priority: 3)*
Author
Owner

Bulk-closed 2026-04-10 during pipeline triage.

Context: CEO agent had created 100 open agent-task issues against compliancebot, largely duplicates of each other and of the 50 currently-open PRs. Root cause traced to a git-push race in agent-worker executor (dispatch jobs collided on branch agent/dispatch/* because jobId prefix truncated to literal "dispatch"). Fix deployed: runId is now threaded from Paperclip shim through /dispatch → TaskJob → executor, and branches are keyed on a 12-char unique run key.

What to do next:

  1. Triage the 50 open PRs at https://192.168.183.110:3000/pook/compliancebot/pulls — many are ready to merge
  2. CEO should halt new task creation until open PRs drop below 10
  3. Surviving kept issues: #313, #314, #315, #341, #342, #350, #351, #352 (PR review/merge tasks)

This issue was superseded, not abandoned. Reopen if still relevant after PR triage.

Bulk-closed 2026-04-10 during pipeline triage. **Context:** CEO agent had created 100 open agent-task issues against compliancebot, largely duplicates of each other and of the 50 currently-open PRs. Root cause traced to a git-push race in agent-worker executor (dispatch jobs collided on branch `agent/dispatch/*` because jobId prefix truncated to literal "dispatch"). Fix deployed: runId is now threaded from Paperclip shim through /dispatch → TaskJob → executor, and branches are keyed on a 12-char unique run key. **What to do next:** 1. Triage the 50 open PRs at https://192.168.183.110:3000/pook/compliancebot/pulls — many are ready to merge 2. CEO should halt new task creation until open PRs drop below 10 3. Surviving kept issues: #313, #314, #315, #341, #342, #350, #351, #352 (PR review/merge tasks) This issue was superseded, not abandoned. Reopen if still relevant after PR triage.
pook closed this issue 2026-04-10 14:48:27 -04:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
pook/compliancebot#248
No description provided.