dead_letters


Description

{“what”:“Table holding tasks that failed permanently after retries.”,“why”:“Without it, failed tasks would be lost, preventing investigation and manual recovery.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:30.956600029+00:00”}

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

Relationships