n8n - 💡(How to fix) Fix GET /rest/workflows/:id returns 404 for specific IDs while list/export all shows them [1 comments, 2 participants]

Summary\nSelf-hosted n8n: GET /rest/workflows/:id returns 404 ("Could not load the workflow - you can only access workflows owned by you") for specific workflow IDs, while the same workflows are visible in /rest/workflows and in n8n export:workflow --all.\n\n## Environment\n- Self-hosted Docker\n- n8n 2.10.3 (initial) -> upgraded to 2.17.7 (latest as of 2026-04-24)\n- Postgres 15 (pgvector image)\n- Basic auth enabled\n\n## Affected workflow IDs\n- hJfoNbvdOPwMLl1v (Create Meeting v2.5.4)\n- JkwQlKni4Lx8duw9 (Free slots Google Calendar)\n\nControl (works):\n- ORrDtJJaHDh5clTt (Gen-Critic Sales Loop v2.5.4)\n\n## Steps to reproduce\n1. Login via /rest/login (admin user, global owner).\n2. GET /rest/workflows/hJfoNbvdOPwMLl1v -> 404.\n3. GET /rest/workflows/JkwQlKni4Lx8duw9 -> 404.\n4. GET /rest/workflows/ORrDtJJaHDh5clTt -> 200.\n5. GET /rest/workflows (list) shows both broken IDs in the response.\n6. n8n export:workflow --all includes both broken IDs.\n7. n8n export:workflow --id=hJfoNbvdOPwMLl1v returns 'No workflows found with specified filters'.\n\n## Expected\nGET /rest/workflows/:id returns 200 for workflows owned by the user.\n\n## Actual\nGET /rest/workflows/:id returns 404 with message about ownership, only for specific IDs.\n\n## Notes\n- shared_workflow/project_relation rows look correct for all three IDs (same projectId, workflow:owner, project:personalOwner).\n- workflow_history row exists for activeVersionId for all three IDs.\n- workflow_publish_history has no missing workflow_history rows; duplicates exist only on the working workflow (ORr).\n- Upgrading from 2.10.3 -> 2.17.7 did not change behavior.\n