Bug: SQLite sync queue - Missing named parameter limit

[microonline]

Bug Description

When running openclaw-memory in full mode (with PostgreSQL + AGE), the server fails to start with this error:

RangeError: Missing named parameter "limit"
    at Object.all (file:///.../node_modules/@poprobertdaniel/openclaw-memory/dist/chunk-BTR4T5L3.js:41:33)
    at SqliteStorage.getSyncQueue (file:///.../node_modules/@poprobertdaniel/openclaw-memory/dist/chunk-BTR4T5L3.js:323:7)
    at _SyncQueueProcessor.processQueue (file:///.../node_modules/@poprobertdaniel/openclaw-memory/dist/chunk-BTR4T5L3.js:1101:33)
    at _SyncQueueProcessor.start
    at StorageOrchestrator.init

Environment

• Node.js v22.22.0
• Bun 1.3.10
• OS: Linux
• Package version: latest (from npm)
• Tier: full (SQLite + Qdrant + PostgreSQL/AGE)

Steps to Reproduce

1. Have Qdrant running on localhost:6333
2. Have PostgreSQL + AGE running on localhost:5432
3. Run: PGHOST=localhost PGPORT=5432 PGUSER=openclaw PGPASSWORD=openclaw123 PGDATABASE=jarvis_memory bunx @poprobertdaniel/openclaw-memory start --tier full

Expected Behavior

Server should start successfully with all three layers (SQLite, Qdrant, AGE)

Actual Behavior

Server fails with RangeError about missing 'limit' parameter in SqliteStorage.getSyncQueue

Additional Notes

• Qdrant connects successfully
• AGE graph creates successfully
• The error happens in SQLite sync queue processing
• This prevents full tier from working

[oadank]

I have the same problem.

[oadank]

My AI solved, perfect! 🐟🔥**

Fix Summary

Root of the Problem:

1. ❌ Dockerfile is missing 'better-sqlite3' dependency
2. ❌ SQLite parameter syntax problem ('$limit' → ':limit')
3. ❌ Elysia is not compatible with 'app.listen()' in Node.js environments

Repair Steps:

1. ✅ Fix the naming parameter syntax of 'sqlite.ts'
2. ✅ Update the Dockerfile to install 'better-sqlite3'
3. ✅ Wrap the Elysia app with a native Node.js HTTP server

Current Status:

container: memory-server - up
Port: 7777
SQLite: ok
Qdrant: ok
AGE:    ok
Tier:   full