Skip to content

ui: database list breaks down entirely when there are many databases #94333

@knz

Description

@knz

(Found via #94027)

Describe the problem

When there are many databases, the database list page refuses to load with an error.
The specific limit seems to be environment-dependent. For example on my machine I encounter this limit at ~450 databases.

To Reproduce

  1. start cockroach demo with the changes from sql: new functions crdb_internal.generate_test_objects and .gen_rand_ident #94027
  2. generate 1000 databases, e.g. via select crdb_internal.generate_test_objects('{"names":"mydb._._","counts":[1000,0,0],"name_gen":{"noise":false}}'::jsonb);
  3. navigate to db console -> databaes

Observe: page is broken (see screenshot below)

Expected behavior

Database list should always display regardless of database count.

Additional data / screenshots

image

Environment:

  • master towards v23.1

Epic: CRDB-20388

Jira issue: CRDB-22836

Metadata

Metadata

Assignees

Labels

A-sql-observabilityRelated to observability of the SQL layerA-webui-databasesC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions