Session not saved to current project when opencode process terminates unexpectedly.

[TZubiri]

Description

How to replicate this bug.

1. Create new folder mvce
2. cd into mvce
3. run opencode
4. send a test message
5. Kill the opencode process with "kill -SIGKILL $pid"
6. run opencode in the mvce folder again
7. Run the /sessions command
8. Expected: User should find the previous session.
9. Actual: User finds no sessions.

Plugins

No response

OpenCode version

No response

Steps to reproduce

No response

Screenshot and/or share link

No response

Operating System

No response

Terminal

No response

[github-actions]

This issue might be a duplicate of existing issues. Please check:

• Active Session Not Persisted After Desktop App Crash #8352: Active Session Not Persisted After Desktop App Crash - session lost after unexpected app termination
• Session gone missing after opencode collapse. #8661: Session gone missing after opencode collapse - session disappears after unexpected process exit

If your issue is distinct from these, please clarify what's different. Otherwise, consider adding a "+1" or additional context to those issues instead.

[TZubiri]

This issue might be a duplicate of existing issues. Please check:

• Active Session Not Persisted After Desktop App Crash #8352: Active Session Not Persisted After Desktop App Crash - session lost after unexpected app termination
• Session gone missing after opencode collapse. #8661: Session gone missing after opencode collapse - session disappears after unexpected process exit

If your issue is distinct from these, please clarify what's different. Otherwise, consider adding a "+1" or additional context to those issues instead.

While the issue might be the same ( I don't know for sure), the difference with this report is that I have identified where the session actually is, and as such the fix becomes much easier.

[TZubiri]

@thdxr I can give the fix a shot if you want to assign it to me.

I think the idea is to change the initial assignment of the 'project' column of the session table in the sqlite db from global to the specific project that would otherwise have been assigned on graceful termination.