Last modified: 2014-10-21 16:47:34 UTC
[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]]
2cfce9f might have reduced that instances of this happening when there are network problems. We don't want "non-answer" file existing checks to count as "does not exist"...
Still, it would be nice to know how many of these files *started off* with the file missing.
So did anybody ever really investigate (as this task is still open)? And if not, does it still makes sense to keep this ticket open? bawulff? Aaron?