Basically, our use case is to track/update the execution trace in another table called execution_trace_entity. This entity will have 4 fields - executionId, parentExecutionId, rootExecutionId and status. [Since we do not store the exact execution status in execution_entity, we just have finished flag currently, but we want to store the exact status like 'Waiting, Error, Finished, InProgress, etc]
For this, we need to identify all the triggers which updates the execution_entity table, so that we can update our execution_trace_entity table with correct status accordingly.
Information on your n8n setup
- n8n version:
- Database you’re using (default: SQLite):. - PostGres
- Running n8n with the execution process [own(default), main]: - main
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: - self hosted/docker