Page MenuHomePhabricator

Fix mismatching field type of logging.log_timestamp on wmf wikis
Open, LowestPublic

Description

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

Mismatching field type of logging.log_timestamp

on s1, s2, s3, s4, 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 41e752879cd906767c8473bb124345e8beb190e6#change-pVGjpnYAcwz0

There is no ready ALTER statement in the commit history.

ALTER TABLE /*_*/logging
  CHANGE log_timestamp log_timestamp BINARY(14) DEFAULT '19700101000000' 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 - Please check also s5, s6, s8 before closing as the drift tracker checks a random wiki, which could pass the check, while other wikis on the same section would fail the check
  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

  • s1 Done except master (db1163)
  • s2: Done except master (db1162)
  • s3: Done except master (db1123)
  • s4: Done except master (db1160)
  • s5: Done
  • s6: Done
  • s7: Done

Related Objects

Event Timeline

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

Mentioned in SAL (#wikimedia-operations) [2022-05-24T01:06:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1129 (T298555)', diff saved to https://phabricator.wikimedia.org/P28382 and previous config saved to /var/cache/conftool/dbconfig/20220524-010622-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T01:51:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1129 (T298555)', diff saved to https://phabricator.wikimedia.org/P28387 and previous config saved to /var/cache/conftool/dbconfig/20220524-015137-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T01:51:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1122 (T298555)', diff saved to https://phabricator.wikimedia.org/P28388 and previous config saved to /var/cache/conftool/dbconfig/20220524-015145-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T02:43:33Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T298555)', diff saved to https://phabricator.wikimedia.org/P28389 and previous config saved to /var/cache/conftool/dbconfig/20220524-024333-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T03:28:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T298555)', diff saved to https://phabricator.wikimedia.org/P28392 and previous config saved to /var/cache/conftool/dbconfig/20220524-032848-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T04:10:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1122 (T298555)', diff saved to https://phabricator.wikimedia.org/P28393 and previous config saved to /var/cache/conftool/dbconfig/20220524-041034-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T04:55:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1122 (T298555)', diff saved to https://phabricator.wikimedia.org/P28397 and previous config saved to /var/cache/conftool/dbconfig/20220524-045549-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T04:56:08Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1156 (T298555)', diff saved to https://phabricator.wikimedia.org/P28398 and previous config saved to /var/cache/conftool/dbconfig/20220524-045602-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T06:12:39Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1157 (T298555)', diff saved to https://phabricator.wikimedia.org/P28405 and previous config saved to /var/cache/conftool/dbconfig/20220524-061237-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T07:00:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1156 (T298555)', diff saved to https://phabricator.wikimedia.org/P28411 and previous config saved to /var/cache/conftool/dbconfig/20220524-070052-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T07:22:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1157 (T298555)', diff saved to https://phabricator.wikimedia.org/P28413 and previous config saved to /var/cache/conftool/dbconfig/20220524-072243-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T07:46:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1156 (T298555)', diff saved to https://phabricator.wikimedia.org/P28417 and previous config saved to /var/cache/conftool/dbconfig/20220524-074607-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-24T08:07:59Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1157 (T298555)', diff saved to https://phabricator.wikimedia.org/P28420 and previous config saved to /var/cache/conftool/dbconfig/20220524-080758-ladsgroup.json

Ladsgroup updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2022-05-25T09:29:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1118 (T298555)', diff saved to https://phabricator.wikimedia.org/P28492 and previous config saved to /var/cache/conftool/dbconfig/20220525-092947-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T11:46:40Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T298555)', diff saved to https://phabricator.wikimedia.org/P28515 and previous config saved to /var/cache/conftool/dbconfig/20220525-114640-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T12:31:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T298555)', diff saved to https://phabricator.wikimedia.org/P28524 and previous config saved to /var/cache/conftool/dbconfig/20220525-123155-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T12:32:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1134 (T298555)', diff saved to https://phabricator.wikimedia.org/P28525 and previous config saved to /var/cache/conftool/dbconfig/20220525-123203-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T15:01:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T298555)', diff saved to https://phabricator.wikimedia.org/P28547 and previous config saved to /var/cache/conftool/dbconfig/20220525-150107-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T15:46:22Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T298555)', diff saved to https://phabricator.wikimedia.org/P28550 and previous config saved to /var/cache/conftool/dbconfig/20220525-154622-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T15:46:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T298555)', diff saved to https://phabricator.wikimedia.org/P28551 and previous config saved to /var/cache/conftool/dbconfig/20220525-154630-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T17:56:48Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T298555)', diff saved to https://phabricator.wikimedia.org/P28553 and previous config saved to /var/cache/conftool/dbconfig/20220525-175648-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T18:42:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T298555)', diff saved to https://phabricator.wikimedia.org/P28556 and previous config saved to /var/cache/conftool/dbconfig/20220525-184203-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T20:37:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1106 (T298555)', diff saved to https://phabricator.wikimedia.org/P28558 and previous config saved to /var/cache/conftool/dbconfig/20220525-203708-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T22:49:57Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T298555)', diff saved to https://phabricator.wikimedia.org/P28559 and previous config saved to /var/cache/conftool/dbconfig/20220525-224957-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T23:35:12Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T298555)', diff saved to https://phabricator.wikimedia.org/P28562 and previous config saved to /var/cache/conftool/dbconfig/20220525-233512-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-25T23:35:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T298555)', diff saved to https://phabricator.wikimedia.org/P28563 and previous config saved to /var/cache/conftool/dbconfig/20220525-233520-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T01:37:42Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T298555)', diff saved to https://phabricator.wikimedia.org/P28566 and previous config saved to /var/cache/conftool/dbconfig/20220526-013741-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T02:23:00Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T298555)', diff saved to https://phabricator.wikimedia.org/P28569 and previous config saved to /var/cache/conftool/dbconfig/20220526-022259-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T02:23:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1119 (T298555)', diff saved to https://phabricator.wikimedia.org/P28570 and previous config saved to /var/cache/conftool/dbconfig/20220526-022307-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T04:31:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T298555)', diff saved to https://phabricator.wikimedia.org/P28571 and previous config saved to /var/cache/conftool/dbconfig/20220526-043126-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T05:16:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T298555)', diff saved to https://phabricator.wikimedia.org/P28574 and previous config saved to /var/cache/conftool/dbconfig/20220526-051641-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T05:16:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3311 (T298555)', diff saved to https://phabricator.wikimedia.org/P28575 and previous config saved to /var/cache/conftool/dbconfig/20220526-051649-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T07:44:36Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T298555)', diff saved to https://phabricator.wikimedia.org/P28577 and previous config saved to /var/cache/conftool/dbconfig/20220526-074436-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T08:29:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T298555)', diff saved to https://phabricator.wikimedia.org/P28581 and previous config saved to /var/cache/conftool/dbconfig/20220526-082951-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T10:23:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3311 (T298555)', diff saved to https://phabricator.wikimedia.org/P28590 and previous config saved to /var/cache/conftool/dbconfig/20220526-102308-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T12:34:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T298555)', diff saved to https://phabricator.wikimedia.org/P28593 and previous config saved to /var/cache/conftool/dbconfig/20220526-123413-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T13:19:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T298555)', diff saved to https://phabricator.wikimedia.org/P28597 and previous config saved to /var/cache/conftool/dbconfig/20220526-131928-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T15:18:06Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1169 (T298555)', diff saved to https://phabricator.wikimedia.org/P28599 and previous config saved to /var/cache/conftool/dbconfig/20220526-151723-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T17:16:38Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T298555)', diff saved to https://phabricator.wikimedia.org/P28602 and previous config saved to /var/cache/conftool/dbconfig/20220526-171638-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T18:01:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T298555)', diff saved to https://phabricator.wikimedia.org/P28605 and previous config saved to /var/cache/conftool/dbconfig/20220526-180153-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T18:02:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1132 (T298555)', diff saved to https://phabricator.wikimedia.org/P28606 and previous config saved to /var/cache/conftool/dbconfig/20220526-180201-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T20:26:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T298555)', diff saved to https://phabricator.wikimedia.org/P28614 and previous config saved to /var/cache/conftool/dbconfig/20220526-202625-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-05-26T21:11:41Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T298555)', diff saved to https://phabricator.wikimedia.org/P28617 and previous config saved to /var/cache/conftool/dbconfig/20220526-211140-ladsgroup.json

Ladsgroup moved this task from In progress to Blocked on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2022-06-27T15:18:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1173 (T298555)', diff saved to https://phabricator.wikimedia.org/P30460 and previous config saved to /var/cache/conftool/dbconfig/20220627-151843-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-06-27T15:47:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1173 (T298555)', diff saved to https://phabricator.wikimedia.org/P30467 and previous config saved to /var/cache/conftool/dbconfig/20220627-154724-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2022-06-27T16:32:40Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1173 (T298555)', diff saved to https://phabricator.wikimedia.org/P30471 and previous config saved to /var/cache/conftool/dbconfig/20220627-163239-ladsgroup.json