github / github/copilot-cli

CloudQueryError prevents /chronicle standup despite local fallback data

Open
#3,904 2 comments 0 reactions 0 assignees View on GitHub
area:sessions
Dominant language
Shell
Stars
11.2k
Forks
1.9k
Avg merge
14h 16m
Merged PRs (30d)
6

Description

### Describe the bug

## Summary

`/chronicle standup` fails when the cloud session store returns `CloudQueryError: internal server error`.

Local session data is available, and some `session_store_sql` queries successfully return local fallback rows. However, the DuckDB-style timestamp predicates used for last-24-hours chronicle queries appear to prevent local fallback from rescuing the command.

## Environment

- GitHub Copilot CLI: `1.0.64`
- Platform: Windows
- Package metadata: `@github/copilot` `1.0.64`, build metadata `ae586e7`
- Startup log showed: `No update needed, current version is 1.0.64, fetched latest release is v1.0.64`

## Impact

`/chronicle standup` cannot generate a standup report even though recent local session rows are available.

## Expected behavior

When the cloud session store fails with an internal server error, `session_store_sql` and `/chronicle standup` should degrade gracefully to local indexed sessions where possible, returning local rows with a warning.

## Actual behavior

The required last-24-hours query fails with:

```text
CloudQueryError: {"documentation_url":"https://docs.github.com/rest","message":"internal server error"}
```

### Affected version

1.0.64

### Steps to reproduce the behavior

This query fails completely:

SELECT id, branch, updated_at
FROM sessions
WHERE updated_at >= TIMESTAMP '2026-06-23T07:47:34.106Z'
ORDER BY updated_at DESC
LIMIT 5

This also failed:

SELECT id, branch, updated_at
FROM sessions
WHERE updated_at >= now() - INTERVAL '1 day'
ORDER BY updated_at DESC
LIMIT 5

But this query returns local fallback rows:

SELECT id, branch, updated_at
FROM sessions
ORDER BY updated_at DESC
LIMIT 5

Observed fallback behavior:

5 row(s) returned from _query_source = local
Cloud query failed (CloudQueryError: {"documentation_url":"https://docs.github.com/rest","message":"internal server error"}). Showing local results only.

### Expected behavior

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Research direction

Start with the session_store_sql handling and the /chronicle standup query path. Reproduce the timestamp-filtered queries and compare them with the unfiltered local fallback query; done means /chronicle standup returns local indexed sessions with a warning when the cloud query fails.

Written by the indexing model from the issue text.

Assessment

Tech stack
shell, sql
Domain
cli, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
58/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.