Workspace sidebar loses older chats after one Load more even though more root sessions exist in DB #20614

Description

The workspace sidebar can stop exposing older chats even though more root, non-archived sessions still exist in the SQLite database for the same directory. Clicking Load more once can make the button disappear without revealing those older chats.

In my case, the missing sessions were still present in ~/.local/share/opencode/opencode.db under the same workspace directory (/). The sidebar appeared to keep only an early trimmed slice of the session list, and sessionTotal may also be undercounted, which makes hasMore flip to false too early.

This looks like a frontend state issue rather than missing data. The behavior seems consistent with the interaction between the sidebar pagination state and cached session slices in Desktop v1.3.13

Plugins

oh-my-opencode (likely unrelated)

OpenCode version

Desktop 1.3.13

Steps to reproduce

1. Use OpenCode Desktop with a workspace that has many older root sessions in the same directory.
2. Open the workspace sidebar.
3. Click Load more.
4. Observe that the button disappears after one click, but older chats still do not appear.
5. Inspect ~/.local/share/opencode/opencode.db and confirm that additional root, non-archived sessions still exist for that same directory.

Screenshot and/or share link

video links attached.
For the affected workspace, SQLite showed 33 root non-archived sessions under /, while the sidebar stopped around the 13th visible item and older sessions ranked 27–29 never became reachable.

Operating System

macOS

Terminal

OpenCode Desktop UI Tauri