Page MenuHomePhabricator

Decommission EventLogging backend components by migrating to MEP
Closed, ResolvedPublic

Description

As discussed in T228175: [Metrics Platform] Event Platform Client Libraries, we believe we can migrate existent EventLogging extension produced streams to Modern Event Platform components. This will finally allow us to decommission the EventLogging backend pieces:

To support existent EventLogging events in eventgate-analytics, we need to do:

  • meta.wikimedia.org schemas ported to draft 7 JSONSchema in a git schema repo with common schema included via $ref.
  • stream config entry for each (active) EventLogging schema/stream.
  • Schema revision extension attributes changed to use the new semver schema version.
  • EL client side code adapted to produce full event (with capsule fields) and to POST to eventgate.
  • Resolve capsule userAgent type issues (This is a string in JSONSchema, and a struct in Hive)

Ideally, EventLogging will produce the full event including EventCapsule fields to eventgate-analytics-external, the same eventgate instance that new style schemas will use. The same Refine job we use for eventgate analytics events should be able to Refine the old EL style events. Not all fields from capsule will be set (e.g. seqId and recvFrom), but we can work with what we have on the client side. The main issue will be resolving the userAgent type discrepancy, as we will parse the user_agent during refinement.

We'll start by migrating a single high volume EventLogging stream to MEP: SearchSatisfaction - T249261: Vertical: Migrate SearchSatisfaction EventLogging event stream to Event Platform

Once T259163: Migrate legacy metawiki schemas to Event Platform is done, we should clean up all schemas on metawiki, either by deleting them or emptying out their content with {}.


Steps

Undeploy varnishkafka-eventlogging

  • Set ensure => 'absent' on varnishkafka::instance and nrpe::monitor_service in profile::cache::kafka::eventlogging.
  • Apply puppet on all varnish cache nodes and ensure varnishkafka-eventlogging is stopped and config files are removed.
  • Remove profile::cache::kafka::eventlogging - patch

Undeploy eventlogging-processor

  • Remove all relevant eventlogging backend code from operations/puppet

Delete the legacy backend eventlogging Kafka topics in Kafka jumbo-eqiad cluster:

  • To delete
eventlogging-client-side
eventlogging-valid-mixed
eventLogging-valid-mixed
eventlogging-virtualpageview

DO NOT delete any eventlogging_* topics. These are migrated eventlogging topics.

Update gobblin job eventlogging_legacy.pull

The eventlogging_legacy Gobblin job is still using wildcard topic names to figure out which Kafka topics to import. Now that all legacy streams are migrated, we should use EventStreamConfig to determine which streams to import.

The eventlogging_legacy_test.pull job (running only in the analytics-test-hadoop cluster) already does this.

Remove refine_eventlogging_analytics job

This is a Refine job dedicated for ingesting not-yet-migrated legacy EventLogging data. This is not to be confused with 'refine_eventlogging_legacy', which is used to ingest migrated legacy EventLogging data.

Now that we have finished the migration, we can delete the refine_eventlogging_analytics job.

Decommission eventlog1003

meta.wikimedia.org schemas

There is not a consistent practice for 'deleting' metawiki schemas. Often, the content is just zeroed out by editing the schema page and deleting the content. We should probably do this for ALL metawiki schemas.

Or, we could decide to just leave them as is. The system won't use these anymore, so it doesn't really matter from a technical perspective.

  • Decision: empty all metawiki schema pages to {}

Code here: https://gitlab.wikimedia.org/-/snippets/208

Remove decommissioned Kafka topics and Hive tables

  • Delete Kafka topics and Hive tables + HDFS data directories for non-migrated schemas listed in the To Decommission tab of the EventLogging Audit Spreadsheet.

Update wikitech and mediawiki documentation

  • mediawiki documentation is already up to date, and outdated pages are marked as such.

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
operations/puppetproduction+0 -2
operations/puppetproduction+1 -1
operations/alertsmaster+0 -91
operations/puppetproduction+11 -16
operations/puppetproduction+0 -13
operations/puppetproduction+2 -62
operations/puppetproduction+5 -44
analytics/refinerymaster+21 -7
operations/dnsmaster+0 -1
operations/puppetproduction+8 -2
operations/puppetproduction+0 -126
operations/puppetproduction+1 -130
operations/puppetproduction+9 -44
operations/puppetproduction+14 -5
operations/puppetproduction+13 -9
operations/puppetproduction+5 -7
operations/puppetproduction+14 -9
operations/puppetproduction+0 -1
operations/puppetproduction+16 -1
operations/puppetproduction+6 -0
operations/mediawiki-configmaster+0 -5
operations/mediawiki-configmaster+0 -1
mediawiki/extensions/TemplateWizardmaster+1 -1
operations/puppetproduction+107 -47
operations/mediawiki-configmaster+3 -0
schemas/event/secondarymaster+138 -0
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+8 -2
operations/mediawiki-configmaster+1 -2
operations/puppetproduction+2 -2
analytics/refinery/sourcemaster+81 -4
analytics/refinery/sourcemaster+280 -156
analytics/refinery/sourcemaster+273 -152
operations/mediawiki-configmaster+42 -2
mediawiki/extensions/EventLoggingmaster+1 -1
operations/mediawiki-configmaster+2 -2
operations/deployment-chartsmaster+9 -3
operations/mediawiki-configmaster+6 -1
operations/mediawiki-configmaster+13 -3
operations/mediawiki-configmaster+22 -0
mediawiki/extensions/WikimediaEventsmaster+2 -1
schemas/event/secondarymaster+327 -1 K
operations/puppetproduction+1 -77
operations/puppetproduction+129 -92
operations/puppetproduction+2 -73
operations/puppetproduction+99 -15
analytics/refinery/sourcemaster+6 -1
analytics/refinery/sourcemaster+559 -148
operations/mediawiki-configmaster+4 -1
operations/mediawiki-configmaster+10 -7
operations/deployment-chartsmaster+3 -3
schemas/event/secondarymaster+231 -173
eventgate-wikimediamaster+25 -3
mediawiki/extensions/EventLoggingmaster+142 -36
analytics/refinery/sourcemaster+187 -7
Show related patches Customize query in gerrit

Related Objects

StatusSubtypeAssignedTask
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
Resolved Gilles
Resolvedmforns
Resolvedovasileva
DeclinedOttomata
ResolvedOttomata
Resolvedmforns
Resolved Mholloway
ResolvedOttomata
DuplicateNone
DuplicateNone
DuplicateNone
DuplicateNone
Resolved Mholloway
DuplicateNone
ResolvedOttomata
ResolvedSBisson
ResolvedSBisson
ResolvedSBisson
Resolvedmforns
ResolvedOttomata
Resolvedmforns
ResolvedOttomata
ResolvedOttomata
DeclinedNone
DeclinedNone
Resolved bmansurov
ResolvedJAllemandou
Resolvedmforns
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
DuplicateNone
ResolvedOttomata
DeclinedMNeisler
ResolvedSBisson
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedOttomata
ResolvedJdrewniak
ResolvedOttomata
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
ResolvedPginer-WMF
Resolvedphuedx
ResolvedMMiller_WMF
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
OpenNone
ResolvedEtonkovidova
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
Resolvedphuedx
ResolvedNone
ResolvedOttomata
Resolvedphuedx
Resolvedphuedx
Resolvedmatmarex
DeclinedNone
ResolvedOttomata
Resolvedmforns
ResolvedOttomata
DeclinedOttomata
ResolvedOttomata
Resolved Sharvaniharan
Resolved Sharvaniharan
DeclinedOttomata
ResolvedOttomata
Resolvedovasileva
OpenNone
ResolvedRequestBTullis

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Mentioned in SAL (#wikimedia-operations) [2024-06-26T19:11:24Z] <ottomata> re-enabling varnishkafka-eventlogging and varnish /beacon/event handling on cache text nodes. /beacon/event/ redirects which breaks the MediaWikiPingback usage - T238230

Change #1070288 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] refine_eventlogging_analytics - only refine MediaWikiPingback data

https://gerrit.wikimedia.org/r/1070288

Change #1070288 merged by Ottomata:

[operations/puppet@production] refine_eventlogging_analytics - only refine MediaWikiPingback data

https://gerrit.wikimedia.org/r/1070288

Change #1105078 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] Disable varnish handling of /beacon/event to decommission eventlogging backend

https://gerrit.wikimedia.org/r/1105078

Mentioned in SAL (#wikimedia-operations) [2025-01-07T17:50:39Z] <ottomata> Disable varnish handling of /beacon/event to decommission eventlogging backend [puppet] - T238230 T353817

Change #1105078 merged by Ottomata:

[operations/puppet@production] Disable varnish handling of /beacon/event to decommission eventlogging backend

https://gerrit.wikimedia.org/r/1105078

Change #1109135 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] refine_eventlogging_analytics - ensure absent

https://gerrit.wikimedia.org/r/1109135

Change #1109135 merged by Ottomata:

[operations/puppet@production] refine_eventlogging_analytics - ensure absent

https://gerrit.wikimedia.org/r/1109135

Change #1109137 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] Remove absented refine_eventlogging_analytics job

https://gerrit.wikimedia.org/r/1109137

Change #1109137 merged by Ottomata:

[operations/puppet@production] Remove absented refine_eventlogging_analytics job

https://gerrit.wikimedia.org/r/1109137

Change #1109140 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] Remove profile::cache::kafka::eventlogging

https://gerrit.wikimedia.org/r/1109140

Change #1050017 abandoned by Ottomata:

[operations/puppet@production] Remove profile::cache::kafka::eventlogging

Reason:

Id70e853de742d89291fe8605c37b4745f42cc50c

https://gerrit.wikimedia.org/r/1050017

Change #1109140 merged by Ottomata:

[operations/puppet@production] Remove profile::cache::kafka::eventlogging

https://gerrit.wikimedia.org/r/1109140

Change #1109142 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] Ensure eventlogging processor backend is absent on eventlog1003

https://gerrit.wikimedia.org/r/1109142

Change #1109142 merged by Ottomata:

[operations/puppet@production] Ensure eventlogging processor backend is absent on eventlog1003

https://gerrit.wikimedia.org/r/1109142

I have stopped eventlogging-processor on eventlog1003 and removed relevant puppet code.

There is still eventlogging related stuff to remove in operations/puppet. Am keeping track of my completed steps in the task description.

Gotta run for the day!

Change #1109477 had a related patch set uploaded (by Ottomata; author: Ottomata):

[analytics/refinery@master] gobblin eventlogging_legacy - use EventStreamConfig to pull topics

https://gerrit.wikimedia.org/r/1109477

Change #1110775 had a related patch set uploaded (by Btullis; author: Btullis):

[operations/dns@master] Remove CNAME for eventlogging.eqiad.wmnet

https://gerrit.wikimedia.org/r/1110775

Change #1110775 merged by Btullis:

[operations/dns@master] Remove CNAME for eventlogging.eqiad.wmnet

https://gerrit.wikimedia.org/r/1110775

Change #1109477 merged by Ottomata:

[analytics/refinery@master] gobblin eventlogging_legacy - use EventStreamConfig to pull topics

https://gerrit.wikimedia.org/r/1109477

Mentioned in SAL (#wikimedia-analytics) [2025-01-13T14:40:26Z] <ottomata> deploying refinery to analytics test cluster, and then to an-launcher1002 for gobblin eventlogging_legacy - use EventStreamConfig to pull topics (1109477) as part of T238230 Decommission EventLogging backend components by migrating to MEP

After deploying gobblin eventlogging_legacy - use EventStreamConfig to pull topics (1109477), gobblin looking good! It only imports migrated and configured eventlogging legacy topics now, instead of all of them!

Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:49 UTC INFO  [main] org.wikimedia.gobblin.kafka.WikimediaKafkaSource  - Getting topic.include from EventStreamConfig at https://meta.wikimedia.org/w/api.php.
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.apache.kafka.clients.Metadata  - Cluster ID: XU3M9vwdQR2VUdeslyWHLg
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_SaveTiming
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TranslationRecommendationUIRequests
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_NavigationTiming
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_QuickSurveysResponses
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TemplateWizard
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_PaintTiming
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TranslationRecommendationAPIRequests
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_CentralNoticeBannerHistory
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_KaiOSAppFeedback
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_UniversalLanguageSelector
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_MediaWikiPingback
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TemplateDataApi
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_ReferencePreviewsPopups
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_VirtualPageView
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TwoColConflictConflict
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_KaiOSAppFirstRun
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_WikipediaPortal
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_WikibaseTermboxInteraction
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TemplateDataEditor
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_WikidataCompletionSearchClicks
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_WMDEBannerSizeIssue
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TranslationRecommendationUserAction
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_PrefUpdate
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_ReferencePreviewsBaseline
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_VisualEditorFeatureUse
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_NewcomerTask
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_LandingPageImpression
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_ServerSideAccountCreation
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_WMDEBannerEvents
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_WMDEBannerInteractions
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_QuickSurveyInitiation
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_CpuBenchmark
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_ContentTranslationAbuseFilter
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_HomepageVisit
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_Test
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_SpecialInvestigate
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_CodeMirrorUsage
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_TwoColConflictExit
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_HelpPanel
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_VisualEditorTemplateDialogUse
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_InukaPageView
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_SearchSatisfaction
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_CentralNoticeImpression
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_ReferencePreviewsCite
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_HomepageModule
Jan 13 14:49:56 an-launcher1002 kerberos-run-command[1241195]: 2025-01-13 14:48:50 UTC INFO  [main] org.wikimedia.gobblin.copy.KafkaSource  - Discovered topic eventlogging_EditAttemptStep

Change #1110787 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] Remove some unused eventlogging references

https://gerrit.wikimedia.org/r/1110787

Change #1110807 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] logstash - remove legacy eventlogging related input and filters

https://gerrit.wikimedia.org/r/1110807

Change #1110787 merged by Ottomata:

[operations/puppet@production] Remove some unused eventlogging references

https://gerrit.wikimedia.org/r/1110787

Change #1110807 merged by Cwhite:

[operations/puppet@production] logstash - remove legacy eventlogging related input and filters

https://gerrit.wikimedia.org/r/1110807

Change #1110844 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] logstash - remove absented input

https://gerrit.wikimedia.org/r/1110844

Change #1110845 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] admin - ensure unused eventlogging groups are absent

https://gerrit.wikimedia.org/r/1110845

Change #1110844 merged by Cwhite:

[operations/puppet@production] logstash - remove absented input

https://gerrit.wikimedia.org/r/1110844

Change #1110845 merged by Ottomata:

[operations/puppet@production] admin - remove and deprecate unused eventlogging groups

https://gerrit.wikimedia.org/r/1110845

Change #1111239 had a related patch set uploaded (by Ottomata; author: Ottomata):

[operations/puppet@production] configcluster.yaml - remove eventlogging from profile::etcd::tlsproxy::acls

https://gerrit.wikimedia.org/r/1111239

Ottomata updated the task description. (Show Details)

Moved all EventLogging/ and subpages under Analytics/Archive

← Data Platform/Systems/EventLogging
"Data Platform/Systems/EventLogging" has been moved to "Analytics/Archive/EventLogging"

A redirect has been created.

The page Data Platform/Systems/EventLogging/Administration has been moved to Analytics/Archive/EventLogging/Administration.
The page Data Platform/Systems/EventLogging/Architecture has been moved to Analytics/Archive/EventLogging/Architecture.
The page Data Platform/Systems/EventLogging/Backfilling has been moved to Analytics/Archive/EventLogging/Backfilling.
The page Data Platform/Systems/EventLogging/Data representations has been moved to Analytics/Archive/EventLogging/Data representations.
The page Data Platform/Systems/EventLogging/Data retention has been moved to Analytics/Archive/EventLogging/Data retention.
The page Data Platform/Systems/EventLogging/Data retention/AppInstallId has been moved to Analytics/Archive/EventLogging/Data retention/AppInstallId.
The page Data Platform/Systems/EventLogging/Data retention and auto-purging has been moved to Analytics/Archive/EventLogging/Data retention and auto-purging.
The page Data Platform/Systems/EventLogging/Data retention and auto-purging/AppInstallId has been moved to Analytics/Archive/EventLogging/Data retention and auto-purging/AppInstallId.
The page Data Platform/Systems/EventLogging/EventCapsule has been moved to Analytics/Archive/EventLogging/EventCapsule.
The page Data Platform/Systems/EventLogging/How to has been moved to Analytics/Archive/EventLogging/How to.
The page Data Platform/Systems/EventLogging/Monitoring has been moved to Analytics/Archive/EventLogging/Monitoring.
The page Data Platform/Systems/EventLogging/New pipeline has been moved to Analytics/Archive/EventLogging/New pipeline.
The page Data Platform/Systems/EventLogging/NotErrorLogging has been moved to Analytics/Archive/EventLogging/NotErrorLogging.
The page Data Platform/Systems/EventLogging/Oncall has been moved to Analytics/Archive/EventLogging/Oncall.
The page Data Platform/Systems/EventLogging/Outages has been moved to Analytics/Archive/EventLogging/Outages.
The page Data Platform/Systems/EventLogging/Performance has been moved to Analytics/Archive/EventLogging/Performance.
The page Data Platform/Systems/EventLogging/Publishing has been moved to Analytics/Archive/EventLogging/Publishing.
The page Data Platform/Systems/EventLogging/Sanitization vs Aggregation has been moved to Analytics/Archive/EventLogging/Sanitization vs Aggregation.
The page Data Platform/Systems/EventLogging/Schema Guidelines has been moved to Analytics/Archive/EventLogging/Schema Guidelines.
The page Data Platform/Systems/EventLogging/Sensitive Fields has been moved to Analytics/Archive/EventLogging/Sensitive Fields.
The page Data Platform/Systems/EventLogging/TestingOnBetaCluster has been moved to Analytics/Archive/EventLogging/TestingOnBetaCluster.
The page Data Platform/Systems/EventLogging/TestingOnBetaLabs has been moved to Analytics/Archive/EventLogging/TestingOnBetaLabs.
The page Data Platform/Systems/EventLogging/User agent sanitization has been moved to Analytics/Archive/EventLogging/User agent sanitization.
The page Talk:Data Platform/Systems/EventLogging has been moved to Talk:Analytics/Archive/EventLogging.
The page Talk:Data Platform/Systems/EventLogging/Administration has been moved to Talk:Analytics/Archive/EventLogging/Administration.
The page Talk:Data Platform/Systems/EventLogging/Data retention has been moved to Talk:Analytics/Archive/EventLogging/Data retention.
The page Talk:Data Platform/Systems/EventLogging/Data retention and auto-purging has been moved to Talk:Analytics/Archive/EventLogging/Data retention and auto-purging.
The page Talk:Data Platform/Systems/EventLogging/Sanitization vs Aggregation has been moved to Talk:Analytics/Archive/EventLogging/Sanitization vs Aggregation.
Ottomata updated the task description. (Show Details)

Deleted eventlogging backend topics from kafka jumbo-eqiad:

kafka topics --delete --topic eventlogging-virtualpageview
kafka topics --delete --topic eventlogging-valid-mixed
kafka topics --delete --topic eventLogging-valid-mixed
kafka topics --delete --topic eventlogging-client-side
Ottomata updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-analytics) [2025-01-14T15:36:59Z] <ottomata> deleteing decomissioned eventlogging_ topics from kafka jumbo - T238230

Deleting decommissioned eventlogging_ kafka topics from Kafka jumbo-eqiad

kafka topics --delete --topic 'eventlogging_(AutoblockIpBlock|CookieBlock|EditorJourney|ExternalLinksChange|AdvancedSearchRequest|AnonymousUserSiteUsage|APIRequest|ArticleCreationHelp|ArticleCreationWorkflow|AutocompleteSatisfaction|AutomatedRequest|BandwidthStats|BDavisTest|BlankSchema|Campaigns obsolete|CentralAuth|ChangesListClickTracking|ChangesListFilters|ClickTiming|CommandInvocation|CommonsCategoryTreeUse|CommunityPortal|CompletionSuggestions|CreateAccountPrompt|Deployment|DeprecatedUsage|DiacriticsPoll|DiacriticsVisibility|DidYouMean|EchoPageViewsUntilSeen|EchoPrefUpdate|EditConflict|EditDebugging|EditLifecycle|EditorActivation|EditPageTracking|EUCCStats|EUCCVisit|EventLoggerTest|EventloggingError|EventLoggingPEF|EventLoggingWorkshop|EventQueryMeta|EventTiming|ExtDistDownloads|ExternalGuidance|Flow|FlowMenu|FlowReplies|FlowSorting|FullTextSearchBackendZeroResults|FundraisingBannerPaymentMethod|GatherClicks|GatherFlags|GeoFeatures|GettingStarted|GettingStartedNavbar|GettingStartedNewLandingPage|GettingStartedNoSuggestedArticle|GettingStartedOnRedirect|GettingStartedRedirectImpression|GuidedTour|GuidedTourButtonClick|GuidedTourExited|GuidedTourExternalLinkActivation|GuidedTourGuiderHidden|GuidedTourGuiderImpression|GuidedTourInternalLinkActivation|Hovercards|HttpsSupport|HumanSearchRelevance|ImageMetricsCorsSupport|ImageMetricsLoadingTime|InputDeviceDynamics|JQMigrateUsage|Kartographer|KirstenTest|LayoutGlitchDetected|LayoutJank|LinkInteractionTiming|LoginUserAgent|MediaViewer|MediaWikiException|MediaWikiInstallPingback|MediaWikiVagrantUsage|MobileACUX|MobileBehaviouralDifferences|MobileBetaWatchlist|MobileLeftNavbarEditCTA|MobileOptionsTracking|MobileWatchlistInteraction|MobileWebDiff|MobileWebSearch|MobileWikiAppABTest|MobileWikiAppAppearanceSettings|MobileWikiAppArticleSuggestions|MobileWikiAppCreateAccount|MobileWikiAppDailyStats|MobileWikiAppEdit|MobileWikiAppFeed|MobileWikiAppFeedConfigure|MobileWikiAppFindInPage|MobileWikiAppInstallReferrer|MobileWikiAppIntents|MobileWikiAppiOSEditHistoryCompare|MobileWikiAppiOSEditHistoryFeature|MobileWikiAppiOSFeed|MobileWikiAppiOSLoginAction|MobileWikiAppiOSReadingLists|MobileWikiAppiOSSearch|MobileWikiAppiOSSessions|MobileWikiAppiOSSettingAction|MobileWikiAppiOSUserHistory|MobileWikiAppLangSelect|MobileWikiAppLanguageSearching|MobileWikiAppLanguageSettings|MobileWikiAppLinkPreview|MobileWikiAppLogin|MobileWikiAppMediaGallery|MobileWikiAppNavMenu|MobileWikiAppNotificationInteraction|MobileWikiAppNotificationPreferences|MobileWikiAppOnboarding|MobileWikiAppOnThisDay|MobileWikiAppPageScroll|MobileWikiAppProtectedEditAttempt|MobileWikiAppRandomizer|MobileWikiAppReadingLists|MobileWikiAppSavedPages|MobileWikiAppSearch|MobileWikiAppSessions|MobileWikiAppShareAFact|MobileWikiAppSuggestedEdits|MobileWikiAppTabs|MobileWikiAppToCInteraction|MobileWikiAppUserContribution|MobileWikiAppWidgets|MobileWikiAppWiktionaryPopup|ModuleLoadFailure|ModuleStorage|MultimediaTiming|NewEditorEdit|Onboarding|OpenTask|PageContentSaveComplete|PageCreation|PageDeletion|PageMove|PageRestoration|PageRestore|PageSaveTiming|PersonalBar|PlanOutExperimentExposure|Popups|Print|Proofread Page|PseudoPageView|Sandbox|SavePageAttempt|SavePageAttempts|Schema|SearchSatisfactionErrors|SendBeaconReliability|ServerSideEventMeta|ServerSideGettingStarted|ServerTiming|SignupExpAccountCreationComplete|SignupExpAccountCreationImpression|SignupExpCTAButtonClick|SignupExpCTAImpression|SignupExpPageLinkClick|SimpleBanner|StatsD|TestEventDuplication|TestSchema|TimEventLoggingDemo|ToolsJobManipulation|ToolsJobSubmission|TrackedPageContentSaveComplete|UserFeedback|ValidationError|ViewportMetrics|WatchlistUsage|WebClientError|AccountCreation|Analytics|BookManagerv2|BrowserWindowSize|ChangesListFilterGrouping|ChangesListHighlights|CirrusTiming|CitationUsage|CitationUsagePageLoad|ClientSideError|ContentTranslation|ContentTranslation-interlanguage-entrypoint|ContentTranslationCTA|ContentTranslationError|ContentTranslationSuggestion|CXActivity|Echo|Edit|EventCapsule|EventError|ExtenalLinksChange|FishRetention|GenderSurvey|MachineAidedDepictsUsage|MediaViewerPerf|MobileAppCategorizationAttempts|MobileAppLoginAttempts|MobileAppShareAttempts|MobileAppTrackingChange|MobileAppUploadAttempts|MobileWebBrowse|MobileWebCentralAuthError|MobileWebClickTracking|MobileWebCta|MobileWebDiffClickTracking|MobileWebEditing|MobileWebInfobox|MobileWebLanguageSwitcher|MobileWebMainMenuClickTracking|MobileWebSectionUsage|MobileWebShareButton|MobileWebUIClickTracking|MobileWebUploads|MobileWebWatching|MobileWebWatchlistClickTracking|MobileWebWikiGrok|MobileWebWikiGrokBinary|MobileWebWikiGrokError|MobileWebWikiGrokResponse|MobileWikiAppBannerClickThrough|MobileWikiAppOfflineLibrary|MobileWikiAppOperatorCode|MobileWikiAppRLSRegistration|MobileWikiAppShareAFactOnboarding|MobileWikiAppStuffHappens|MultimediaViewerAttribution|MultimediaViewerDimensions|MultimediaViewerDuration|MultimediaViewerNetworkPerformance|MultimediaViewerVariant|MultimediaViewerVersusPageFilePerformance|PageIssues|PageLinkInteraction|ReadingDepth|RecentChangesTopLinks|RelatedArticles|Search|TaskRecommendation|TaskRecommendationClick|TaskRecommendationImpression|TaskRecommendationLightbulbClick|TestSearchSatisfaction|TestSearchSatisfaction2|TestSearchSatisfaction3|TimingData|TranslationRecommendationFlagging|ULS|UniversalLanguageSelector-tofu|UploadWizardDeedFlowEvent|UploadWizardErrorFlowEvent|UploadWizardExceptionFlowEvent|UploadWizardFlowEvent|UploadWizardFlowEventUpload|UploadWizardStep|UploadWizardTutorialActions|UploadWizardUploadActions|UploadWizardUploadFlowEvent|VET135171|VisualEditorActivation|VisualEditorBehaviorSaveDialogToClose|VisualEditorBehaviorSaveDialogToReview|VisualEditorBehaviorSaveDialogToSave|VisualEditorBehaviorTransactionToSaveDialog|VisualEditorDOMDiffed|VisualEditorDOMPreviewed|VisualEditorDOMRetrieved|VisualEditorDOMSaved|VisualEditorDOMSerialized|VisualEditorReviewComplete|VisualEditorReviewError|VisualEditorSaveComplete|VisualEditorSaveError|WikimediaBlogVisit|WikipediaZeroUsage)'

Mentioned in SAL (#wikimedia-analytics) [2025-01-14T15:47:53Z] <ottomata> drop decommed eventlogging hive tables - T238230

DROP TABLE IF EXISTS event.AutoblockIpBlock;
DROP TABLE IF EXISTS event.CookieBlock;
DROP TABLE IF EXISTS event.EditorJourney;
DROP TABLE IF EXISTS event.ExternalLinksChange;
DROP TABLE IF EXISTS event.AdvancedSearchRequest;
DROP TABLE IF EXISTS event.AnonymousUserSiteUsage;
DROP TABLE IF EXISTS event.APIRequest;
DROP TABLE IF EXISTS event.ArticleCreationHelp;
DROP TABLE IF EXISTS event.ArticleCreationWorkflow;
DROP TABLE IF EXISTS event.AutocompleteSatisfaction;
DROP TABLE IF EXISTS event.AutomatedRequest;
DROP TABLE IF EXISTS event.BandwidthStats;
DROP TABLE IF EXISTS event.BDavisTest;
DROP TABLE IF EXISTS event.BlankSchema;
DROP TABLE IF EXISTS event.Campaigns;
DROP TABLE IF EXISTS event.CentralAuth;
DROP TABLE IF EXISTS event.ChangesListClickTracking;
DROP TABLE IF EXISTS event.ChangesListFilters;
DROP TABLE IF EXISTS event.ClickTiming;
DROP TABLE IF EXISTS event.CommandInvocation;
DROP TABLE IF EXISTS event.CommonsCategoryTreeUse;
DROP TABLE IF EXISTS event.CommunityPortal;
DROP TABLE IF EXISTS event.CompletionSuggestions;
DROP TABLE IF EXISTS event.CreateAccountPrompt;
DROP TABLE IF EXISTS event.Deployment;
DROP TABLE IF EXISTS event.DeprecatedUsage;
DROP TABLE IF EXISTS event.DiacriticsPoll;
DROP TABLE IF EXISTS event.DiacriticsVisibility;
DROP TABLE IF EXISTS event.DidYouMean;
DROP TABLE IF EXISTS event.EchoPageViewsUntilSeen;
DROP TABLE IF EXISTS event.EchoPrefUpdate;
DROP TABLE IF EXISTS event.EditConflict;
DROP TABLE IF EXISTS event.EditDebugging;
DROP TABLE IF EXISTS event.EditLifecycle;
DROP TABLE IF EXISTS event.EditorActivation;
DROP TABLE IF EXISTS event.EditPageTracking;
DROP TABLE IF EXISTS event.EUCCStats;
DROP TABLE IF EXISTS event.EUCCVisit;
DROP TABLE IF EXISTS event.EventLoggerTest;
DROP TABLE IF EXISTS event.EventloggingError;
DROP TABLE IF EXISTS event.EventLoggingPEF;
DROP TABLE IF EXISTS event.EventLoggingWorkshop;
DROP TABLE IF EXISTS event.EventQueryMeta;
DROP TABLE IF EXISTS event.EventTiming;
DROP TABLE IF EXISTS event.ExtDistDownloads;
DROP TABLE IF EXISTS event.ExternalGuidance;
DROP TABLE IF EXISTS event.Flow;
DROP TABLE IF EXISTS event.FlowMenu;
DROP TABLE IF EXISTS event.FlowReplies;
DROP TABLE IF EXISTS event.FlowSorting;
DROP TABLE IF EXISTS event.FullTextSearchBackendZeroResults;
DROP TABLE IF EXISTS event.FundraisingBannerPaymentMethod;
DROP TABLE IF EXISTS event.GatherClicks;
DROP TABLE IF EXISTS event.GatherFlags;
DROP TABLE IF EXISTS event.GeoFeatures;
DROP TABLE IF EXISTS event.GettingStarted;
DROP TABLE IF EXISTS event.GettingStartedNavbar;
DROP TABLE IF EXISTS event.GettingStartedNewLandingPage;
DROP TABLE IF EXISTS event.GettingStartedNoSuggestedArticle;
DROP TABLE IF EXISTS event.GettingStartedOnRedirect;
DROP TABLE IF EXISTS event.GettingStartedRedirectImpression;
DROP TABLE IF EXISTS event.GuidedTour;
DROP TABLE IF EXISTS event.GuidedTourButtonClick;
DROP TABLE IF EXISTS event.GuidedTourExited;
DROP TABLE IF EXISTS event.GuidedTourExternalLinkActivation;
DROP TABLE IF EXISTS event.GuidedTourGuiderHidden;
DROP TABLE IF EXISTS event.GuidedTourGuiderImpression;
DROP TABLE IF EXISTS event.GuidedTourInternalLinkActivation;
DROP TABLE IF EXISTS event.Hovercards;
DROP TABLE IF EXISTS event.HttpsSupport;
DROP TABLE IF EXISTS event.HumanSearchRelevance;
DROP TABLE IF EXISTS event.ImageMetricsCorsSupport;
DROP TABLE IF EXISTS event.ImageMetricsLoadingTime;
DROP TABLE IF EXISTS event.InputDeviceDynamics;
DROP TABLE IF EXISTS event.JQMigrateUsage;
DROP TABLE IF EXISTS event.Kartographer;
DROP TABLE IF EXISTS event.KirstenTest;
DROP TABLE IF EXISTS event.LayoutGlitchDetected;
DROP TABLE IF EXISTS event.LayoutJank;
DROP TABLE IF EXISTS event.LinkInteractionTiming;
DROP TABLE IF EXISTS event.LoginUserAgent;
DROP TABLE IF EXISTS event.MediaViewer;
DROP TABLE IF EXISTS event.MediaWikiException;
DROP TABLE IF EXISTS event.MediaWikiInstallPingback;
DROP TABLE IF EXISTS event.MediaWikiVagrantUsage;
DROP TABLE IF EXISTS event.MobileACUX;
DROP TABLE IF EXISTS event.MobileBehaviouralDifferences;
DROP TABLE IF EXISTS event.MobileBetaWatchlist;
DROP TABLE IF EXISTS event.MobileLeftNavbarEditCTA;
DROP TABLE IF EXISTS event.MobileOptionsTracking;
DROP TABLE IF EXISTS event.MobileWatchlistInteraction;
DROP TABLE IF EXISTS event.MobileWebDiff;
DROP TABLE IF EXISTS event.MobileWebSearch;
DROP TABLE IF EXISTS event.MobileWikiAppABTest;
DROP TABLE IF EXISTS event.MobileWikiAppAppearanceSettings;
DROP TABLE IF EXISTS event.MobileWikiAppArticleSuggestions;
DROP TABLE IF EXISTS event.MobileWikiAppCreateAccount;
DROP TABLE IF EXISTS event.MobileWikiAppDailyStats;
DROP TABLE IF EXISTS event.MobileWikiAppEdit;
DROP TABLE IF EXISTS event.MobileWikiAppFeed;
DROP TABLE IF EXISTS event.MobileWikiAppFeedConfigure;
DROP TABLE IF EXISTS event.MobileWikiAppFindInPage;
DROP TABLE IF EXISTS event.MobileWikiAppInstallReferrer;
DROP TABLE IF EXISTS event.MobileWikiAppIntents;
DROP TABLE IF EXISTS event.MobileWikiAppiOSEditHistoryCompare;
DROP TABLE IF EXISTS event.MobileWikiAppiOSEditHistoryFeature;
DROP TABLE IF EXISTS event.MobileWikiAppiOSFeed;
DROP TABLE IF EXISTS event.MobileWikiAppiOSLoginAction;
DROP TABLE IF EXISTS event.MobileWikiAppiOSReadingLists;
DROP TABLE IF EXISTS event.MobileWikiAppiOSSearch;
DROP TABLE IF EXISTS event.MobileWikiAppiOSSessions;
DROP TABLE IF EXISTS event.MobileWikiAppiOSSettingAction;
DROP TABLE IF EXISTS event.MobileWikiAppiOSUserHistory;
DROP TABLE IF EXISTS event.MobileWikiAppLangSelect;
DROP TABLE IF EXISTS event.MobileWikiAppLanguageSearching;
DROP TABLE IF EXISTS event.MobileWikiAppLanguageSettings;
DROP TABLE IF EXISTS event.MobileWikiAppLinkPreview;
DROP TABLE IF EXISTS event.MobileWikiAppLogin;
DROP TABLE IF EXISTS event.MobileWikiAppMediaGallery;
DROP TABLE IF EXISTS event.MobileWikiAppNavMenu;
DROP TABLE IF EXISTS event.MobileWikiAppNotificationInteraction;
DROP TABLE IF EXISTS event.MobileWikiAppNotificationPreferences;
DROP TABLE IF EXISTS event.MobileWikiAppOnboarding;
DROP TABLE IF EXISTS event.MobileWikiAppOnThisDay;
DROP TABLE IF EXISTS event.MobileWikiAppPageScroll;
DROP TABLE IF EXISTS event.MobileWikiAppProtectedEditAttempt;
DROP TABLE IF EXISTS event.MobileWikiAppRandomizer;
DROP TABLE IF EXISTS event.MobileWikiAppReadingLists;
DROP TABLE IF EXISTS event.MobileWikiAppSavedPages;
DROP TABLE IF EXISTS event.MobileWikiAppSearch;
DROP TABLE IF EXISTS event.MobileWikiAppSessions;
DROP TABLE IF EXISTS event.MobileWikiAppShareAFact;
DROP TABLE IF EXISTS event.MobileWikiAppSuggestedEdits;
DROP TABLE IF EXISTS event.MobileWikiAppTabs;
DROP TABLE IF EXISTS event.MobileWikiAppToCInteraction;
DROP TABLE IF EXISTS event.MobileWikiAppUserContribution;
DROP TABLE IF EXISTS event.MobileWikiAppWidgets;
DROP TABLE IF EXISTS event.MobileWikiAppWiktionaryPopup;
DROP TABLE IF EXISTS event.ModuleLoadFailure;
DROP TABLE IF EXISTS event.ModuleStorage;
DROP TABLE IF EXISTS event.MultimediaTiming;
DROP TABLE IF EXISTS event.NewEditorEdit;
DROP TABLE IF EXISTS event.Onboarding;
DROP TABLE IF EXISTS event.OpenTask;
DROP TABLE IF EXISTS event.PageContentSaveComplete;
DROP TABLE IF EXISTS event.PageCreation;
DROP TABLE IF EXISTS event.PageDeletion;
DROP TABLE IF EXISTS event.PageMove;
DROP TABLE IF EXISTS event.PageRestoration;
DROP TABLE IF EXISTS event.PageRestore;
DROP TABLE IF EXISTS event.PageSaveTiming;
DROP TABLE IF EXISTS event.PersonalBar;
DROP TABLE IF EXISTS event.PlanOutExperimentExposure;
DROP TABLE IF EXISTS event.Popups;
DROP TABLE IF EXISTS event.Print;
DROP TABLE IF EXISTS event.Proofread;
DROP TABLE IF EXISTS event.PseudoPageView;
DROP TABLE IF EXISTS event.Sandbox;
DROP TABLE IF EXISTS event.SavePageAttempt;
DROP TABLE IF EXISTS event.SavePageAttempts;
DROP TABLE IF EXISTS event.Schema;
DROP TABLE IF EXISTS event.SearchSatisfactionErrors;
DROP TABLE IF EXISTS event.SendBeaconReliability;
DROP TABLE IF EXISTS event.ServerSideEventMeta;
DROP TABLE IF EXISTS event.ServerSideGettingStarted;
DROP TABLE IF EXISTS event.ServerTiming;
DROP TABLE IF EXISTS event.SignupExpAccountCreationComplete;
DROP TABLE IF EXISTS event.SignupExpAccountCreationImpression;
DROP TABLE IF EXISTS event.SignupExpCTAButtonClick;
DROP TABLE IF EXISTS event.SignupExpCTAImpression;
DROP TABLE IF EXISTS event.SignupExpPageLinkClick;
DROP TABLE IF EXISTS event.SimpleBanner;
DROP TABLE IF EXISTS event.StatsD;
DROP TABLE IF EXISTS event.TestEventDuplication;
DROP TABLE IF EXISTS event.TestSchema;
DROP TABLE IF EXISTS event.TimEventLoggingDemo;
DROP TABLE IF EXISTS event.ToolsJobManipulation;
DROP TABLE IF EXISTS event.ToolsJobSubmission;
DROP TABLE IF EXISTS event.TrackedPageContentSaveComplete;
DROP TABLE IF EXISTS event.UserFeedback;
DROP TABLE IF EXISTS event.ValidationError;
DROP TABLE IF EXISTS event.ViewportMetrics;
DROP TABLE IF EXISTS event.WatchlistUsage;
DROP TABLE IF EXISTS event.WebClientError;
DROP TABLE IF EXISTS event.AccountCreation;
DROP TABLE IF EXISTS event.Analytics;
DROP TABLE IF EXISTS event.BookManagerv2;
DROP TABLE IF EXISTS event.BrowserWindowSize;
DROP TABLE IF EXISTS event.ChangesListFilterGrouping;
DROP TABLE IF EXISTS event.ChangesListHighlights;
DROP TABLE IF EXISTS event.CirrusTiming;
DROP TABLE IF EXISTS event.CitationUsage;
DROP TABLE IF EXISTS event.CitationUsagePageLoad;
DROP TABLE IF EXISTS event.ClientSideError;
DROP TABLE IF EXISTS event.ContentTranslation;
DROP TABLE IF EXISTS event.ContentTranslation_interlanguage_entrypoint;
DROP TABLE IF EXISTS event.ContentTranslationCTA;
DROP TABLE IF EXISTS event.ContentTranslationError;
DROP TABLE IF EXISTS event.ContentTranslationSuggestion;
DROP TABLE IF EXISTS event.CXActivity;
DROP TABLE IF EXISTS event.Echo;
DROP TABLE IF EXISTS event.Edit;
DROP TABLE IF EXISTS event.EventCapsule;
DROP TABLE IF EXISTS event.EventError;
DROP TABLE IF EXISTS event.ExtenalLinksChange;
DROP TABLE IF EXISTS event.FishRetention;
DROP TABLE IF EXISTS event.GenderSurvey;
DROP TABLE IF EXISTS event.MachineAidedDepictsUsage;
DROP TABLE IF EXISTS event.MediaViewerPerf;
DROP TABLE IF EXISTS event.MobileAppCategorizationAttempts;
DROP TABLE IF EXISTS event.MobileAppLoginAttempts;
DROP TABLE IF EXISTS event.MobileAppShareAttempts;
DROP TABLE IF EXISTS event.MobileAppTrackingChange;
DROP TABLE IF EXISTS event.MobileAppUploadAttempts;
DROP TABLE IF EXISTS event.MobileWebBrowse;
DROP TABLE IF EXISTS event.MobileWebCentralAuthError;
DROP TABLE IF EXISTS event.MobileWebClickTracking;
DROP TABLE IF EXISTS event.MobileWebCta;
DROP TABLE IF EXISTS event.MobileWebDiffClickTracking;
DROP TABLE IF EXISTS event.MobileWebEditing;
DROP TABLE IF EXISTS event.MobileWebInfobox;
DROP TABLE IF EXISTS event.MobileWebLanguageSwitcher;
DROP TABLE IF EXISTS event.MobileWebMainMenuClickTracking;
DROP TABLE IF EXISTS event.MobileWebSectionUsage;
DROP TABLE IF EXISTS event.MobileWebShareButton;
DROP TABLE IF EXISTS event.MobileWebUIClickTracking;
DROP TABLE IF EXISTS event.MobileWebUploads;
DROP TABLE IF EXISTS event.MobileWebWatching;
DROP TABLE IF EXISTS event.MobileWebWatchlistClickTracking;
DROP TABLE IF EXISTS event.MobileWebWikiGrok;
DROP TABLE IF EXISTS event.MobileWebWikiGrokBinary;
DROP TABLE IF EXISTS event.MobileWebWikiGrokError;
DROP TABLE IF EXISTS event.MobileWebWikiGrokResponse;
DROP TABLE IF EXISTS event.MobileWikiAppBannerClickThrough;
DROP TABLE IF EXISTS event.MobileWikiAppOfflineLibrary;
DROP TABLE IF EXISTS event.MobileWikiAppOperatorCode;
DROP TABLE IF EXISTS event.MobileWikiAppRLSRegistration;
DROP TABLE IF EXISTS event.MobileWikiAppShareAFactOnboarding;
DROP TABLE IF EXISTS event.MobileWikiAppStuffHappens;
DROP TABLE IF EXISTS event.MultimediaViewerAttribution;
DROP TABLE IF EXISTS event.MultimediaViewerDimensions;
DROP TABLE IF EXISTS event.MultimediaViewerDuration;
DROP TABLE IF EXISTS event.MultimediaViewerNetworkPerformance;
DROP TABLE IF EXISTS event.MultimediaViewerVariant;
DROP TABLE IF EXISTS event.MultimediaViewerVersusPageFilePerformance;
DROP TABLE IF EXISTS event.PageIssues;
DROP TABLE IF EXISTS event.PageLinkInteraction;
DROP TABLE IF EXISTS event.ReadingDepth;
DROP TABLE IF EXISTS event.RecentChangesTopLinks;
DROP TABLE IF EXISTS event.RelatedArticles;
DROP TABLE IF EXISTS event.Search;
DROP TABLE IF EXISTS event.TaskRecommendation;
DROP TABLE IF EXISTS event.TaskRecommendationClick;
DROP TABLE IF EXISTS event.TaskRecommendationImpression;
DROP TABLE IF EXISTS event.TaskRecommendationLightbulbClick;
DROP TABLE IF EXISTS event.TestSearchSatisfaction;
DROP TABLE IF EXISTS event.TestSearchSatisfaction2;
DROP TABLE IF EXISTS event.TestSearchSatisfaction3;
DROP TABLE IF EXISTS event.TimingData;
DROP TABLE IF EXISTS event.TranslationRecommendationFlagging;
DROP TABLE IF EXISTS event.ULS;
DROP TABLE IF EXISTS event.UniversalLanguageSelector_tofu;
DROP TABLE IF EXISTS event.UploadWizardDeedFlowEvent;
DROP TABLE IF EXISTS event.UploadWizardErrorFlowEvent;
DROP TABLE IF EXISTS event.UploadWizardExceptionFlowEvent;
DROP TABLE IF EXISTS event.UploadWizardFlowEvent;
DROP TABLE IF EXISTS event.UploadWizardFlowEventUpload;
DROP TABLE IF EXISTS event.UploadWizardStep;
DROP TABLE IF EXISTS event.UploadWizardTutorialActions;
DROP TABLE IF EXISTS event.UploadWizardUploadActions;
DROP TABLE IF EXISTS event.UploadWizardUploadFlowEvent;
DROP TABLE IF EXISTS event.VET135171;
DROP TABLE IF EXISTS event.VisualEditorActivation;
DROP TABLE IF EXISTS event.VisualEditorBehaviorSaveDialogToClose;
DROP TABLE IF EXISTS event.VisualEditorBehaviorSaveDialogToReview;
DROP TABLE IF EXISTS event.VisualEditorBehaviorSaveDialogToSave;
DROP TABLE IF EXISTS event.VisualEditorBehaviorTransactionToSaveDialog;
DROP TABLE IF EXISTS event.VisualEditorDOMDiffed;
DROP TABLE IF EXISTS event.VisualEditorDOMPreviewed;
DROP TABLE IF EXISTS event.VisualEditorDOMRetrieved;
DROP TABLE IF EXISTS event.VisualEditorDOMSaved;
DROP TABLE IF EXISTS event.VisualEditorDOMSerialized;
DROP TABLE IF EXISTS event.VisualEditorReviewComplete;
DROP TABLE IF EXISTS event.VisualEditorReviewError;
DROP TABLE IF EXISTS event.VisualEditorSaveComplete;
DROP TABLE IF EXISTS event.VisualEditorSaveError;
DROP TABLE IF EXISTS event.WikimediaBlogVisit;
DROP TABLE IF EXISTS event.WikipediaZeroUsage;

Deleted decommed hive table location directories:

sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -f -r /wmf/data/event/autoblockipblock /wmf/data/event/cookieblock /wmf/data/event/editorjourney /wmf/data/event/externallinkschange /wmf/data/event/advancedsearchrequest /wmf/data/event/anonymoususersiteusage /wmf/data/event/apirequest /wmf/data/event/articlecreationhelp /wmf/data/event/articlecreationworkflow /wmf/data/event/autocompletesatisfaction /wmf/data/event/automatedrequest /wmf/data/event/bandwidthstats /wmf/data/event/bdavistest /wmf/data/event/blankschema /wmf/data/event/campaigns /wmf/data/event/centralauth /wmf/data/event/changeslistclicktracking /wmf/data/event/changeslistfilters /wmf/data/event/clicktiming /wmf/data/event/commandinvocation /wmf/data/event/commonscategorytreeuse /wmf/data/event/communityportal /wmf/data/event/completionsuggestions /wmf/data/event/createaccountprompt /wmf/data/event/deployment /wmf/data/event/deprecatedusage /wmf/data/event/diacriticspoll /wmf/data/event/diacriticsvisibility /wmf/data/event/didyoumean /wmf/data/event/echopageviewsuntilseen /wmf/data/event/echoprefupdate /wmf/data/event/editconflict /wmf/data/event/editdebugging /wmf/data/event/editlifecycle /wmf/data/event/editoractivation /wmf/data/event/editpagetracking /wmf/data/event/euccstats /wmf/data/event/euccvisit /wmf/data/event/eventloggertest /wmf/data/event/eventloggingerror /wmf/data/event/eventloggingpef /wmf/data/event/eventloggingworkshop /wmf/data/event/eventquerymeta /wmf/data/event/eventtiming /wmf/data/event/extdistdownloads /wmf/data/event/externalguidance /wmf/data/event/flow /wmf/data/event/flowmenu /wmf/data/event/flowreplies /wmf/data/event/flowsorting /wmf/data/event/fulltextsearchbackendzeroresults /wmf/data/event/fundraisingbannerpaymentmethod /wmf/data/event/gatherclicks /wmf/data/event/gatherflags /wmf/data/event/geofeatures /wmf/data/event/gettingstarted /wmf/data/event/gettingstartednavbar /wmf/data/event/gettingstartednewlandingpage /wmf/data/event/gettingstartednosuggestedarticle /wmf/data/event/gettingstartedonredirect /wmf/data/event/gettingstartedredirectimpression /wmf/data/event/guidedtour /wmf/data/event/guidedtourbuttonclick /wmf/data/event/guidedtourexited /wmf/data/event/guidedtourexternallinkactivation /wmf/data/event/guidedtourguiderhidden /wmf/data/event/guidedtourguiderimpression /wmf/data/event/guidedtourinternallinkactivation /wmf/data/event/hovercards /wmf/data/event/httpssupport /wmf/data/event/humansearchrelevance /wmf/data/event/imagemetricscorssupport /wmf/data/event/imagemetricsloadingtime /wmf/data/event/inputdevicedynamics /wmf/data/event/jqmigrateusage /wmf/data/event/kartographer /wmf/data/event/kirstentest /wmf/data/event/layoutglitchdetected /wmf/data/event/layoutjank /wmf/data/event/linkinteractiontiming /wmf/data/event/loginuseragent /wmf/data/event/mediaviewer /wmf/data/event/mediawikiexception /wmf/data/event/mediawikiinstallpingback /wmf/data/event/mediawikivagrantusage /wmf/data/event/mobileacux /wmf/data/event/mobilebehaviouraldifferences /wmf/data/event/mobilebetawatchlist /wmf/data/event/mobileleftnavbareditcta /wmf/data/event/mobileoptionstracking /wmf/data/event/mobilewatchlistinteraction /wmf/data/event/mobilewebdiff /wmf/data/event/mobilewebsearch /wmf/data/event/mobilewikiappabtest /wmf/data/event/mobilewikiappappearancesettings /wmf/data/event/mobilewikiapparticlesuggestions /wmf/data/event/mobilewikiappcreateaccount /wmf/data/event/mobilewikiappdailystats /wmf/data/event/mobilewikiappedit /wmf/data/event/mobilewikiappfeed /wmf/data/event/mobilewikiappfeedconfigure /wmf/data/event/mobilewikiappfindinpage /wmf/data/event/mobilewikiappinstallreferrer /wmf/data/event/mobilewikiappintents /wmf/data/event/mobilewikiappiosedithistorycompare /wmf/data/event/mobilewikiappiosedithistoryfeature /wmf/data/event/mobilewikiappiosfeed /wmf/data/event/mobilewikiappiosloginaction /wmf/data/event/mobilewikiappiosreadinglists /wmf/data/event/mobilewikiappiossearch /wmf/data/event/mobilewikiappiossessions /wmf/data/event/mobilewikiappiossettingaction /wmf/data/event/mobilewikiappiosuserhistory /wmf/data/event/mobilewikiapplangselect /wmf/data/event/mobilewikiapplanguagesearching /wmf/data/event/mobilewikiapplanguagesettings /wmf/data/event/mobilewikiapplinkpreview /wmf/data/event/mobilewikiapplogin /wmf/data/event/mobilewikiappmediagallery /wmf/data/event/mobilewikiappnavmenu /wmf/data/event/mobilewikiappnotificationinteraction /wmf/data/event/mobilewikiappnotificationpreferences /wmf/data/event/mobilewikiapponboarding /wmf/data/event/mobilewikiapponthisday /wmf/data/event/mobilewikiapppagescroll /wmf/data/event/mobilewikiappprotectededitattempt /wmf/data/event/mobilewikiapprandomizer /wmf/data/event/mobilewikiappreadinglists /wmf/data/event/mobilewikiappsavedpages /wmf/data/event/mobilewikiappsearch /wmf/data/event/mobilewikiappsessions /wmf/data/event/mobilewikiappshareafact /wmf/data/event/mobilewikiappsuggestededits /wmf/data/event/mobilewikiapptabs /wmf/data/event/mobilewikiapptocinteraction /wmf/data/event/mobilewikiappusercontribution /wmf/data/event/mobilewikiappwidgets /wmf/data/event/mobilewikiappwiktionarypopup /wmf/data/event/moduleloadfailure /wmf/data/event/modulestorage /wmf/data/event/multimediatiming /wmf/data/event/neweditoredit /wmf/data/event/onboarding /wmf/data/event/opentask /wmf/data/event/pagecontentsavecomplete /wmf/data/event/pagecreation /wmf/data/event/pagedeletion /wmf/data/event/pagemove /wmf/data/event/pagerestoration /wmf/data/event/pagerestore /wmf/data/event/pagesavetiming /wmf/data/event/personalbar /wmf/data/event/planoutexperimentexposure /wmf/data/event/popups /wmf/data/event/print /wmf/data/event/proofread /wmf/data/event/pseudopageview /wmf/data/event/sandbox /wmf/data/event/savepageattempt /wmf/data/event/savepageattempts /wmf/data/event/schema /wmf/data/event/searchsatisfactionerrors /wmf/data/event/sendbeaconreliability /wmf/data/event/serversideeventmeta /wmf/data/event/serversidegettingstarted /wmf/data/event/servertiming /wmf/data/event/signupexpaccountcreationcomplete /wmf/data/event/signupexpaccountcreationimpression /wmf/data/event/signupexpctabuttonclick /wmf/data/event/signupexpctaimpression /wmf/data/event/signupexppagelinkclick /wmf/data/event/simplebanner /wmf/data/event/statsd /wmf/data/event/testeventduplication /wmf/data/event/testschema /wmf/data/event/timeventloggingdemo /wmf/data/event/toolsjobmanipulation /wmf/data/event/toolsjobsubmission /wmf/data/event/trackedpagecontentsavecomplete /wmf/data/event/userfeedback /wmf/data/event/validationerror /wmf/data/event/viewportmetrics /wmf/data/event/watchlistusage /wmf/data/event/webclienterror /wmf/data/event/accountcreation /wmf/data/event/analytics /wmf/data/event/bookmanagerv2 /wmf/data/event/browserwindowsize /wmf/data/event/changeslistfiltergrouping /wmf/data/event/changeslisthighlights /wmf/data/event/cirrustiming /wmf/data/event/citationusage /wmf/data/event/citationusagepageload /wmf/data/event/clientsideerror /wmf/data/event/contenttranslation /wmf/data/event/contenttranslation_interlanguage_entrypoint /wmf/data/event/contenttranslationcta /wmf/data/event/contenttranslationerror /wmf/data/event/contenttranslationsuggestion /wmf/data/event/cxactivity /wmf/data/event/echo /wmf/data/event/edit /wmf/data/event/eventcapsule /wmf/data/event/eventerror /wmf/data/event/extenallinkschange /wmf/data/event/fishretention /wmf/data/event/gendersurvey /wmf/data/event/machineaideddepictsusage /wmf/data/event/mediaviewerperf /wmf/data/event/mobileappcategorizationattempts /wmf/data/event/mobileapploginattempts /wmf/data/event/mobileappshareattempts /wmf/data/event/mobileapptrackingchange /wmf/data/event/mobileappuploadattempts /wmf/data/event/mobilewebbrowse /wmf/data/event/mobilewebcentralautherror /wmf/data/event/mobilewebclicktracking /wmf/data/event/mobilewebcta /wmf/data/event/mobilewebdiffclicktracking /wmf/data/event/mobilewebediting /wmf/data/event/mobilewebinfobox /wmf/data/event/mobileweblanguageswitcher /wmf/data/event/mobilewebmainmenuclicktracking /wmf/data/event/mobilewebsectionusage /wmf/data/event/mobilewebsharebutton /wmf/data/event/mobilewebuiclicktracking /wmf/data/event/mobilewebuploads /wmf/data/event/mobilewebwatching /wmf/data/event/mobilewebwatchlistclicktracking /wmf/data/event/mobilewebwikigrok /wmf/data/event/mobilewebwikigrokbinary /wmf/data/event/mobilewebwikigrokerror /wmf/data/event/mobilewebwikigrokresponse /wmf/data/event/mobilewikiappbannerclickthrough /wmf/data/event/mobilewikiappofflinelibrary /wmf/data/event/mobilewikiappoperatorcode /wmf/data/event/mobilewikiapprlsregistration /wmf/data/event/mobilewikiappshareafactonboarding /wmf/data/event/mobilewikiappstuffhappens /wmf/data/event/multimediaviewerattribution /wmf/data/event/multimediaviewerdimensions /wmf/data/event/multimediaviewerduration /wmf/data/event/multimediaviewernetworkperformance /wmf/data/event/multimediaviewervariant /wmf/data/event/multimediaviewerversuspagefileperformance /wmf/data/event/pageissues /wmf/data/event/pagelinkinteraction /wmf/data/event/readingdepth /wmf/data/event/recentchangestoplinks /wmf/data/event/relatedarticles /wmf/data/event/search /wmf/data/event/taskrecommendation /wmf/data/event/taskrecommendationclick /wmf/data/event/taskrecommendationimpression /wmf/data/event/taskrecommendationlightbulbclick /wmf/data/event/testsearchsatisfaction /wmf/data/event/testsearchsatisfaction2 /wmf/data/event/testsearchsatisfaction3 /wmf/data/event/timingdata /wmf/data/event/translationrecommendationflagging /wmf/data/event/uls /wmf/data/event/universallanguageselector_tofu /wmf/data/event/uploadwizarddeedflowevent /wmf/data/event/uploadwizarderrorflowevent /wmf/data/event/uploadwizardexceptionflowevent /wmf/data/event/uploadwizardflowevent /wmf/data/event/uploadwizardfloweventupload /wmf/data/event/uploadwizardstep /wmf/data/event/uploadwizardtutorialactions /wmf/data/event/uploadwizarduploadactions /wmf/data/event/uploadwizarduploadflowevent /wmf/data/event/vet135171 /wmf/data/event/visualeditoractivation /wmf/data/event/visualeditorbehaviorsavedialogtoclose /wmf/data/event/visualeditorbehaviorsavedialogtoreview /wmf/data/event/visualeditorbehaviorsavedialogtosave /wmf/data/event/visualeditorbehaviortransactiontosavedialog /wmf/data/event/visualeditordomdiffed /wmf/data/event/visualeditordompreviewed /wmf/data/event/visualeditordomretrieved /wmf/data/event/visualeditordomsaved /wmf/data/event/visualeditordomserialized /wmf/data/event/visualeditorreviewcomplete /wmf/data/event/visualeditorreviewerror /wmf/data/event/visualeditorsavecomplete /wmf/data/event/visualeditorsaveerror /wmf/data/event/wikimediablogvisit /wmf/data/event/wikipediazerousage

After discussing with Timo I decided to edit all pages in the Schema namespace on metawiki and set the content to {}.

Code here: https://gitlab.wikimedia.org/-/snippets/208

Change #1124787 had a related patch set uploaded (by Filippo Giunchedi; author: Filippo Giunchedi):

[operations/alerts@master] data-engineering: remove legacy eventlogging alerts

https://gerrit.wikimedia.org/r/1124787

Change #1124787 merged by Filippo Giunchedi:

[operations/alerts@master] data-engineering: remove legacy eventlogging alerts

https://gerrit.wikimedia.org/r/1124787

Change #1170111 had a related patch set uploaded (by Muehlenhoff; author: Muehlenhoff):

[operations/puppet@production] No longer apply the eventlogging-admins access group to perf and deploy hosts

https://gerrit.wikimedia.org/r/1170111

Change #1111239 merged by Scott French:

[operations/puppet@production] configcluster.yaml - remove eventlogging from profile::etcd::tlsproxy::acls

https://gerrit.wikimedia.org/r/1111239

Change #1170111 merged by Muehlenhoff:

[operations/puppet@production] No longer apply the eventlogging-admins access group to perf and deploy hosts

https://gerrit.wikimedia.org/r/1170111