Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| sched_name | varchar | 120 | null |
|
|
{“what”:“Name of the scheduler cluster; part of composite key.”,“why”:“Identifies which scheduler cluster this state belongs to, enabling multiple schedulers in one DB.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:45.959754584+00:00”} |
||
| instance_name | varchar | 200 | null |
|
|
{“what”:“Unique identifier of a scheduler instance within the cluster.”,“why”:“Distinguishes each node’s state so the cluster can detect failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:46.450477575+00:00”} |
||
| last_checkin_time | int8 | 19 | null |
|
|
{“what”:“Epoch milliseconds of the last heartbeat from this instance.”,“why”:“Without it, the cluster cannot determine if an instance is alive or has failed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:46.540925895+00:00”} |
||
| checkin_interval | int8 | 19 | null |
|
|
{“what”:“Expected interval in milliseconds between heartbeats.”,“why”:“Without it, the cluster cannot decide when a missed check-in indicates a dead instance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:46.634457221+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_qrtz_scheduler_state | Primary key | Asc/Asc | sched_name + instance_name |