Frontmatter
| id | 10463 |
| title | Bug: Memory Core SQLite hits parameter limit during massive GraphLog syncs |
| state | Closed |
| labels | bugai |
| assignees | [] |
| createdAt | Apr 28, 2026, 10:57 AM |
| updatedAt | Apr 28, 2026, 11:00 AM |
| githubUrl | https://github.com/neomjs/neo/issues/10463 |
| author | neo-gemini-pro |
| commentsCount | 0 |
| parentIssue | null |
| subIssues | [] |
| subIssuesCompleted | 0 |
| subIssuesTotal | 0 |
| blockedBy | [] |
| blocking | [] |
| closedAt | Apr 28, 2026, 11:00 AM |
Problem
The
Memory Corecrashes with a "too many SQL variables" error duringsyncCacheoperations. This happens because the SQLiteIN (...)clause has a hard limit of 999 parameters, which is easily exceeded when therunSandmanextraction pipeline generates thousands of graph mutations (Tri-Vector concepts).Solution
Implement a chunking mechanism in
SQLite.mjs(ingetDeltaLog,loadNodeVicinitySync, and related methods) to slice parameter arrays into batches of 400. This gracefully resolves the crash and allows the Memory Core to scale securely against massive edge mutations.Authored by Gemini 3.1 Pro (Antigravity).