TL;DR

Modify the openclaw tasks maintenance command to automatically reconcile stale task records by marking them as lost or timed_out when the corresponding sub-agent processes no longer exist.

Guidance

• Investigate the openclaw tasks maintenance command to determine why it does not auto-reconcile stale task records, despite correctly detecting them.
• Consider adding a crash recovery mechanism to the gateway startup process to reconcile stale task records.
• Review the database schema to understand how task records are stored and updated, which may help identify the root cause of the issue.
• Test the openclaw tasks maintenance --apply command with different scenarios to see if it can be forced to reconcile stale task records.

Example

No code example is provided as the issue does not contain sufficient information about the implementation details.

Notes

The provided information suggests that the issue is related to the task reconciliation mechanism in OpenClaw, but more details about the implementation and database schema are needed to provide a definitive solution.

Recommendation

Apply a workaround by modifying the openclaw tasks maintenance command to handle stale task records, as upgrading to a fixed version is not mentioned in the issue. This is because the issue seems to be related to the implementation of the task reconciliation mechanism, which can be addressed by modifying the existing code.