http proxy error: /e0e10e6f-ff2b-0d4c-8011-1fc1eee7cb32/message

[cxp-13]

Describe the bug

I checkout in main branch and running on WSL2, I have set the WSL2 proxy and it can normally access google.com eg.,
I set the SERVER_PORT as my local proxy port 7897.

1. execute pnpm start --character="characters/trump.character.json" and pnpm start:client
2. input some text on dialogue.
   The pnpm start:client terminal show

9:04:17 AM [vite] http proxy error: /e0e10e6f-ff2b-0d4c-8011-1fc1eee7cb32/message
Error: socket hang up
    at Socket.socketOnEnd (node:_http_client:542:25)
    at Socket.emit (node:events:525:35)
    at endReadableNT (node:internal/streams/readable:1696:12)
    at process.processTicksAndRejections (node:internal/process/task_queues:90:21)

The pnpm start --character="characters/trump.character.json terminal show

file:///home/cxp/solana_learn/AI/eliza/packages/adapter-sqlite/dist/index.js:308
        const memories = this.db.prepare(sql).all(...queryParams);
                                              ^
SqliteError: Error reading 1st vector: zero-length vectors are not supported.
    at SqliteDatabaseAdapter.searchMemoriesByEmbedding (file:///home/cxp/solana_learn/AI/eliza/packages/adapter-sqlite/dist/index.js:308:47)
    at SqliteDatabaseAdapter.createMemory (file:///home/cxp/solana_learn/AI/eliza/packages/adapter-sqlite/dist/index.js:240:48)
    at MemoryManager.createMemory (file:///home/cxp/solana_learn/AI/eliza/packages/core/dist/index.js:3176:44)
    at async file:///home/cxp/solana_learn/AI/eliza/packages/client-direct/dist/index.js:250:13 {
  code: 'SQLITE_ERROR'
}

Node.js v23.5.0
/home/cxp/solana_learn/AI/eliza/agent:
 ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL  @elizaos/agent@0.1.7-alpha.2 start: `node --loader ts-node/esm src/index.ts "--isRoot" "--character=characters/trump.character.json"`
Exit status 1

To Reproduce

Expected behavior

Can normally access the openai service

Screenshots

Additional context

[AIFlowML]

What is the version of ElizaOS you running ? Are you able to run without the proxy activated ?

[cxp-13]

What is the version of ElizaOS you running ? Are you able to run without the proxy activated ?

1. version of ElizaOS

cxp@R9000P:~/solana_learn/AI/eliza$ git log
commit 76d4f42e5763f638095d1179b2e88afc03fb8896 (HEAD -> main, origin/main, origin/HEAD)
Author: GitHub Action <actions@github.com>
Date:   Sat Dec 28 12:20:16 2024 +0000

    chore: update changelog

2. Yes, I once tried to start with the default proxy localhost:3000 on vite.confit.ts, but it still has mistakes as mentioned above

[jackoelv]

I have meet the same problem with tag v0.1.7-alpha.2.
It`s working correctly with tag v0.1.7-alpha.1

[lukaskai]

Issue is in your agent/src/index.ts that it tries to load old SQLITE Db, which is probably incompatible.
Changing

process.env.SQLITE_FILE ?? path.resolve(dataDir, "db.sqlite");

To

process.env.SQLITE_FILE ?? path.resolve(dataDir, "devdb.sqlite");

Solved it for me.

[MyJoiT]

Same issue here.
I removed the db.sqlite file in agent/data & re-ran pnpm start xx, worked

[tetreault]

Same issue here. I removed the db.sqlite file in agent/data & re-ran pnpm start xx, worked

Still run into this issue even after deleting & rerunning

[AIFlowML]

The issue is generally solved by either the solution proposed by @MyJoiT or @lukaskai
Is not a bug of the main code but i keep this open for investigation.

[ViniciusSerafim]

+1 none of the solutions worked for me

[0xsarvesh]

If I delete the file, it works for 1 interaction but again fails

[AIFlowML]

Solution was already posted with consensus.
I close this issue now.

[cxp-13]

The issue is generally solved by either the solution proposed by @MyJoiT or @lukaskai Is not a bug of the main code but i keep this open for investigation.

in latest commit on main branch,

commit ea9d1c02291dea26b25c815be30db5c91e6ceb21 (HEAD -> main, origin/main, origin/HEAD)
Merge: 62abe4c3 3c753065
Author: Odilitime <janesmith@airmail.cc>
Date:   Sun Jan 5 02:07:15 2025 -0800

    Merge pull request #1867 from elizaOS/odilitime-patch-1
    
    docs: Add DAO donation ask & dev discord

still have an error after removing the db.sqlite on agent/data, and running pnpm run xxxx

 ◎ LOGS
   Creating Memory 
   afeaf89b-5766-07e6-a4f2-3611ffa3245e 
   understands states' rights better than anyone 

Killed
/home/cxp/solana_learn/AI/eliza/agent:
 ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL  @elizaos/agent@0.1.7 start: `node --loader ts-node/esm src/index.ts "--isRoot" "--character=characters/trump.character.json"`
Exit status 137
 ELIFECYCLE  Command failed with exit code 137.
 ```

[cxp-13]

The issue is generally solved by either the solution proposed by @MyJoiT or @lukaskai Is not a bug of the main code but i keep this open for investigation.

in latest commit on main branch,

commit ea9d1c02291dea26b25c815be30db5c91e6ceb21 (HEAD -> main, origin/main, origin/HEAD)
Merge: 62abe4c3 3c753065
Author: Odilitime <janesmith@airmail.cc>
Date:   Sun Jan 5 02:07:15 2025 -0800

    Merge pull request #1867 from elizaOS/odilitime-patch-1
    
    docs: Add DAO donation ask & dev discord

still have an error after removing the db.sqlite on agent/data, and running pnpm run xxxx

 ◎ LOGS
   Creating Memory 
   afeaf89b-5766-07e6-a4f2-3611ffa3245e 
   understands states' rights better than anyone 

Killed
/home/cxp/solana_learn/AI/eliza/agent:
 ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL  @elizaos/agent@0.1.7 start: `node --loader ts-node/esm src/index.ts "--isRoot" "--character=characters/trump.character.json"`
Exit status 137
 ELIFECYCLE  Command failed with exit code 137.
 ```

My wsl2 memory limit causes it, and it works locally.