Page MenuHomePhabricator
Paste P6685

Purge old IP data on Beta Cluster
ActivePublic

Authored by MarcoAurelio on Feb 12 2018, 6:59 PM.
maurelio@deployment-tin:~$ foreachwikiindblist all-labs.dblist extensions/AbuseFilter/maintenance/purgeOldLogIPData.php
-----------------------------------------------------------------
aawiki
-----------------------------------------------------------------
aawiki: Purging old IP Address data from abuse_filter_log...
aawiki: 0 rows.
aawiki: Done.
-----------------------------------------------------------------
arwiki
-----------------------------------------------------------------
arwiki: Purging old IP Address data from abuse_filter_log...
arwiki: 0 rows.
arwiki: Done.
-----------------------------------------------------------------
cawiki
-----------------------------------------------------------------
cawiki: Purging old IP Address data from abuse_filter_log...
cawiki: 40
cawiki: 40 rows.
cawiki: Done.
-----------------------------------------------------------------
commonswiki
-----------------------------------------------------------------
commonswiki: Purging old IP Address data from abuse_filter_log...
commonswiki: 200
commonswiki: 400
commonswiki: 600
commonswiki: 800
commonswiki: 1000
commonswiki: 1200
commonswiki: 1400
commonswiki: 1600
commonswiki: 1800
commonswiki: 2000
commonswiki: 2200
commonswiki: 2400
commonswiki: 2600
commonswiki: 2800
commonswiki: 3000
commonswiki: 3200
commonswiki: 3400
commonswiki: 3600
commonswiki: 3800
commonswiki: 4000
commonswiki: 4200
commonswiki: 4400
commonswiki: 4600
commonswiki: 4800
commonswiki: 5000
commonswiki: 5200
commonswiki: 5400
commonswiki: 5600
commonswiki: 5800
commonswiki: 6000
commonswiki: 6200
commonswiki: 6400
commonswiki: 6600
commonswiki: 6800
commonswiki: 7000
commonswiki: 7200
commonswiki: 7400
commonswiki: 7600
commonswiki: 7800
commonswiki: 8000
commonswiki: 8200
commonswiki: 8400
commonswiki: 8600
commonswiki: 8800
commonswiki: 9000
commonswiki: 9200
commonswiki: 9400
commonswiki: 9600
commonswiki: 9800
commonswiki: 10000
commonswiki: 10200
commonswiki: 10400
commonswiki: 10600
commonswiki: 10800
commonswiki: 11000
commonswiki: 11200
commonswiki: 11400
commonswiki: 11600
commonswiki: 11800
commonswiki: 12000
commonswiki: 12200
commonswiki: 12400
commonswiki: 12600
commonswiki: 12800
commonswiki: 13000
commonswiki: 13200
commonswiki: 13400
commonswiki: 13600
commonswiki: 13800
commonswiki: 14000
commonswiki: 14200
commonswiki: 14400
commonswiki: 14600
commonswiki: 14800
commonswiki: 15000
commonswiki: 15200
commonswiki: 15400
commonswiki: 15600
commonswiki: 15800
commonswiki: 16000
commonswiki: 16200
commonswiki: 16400
commonswiki: 16600
commonswiki: 16800
commonswiki: 17000
commonswiki: 17200
commonswiki: 17400
commonswiki: 17600
commonswiki: 17800
commonswiki: 18000
commonswiki: 18200
commonswiki: 18400
commonswiki: 18600
commonswiki: 18800
commonswiki: 19000
commonswiki: 19200
commonswiki: 19400
commonswiki: 19600
commonswiki: 19800
commonswiki: 20000
commonswiki: 20200
commonswiki: 20400
commonswiki: 20600
commonswiki: 20800
commonswiki: 21000
commonswiki: 21200
commonswiki: 21400
commonswiki: 21600
commonswiki: 21800
commonswiki: 22000
commonswiki: 22200
commonswiki: 22400
commonswiki: 22600
commonswiki: 22800
commonswiki: 23000
commonswiki: 23200
commonswiki: 23400
commonswiki: 23600
commonswiki: 23800
commonswiki: 24000
commonswiki: 24200
commonswiki: 24400
commonswiki: 24600
commonswiki: 24800
commonswiki: 25000
commonswiki: 25200
commonswiki: 25400
commonswiki: 25600
commonswiki: 25800
commonswiki: 26000
commonswiki: 26200
commonswiki: 26373
commonswiki: 26373 rows.
commonswiki: Done.
-----------------------------------------------------------------
deploymentwiki
-----------------------------------------------------------------
deploymentwiki: Purging old IP Address data from abuse_filter_log...
deploymentwiki: 200
deploymentwiki: 400
deploymentwiki: 600
deploymentwiki: 800
deploymentwiki: 1000
deploymentwiki: 1200
deploymentwiki: 1400
deploymentwiki: 1600
deploymentwiki: 1800
deploymentwiki: 2000
deploymentwiki: 2200
deploymentwiki: 2400
deploymentwiki: 2600
deploymentwiki: 2800
deploymentwiki: 3000
deploymentwiki: 3200
deploymentwiki: 3400
deploymentwiki: 3600
deploymentwiki: 3800
deploymentwiki: 4000
deploymentwiki: 4200
deploymentwiki: 4400
deploymentwiki: 4600
deploymentwiki: 4800
deploymentwiki: 5000
deploymentwiki: 5200
deploymentwiki: 5400
deploymentwiki: 5600
deploymentwiki: 5800
deploymentwiki: 6000
deploymentwiki: 6200
deploymentwiki: 6400
deploymentwiki: 6600
deploymentwiki: 6800
deploymentwiki: 7000
deploymentwiki: 7200
deploymentwiki: 7400
deploymentwiki: 7600
deploymentwiki: 7800
deploymentwiki: 8000
deploymentwiki: 8200
deploymentwiki: 8400
deploymentwiki: 8600
deploymentwiki: 8800
deploymentwiki: 9000
deploymentwiki: 9200
deploymentwiki: 9400
deploymentwiki: 9600
deploymentwiki: 9800
deploymentwiki: 10000
deploymentwiki: 10200
deploymentwiki: 10400
deploymentwiki: 10600
deploymentwiki: 10800
deploymentwiki: 11000
deploymentwiki: 11200
deploymentwiki: 11400
deploymentwiki: 11600
deploymentwiki: 11800
deploymentwiki: 12000
deploymentwiki: 12200
deploymentwiki: 12400
deploymentwiki: 12600
deploymentwiki: 12800
deploymentwiki: 13000
deploymentwiki: 13200
deploymentwiki: 13400
deploymentwiki: 13600
deploymentwiki: 13800
deploymentwiki: 14000
deploymentwiki: 14200
deploymentwiki: 14400
deploymentwiki: 14600
deploymentwiki: 14800
deploymentwiki: 15000
deploymentwiki: 15200
deploymentwiki: 15400
deploymentwiki: 15600
deploymentwiki: 15800
deploymentwiki: 16000
deploymentwiki: 16200
deploymentwiki: 16400
deploymentwiki: 16600
deploymentwiki: 16800
deploymentwiki: 17000
deploymentwiki: 17200
deploymentwiki: 17400
deploymentwiki: 17600
deploymentwiki: 17800
deploymentwiki: 18000
deploymentwiki: 18200
deploymentwiki: 18400
deploymentwiki: 18600
deploymentwiki: 18800
deploymentwiki: 19000
deploymentwiki: 19200
deploymentwiki: 19400
deploymentwiki: 19600
deploymentwiki: 19800
deploymentwiki: 20000
deploymentwiki: 20200
deploymentwiki: 20400
deploymentwiki: 20600
deploymentwiki: 20800
deploymentwiki: 21000
deploymentwiki: 21200
deploymentwiki: 21400
deploymentwiki: 21600
deploymentwiki: 21800
deploymentwiki: 22000
deploymentwiki: 22044
deploymentwiki: 22044 rows.
deploymentwiki: Done.
-----------------------------------------------------------------
dewiki
-----------------------------------------------------------------
dewiki: Purging old IP Address data from abuse_filter_log...
dewiki: 200
dewiki: 400
dewiki: 600
dewiki: 680
dewiki: 680 rows.
dewiki: Done.
-----------------------------------------------------------------
dewiktionary
-----------------------------------------------------------------
dewiktionary: Purging old IP Address data from abuse_filter_log...
dewiktionary: 1
dewiktionary: 1 rows.
dewiktionary: Done.
-----------------------------------------------------------------
en_rtlwiki
-----------------------------------------------------------------
en_rtlwiki: Purging old IP Address data from abuse_filter_log...
en_rtlwiki: 6
en_rtlwiki: 6 rows.
en_rtlwiki: Done.
-----------------------------------------------------------------
enwiki
-----------------------------------------------------------------
enwiki: Purging old IP Address data from abuse_filter_log...
enwiki: 200
enwiki: 400
enwiki: 600
enwiki: 800
enwiki: 1000
enwiki: 1200
enwiki: 1400
enwiki: 1600
enwiki: 1800
enwiki: 2000
enwiki: 2200
enwiki: 2400
enwiki: 2600
enwiki: 2800
enwiki: 3000
enwiki: 3200
enwiki: 3400
enwiki: 3600
enwiki: 3800
enwiki: 4000
enwiki: 4200
enwiki: 4400
enwiki: 4600
enwiki: 4800
enwiki: 5000
enwiki: 5200
enwiki: 5400
enwiki: 5600
enwiki: 5800
enwiki: 6000
enwiki: 6200
enwiki: 6400
enwiki: 6600
enwiki: 6800
enwiki: 7000
enwiki: 7200
enwiki: 7400
enwiki: 7600
enwiki: 7800
enwiki: 8000
enwiki: 8200
enwiki: 8400
enwiki: 8600
enwiki: 8800
enwiki: 9000
enwiki: 9200
enwiki: 9400
enwiki: 9600
enwiki: 9800
enwiki: 10000
enwiki: 10200
enwiki: 10400
enwiki: 10600
enwiki: 10800
enwiki: 11000
enwiki: 11200
enwiki: 11400
enwiki: 11600
enwiki: 11800
enwiki: 12000
enwiki: 12200
enwiki: 12400
enwiki: 12600
enwiki: 12800
enwiki: 13000
enwiki: 13200
enwiki: 13400
enwiki: 13600
enwiki: 13800
enwiki: 14000
enwiki: 14200
enwiki: 14400
enwiki: 14600
enwiki: 14800
enwiki: 15000
enwiki: 15200
enwiki: 15400
enwiki: 15600
enwiki: 15800
enwiki: 16000
enwiki: 16200
enwiki: 16400
enwiki: 16600
enwiki: 16800
enwiki: 17000
enwiki: 17200
enwiki: 17400
enwiki: 17600
enwiki: 17800
enwiki: 18000
enwiki: 18200
enwiki: 18400
enwiki: 18600
enwiki: 18800
enwiki: 19000
enwiki: 19200
enwiki: 19400
enwiki: 19600
enwiki: 19800
enwiki: 20000
enwiki: 20200
enwiki: 20400
enwiki: 20600
enwiki: 20800
enwiki: 21000
enwiki: 21200
enwiki: 21400
enwiki: 21600
enwiki: 21800
enwiki: 22000
enwiki: 22200
enwiki: 22400
enwiki: 22600
enwiki: 22800
enwiki: 23000
enwiki: 23200
enwiki: 23400
enwiki: 23600
enwiki: 23800
enwiki: 24000
enwiki: 24200
enwiki: 24400
enwiki: 24600
enwiki: 24800
enwiki: 25000
enwiki: 25200
enwiki: 25400
enwiki: 25600
enwiki: 25800
enwiki: 26000
enwiki: 26200
enwiki: 26400
enwiki: 26600
enwiki: 26800
enwiki: 27000
enwiki: 27200
enwiki: 27400
enwiki: 27600
enwiki: 27800
enwiki: 28000
enwiki: 28200
enwiki: 28400
enwiki: 28600
enwiki: 28800
enwiki: 29000
enwiki: 29200
enwiki: 29400
enwiki: 29600
enwiki: 29800
enwiki: 30000
enwiki: 30200
enwiki: 30400
enwiki: 30600
enwiki: 30800
enwiki: 31000
enwiki: 31200
enwiki: 31400
enwiki: 31600
enwiki: 31800
enwiki: 32000
enwiki: 32200
enwiki: 32400
enwiki: 32600
enwiki: 32800
enwiki: 33000
enwiki: 33200
enwiki: 33400
enwiki: 33600
enwiki: 33800
enwiki: 34000
enwiki: 34200
enwiki: 34400
enwiki: 34600
enwiki: 34800
enwiki: 35000
enwiki: 35200
enwiki: 35400
enwiki: 35600
enwiki: 35800
enwiki: 36000
enwiki: 36200
enwiki: 36400
enwiki: 36600
enwiki: 36800
enwiki: 37000
enwiki: 37200
enwiki: 37400
enwiki: 37600
enwiki: 37800
enwiki: 38000
enwiki: 38200
enwiki: 38400
enwiki: 38600
enwiki: 38800
enwiki: 39000
enwiki: 39200
enwiki: 39400
enwiki: 39600
enwiki: 39800
enwiki: 40000
enwiki: 40200
enwiki: 40400
enwiki: 40600
enwiki: 40800
enwiki: 41000
enwiki: 41200
enwiki: 41400
enwiki: 41600
enwiki: 41800
enwiki: 42000
enwiki: 42200
enwiki: 42400
enwiki: 42600
enwiki: 42800
enwiki: 43000
enwiki: 43200
enwiki: 43400
enwiki: 43600
enwiki: 43800
enwiki: 44000
enwiki: 44200
enwiki: 44400
enwiki: 44600
enwiki: 44800
enwiki: 45000
enwiki: 45200
enwiki: 45400
enwiki: 45600
enwiki: 45800
enwiki: 46000
enwiki: 46200
enwiki: 46400
enwiki: 46600
enwiki: 46800
enwiki: 47000
enwiki: 47200
enwiki: 47400
enwiki: 47600
enwiki: 47800
enwiki: 48000
enwiki: 48200
enwiki: 48400
enwiki: 48600
enwiki: 48800
enwiki: 49000
enwiki: 49200
enwiki: 49400
enwiki: 49600
enwiki: 49800
enwiki: 50000
enwiki: 50200
enwiki: 50400
enwiki: 50600
enwiki: 50800
enwiki: 51000
enwiki: 51200
enwiki: 51400
enwiki: 51600
enwiki: 51800
enwiki: 52000
enwiki: 52200
enwiki: 52400
enwiki: 52600
enwiki: 52800
enwiki: 53000
enwiki: 53200
enwiki: 53400
enwiki: 53600
enwiki: 53800
enwiki: 54000
enwiki: 54200
enwiki: 54400
enwiki: 54600
enwiki: 54800
enwiki: 55000
enwiki: 55200
enwiki: 55400
enwiki: 55600
enwiki: 55800
enwiki: 56000
enwiki: 56200
enwiki: 56400
enwiki: 56600
enwiki: 56800
enwiki: 57000
enwiki: 57200
enwiki: 57400
enwiki: 57600
enwiki: 57800
enwiki: 58000
enwiki: 58200
enwiki: 58400
enwiki: 58600
enwiki: 58800
enwiki: 59000
enwiki: 59200
enwiki: 59400
enwiki: 59600
enwiki: 59800
enwiki: 60000
enwiki: 60200
enwiki: 60400
enwiki: 60600
enwiki: 60800
enwiki: 61000
enwiki: 61200
enwiki: 61400
enwiki: 61600
enwiki: 61800
enwiki: 62000
enwiki: 62200
enwiki: 62400
enwiki: 62600
enwiki: 62800
enwiki: 63000
enwiki: 63200
enwiki: 63400
enwiki: 63600
enwiki: 63800
enwiki: 64000
enwiki: 64200
enwiki: 64400
enwiki: 64600
enwiki: 64800
enwiki: 65000
enwiki: 65080
enwiki: 65080 rows.
enwiki: Done.
-----------------------------------------------------------------
enwikibooks
-----------------------------------------------------------------
enwikibooks: Purging old IP Address data from abuse_filter_log...
enwikibooks: 200
enwikibooks: 400
enwikibooks: 600
enwikibooks: 800
enwikibooks: 1000
enwikibooks: 1200
enwikibooks: 1400
enwikibooks: 1600
enwikibooks: 1800
enwikibooks: 2000
enwikibooks: 2200
enwikibooks: 2400
enwikibooks: 2600
enwikibooks: 2800
enwikibooks: 3000
enwikibooks: 3200
enwikibooks: 3400
enwikibooks: 3600
enwikibooks: 3800
enwikibooks: 4000
enwikibooks: 4200
enwikibooks: 4400
enwikibooks: 4600
enwikibooks: 4800
enwikibooks: 4854
enwikibooks: 4854 rows.
enwikibooks: Done.
-----------------------------------------------------------------
enwikinews
-----------------------------------------------------------------
enwikinews: Purging old IP Address data from abuse_filter_log...
enwikinews: 12
enwikinews: 12 rows.
enwikinews: Done.
-----------------------------------------------------------------
enwikiquote
-----------------------------------------------------------------
enwikiquote: Purging old IP Address data from abuse_filter_log...
enwikiquote: 11
enwikiquote: 11 rows.
enwikiquote: Done.
-----------------------------------------------------------------
enwikisource
-----------------------------------------------------------------
enwikisource: Purging old IP Address data from abuse_filter_log...
enwikisource: 14
enwikisource: 14 rows.
enwikisource: Done.
-----------------------------------------------------------------
enwikiversity
-----------------------------------------------------------------
enwikiversity: Purging old IP Address data from abuse_filter_log...
enwikiversity: 15
enwikiversity: 15 rows.
enwikiversity: Done.
-----------------------------------------------------------------
enwikivoyage
-----------------------------------------------------------------
enwikivoyage: Purging old IP Address data from abuse_filter_log...
enwikivoyage: 43
enwikivoyage: 43 rows.
enwikivoyage: Done.
-----------------------------------------------------------------
enwiktionary
-----------------------------------------------------------------
enwiktionary: Purging old IP Address data from abuse_filter_log...
enwiktionary: 200
enwiktionary: 282
enwiktionary: 282 rows.
enwiktionary: Done.
-----------------------------------------------------------------
eowiki
-----------------------------------------------------------------
eowiki: Purging old IP Address data from abuse_filter_log...
eowiki: 22
eowiki: 22 rows.
eowiki: Done.
-----------------------------------------------------------------
eswiki
-----------------------------------------------------------------
eswiki: Purging old IP Address data from abuse_filter_log...
eswiki: 0 rows.
eswiki: Done.
-----------------------------------------------------------------
fawiki
-----------------------------------------------------------------
fawiki: Purging old IP Address data from abuse_filter_log...
fawiki: 92
fawiki: 92 rows.
fawiki: Done.
-----------------------------------------------------------------
hewiki
-----------------------------------------------------------------
hewiki: Purging old IP Address data from abuse_filter_log...
hewiki: 56
hewiki: 56 rows.
hewiki: Done.
-----------------------------------------------------------------
hewiktionary
-----------------------------------------------------------------
hewiktionary: Purging old IP Address data from abuse_filter_log...
hewiktionary: 0 rows.
hewiktionary: Done.
-----------------------------------------------------------------
hiwiki
-----------------------------------------------------------------
hiwiki: Purging old IP Address data from abuse_filter_log...
hiwiki: 24
hiwiki: 24 rows.
hiwiki: Done.
-----------------------------------------------------------------
jawiki
-----------------------------------------------------------------
jawiki: Purging old IP Address data from abuse_filter_log...
jawiki: 18
jawiki: 18 rows.
jawiki: Done.
-----------------------------------------------------------------
kowiki
-----------------------------------------------------------------
kowiki: Purging old IP Address data from abuse_filter_log...
kowiki: 18
kowiki: 18 rows.
kowiki: Done.
-----------------------------------------------------------------
loginwiki
-----------------------------------------------------------------
loginwiki: Purging old IP Address data from abuse_filter_log...
loginwiki: 0 rows.
loginwiki: Done.
-----------------------------------------------------------------
metawiki
-----------------------------------------------------------------
metawiki: Purging old IP Address data from abuse_filter_log...
metawiki: 164
metawiki: 164 rows.
metawiki: Done.
-----------------------------------------------------------------
nlwiki
-----------------------------------------------------------------
nlwiki: Purging old IP Address data from abuse_filter_log...
nlwiki: 0 rows.
nlwiki: Done.
-----------------------------------------------------------------
ruwiki
-----------------------------------------------------------------
ruwiki: Purging old IP Address data from abuse_filter_log...
ruwiki: 72
ruwiki: 72 rows.
ruwiki: Done.
-----------------------------------------------------------------
simplewiki
-----------------------------------------------------------------
simplewiki: Purging old IP Address data from abuse_filter_log...
simplewiki: 200
simplewiki: 400
simplewiki: 600
simplewiki: 800
simplewiki: 1000
simplewiki: 1200
simplewiki: 1400
simplewiki: 1600
simplewiki: 1800
simplewiki: 2000
simplewiki: 2200
simplewiki: 2400
simplewiki: 2600
simplewiki: 2800
simplewiki: 3000
simplewiki: 3200
simplewiki: 3400
simplewiki: 3600
simplewiki: 3800
simplewiki: 4000
simplewiki: 4200
simplewiki: 4400
simplewiki: 4600
simplewiki: 4800
simplewiki: 5000
simplewiki: 5200
simplewiki: 5400
simplewiki: 5600
simplewiki: 5800
simplewiki: 6000
simplewiki: 6200
simplewiki: 6400
simplewiki: 6600
simplewiki: 6800
simplewiki: 7000
simplewiki: 7200
simplewiki: 7400
simplewiki: 7600
simplewiki: 7800
simplewiki: 7948
simplewiki: 7948 rows.
simplewiki: Done.
-----------------------------------------------------------------
sqwiki
-----------------------------------------------------------------
sqwiki: Purging old IP Address data from abuse_filter_log...
sqwiki: 26
sqwiki: 26 rows.
sqwiki: Done.
-----------------------------------------------------------------
testwiki
-----------------------------------------------------------------
testwiki: Purging old IP Address data from abuse_filter_log...
testwiki: 75
testwiki: 75 rows.
testwiki: Done.
-----------------------------------------------------------------
ukwiki
-----------------------------------------------------------------
ukwiki: Purging old IP Address data from abuse_filter_log...
ukwiki: 26
ukwiki: 26 rows.
ukwiki: Done.
-----------------------------------------------------------------
wikidatawiki
-----------------------------------------------------------------
wikidatawiki: Purging old IP Address data from abuse_filter_log...
wikidatawiki: 171
wikidatawiki: 171 rows.
wikidatawiki: Done.
-----------------------------------------------------------------
zerowiki
-----------------------------------------------------------------
zerowiki: Purging old IP Address data from abuse_filter_log...
zerowiki: 0 rows.
zerowiki: Done.
-----------------------------------------------------------------
zhwiki
-----------------------------------------------------------------
zhwiki: Purging old IP Address data from abuse_filter_log...
zhwiki: 75
zhwiki: 75 rows.
zhwiki: Done.