able-dusk-27311
12/12/2022, 3:01 AMtask_executions
table in flyte AdminDb
?
1. Can you please let me know when are started_at
and duration
set to null
?
2. I am of the impression that { created_at
and task_execution_created_at
}, { updated_at
and task_execution_updated_at
} should be the same. Can you please confirm this?
cc @thankful-minister-83577
@orange-hairdresser-63684 (FYI)hallowed-mouse-14616
12/12/2022, 5:03 PMstarted_at
field is set when the task initially transitions to the RUNNING
state either here or here . Consequently, it will not be set if the task never transitions to RUNNING
. So things like cache hits, failure to create pods, etc. Similarly, duration is computed when a task reaches a terminal state here or here . So if a task finishes (ex. succeeds, fails, etc). Then duration is computed based on the difference between started_at
and the current time.
2. There is some very specific differences here to keep in mind. The created_at
and updated_at
fields are maintained by gorm (the DB ORM we use internally) based on the conventions. So these timestamps should refer to DB object creation and update timestamps. Alternatively, the task_execution_created_at
and task_execution_updated_at
fields are set based on event timestamps from flytepropeller tracking the workflow execution. Propeller marks an event with timestamp A, send this to admin to track the status, and admin updates the DB. So, generally, they are going to be identical, or at least VERY close. However, if your attempted to track task execution times, it would be best practice to rely on the task_execution_created_at
and task_execution_updated_at
fields.