YAML Chains --replace and execution_log

[JBHighHair]

YAML Chains is a great way to facilitate homogeneous chain\task definitions across multiple instances using --replace
Restarting pg_timetable process with --replace every time will increment the chain_id and task_id for matching (unique) chain names.
This is correct and proper, but the issue is that the table timetable.execution_log references chain_ids and task_ids which are no longer present in tables timetable.chain and timetable.task
This makes reviewing historical records in the execution_log difficult because of the broken reference to chain_name and task_name

(I'm not too concerned about entries in the table execution_log for chains\tasks which users have intentionally removed\deleted.)

Some options for resolution are:

[1]
The --replace function could also be made to update the chain_id and task_id in the table timetable.execution_log with the newly "replaced" values.
The negative aspect of doing this is this will cause lots of updates to the table timetable.execution_log when --replace is run.

[2]
The more difficult method is for the --replace function to determine if the chain or task is actually different to the YAML definition and only recreate them if they are dissimilar.
The negative aspect here is that even if this is done the table timetable.execution_log will still reference old IDs for the chain\task which were replaced.

[3]
Add to the table timetable.execution_log columns for chain_name and task_name to record when the task runs.

[pashagolub]

I think you can have @reboot chain that will do some magic you want here.

[JBHighHair]

Yes, that could work.
Are you suggesting after the reboot to increment all the unmatching chain_ids and task_ids in the table timetable.execution_log (when compared to task and chain tables) which have a differing value of 1?
That can be quite messy.
Not all chains are yaml chains - there can be a mix.

I think Option 3 would be the easiest.
At least you have a record of the chain and task names.
Some users may completely re-purpose an existing task (or chain) (update record - without deleting)
timetable.execution_log should just be a record of what ran and when.

[pashagolub]

Maybe you're right. Having a human-readable name might help in reading logs.