Hi,
per T331762: Remove FlaggedRevs for ptwikisource tables for FlaggedRevs should be dropped.
I know that it can't be dropped right away, so firstly renaming tables is fine, and then dropping after a week or something like that.
Thank you!
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Kizule | T331762 Remove FlaggedRevs for ptwikisource | |||
| Resolved | BTullis | T332596 Drop several views from ptwikisource | |||
| Resolved | • Marostegui | T332594 Drop FlaggedRevs tables in database for ptwikisource |
Event Timeline
Comment Actions
@Kizule to confirm the tables that need to be dropped are:
root@db1123.eqiad.wmnet[ptwikisource]> show tables like 'flagged%'; +-----------------------------------+ | Tables_in_ptwikisource (flagged%) | +-----------------------------------+ | flaggedpage_config | | flaggedpage_pending | | flaggedpages | | flaggedrevs | | flaggedrevs_promote | | flaggedrevs_statistics | | flaggedrevs_tracking | | flaggedtemplates | +-----------------------------------+ 8 rows in set (0.001 sec)
Comment Actions
Or only Flaggedrevs related ones are meant to be dropped?
root@db1123.eqiad.wmnet[ptwikisource]> show tables like 'flaggedrevs%'; +---------------------------------------+ | Tables_in_ptwikisource (flaggedrevs%) | +---------------------------------------+ | flaggedrevs | | flaggedrevs_promote | | flaggedrevs_statistics | | flaggedrevs_tracking | +---------------------------------------+ 4 rows in set (0.001 sec)
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2023-03-27T06:40:20Z] <marostegui> Rename flaggedrevs tables on db1123 ptwikisource T332594
Comment Actions
I just rename these tables on db1123:
root@db1123.eqiad.wmnet[ptwikisource]> show tables like 'T%'; +--------------------------------+ | Tables_in_ptwikisource (T%) | +--------------------------------+ | T332594_flaggedpage_config | | T332594_flaggedpage_pending | | T332594_flaggedpages | | T332594_flaggedrevs | | T332594_flaggedrevs_promote | | T332594_flaggedrevs_statistics | | T332594_flaggedrevs_tracking | | T332594_flaggedtemplates | +--------------------------------+ 8 rows in set (0.001 sec)
I will leave them for a few days before dropping them for good everywhere.
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2023-03-27T06:51:53Z] <marostegui> dbmaint s3 eqiad Rename flaggedrevs tables on db1123 ptwikisource T332594
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2023-04-12T07:16:34Z] <marostegui> Drop flaggerevs tables from ptwikisource T332594