Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | text | 2147483647 | null |
|
|
{“what”:“Unique identifier for this dead-letter record; UUID or similar.”,“why”:“Without it, records cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.020601740+00:00”} |
||
| original_task_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the original task that failed; matches a task ID in the main queue.”,“why”:“Without it, the failed task cannot be traced back to its source for retry or analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.037426370+00:00”} |
||
| device | text | 2147483647 | null |
|
|
{“what”:“Device identifier (e.g., serial number) that the task was intended for.”,“why”:“Without it, failures cannot be grouped by device to detect hardware-specific issues.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.059306247+00:00”} |
||
| task_type | text | 2147483647 | null |
|
|
{“what”:“Type of task (e.g., ‘firmware_update’, ‘diagnostic’) that failed.”,“why”:“Without it, failure patterns by task category cannot be identified for prioritization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.075343478+00:00”} |
||
| payload | text | 2147483647 | null |
|
|
{“what”:“Original task payload as JSON or serialized string; used for retry.”,“why”:“Without it, the task cannot be re-executed or inspected for the exact input that caused failure.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.089104800+00:00”} |
||
| attempts | int4 | 10 | null |
|
|
{“what”:“Number of times the task was attempted before being dead-lettered.”,“why”:“Without it, retry policies cannot be enforced or the failure severity assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.187714957+00:00”} |
||
| last_error | text | 2147483647 | √ | null |
|
|
{“what”:“Last error message or stack trace from the final failed attempt.”,“why”:“Without it, the cause of failure is unknown, hindering debugging and alerting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.202873540+00:00”} |
|
| dead_at | text | 2147483647 | null |
|
|
{“what”:“Timestamp (ISO 8601) when the task was moved to dead letters.”,“why”:“Without it, the age of the failure cannot be determined for SLA or cleanup decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.260757708+00:00”} |
||
| acknowledged | int4 | 10 | 0 |
|
|
{“what”:“Flag (0/1) indicating whether an operator has acknowledged this dead letter; default 0.”,“why”:“Without it, unacknowledged failures cannot be distinguished from processed ones, risking missed alerts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:31.400655678+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dead_letters_pkey | Primary key | Asc | id |