Bug: Dremio SQL Runner error when exceeding ~1000 saved scripts

1

Issue

I’m experiencing what appears to be a threshold-based bug in the SQL Runner. When the total number of saved user scripts exceeds approximately 1000, the SQL Editor malfunctions when attempting to create new scripts. Specifically:

  1. The new script tab gets stuck trying to generate its default title (which should be the current date and timestamp)
  2. The UI becomes unresponsive for this tab - cannot save the script or interact properly
  3. Browser developer console shows error: TypeError: Cannot read properties of undefined (reading 'id')

838×202 19.6 KB

Steps to Reproduce

  1. Allow the number of saved user scripts to exceed 1000 (verified via Scripts API)
{
  "total": 1032,
  [...]
}
  1. Attempt to open a new script in the UI

Workaround

It seems that manually cleaning up saved user scripts to reduce the total below 1000 resolves the issue completely. After reducing the script count, new script tabs open and function as expected.

Environment

Build
25.2.0-202410241428100111-a963b970
Edition
Community Edition
Build Time
24.10.2024 14:32:31
Change Hash
a963b9700065580085db55774de40257e6ea70cd
Change Time
24.10.2024 14:27:52

Note

Most of the scripts that trigger this issue are not explicitly saved scripts, but rather temporary ones. When checking with the Scripts API, I found that many of these scripts have names starting with __DREMIO_TMP__ and are pretty old. Is it expected that they’re accumulating in my system and I need to do manual housekeeping?

Thank you!