Skip to content

bug: GetLatestWorkspaceAppStatusesByAppID returns an unbounded number of rows #20862

New issue
New issue
Closed
Bug
#20917
Closed
bug: GetLatestWorkspaceAppStatusesByAppID returns an unbounded number of rows#20862
Bug
#20917
Labels
project/tasksCoder tasksscaletestIssues related to scale testing.

Description

@spikecurtis
spikecurtis
opened on Nov 21, 2025

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

GetLatestWorkspaceAppStatusesByAppID returns all app statuses ever written for the given app. This could be quite large for a long running AI task.

Only the first (most recent) status is ever used at present, to determine whether the WorkspaceAppStatusState is changing while inserting a new status update.

Relevant Log Output



Expected Behavior


No response


Steps to Reproduce


Run an AI task that updates status more than once.


Environment


    

  • Host OS:
    • 

  • Coder version:
    • 



Additional Context


No response
Activity
  1. spikecurtis
    added 
    scaletestIssues related to scale testing.
     on Nov 21, 2025
  2. spikecurtis
    added the
    Bug
    issue type on Nov 21, 2025
  3. david-fraley
    added 
    project/tasksCoder tasks
     on Nov 21, 2025
  4. mafredri commented on Nov 21, 2025 
    @mafredri
    mafredri
    on Nov 21, 2025
    Member
    Nice find, this seems like an easy win as the query only used in one place.
    

      

    1. Rename GetLatestWorkspaceAppStatusesByAppID -> GetLatestWorkspaceAppStatusByAppID and change :many -> :one
      2. 

    2. Add LIMIT 1
      3. 

    

    Slack thread for context: https://codercom.slack.com/archives/C05D8G51P8Q/p1763726141970759
  5. mafredri
    closed this as completedin #20917on Nov 25, 2025
  6. mafredri
    added a commit that references this issue on Nov 25, 2025
    perf(coderd/database): limit `GetLatestWorkspaceAppStatusByAppID` to …
    37fc664
  7. david-fraley
    added a commit that references this issue on Nov 25, 2025
    perf(coderd/database): limit `GetLatestWorkspaceAppStatusByAppID` to …
    7c15cc6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Metadata
Metadata
Assignees
No one assigned
    Labels
    project/tasksCoder tasksscaletestIssues related to scale testing.
    Type
    Bug
    Projects
    No projects
      Milestone
      No milestone
      Relationships
      None yet
      Development
      No branches or pull requests
      Issue actions