Spike: Can we recreate a skeleton page_change (revision_change) event from DB replica alone?
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	xcollazo
	Jun 17 2024, 7:36 PM

Description

Recently we discussed whether Dumps 2.0 should do reconciliation directly from the Analytics replicas, or whether it should delegate this mechanism elsewhere by just emitting (wiki_db, revision_id) pairs.

In this spike we want to see how much context we would miss, if any, when trying to generate any revisions that are missing, or to rectify revisions that have bad metadata.

Context:

DDL for wikitext_raw_rc2: https://gitlab.wikimedia.org/repos/data-engineering/dumps/mediawiki-content-dump/-/blob/main/hql/create-mediawiki_build_dumps_from_events_merge_into.hql

page_change schema: https://schema.wikimedia.org/repositories//primary/jsonschema/mediawiki/page/change/1.1.0.yaml

Related Objects
Search...

Status	Assigned	Task
Resolved	xcollazo	T358877 Dumps 2.0 Phase II: Production intermediate table milestone
Resolved	xcollazo	T358373 [Dumps 2] Reconciliation mechanism to detect and fetch missing/mismatched revisions
Resolved	Milimetric	T367810 Spike: Can we recreate a skeleton page_change (revision_change) event from DB replica alone?

Event Timeline

xcollazo created this task.Jun 17 2024, 7:36 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 17 2024, 7:36 PM

Analysis available in this spreadsheet: https://docs.google.com/spreadsheets/d/1iSlH5XsRXV7mDoku0F5HbLNJmx1CMBm6ECakZMPUbU8/edit?usp=sharing

Screenshot from 2024-06-17 15-42-33.png (858×1 px, 103 KB)

Ottomata mentioned this in T358373: [Dumps 2] Reconciliation mechanism to detect and fetch missing/mismatched revisions.Jun 17 2024, 8:56 PM

@Milimetric

page_namespace
page_title
user_text

are not available in mariadb?

• lbowmaker subscribed.Jun 18 2024, 12:02 PM

In T367810#9901252, @Ottomata wrote:

@Milimetric

page_namespace

page_title

user_text

are not available in mariadb?

I think we do have access to page details via the rev_page foreign key: https://www.mediawiki.org/wiki/Manual:Revision_table#rev_page.

User text seems also available via rev_actor foreign key: https://www.mediawiki.org/wiki/Manual:Revision_table#rev_actor

Okay, so we can get:

page_namespace
page_title
user_text

from the MariaDB replicas, but we cannot get these historically. When reconciling, they will only match the current state. This is true if we use MediaWiki as well.

Without MediaWiki involved, we only miss:

revision_content_slots (content body).
redirect_page_title (this is encoded in content body, and we need mediawiki to parse content to get this)

Is that correct?

@Milimetric I think this task is also about figuring out if we could construct a mediawiki.page_content_change.v1 equivalent event from MariaDB + MW API as is.

Your analysis shows us how we could use MariaDB + MW API to reconcile and insert into wikitext_raw.

What about producing a mediawiki/page/change like event? Could we create an event like that from MariaDB + MW API (to get content or other fields) now?

I think we can close this spike considering we decided to go with the API approach. Yes?

In T367810#9935107, @xcollazo wrote:

I think we can close this spike considering we decided to go with the API approach. Yes?

Never mind. We are still debating this.

Here is an annotated version of https://schema.wikimedia.org/repositories//primary/jsonschema/mediawiki/page/change/1.2.0.yaml with YES, NO, and PARTIAL on the fields that we could produce if we only had the Analytics Replicas for context:

title: mediawiki/page/change
description: >
  Represents a MediaWiki page state change in a changelog. This event models all
  state changes to MediaWiki pages. It supersedes the other page and revision
  based event models. See: https://phabricator.wikimedia.org/T308017
$id: /mediawiki/page/change/1.2.0
$schema: 'https://json-schema.org/draft-07/schema#'
type: object
additionalProperties: false
required:
  - $schema                                                                              YES
  - changelog_kind                                                                       NO
  - dt                                                                                   YES
  - meta                                                                                 PARTIAL
  - page                                                                                 PARTIAL
  - page_change_kind                                                                     NO
  - revision                                                                             PARTIAL
  - wiki_id                                                                              YES
properties:
  $schema:
    description: >
      A URI identifying the JSONSchema for this event. This should match an
      schema's $id in a schema repository. E.g. /schema/title/1.0.0
    type: string
  changelog_kind:                                                                       NO
    description: >
      The kind of this event in a changelog. This is used to map the event to an
      action in a data store.
    type: string
    enum:
      - insert
      - update
      - delete
  comment:                                                                              YES
    description: >
      The comment left by the user that performed this change. Same as
      revision.comment on edits.
    type: string
  created_redirect_page:                                                                NO
    title: fragment/mediawiki/state/entity/page
    description: >
      Page entity that was created at the old title during a page move. This is
      only set for page move events. Note that the created_redirect_page will
      also have its own associated page create event.
    $id: /fragment/mediawiki/state/entity/page/2.0.0
    $schema: 'https://json-schema.org/draft-07/schema#'
    type: object
    additionalProperties: false
    required:
      - page_id
      - page_title
    properties:
      is_redirect:
        description: True if the page is a redirect page at the time of this event.
        type: boolean
      namespace_id:
        description: The id of the namespace this page belongs to.
        type: integer
        maximum: 9007199254740991
        minimum: 0
      page_id:
        description: The (database) page ID of the page.
        type: integer
        maximum: 9007199254740991
        minimum: 0
      page_title:
        description: The normalized title of the page.
        type: string
        minLength: 1
      revision_count:
        description: >
          NOTE: revision_count is never set for created_redirect_page. It is
          present here for backwards compatibility only.
        type: integer
        maximum: 9007199254740991
        minimum: 0
    examples:
      - is_redirect: false
        namespace_id: 1351079888211148
        page_id: 1351079888211148
        page_title: dolor
  dt:                                                                                YES
    description: >
      ISO-8601 formatted timestamp of when the event occurred/was generated in
      UTC), AKA 'event time'. This is different than meta.dt, which is used as
      the time the system received this event.
    type: string
    format: date-time
    maxLength: 128
  meta:                                                                              PARTIAL
    type: object
    required:
      - stream
    properties:
      domain:                                                                           NO
        description: Domain the event or entity pertains to
        type: string
        minLength: 1
      dt:
        description: 'Time the event was received by the system, in UTC ISO-8601 format'
        type: string
        format: date-time
        maxLength: 128
      id:                                                                               YES
        description: Unique ID of this event
        type: string
      request_id:                                                                       NO
        description: Unique ID of the request that caused the event
        type: string
      stream:                                                                           YES
        description: Name of the stream (dataset) that this event belongs in
        type: string
        minLength: 1
      uri:                                                                              NO
        description: Unique URI identifying the event or entity
        type: string
        format: uri-reference
        maxLength: 8192
  page:
    title: fragment/mediawiki/state/entity/page
    description: Fields for MediaWiki page entity.
    $id: /fragment/mediawiki/state/entity/page/2.0.0
    $schema: 'https://json-schema.org/draft-07/schema#'
    type: object
    additionalProperties: false
    required:
      - page_id
      - page_title
    properties:
      is_redirect:                                                                       YES
        description: True if the page is a redirect page at the time of this event.
        type: boolean
      namespace_id:                                                                       YES
        description: The id of the namespace this page belongs to.
        type: integer
        maximum: 9007199254740991
        minimum: 0
      page_id:                                                                       YES
        description: The (database) page ID of the page.
        type: integer
        maximum: 9007199254740991
        minimum: 0
      page_title:                                                                       YES
        description: The normalized title of the page.
        type: string
        minLength: 1
      redirect_page_link:                                                                       NO
        title: fragment/mediawiki/state/entity/page_link
        description: >
          If this page is currently a redirect, then this field contains
          information about the target page the redirect links to.
        $id: /fragment/mediawiki/state/entity/page_link/1.0.0
        $schema: 'https://json-schema.org/draft-07/schema#'
        type: object
        additionalProperties: false
        properties:
          interwiki_prefix:
            description: >
              The interwiki prefix (iw_prefix) of this link. The presence of
              this prefix implies a target outside the local wiki. See
              https://meta.wikimedia.org/wiki/Help:Interwiki_linking
            type: string
          is_redirect:
            description: True if the page is a redirect page at the time of this event.
            type: boolean
          namespace_id:
            description: The id of the namespace this page belongs to.
            type: integer
            maximum: 9007199254740991
            minimum: 0
          page_id:
            description: The (database) page ID of the page.
            type: integer
            maximum: 9007199254740991
            minimum: 0
          page_title:
            description: The normalized title of the page.
            type: string
            minLength: 1
        examples:
          - interwiki_prefix: dolor
            is_redirect: false
            namespace_id: 1351079888211148
            page_id: 1351079888211148
            page_title: dolor
      revision_count:                                                                       NO
        description: >
          The number of revisions of this page at the time of this event. During
          a delete, this number of revisions will be archived. This field is
          likely only set for page delete events, as getting this information on
          all events is expensive.
        type: integer
        maximum: 9007199254740991
        minimum: 0
    examples:
      - is_redirect: false
        namespace_id: 1351079888211148
        page_id: 1351079888211148
        page_title: dolor
  page_change_kind:                                                                       NO
    description: |
      The origin kind of the change to this page as viewed by MediaWiki.
    type: string
    enum:
      - create
      - undelete
      - edit
      - move
      - delete
      - visibility_change
  performer:                                                                       PARTIAL
    title: fragment/mediawiki/state/entity/user
    description: >
      Represents the MediaWiki actor that made this change. If this change is an
      edit, this will be the same as revision.editor.
    $id: /fragment/mediawiki/state/entity/user/1.0.0
    $schema: 'https://json-schema.org/draft-07/schema#'
    type: object
    additionalProperties: false
    properties:
      edit_count:                                                                       NO
        description: >
          The number of edits this user has made at the time of this event. Not
          present for anonymous users.
        type: integer
        maximum: 9007199254740991
        minimum: 0
      groups:                                                                       NO
        description: >
          A list of the groups this user belongs to.  E.g. bot, sysop etc. Not
          present for anonymous users.
        type: array
        items:
          type: string
          minLength: 1
      is_bot:                                                                       NO
        description: >
          True if this user is considered to be a bot at the time of this event.
          This is checked via the $user->isBot() method, which considers both
          user_groups and user permissions.
        type: boolean
      is_system:                                                                       NO
        description: >
          True if the user is a MediaWiki 'system' user. These are users that
          cannot 'authenticate'.  These are usually listed in ReservedUsernames.
        type: boolean
      is_temp:                                                                       NO
        description: >
          True if the user is an autocreated temporary MediaWiki user. This is
          used for IP masking.
        type: boolean
      registration_dt:                                                                       NO
        description: >
          The datetime of the user account registration. Not present for
          anonymous users or if missing in the MW database.
        type: string
        format: date-time
        maxLength: 128
      user_id:                                                                       YES
        description: >
          The user ID that performed this change.  This is optional, and will
          not be present for anonymous users.
        type: integer
        maximum: 9007199254740991
        minimum: 0
      user_text:                                                                       YES
        description: >
          The user name or text representation of the user that performed this
          change.
        type: string
        minLength: 1
    examples:
      - edit_count: 1351079888211148
        groups:
          - dolor
        is_bot: false
        is_system: false
        is_temp: false
        registration_dt: '2021-01-01T00:00:00.0Z'
        user_id: 1351079888211148
        user_text: dolor
  prior_state:                                                                       NO
    description: >
      Prior state of this page before this event. Fields are only present if
      their values have changed.
    type: object
    properties:
      page:
        title: fragment/mediawiki/state/entity/page
        description: Fields for MediaWiki page entity.
        $id: /fragment/mediawiki/state/entity/page/2.0.0
        $schema: 'https://json-schema.org/draft-07/schema#'
        type: object
        additionalProperties: false
        properties:
          is_redirect:
            description: True if the page is a redirect page at the time of this event.
            type: boolean
          namespace_id:
            description: The id of the namespace this page belongs to.
            type: integer
            maximum: 9007199254740991
            minimum: 0
          page_id:
            description: The (database) page ID of the page.
            type: integer
            maximum: 9007199254740991
            minimum: 0
          page_title:
            description: The normalized title of the page.
            type: string
            minLength: 1
          revision_count:
            description: >
              NOTE: prior_state.page.revision_count is unlikely to be set, as
              getting the # of revisions previous to this change is difficult.
              This field is present here for backwards compatibiliy.
            type: integer
            maximum: 9007199254740991
            minimum: 0
        examples:
          - is_redirect: false
            namespace_id: 1351079888211148
            page_id: 1351079888211148
            page_title: dolor
      revision:
        title: fragment/mediawiki/state/entity/revision
        description: Fields for MediaWiki revision entity.
        $id: /fragment/mediawiki/state/entity/revision/1.0.0
        $schema: 'https://json-schema.org/draft-07/schema#'
        type: object
        additionalProperties: false
        properties:
          comment:
            description: The comment left by the editor when this revision was made.
            type: string
          content_slots:
            title: fragment/mediawiki/state/entity/revision_slots
            description: >
              Map type representing MediaWiki's revision content slots. This map
              is keyed by the slot role name, e.g. 'main'.
            $id: /fragment/mediawiki/state/entity/revision_slots/1.0.0
            $schema: 'https://json-schema.org/draft-07/schema#'
            type: object
            additionalProperties:
              title: fragment/mediawiki/state/entity/content
              description: |
                Fields for representing MediaWiki page revision content.
              $id: /fragment/mediawiki/state/entity/content/1.0.0
              $schema: 'https://json-schema.org/draft-07/schema#'
              type: object
              additionalProperties: false
              properties:
                content_body:
                  description: >
                    Content body. NOTE: This field is not required, and is often
                    not set in streams as it can make events very large. It is
                    included here for events that do include the content body.
                  type: string
                content_format:
                  description: >-
                    The 'content type' of the content.  E.g. wikitext/html. This
                    is similiar to a MIME type.
                  type: string
                content_model:
                  description: >-
                    MediaWiki's content model of this content. E.g. wikitext,
                    json, etc.
                  type: string
                content_sha1:
                  description: sha1 sum of the content body.
                  type: string
                content_size:
                  description: Byte size of the content body.
                  type: integer
                  maximum: 9007199254740991
                  minimum: 0
                origin_rev_id:
                  description: Revision in which this slot was originally created
                  type: integer
                  maximum: 9007199254740991
                  minimum: 0
                slot_role:
                  description: Slot role name.
                  type: string
              examples:
                - content_body: dolor
                  content_format: dolor
                  content_model: dolor
                  content_sha1: dolor
                  content_size: 1351079888211148
                  origin_rev_id: 1351079888211148
            examples:
              - dolorb:
                  content_body: dolor
                  content_format: dolor
                  content_model: dolor
                  content_sha1: dolor
                  content_size: 1351079888211148
                  origin_rev_id: 1351079888211148
                  slot_role: dolor
          editor:
            title: fragment/mediawiki/state/entity/user
            description: Represents the MediaWiki user that made this edit.
            $id: /fragment/mediawiki/state/entity/user/1.0.0
            $schema: 'https://json-schema.org/draft-07/schema#'
            type: object
            additionalProperties: false
            properties:
              edit_count:
                description: >
                  The number of edits this user has made at the time of this
                  event. Not present for anonymous users.
                type: integer
                maximum: 9007199254740991
                minimum: 0
              groups:
                description: >
                  A list of the groups this user belongs to.  E.g. bot, sysop
                  etc. Not present for anonymous users.
                type: array
                items:
                  type: string
                  minLength: 1
              is_bot:
                description: >
                  True if this user is considered to be a bot at the time of
                  this event. This is checked via the $user->isBot() method,
                  which considers both user_groups and user permissions.
                type: boolean
              is_system:
                description: >
                  True if the user is a MediaWiki 'system' user. These are users
                  that cannot 'authenticate'.  These are usually listed in
                  ReservedUsernames.
                type: boolean
              is_temp:
                description: >
                  True if the user is an autocreated temporary MediaWiki user.
                  This is used for IP masking.
                type: boolean
              registration_dt:
                description: >
                  The datetime of the user account registration. Not present for
                  anonymous users or if missing in the MW database.
                type: string
                format: date-time
                maxLength: 128
              user_id:
                description: >
                  The user ID that performed this change.  This is optional, and
                  will not be present for anonymous users.
                type: integer
                maximum: 9007199254740991
                minimum: 0
              user_text:
                description: >
                  The user name or text representation of the user that
                  performed this change.
                type: string
                minLength: 1
            examples:
              - edit_count: 1351079888211148
                groups:
                  - dolor
                is_bot: false
                is_system: false
                is_temp: false
                registration_dt: '2021-01-01T00:00:00.0Z'
                user_id: 1351079888211148
                user_text: dolor
          is_comment_visible:
            description: >
              Whether the comment of the revision is visible. See
              RevisionRecord->DELETED_COMMENT.
            type: boolean
          is_content_visible:
            description: >
              Whether the revision's content body is visible. If this is false,
              then content should be redacted. See RevisionRecord->DELETED_TEXT
            type: boolean
          is_editor_visible:
            description: >
              Whether the revision's editor information is visible. Affects
              editor field. See RevisionRecord->DELETED_USER
            type: boolean
          is_minor_edit:
            description: True if the editor marked this revision as a minor edit.
            type: boolean
          rev_dt:
            description: >
              Time this revision was created. This is rev_timestamp in the
              MediaWiki database.
            type: string
            format: date-time
            maxLength: 128
          rev_id:
            description: The (database) revision ID.
            type: integer
            maximum: 9007199254740991
            minimum: 1
          rev_parent_id:
            description: This revision's parent rev_id.
            type: integer
            maximum: 9007199254740991
            minimum: 0
          rev_sha1:
            description: |
              sha1 sum considering all the content slots for this revision.
            type: string
          rev_size:
            description: >
              Byte size 'sum' of all the content slots for this revision. This
              'size' is approximate, but may not be exact, depending on the kind
              of data that is stored in the content slots.
            type: integer
            maximum: 9007199254740991
            minimum: 0
        examples:
          - comment: dolor
            editor:
              edit_count: 1351079888211148
              groups:
                - dolor
              is_bot: false
              is_system: false
              is_temp: false
              registration_dt: '2021-01-01T00:00:00.0Z'
              user_id: 1351079888211148
              user_text: dolor
            is_comment_visible: false
            is_content_visible: false
            is_editor_visible: false
            is_minor_edit: false
            rev_dt: '2021-01-01T00:00:00.0Z'
            rev_id: 1351079888211149
            rev_parent_id: 1351079888211148
            rev_sha1: dolor
            rev_size: 1351079888211148
  revision:                                                                       PARTIAL
    title: fragment/mediawiki/state/entity/revision
    description: Fields for MediaWiki revision entity.
    $id: /fragment/mediawiki/state/entity/revision/1.0.0
    $schema: 'https://json-schema.org/draft-07/schema#'
    type: object
    additionalProperties: false
    required:
      - rev_id
      - rev_dt
    properties:
      comment:                                                                       YES
        description: The comment left by the editor when this revision was made.
        type: string
      content_slots:                                                                       NO
        title: fragment/mediawiki/state/entity/revision_slots
        description: >
          Map type representing MediaWiki's revision content slots. This map is
          keyed by the slot role name, e.g. 'main'.
        $id: /fragment/mediawiki/state/entity/revision_slots/1.0.0
        $schema: 'https://json-schema.org/draft-07/schema#'
        type: object
        additionalProperties:
          title: fragment/mediawiki/state/entity/content
          description: |
            Fields for representing MediaWiki page revision content.
          $id: /fragment/mediawiki/state/entity/content/1.0.0
          $schema: 'https://json-schema.org/draft-07/schema#'
          type: object
          additionalProperties: false
          properties:
            content_body:
              description: >
                Content body. NOTE: This field is not required, and is often not
                set in streams as it can make events very large. It is included
                here for events that do include the content body.
              type: string
            content_format:
              description: >-
                The 'content type' of the content.  E.g. wikitext/html. This is
                similiar to a MIME type.
              type: string
            content_model:
              description: >-
                MediaWiki's content model of this content. E.g. wikitext, json,
                etc.
              type: string
            content_sha1:
              description: sha1 sum of the content body.
              type: string
            content_size:
              description: Byte size of the content body.
              type: integer
              maximum: 9007199254740991
              minimum: 0
            origin_rev_id:
              description: Revision in which this slot was originally created
              type: integer
              maximum: 9007199254740991
              minimum: 0
            slot_role:
              description: Slot role name.
              type: string
          examples:
            - content_body: dolor
              content_format: dolor
              content_model: dolor
              content_sha1: dolor
              content_size: 1351079888211148
              origin_rev_id: 1351079888211148
        examples:
          - dolorb:
              content_body: dolor
              content_format: dolor
              content_model: dolor
              content_sha1: dolor
              content_size: 1351079888211148
              origin_rev_id: 1351079888211148
              slot_role: dolor
      editor:                                                                       PARTIAL
        title: fragment/mediawiki/state/entity/user
        description: Represents the MediaWiki user that made this edit.
        $id: /fragment/mediawiki/state/entity/user/1.0.0
        $schema: 'https://json-schema.org/draft-07/schema#'
        type: object
        additionalProperties: false
        properties:
          edit_count:                                                                       NO
            description: >
              The number of edits this user has made at the time of this event.
              Not present for anonymous users.
            type: integer
            maximum: 9007199254740991
            minimum: 0
          groups:                                                                       NO
            description: >
              A list of the groups this user belongs to.  E.g. bot, sysop etc.
              Not present for anonymous users.
            type: array
            items:
              type: string
              minLength: 1
          is_bot:                                                                       NO
            description: >
              True if this user is considered to be a bot at the time of this
              event. This is checked via the $user->isBot() method, which
              considers both user_groups and user permissions.
            type: boolean
          is_system:                                                                       NO
            description: >
              True if the user is a MediaWiki 'system' user. These are users
              that cannot 'authenticate'.  These are usually listed in
              ReservedUsernames.
            type: boolean
          is_temp:                                                                       NO
            description: >
              True if the user is an autocreated temporary MediaWiki user. This
              is used for IP masking.
            type: boolean
          registration_dt:                                                                       NO
            description: >
              The datetime of the user account registration. Not present for
              anonymous users or if missing in the MW database.
            type: string
            format: date-time
            maxLength: 128
          user_id:                                                                       YES
            description: >
              The user ID that performed this change.  This is optional, and
              will not be present for anonymous users.
            type: integer
            maximum: 9007199254740991
            minimum: 0
          user_text:                                                                       YES
            description: >
              The user name or text representation of the user that performed
              this change.
            type: string
            minLength: 1
        examples:
          - edit_count: 1351079888211148
            groups:
              - dolor
            is_bot: false
            is_system: false
            is_temp: false
            registration_dt: '2021-01-01T00:00:00.0Z'
            user_id: 1351079888211148
            user_text: dolor
      is_comment_visible:                                                                       YES
        description: >
          Whether the comment of the revision is visible. See
          RevisionRecord->DELETED_COMMENT.
        type: boolean
      is_content_visible:                                                                       YES
        description: >
          Whether the revision's content body is visible. If this is false, then
          content should be redacted. See RevisionRecord->DELETED_TEXT
        type: boolean
      is_editor_visible:                                                                       YES
        description: >
          Whether the revision's editor information is visible. Affects editor
          field. See RevisionRecord->DELETED_USER
        type: boolean
      is_minor_edit:                                                                           YES
        description: True if the editor marked this revision as a minor edit.
        type: boolean
      rev_dt:                                                                                  YES
        description: >
          Time this revision was created. This is rev_timestamp in the MediaWiki
          database.
        type: string
        format: date-time
        maxLength: 128
      rev_id:                                                                                  YES
        description: The (database) revision ID.
        type: integer
        maximum: 9007199254740991
        minimum: 1
      rev_parent_id:                                                                       YES
        description: This revision's parent rev_id.
        type: integer
        maximum: 9007199254740991
        minimum: 0
      rev_sha1:                                                                             YES
        description: |
          sha1 sum considering all the content slots for this revision.
        type: string
      rev_size:                                                                           YES
        description: >
          Byte size 'sum' of all the content slots for this revision. This
          'size' is approximate, but may not be exact, depending on the kind of
          data that is stored in the content slots.
        type: integer
        maximum: 9007199254740991
        minimum: 0
    examples:
      - comment: dolor
        editor:
          edit_count: 1351079888211148
          groups:
            - dolor
          is_bot: false
          is_system: false
          is_temp: false
          registration_dt: '2021-01-01T00:00:00.0Z'
          user_id: 1351079888211148
          user_text: dolor
        is_comment_visible: false
        is_content_visible: false
        is_editor_visible: false
        is_minor_edit: false
        rev_dt: '2021-01-01T00:00:00.0Z'
        rev_id: 1351079888211149
        rev_parent_id: 1351079888211148
        rev_sha1: dolor
        rev_size: 1351079888211148
  wiki_id:                                                                              YES
    description: >
      The wiki ID, which is usually the same as the MediaWiki database name.
      E.g. enwiki, metawiki, etc.
    type: string
    minLength: 1
examples:
  - $schema: /mediawiki/page/change/1.2.0
    changelog_kind: update
    comment: changed a thing
    dt: '2021-01-01T00:00:00.0Z'
    meta:
      domain: examplewiki
      dt: '2021-01-01T00:00:00.0Z'
      stream: mediawiki.page_change
    page:
      is_redirect: true
      namespace_id: 1
      page_id: 1
      page_title: example
      redirect_page_link:
        is_redirect: false
        namespace_id: 1
        page_id: 2
        page_title: Redirect_Target
      revision_count: 1
    page_change_kind: edit
    performer:
      user_id: 123
      user_text: yoohoo
    revision:
      comment: changed a thing
      content_slots:
        main:
          content_format: text/x-wiki
          content_model: wikitext
          content_sha1: 16619839a55cfb5c61bcf520bf9734e0c67f98cc
          content_size: 100
          origin_rev_id: 2
          slot_role: main
      editor:
        user_id: 123
        user_text: example
      is_comment_visible: true
      is_content_visible: true
      is_editor_visible: true
      is_minor_edit: false
      rev_dt: '2021-01-01T00:00:00.0Z'
      rev_id: 2
      rev_parent_id: 1
      rev_sha1: 16619839a55cfb5c61bcf520bf9734e0c67f98cc
      rev_size: 100
    wiki_id: example
definitions:
  revision_count:
    description: >
      The number of revisions of this page at the time of this event. During a
      delete, this number of revisions will be archived. This field is likely
      only set for page delete events, as getting this information on all events
      is expensive.
    type: integer
    maximum: 9007199254740991
    minimum: 0

Example of existing /mediawiki/page/change/1.2.0:

- $schema: /mediawiki/page/change/1.2.0
  changelog_kind: update
  comment: changed a thing
  dt: '2021-01-01T00:00:00.0Z'
  meta:
    domain: examplewiki
    dt: '2021-01-01T00:00:00.0Z'
    stream: mediawiki.page_change
  page:
    is_redirect: true
    namespace_id: 1
    page_id: 1
    page_title: example
    redirect_page_link:
      is_redirect: false
      namespace_id: 1
      page_id: 2
      page_title: Redirect_Target
    revision_count: 1
  page_change_kind: edit
  performer:
    user_id: 123
    user_text: yoohoo
  revision:
    comment: changed a thing
    content_slots:
      main:
        content_format: text/x-wiki
        content_model: wikitext
        content_sha1: 16619839a55cfb5c61bcf520bf9734e0c67f98cc
        content_size: 100
        origin_rev_id: 2
        slot_role: main
    editor:
      user_id: 123
      user_text: example
    is_comment_visible: true
    is_content_visible: true
    is_editor_visible: true
    is_minor_edit: false
    rev_dt: '2021-01-01T00:00:00.0Z'
    rev_id: 2
    rev_parent_id: 1
    rev_sha1: 16619839a55cfb5c61bcf520bf9734e0c67f98cc
    rev_size: 100
  wiki_id: example

Example of what we could actually do for /mediawiki/page/late/1.0.0 :

- $schema: /mediawiki/page/late/1.0.0
  comment: changed a thing
  dt: '2021-01-01T00:00:00.0Z'
  meta:
    dt: '2021-01-01T00:00:00.0Z'
    stream: mediawiki.page_late
  page:
    is_redirect: true
    namespace_id: 1
    page_id: 1
    page_title: example
  performer:
    user_id: 123
    user_text: yoohoo
  revision:
    comment: changed a thing
    editor:
      user_id: 123
      user_text: example
    is_comment_visible: true
    is_content_visible: true
    is_editor_visible: true
    is_minor_edit: false
    rev_dt: '2021-01-01T00:00:00.0Z'
    rev_id: 2
    rev_parent_id: 1
    rev_sha1: 16619839a55cfb5c61bcf520bf9734e0c67f98cc
    rev_size: 100
  wiki_id: example

• lbowmaker moved this task from Code Review / Tech Input to Done on the Dumps 2.0 (Kanban Board) board.Jul 22 2024, 1:22 PM

xcollazo closed this task as Resolved.Aug 16 2024, 7:57 PM

xcollazo mentioned this in T374055: Spike: Figure out if we have everything we need in Spark to emit page_change_late events.Sep 4 2024, 7:58 PM

	F55413557: Screenshot from 2024-06-17 15-42-33.png
	Jun 17 2024, 7:43 PM

Spike: Can we recreate a skeleton page_change (revision_change) event from DB replica alone?Closed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Spike: Can we recreate a skeleton page_change (revision_change) event from DB replica alone?
Closed, ResolvedPublic
Actions

Related Objects
Search...