https://bugzilla.wikimedia.org/show_bug.cgi?id=65511
Bug ID: 65511
Summary: Investigate cause of new files that have empty
oi_archive_name
Product: Wikimedia
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Media storage
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected]
Web browser: ---
Mobile Platform: ---
[Sort of related/split off from bug 53770]
In regards to files where a history entry appears to be missing. A main cause
of this was fixed in mid october 2013 (bug 54736). However it looks like there
is still a second bug causing this issue, but in much smaller number:
MariaDB [commonswiki_p]> select substring( oi_timestamp, 1, 6 ), count(*) from
oldimage where oi_archive_name = '' and oi_timestamp > '20130800000000' group
by substring( oi_timestamp, 1, 6 );
+---------------------------------+----------+
| substring( oi_timestamp, 1, 6 ) | count(*) |
+---------------------------------+----------+
| 201308 | 492 |
| 201309 | 2563 |
| 201310 | 196 |
[After this point, bug 54736 is fixed]
| 201311 | 8 |
| 201312 | 21 |
| 201401 | 5 |
| 201402 | 7 |
| 201403 | 7 |
| 201404 | 51 |
| 201405 | 2 |
+---------------------------------+----------+
10 rows in set (27.67 sec)
Additionally, the newer files with this issue are not consistent with the
symptoms of the old bug (same timestamp, upload wizard).
So we should figure out remaining causes of this type of issue, and stop it
from happening in the future.
------
Example files for reference:
[[commons:File:MG_8994_(2438128514).jpg]]
[[commons:File:2011_Youth_Fishing_Tourney1_(6329969605).jpg]]
[[commons:File:US_Route_522_-_Virginia_(6327355022).jpg]]
[[commons:File:UR-GAH_(7273397624).jpg]]
[[commons:File:Eurocopter_EC_725_Caracal,_Mexico_-_Air_Force_JP7645622.jpg]]
[[commons:File:ABS-5368.0-InternationalTradeInGoodsServicesAustralia-MonthlyCombinedSeasonalAdjustmentFactors-ServicesCreditsOtherTransport-A3343460V.svg]]
[[commons:File:Forchheim_bei_Freystadt_NM_010.jpg]]
[[commons:File:Airbus_A320-214,_Juneyao_Airlines_JP6477864.jpg]]
[[commons:File:Metrocar_cab_CCTV_camera,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010.jpg]]
[[commons:File:Locomotive_BL1,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010.jpg]]
[[commons:File:Metrocar_motor,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010.jpg]]
[[commons:File:Metrocar_axle,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(1).jpg]]
[[commons:File:Metrocar_axles,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(1).jpg]]
[[commons:File:Metrocar_axle_bars,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(2).jpg]]
[[commons:File:Metrocar_axle_bars,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(1).jpg]]
[[commons:File:Metrocar_axle,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(2).jpg]]
[[commons:File:Metrocar_drivers_cab_interior,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(4).jpg]]
[[commons:File:Metrocar_drivers_cab_interior,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(2).jpg]]
[[commons:File:Road-rail_vehicle,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(1).jpg]]
[[commons:File:Depot_yard,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(1).jpg]]
[[commons:File:Depot_yard,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(2).jpg]]
[[commons:File:Road-rail_vehicle,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(2).jpg]]
[[commons:File:Locomotive_BL3,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010.jpg]]
[[commons:File:Metrocar_axles,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010_(2).jpg]]
[[commons:File:Depot_approach_tracks,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010.jpg]]
[[commons:File:Depot_interior,_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010.jpg]]
[[commons:File:1899_Aveling_&_Porter_R10_steam_road_roller_No_4307_"Coquet_Lass"_(NL_2561),_Tyne_and_Wear_Metro_depot_open_day,_8_August_2010.jpg]]
[[commons:File:Alex_Martinez.png]]
[[commons:File:Galician_market_square_in_Skansen,_Sanok_-_GOPR_house.jpg]]
[[commons:File:Sepolcro_di_agnese_e_clemenza_durazzo,_inizio_del_XV_secolo,_01.JPG]]
[[commons:File:Thomas_equation_traveling_wave_plot_9.gif]]
[[commons:File:Anerkennung_des_intersexuellen_Geschlechts.png]]
[[commons:File:Papa_Ciro_siege.jpg]]
[[commons:File:Studentenwappen_der_Talavija.jpg]]
[[commons:File:Monaster_Cetyński_01.jpg]]
[[commons:File:HMS_Danae_Art.IWMART1303.jpg]]
[[commons:File:ABS-6401.0-ConsumerPriceIndexAustralia-Cpi-GroupSubgroupExpenditureClassContributionChangeInAllGroupsIndexesByCapitalCity-ChangeInContributionTotalCpi-Communication-Australia-A3602251C.svg]]
[[commons:File:Нижний_Новгород_(указатель_города).JPG]]
[[commons:File:Cecco_bravo,_san_michele_arcangelo_e_angeli_adoranti,_1635_ca.,_04.JPG]]
[[commons:File:FvfMalacananMuseum9874_02.JPG]]
[[commons:File:Kairounan.jpg]]
[[commons:File:Boeing_737-8AS,_Ryanair_JP7742994.jpg]]
[[commons:File:Montenstr8_München.jpg]]
[[commons:File:Mettingen_Rainer_Schepper_01.jpg]]
[[commons:File:WMRS_Educational_program,_UBSM,_2014-8.jpg]]
[[commons:File:Pone.0057779.g004.jpg]]
[[commons:File:Crimea-sevastopol-orthographic-projection2.svg]]
[[commons:File:Montes_anys_20.jpg]]
[[commons:File:Ken_Yaremchuk_1984.JPG]]
[[commons:File:Yash_Early_career.jpg]]
[[commons:File:Luca_carey_morgan_LCM.jpg]]
[[commons:File:Geisendorf_ritningsstämpel.jpg]]
[[commons:File:CH-NB_-_Maloja,_Ortsteilansicht_-_EAD-WEHR-14959-B.jpg]]
[[commons:File:Newport,_Oregon.jpg]]
[[commons:File:20140416_Heden_door_Ruurd_Hallema_Paasloo.jpg]]
[[commons:File:Chasteuil-v.jpg]]
[[commons:File:Kit_body_bluestripesleft.png]]
[[commons:File:Kit_body_DSVAway09.png]]
[[commons:File:CH-NB_-_Maloja,_Ortsteilansicht_-_EAD-WEHR-14959-B.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_122.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_117.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_123.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_121.jpg]]
[[commons:File:Billerbeck,_Abtei_Gerleve_--_2014_--_7625.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_124.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_126.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_128.jpg]]
[[commons:File:Canadian_Official_War_Photographs_(BL_l.r.233.b.57.v1_f078r).jpg]]
[[commons:File:Tibi_Fall-Winter_2010_129.jpg]]
[[commons:File:The_Foolish_Age_(1919)_1.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_125.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_131.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_135.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_134.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_136.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_137.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_139.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_141.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_142.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_140.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_145.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_148.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_146.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_147.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_151.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_149.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_153.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_152.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_154.jpg]]
[[commons:File:20140416_Heden_door_Ruurd_Hallema_Paasloo.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_157.jpg]]
[[commons:File:Tibi_Fall-Winter_2010_161.jpg]]
[[commons:File:Skanes_jarnvagsnat_Oresundsbanan.svg]]
[[commons:File:Beatrix_of_the_Netherlands_1980.jpg]]
[[commons:File:Yenovk_shahen_1915.jpg]]
[[commons:File:新・大槌町役場庁舎.jpg]]
[[commons:File:Jorge_Amado_Gabriel_García_Márquez.jpg]]
[[commons:File:Spor.jpg]]
[[commons:File:Nesmith_Cougar_N9092R_Opa_Locka_08.02.71_edited-3.jpg]]
[[commons:File:Природа_українського_краю.JPG]]
[[commons:File:SYNTAX(1813)_-_13_-_Doctor_Syntax,_At_a_Review.jpg]]
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
