Skip to content

DB Console: Databases page is showing incorrect zone configuration values #57896

@exalate-issue-sync

Description

@exalate-issue-sync

Observation. When a user edits zone configurations for a database or a table, those updated attributes are not reflected in the {{Databases}} page. What’s currently shown in the DB Console UI is incorrect.

Repo steps. Define new zone configs for a table and notice that {{Databases}} page does not update to reflect that change. I have a test {{bank}} database with a table called {{orders}}

  • SHOW ZONE CONFIGURATION FOR TABLE orders;
    ** !Image 2020-11-19 at 11.58.56 AM.png|width=757,height=215!

  • ALTER TABLE orders CONFIGURE ZONE USING num_replicas = 5, gc.ttlseconds = 180000;

  • SHOW ZONE CONFIGURATION FOR TABLE orders;
    ** !Image 2020-11-19 at 11.59.35 AM.png|width=759,height=213!

  • See corresponding {{Databases}} page - the page does not show the updated values (it continues to show the {{RANGE default}} values)
    ** !Image 2020-11-19 at 12.01.14 PM.png|width=1307,height=825!

Expectation. After a user edits zone configurations, the DB Console UI should match the output of {{SHOW ZONE CONFIGURATION FOR database or table}}.


From Slack:

It looks like from the output of {{show all zone configurationson}} that you altered the zone config for {{range default}}. Then it seems you created a table without changing the zone configs on the database/table itself. Our zone configurations apply in a cascading fashion (see this [issue](https://github.com/cockroachdb/cockroach/issues/31398] for details). It looks like we have both some work to do in the SQL shell to show inheritance for zone configs and also to update the UI to properly reflect inheritance.

cc [~accountid:5bd8d5d73aa82432ce72c0e5) for awareness who investigated the issue

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-communityOriginated from the communityX-blathers-triagedblathers was able to find an owner

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions