Page MenuHomePhabricator

Expose the gb_block_email column of the centralauth_p.globalblocks table in the wiki replicas view
Open, MediumPublicFeature

Description

I am displaying flags of global blocks in allblocksever. Flags such as gb_create_account are replicated in the replica view, only the recently introduced gb_block_email is missing.

Steps to replicate the issue (include links if applicable):

  • Log in to a Toolforge bastion host
  • Run sql centralauth describe globalblocks

What happens?:
Output:

+------------------------+------------------+------+-----+---------+-------+
| Field                  | Type             | Null | Key | Default | Extra |
+------------------------+------------------+------+-----+---------+-------+
| gb_id                  | int(10) unsigned | NO   |     | 0       |       |
| gb_address             | varbinary(255)   | YES  |     | NULL    |       |
| gb_target_central_id   | int(10) unsigned | NO   |     | 0       |       |
| gb_by_central_id       | int(10) unsigned | NO   |     | NULL    |       |
| gb_by_wiki             | varbinary(255)   | NO   |     | NULL    |       |
| gb_reason              | varbinary(767)   | NO   |     | NULL    |       |
| gb_timestamp           | binary(14)       | NO   |     | NULL    |       |
| gb_anon_only           | tinyint(1)       | NO   |     | 0       |       |
| gb_create_account      | tinyint(1)       | NO   |     | 1       |       |
| gb_enable_autoblock    | tinyint(1)       | NO   |     | 0       |       |
| gb_autoblock_parent_id | int(10) unsigned | NO   |     | 0       |       |
| gb_expiry              | varbinary(14)    | NO   |     | NULL    |       |
| gb_range_start         | varbinary(35)    | YES  |     | NULL    |       |
| gb_range_end           | varbinary(35)    | YES  |     | NULL    |       |
+------------------------+------------------+------+-----+---------+-------+

What should have happened instead?:

The gb_block_email should be included.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
JJMC89 renamed this task from The gb_block_email column of the centralauth_p.globalblocks view is missing in the toolforge replicas to The gb_block_email column of the centralauth_p.globalblocks view is missing in the wiki replicas.Wed, Aug 5, 7:10 AM
JJMC89 removed a project: Toolforge.
JJMC89 moved this task from Backlog to Wiki replicas on the Data-Services board.
JJMC89 updated the task description. (Show Details)
JJMC89 changed the subtype of this task from "Bug Report" to "Feature Request".Wed, Aug 5, 7:28 AM
JJMC89 subscribed.

The view is working as defined. The view definition was not updated following T413198.

JJMC89 renamed this task from The gb_block_email column of the centralauth_p.globalblocks view is missing in the wiki replicas to Expose the gb_block_email column of the centralauth_p.globalblocks table in the wiki replicas view.Wed, Aug 5, 7:28 AM

@JJMC89, sorry but a column missing in the Toolforge replica view for no good reason is a bug not a missing feature.

aputhin triaged this task as Medium priority.Wed, Aug 5, 2:09 PM
aputhin moved this task from Backlog to Todos on the tools-platform-team board.