GraphQL type mismatch: last_run_deleted_size uses Int instead of BigInt causing 500 errors for large values

Summary

In Virtual Registries cleanup policy, the database field last_run_deleted_size is defined as a bigint, but the corresponding GraphQL type is set as Int. This type mismatch causes 500 errors when querying values larger than the GraphQL Int maximum.

Details

  • GraphQL Int type: Signed 32-bit integer
    • Range: -2,147,483,648 to +2,147,483,647
  • Database type (PostgreSQL bigint): Signed 64-bit integer
    • Range: -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807

Steps to reproduce

  1. Have a last_run_deleted_size value in the database that exceeds 2,147,483,647
  2. Query the field via GraphQL
  3. Observe a 500 error response

Expected behavior

The GraphQL query should return the correct large integer value without error.

Actual behavior

The query returns a 500 error when the value exceeds the 32-bit integer limit.

Proposal

Update the GraphQL type for last_run_deleted_size from Int to BigInt to match the database column type.

Edited Dec 18, 2025 by Fiona McCawley
Assignee Loading
Time tracking Loading