-
Notifications
You must be signed in to change notification settings - Fork 4.1k
DB Console: Databases page is showing incorrect zone configuration values #57896
Description
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