Skip to main content

Troubleshoot Leave Database and Migration

Summary​

Safe triage for startup, schema, persistence, and migration failures.

Audience​

Employees or administrators affected by the scenario, first-line support, QA, service owners, and architects.

Symptoms​

Leave fails startup, persistence operations fail, or schema/migration evidence is inconsistent.

Scope​

Leave data-store connectivity, configured migration behavior, schema compatibility, and transactional persistence.

Cause​

The cause must be confirmed from current state and source-backed evidence.

Likely causes​

  • Data store unavailable
  • Schema version incompatible with application
  • Migration failed or was not applied as expected
  • Database permissions/capacity issue
  • Application/data rollback boundary mismatch

Safe diagnostic steps​

  1. Capture safe startup/error category and deployed application version.
  2. Ask the database owner to verify connectivity and migration history through approved tools.
  3. Compare expected migration lineage without exposing connection details.

Resolution​

Restore connectivity/capacity or apply the approved migration/redeployment/rollback plan. Do not run ad-hoc SQL, edit migration history, or manipulate Leave rows.

Safe resolution​

Use only the resolution above and approved operational processes. Do not modify databases, replay messages, bypass authorization, or repeat ambiguous state-changing actions.

Validation​

Confirm clean startup/process health and a safe read/write smoke operation in an authorized environment.

Evidence to collect​

Collect the safe UTC window, route/operation category, response/status category, deployed version, affected scope count, and a correlation identifier. Exclude credentials, tokens, personal Leave details, employee identifiers, payloads, configuration values, and private topology.

Escalation​

Database owner, Leave service owner, and DevOps/SRE; release approver for rollback decisions.

Source References​

  • microservices/src/leave-service/Infrastructure/Persistence.cs
  • microservices/src/leave-service/Infrastructure/LeaveDbContext.cs
  • microservices/src/leave-service/Infrastructure/Migrations/LeaveDbContextModelSnapshot.cs

See Also​

Keywords​

  • Leave troubleshooting
  • Troubleshoot Leave Database and Migration
  • Safe diagnostics

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-15
  • Review cycle: Quarterly