Snippet update fails with PG::QueryCanceled timeout error

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

Summary

Users are experiencing PG::QueryCanceled timeout errors when attempting to update snippets. The error message indicates a database query timeout during the snippet update operation.

Steps to reproduce

  1. Open an existing snippet for editing
  2. Make changes to the snippet content
  3. Attempt to save/update the snippet
  4. Observe the error: "Can't update snippet: Repository Error updating the snippet - PG::QueryCanceled: ERROR: canceling statement due to statement timeout"

Expected behavior

Snippet updates should complete successfully without timing out.

Actual behavior

The snippet update operation times out with a PG::QueryCanceled error. A second attempt may succeed, suggesting this is an intermittent performance issue rather than a permanent failure.

Error details 

PG::QueryCanceled: ERROR: canceling statement due to statement timeout

Additional context

  • This appears to be unrelated to the vulnerability auto-resolution worker mentioned in #417046 (closed)
  • The issue occurs during normal snippet editing operations
  • Retrying the operation may succeed, indicating database contention or slow queries
Edited by 🤖 GitLab Bot 🤖