Page MenuHomePhabricator

Fix mismatching field type of archive.ar_timestamp on wmf wikis
Closed, ResolvedPublic

Description

https://drift-tracker.toolforge.org/report/core/ shows a schema drift for:

Mismatching field type of archive.ar_timestamp

on s1, s2, s3, s4, s6, s7

According to T42626 the timestamp should be adjust from varbinary(14) to binary(14) because there is no need to hold infinite.
The column was added in d82c14fb4fbac288b42ca5918b0a72f33ecb1e69#change-pVGjpnYAcwz0

There is no ready ALTER statement in the commit history.

ALTER TABLE /*_*/archive
  CHANGE ar_timestamp ar_timestamp BINARY(14) NOT NULL;
  1. ALTERs to run: see above
  2. Where to run those changes: s1, s2, s3, s4, s7 - list of wikis needs to be created
  3. When to run those changes: any time
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster is running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Progress (excluding master)

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7

Masters are not done:

  • s1: db1118
  • s2: db1122
  • s3: db1157
  • s4: db1138
  • s5
  • s6: db1173
  • s7: db1136

Related Objects

Event Timeline

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

It actually needs s6 as well, It was somehow missing from the original report but it's showing up now https://drift-tracker.toolforge.org/report/core/. I run it s6.

Mentioned in SAL (#wikimedia-operations) [2022-02-21T00:16:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1113:3316 (T298554)', diff saved to https://phabricator.wikimedia.org/P21053 and previous config saved to /var/cache/conftool/dbconfig/20220221-001641-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T00:41:28Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T298554)', diff saved to https://phabricator.wikimedia.org/P21054 and previous config saved to /var/cache/conftool/dbconfig/20220221-004128-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T01:26:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T298554)', diff saved to https://phabricator.wikimedia.org/P21057 and previous config saved to /var/cache/conftool/dbconfig/20220221-012642-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T01:26:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1168 (T298554)', diff saved to https://phabricator.wikimedia.org/P21058 and previous config saved to /var/cache/conftool/dbconfig/20220221-012649-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T01:34:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T298554)', diff saved to https://phabricator.wikimedia.org/P21059 and previous config saved to /var/cache/conftool/dbconfig/20220221-013429-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T02:19:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1168 (T298554)', diff saved to https://phabricator.wikimedia.org/P21063 and previous config saved to /var/cache/conftool/dbconfig/20220221-021943-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T02:38:56Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1165 (T298554)', diff saved to https://phabricator.wikimedia.org/P21066 and previous config saved to /var/cache/conftool/dbconfig/20220221-023852-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T02:55:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T298554)', diff saved to https://phabricator.wikimedia.org/P21067 and previous config saved to /var/cache/conftool/dbconfig/20220221-025534-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T03:40:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1165 (T298554)', diff saved to https://phabricator.wikimedia.org/P21072 and previous config saved to /var/cache/conftool/dbconfig/20220221-034052-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T03:41:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1180 (T298554)', diff saved to https://phabricator.wikimedia.org/P21073 and previous config saved to /var/cache/conftool/dbconfig/20220221-034100-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T03:48:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T298554)', diff saved to https://phabricator.wikimedia.org/P21074 and previous config saved to /var/cache/conftool/dbconfig/20220221-034836-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T04:33:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1180 (T298554)', diff saved to https://phabricator.wikimedia.org/P21079 and previous config saved to /var/cache/conftool/dbconfig/20220221-043350-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T04:34:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1098:3316 (T298554)', diff saved to https://phabricator.wikimedia.org/P21080 and previous config saved to /var/cache/conftool/dbconfig/20220221-043358-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T05:00:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T298554)', diff saved to https://phabricator.wikimedia.org/P21082 and previous config saved to /var/cache/conftool/dbconfig/20220221-050050-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T05:46:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T298554)', diff saved to https://phabricator.wikimedia.org/P21085 and previous config saved to /var/cache/conftool/dbconfig/20220221-054604-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T05:46:18Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1131 (T298554)', diff saved to https://phabricator.wikimedia.org/P21086 and previous config saved to /var/cache/conftool/dbconfig/20220221-054612-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T06:07:02Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1131 (T298554)', diff saved to https://phabricator.wikimedia.org/P21087 and previous config saved to /var/cache/conftool/dbconfig/20220221-060701-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-02-21T06:52:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1131 (T298554)', diff saved to https://phabricator.wikimedia.org/P21096 and previous config saved to /var/cache/conftool/dbconfig/20220221-065220-ladsgroup.json

Ladsgroup updated the task description. (Show Details)

s3 old master (db1157) is done

Mentioned in SAL (#wikimedia-operations) [2022-04-26T23:42:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1161 (T298554)', diff saved to https://phabricator.wikimedia.org/P26647 and previous config saved to /var/cache/conftool/dbconfig/20220426-234224-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T00:14:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1161 (T298554)', diff saved to https://phabricator.wikimedia.org/P26650 and previous config saved to /var/cache/conftool/dbconfig/20220427-001438-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T00:59:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1161 (T298554)', diff saved to https://phabricator.wikimedia.org/P26656 and previous config saved to /var/cache/conftool/dbconfig/20220427-005953-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T01:00:08Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1096:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26657 and previous config saved to /var/cache/conftool/dbconfig/20220427-010001-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T01:35:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26662 and previous config saved to /var/cache/conftool/dbconfig/20220427-013530-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T02:20:46Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26670 and previous config saved to /var/cache/conftool/dbconfig/20220427-022045-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T02:21:00Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1130 (T298554)', diff saved to https://phabricator.wikimedia.org/P26671 and previous config saved to /var/cache/conftool/dbconfig/20220427-022053-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T02:44:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1130 (T298554)', diff saved to https://phabricator.wikimedia.org/P26673 and previous config saved to /var/cache/conftool/dbconfig/20220427-024409-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T04:51:56Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1110 (T298554)', diff saved to https://phabricator.wikimedia.org/P26688 and previous config saved to /var/cache/conftool/dbconfig/20220427-045153-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T05:25:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1110 (T298554)', diff saved to https://phabricator.wikimedia.org/P26691 and previous config saved to /var/cache/conftool/dbconfig/20220427-052549-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T06:11:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1110 (T298554)', diff saved to https://phabricator.wikimedia.org/P26695 and previous config saved to /var/cache/conftool/dbconfig/20220427-061104-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T06:11:19Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1144:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26696 and previous config saved to /var/cache/conftool/dbconfig/20220427-061112-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T06:45:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26697 and previous config saved to /var/cache/conftool/dbconfig/20220427-064551-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T07:31:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26700 and previous config saved to /var/cache/conftool/dbconfig/20220427-073106-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T07:31:22Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1113:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26701 and previous config saved to /var/cache/conftool/dbconfig/20220427-073114-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T08:04:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26702 and previous config saved to /var/cache/conftool/dbconfig/20220427-080425-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-04-27T08:49:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1113:3315 (T298554)', diff saved to https://phabricator.wikimedia.org/P26706 and previous config saved to /var/cache/conftool/dbconfig/20220427-084941-ladsgroup.json

Running this on db1118 (old s1 master)

Running this on db1118 (old s1 master)

Done

Marostegui updated the task description. (Show Details)