[Bug]: SQLiteError: NOT NULL constraint failed: session_message.seq

[byStrange]

Summary

When i try to chat with my models inside openwork as soon as i send the message. it raises error in the usual response box:

    at run (unknown)
    at #run (bun:sqlite:185:20)
    at appendMessage (/$bunfs/root/chunk-csbe8aea.js:2:62480)
    at session.next.agent.switched (/$bunfs/root/chunk-csbe8aea.js:2:56601)
    at oP (/$bunfs/root/chunk-csbe8aea.js:2:56546)
    at Gn (/$bunfs/root/chunk-csbe8aea.js:2:62522)
    at <anonymous> (/$bunfs/root/chunk-csbe8aea.js:2:62710)
    at <anonymous> (/$bunfs/root/chunk-a0djr57c.js:39:7317)
    at pf (/$bunfs/root/chunk-c2nqvebx.js:715:34374)
    at w6 (/$bunfs/root/chunk-a0djr57c.js:39:7306)
    at <anonymous> (/$bunfs/root/chunk-a0djr57c.js:39:5669)
    at run (node:async_hooks:62:22)
    at SyncEvent.run (/$bunfs/root/chunk-77nn8esd.js:10:62853)
    at SyncEvent.run (definition) (/$bunfs/root/chunk-a0djr57c.js:39:5213)
    at SessionPrompt.createUserMessage (/$bunfs/root/chunk-77nn8esd.js:1678:366)
    at SessionPrompt.createUserMessage (definition) (/$bunfs/root/chunk-77nn8esd.js:1677:2012)
    at SessionPrompt.prompt (/$bunfs/root/chunk-csbe8aea.js:2:240842)
    at SessionPrompt.prompt (definition) (/$bunfs/root/chunk-77nn8esd.js:1678:250)
    at SessionHttpApi.promptAsync (/$bunfs/root/chunk-csbe8aea.js:2:91990)
    at SessionHttpApi.promptAsync (definition) (/$bunfs/root/chunk-csbe8aea.js:2:240749)
    at Server.listen (/$bunfs/root/chunk-csbe8aea.js:2:259930)
    at Server.listen (definition) (/$bunfs/root/chunk-csbe8aea.js:2:260053)

To Reproduce

1. Download openwork with paru (paru openwork)
2. run openwork
3. Set up ollama cloud integration
4. write a text in chat and send

Expected behavior

SQLiteError: NOT NULL constraint failed: session_message.seq
at run (unknown)
at #run (bun:sqlite:185:20)
at appendMessage (/$bunfs/root/chunk-csbe8aea.js:2:62480)
at session.next.agent.switched (/$bunfs/root/chunk-csbe8aea.js:2:56601)
at oP (/$bunfs/root/chunk-csbe8aea.js:2:56546)
at Gn (/$bunfs/root/chunk-csbe8aea.js:2:62522)
at (/$bunfs/root/chunk-csbe8aea.js:2:62710)
at (/$bunfs/root/chunk-a0djr57c.js:39:7317)
at pf (/$bunfs/root/chunk-c2nqvebx.js:715:34374)
at w6 (/$bunfs/root/chunk-a0djr57c.js:39:7306)
at (/$bunfs/root/chunk-a0djr57c.js:39:5669)
at run (node:async_hooks:62:22)
at SyncEvent.run (/$bunfs/root/chunk-77nn8esd.js:10:62853)
at SyncEvent.run (definition) (/$bunfs/root/chunk-a0djr57c.js:39:5213)
at SessionPrompt.createUserMessage (/$bunfs/root/chunk-77nn8esd.js:1678:366)
at SessionPrompt.createUserMessage (definition) (/$bunfs/root/chunk-77nn8esd.js:1677:2012)
at SessionPrompt.prompt (/$bunfs/root/chunk-csbe8aea.js:2:240842)
at SessionPrompt.prompt (definition) (/$bunfs/root/chunk-77nn8esd.js:1678:250)
at SessionHttpApi.promptAsync (/$bunfs/root/chunk-csbe8aea.js:2:91990)
at SessionHttpApi.promptAsync (definition) (/$bunfs/root/chunk-csbe8aea.js:2:240749)
at Server.listen (/$bunfs/root/chunk-csbe8aea.js:2:259930)
at Server.listen (definition) (/$bunfs/root/chunk-csbe8aea.js:2:260053)

Actual behavior

it shouldn't raise this error and just work normally

Screenshots (optional)

OW version & Desktop info (optional)

• OpenWork version [v0.15.1]
• OS: [CachyOs]

Additional context (optional)

No response

[joemaller]

Seeing exactly the same error immediately with existing and new tasks.

MacOS Sequoia 15.7.7 (24G720)
OpenWork Version 0.15.1 (0.15.1)
same error with OpenCode Zen or OpenRouter models.

FWIW, I also have several OpenCode sessions open in different terminal windows.

[FranzP]

Same on Windows 11 (26200.8524)

Tested versions 0.14.1, 0.15.0 and 0.15.1

[05tprouterccc]

Windows 11 下同样复现 (OpenWork v0.15.2)

我在 Windows 11 上遇到了完全相同的 bug。每次发送消息时都会触发 — 看起来是在第一条消息还没完全初始化的时候，Session 触发了代理切换（session.next.agent.switched），然后 appendMessage 往 session_message 表插入数据时 seq 字段为 NULL，导致 SQLite 报错。

我的错误栈：

SQLiteError: NOT NULL constraint failed: session_message.seq
at appendMessage (B:/~BUN/root/chunk-j582v44c.js:2:62480)
at session.next.agent.switched (B:/~BUN/root/chunk-j582v44c.js:2:56601)
at SessionPrompt.createUserMessage (B:/~BUN/root/chunk-rsc45ft5.js:1677:366)
at SessionPrompt.prompt (B:/~BUN/root/chunk-j582v44c.js:2:240842)
at SessionHttpApi.promptAsync (B:/~BUN/root/chunk-j582v44c.js:2:91990)
环境信息：

系统： Windows 11
OpenWork 版本： v0.15.2 (最新稳定版)
运行模式： Host mode (本地)
AI 提供商： 自定义 OpenAI 兼容接口
补充分析： 这看起来是一个竞态条件问题 — 在 session 的 seq 计数器还没初始化的时候，session.next.agent.switched 事件就被触发了，导致 appendMessage 拿不到正确的序号。系统/切换产生的消息类型可能没有正确地获取序列号赋值。

如果需要我提供更多调试信息，随时告诉我。

[oo00spy00oo]

Same on 1.15.2