Wait until 1.33.0-wmf.6 or later is deployed before doing this! That probably means December 2018 or later.
The table is empty on all wikis, and unused since rMWd099bb6f9578: Drop the image_comment_temp table.
Deletion progress
wikitech
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | LSobanski | T54921 Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) | |||
| Resolved | Anomie | T188132 Merge image_comment_temp table into the image table | |||
| Resolved | • Marostegui | T209591 Drop table image_comment_temp on all wikis |
That's part of why I said "1.33.0-wmf.5 or later".[1]
[1]: The other part is the potential for train stoppage to mean 1.33.0-wmf.6 never makes it out either and we wind up with wmf.8 being the first usable version deployed.
Not quite yet, probably next week. 1.33.0-wmf.6 is being deployed this week, but isn't everywhere yet (and there's the risk of having to rollback to wmf.4).
Confirmed empty on all wikis.
CREATE TABLE `image_comment_temp` ( `imgcomment_name` varbinary(255) NOT NULL, `imgcomment_description_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`imgcomment_name`,`imgcomment_description_id`), UNIQUE KEY `imgcomment_name` (`imgcomment_name`) ) ENGINE=InnoDB DEFAULT CHARSET=binary;
Mentioned in SAL (#wikimedia-operations) [2018-12-19T08:27:20Z] <marostegui> Drop image_comment_temp from s1 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T08:28:42Z] <marostegui> Drop image_comment_temp from s2 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T08:40:21Z] <marostegui> Drop image_comment_temp from s8 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T08:46:41Z] <marostegui> Drop image_comment_temp from s6 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T08:50:27Z] <marostegui> Drop image_comment_temp from s7 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T11:11:17Z] <marostegui> Drop image_comment_temp from s5 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T12:46:40Z] <marostegui> Drop image_comment_temp on s3 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T13:31:06Z] <marostegui> Drop image_comment_temp on s4 - T209591
Mentioned in SAL (#wikimedia-operations) [2018-12-19T15:07:29Z] <marostegui> Drop image_comment_temp from labswiki and labtestwiki - T209591