Motivation

• Legacy/corrupted rows were observed with status = 'system:unclaimed', but system:unclaimed is an agent sentinel that must live in agent_id not status, and such rows are treated as non-available and break consumers that expect canonical statuses.

Description

• Add a startup repair pass repairSystemUnclaimedStatusRows() invoked from WorkqDatabase.initialize() that updates any rows with status = 'system:unclaimed' to status = 'claimed', sets agent_id = 'system:unclaimed' when the row shows the symmetric corrupted shape, and refreshes updated_at.
• Add a regression test to src/database.test.ts which simulates the legacy/corrupted row (status='system:unclaimed', agent_id='claimed') and verifies reopening the DB triggers the repair to status='claimed', agent_id='system:unclaimed'.
• Modified files: extensions/workq/src/database.ts and extensions/workq/src/database.test.ts.

Testing

• Executed package test runner: pnpm --filter @openclaw/workq test -- src/database.test.ts, which failed to run the suites due to a missing Vitest setup file (extensions/workq/test/setup.ts), preventing full automated validation in this environment.
• The new regression test has been added to the workq test suite so it will exercise the repair logic once the repository's test setup is available and Vitest runs successfully.

Codex Task