User:Dispenser/Transcode errors

From Wikimedia Commons, the free media repository
Jump to: navigation, search
-- 2> /dev/null; date; echo '
/* Transcode errors
 * License: Public Domain
 * Run time: 1 minute
 */
SELECT
  CONCAT("[[:File:", REPLACE(transcode_image_name, "_", " "), "]]") AS "File",
  CONCAT("align=right | ", ROUND(img_size / 1024 / 1024, 1)) AS "Size (MB)",
  GROUP_CONCAT(transcode_key ORDER BY 1 SEPARATOR ", ") AS "Video key",
  REPLACE(REGEXP_REPLACE(
   SUBSTRING_INDEX(SUBSTRING_INDEX(transcode_error, "Exitcode: ", -1), "\n", 1),
   "mwstore[&:][^ \"]+", "[snipped]"),
   CONCAT("File:", REPLACE(transcode_image_name,"_"," "), ": "), ""
  ) AS Exitcode
FROM transcode
JOIN image ON img_name=transcode_image_name /* Rename check */
WHERE transcode_time_addjob>=img_timestamp
AND (transcode_time_success IS NULL OR transcode_time_success<transcode_time_error)
GROUP BY Exitcode, transcode_image_name
ORDER BY img_media_type, Exitcode, transcode_image_name;

;-- ' | mysql -ch commonswiki.labsdb commonswiki_p --html > ~/public_html/temp/logs/badtranscodes.html; date
See also: Special:TimedMediaHandler and T157028


File Size (MB) Video key Exitcode
File:2017.4.10 新日本プロレス「戦国炎舞 KIZNA Presents SAKURA GENESIS 2017」両国国技館大会一夜明け会見.webm 414.2 720p.webm * An unknown error occurred in storage backend "local-swift-eqiad".
File:Academic writing, part 2.webm 291.8 360p.ogv * An unknown error occurred in storage backend "local-swift-eqiad".
File:Adding-Diverse-Noncanonical-Backbones-to-Rosetta-Enabling-Peptidomimetic-Design-pone.0067051.s003.ogv 0.1 160p.webm, 240p.webm, 360p.webm, 480p.webm 1
File:Bubbles-Are-Departures-from-Equilibrium-Housing-Markets-Evidence-from-Singapore-and-Taiwan-pone.0166004.s003.ogv 0.8 160p.webm, 240p.webm, 360p.webm 1
File:Common-Transcriptional-Mechanisms-for-Visual-Photoreceptor-Cell-Differentiation-among-Pancrustaceans-pgen.1004484.s019.ogv 1.3 160p.webm, 240p.webm, 360p.webm, 480p.webm, 720p.webm 1
File:Cowpers Cycles thermiques et mécaniques vidéo.ogv 0.2 160p.webm, 240p.webm, 360p.webm, 480p.webm, 720p.webm 1
File:Evaluating-frequency-and-quality-of-pathogen-specific-T-cells-ncomms13264-s5.ogv 0.4 160p.webm, 240p.webm, 360p.webm, 480p.webm, 720p.webm 1
File:Gene-Transfer-to-Chicks-Using-Lentiviral-Vectors-Administered-via-the-Embryonic-Chorioallantoic-pone.0036531.s004.ogv 0.7 160p.webm, 240p.webm, 360p.webm, 480p.webm 1
File:Inclusion-flotation-driven-channel-segregation-in-solidifying-steels-ncomms6572-s4.ogv 0.7 160p.webm, 240p.webm, 360p.webm 1
File:KIF5B-and-Nup358-Cooperatively-Mediate-the-Nuclear-Import-of-HIV-1-during-Infection-ppat.1005700.s006.ogv 1.2 160p.webm, 240p.webm, 360p.webm, 480p.webm, 720p.webm 1
File:KIF5B-and-Nup358-Cooperatively-Mediate-the-Nuclear-Import-of-HIV-1-during-Infection-ppat.1005700.s007.ogv 0.5 160p.webm, 240p.webm, 360p.webm, 480p.webm, 720p.webm 1
File:Pont de Saint-Nazaire en bateau.ogv 8.6 160p.webm, 240p.webm, 360p.webm, 480p.webm, 720p.webm 1
File:Saison des pluies à Yaoundé.ogv 7.8 160p.webm, 240p.webm 1
File:Schmuckmuseum.ogv 2.1 160p.webm, 240p.webm, 360p.webm, 480p.webm 1
File:SviluppoUrbanoCasina.webm 0.8 1080p.webm, 160p.webm, 240p.webm, 360p.webm, 480p.webm, 720p.webm 1
File:The-Cell-Cycle-Timing-of-Centromeric-Chromatin-Assembly-in-Drosophila-Meiosis-Is-Distinct-from-pbio.1001460.s009.ogv 0.0 160p.webm, 240p.webm, 360p.webm, 480p.webm 1
File:The Return of Ulysses (1908).webm 21.6 160p.ogv, 240p.ogv, 360p.ogv, 480p.ogv 134
File:3D-Ultrastructural-Organization-of-Whole-Chlamydomonas-reinhardtii-Cells-Studied-by-Nanoscale-Soft-pone.0053293.s007.ogv 5.7 1080p.ogv 136
File:A-Computational-Clonal-Analysis-of-the-Developing-Mouse-Limb-Bud-pcbi.1001071.s011.ogv 1.5 720p.ogv 136
File:DOSB Einkleidung Olympiamannschaft Einkleidung Sportler.ogv 27.2 240p.ogv 136
File:DOSB Einkleidung Olympiamannschaft Making-Of.ogv 35.4 240p.ogv 136
File:DOSB Einkleidung Olympiamannschaft Prominente Funktionaere.ogv 48.0 240p.ogv 136
File:DOSB Einkleidung Olympiamannschaft Prominente Sportler.ogv 7.9 240p.ogv 136
File:DOSB Einkleidung Olympiamannschaft Sonstiges.ogv 17.4 240p.ogv 136
File:DOSB Einkleidung Olympiamannschaft Vor Beginn.ogv 45.6 240p.ogv 136
File:Entrevistas na Campus Party sobre a Wikipedia (2).ogv 10.8 480p.ogv 136
File:Viking Fest Parade 2009 in Poulsbo, WA — VIDEO 001.ogv 93.8 480p.ogv 136
File:Viking Fest Parade 2009 in Poulsbo, WA — VIDEO 002.ogv 49.5 480p.ogv 136
File:Viking Fest Parade 2009 in Poulsbo, WA — VIDEO 003.ogv 30.6 480p.ogv 136
File:Viking Fest Parade 2009 in Poulsbo, WA — VIDEO 004.ogv 13.7 480p.ogv 136
File:Viking Fest Parade 2009 in Poulsbo, WA — VIDEO 028.ogv 88.1 480p.ogv 136
File:DevSummit2016-Code-Review.webm 2339.8 1080p.webm 137
File:Fantastic Contraption mixed reality Twitch stream, January 21, 2016.webm 1139.3 720p.webm 137
File:Moscow Ring Railway full trip - view from ES2G train.webm 2632.6 1080p.webm 137
File:Quadrature ABC+A.ogv 4.5 160p.ogv, 240p.ogv, 360p.ogv, 480p.ogv 137
File:Trstenica 20130925 075633.ogv 15.3 160p.ogv, 240p.ogv, 360p.ogv, 480p.ogv, 720p.ogv 137
File:U Postupu 20140216 111253.ogv 3.7 160p.ogv, 240p.ogv, 360p.ogv, 480p.ogv, 720p.ogv 137
File:Zona 20140111 171421.ogv 15.4 160p.ogv, 240p.ogv, 360p.ogv, 480p.ogv, 720p.ogv 137
File:Zona 20140111 172041.ogv 8.2 160p.ogv, 240p.ogv, 360p.ogv, 480p.ogv, 720p.ogv 137
File:NorthPoleApril14.webm 0.4 160p.ogv 139
File:1937 Великий гражданин.webm 1484.7 480p.ogv 153
File:2017 Budget Address.webm 2176.6 1080p.webm 153
File:Aurat, 1940.webm 2923.8 1080p.ogv, 1080p.webm 153
File:Awaara (1951).webm 3188.6 1080p.ogv, 1080p.webm 153
File:Baiju Bawara (1952).webm 3217.3 1080p.ogv, 1080p.webm 153
File:Barsaat (1949).webm 2535.8 1080p.webm 153
File:Bernie Sanders - full 2010-12-10 filibuster.webm 1645.0 360p.ogv 153
File:Deževen Kašelj - deževen Ig.webm 3209.6 1080p.ogv 153
File:Državno prvenstvo v boksu 2016 Ravne na Koroškem.webm 2386.9 1080p.ogv 153
File:Futures Lectures 2016.webm 1321.5 1080p.webm 153
File:Gradovi na razpotju - Dvorec Krumperk.webm 1298.6 1080p.webm 153
File:Ig - Rudnik.webm 3763.1 1080p.ogv 153
File:Iskrin okoljski seminar- Gensko spremenjeni organizmi.webm 595.7 1080p.webm 153
File:Javna tribuna Kluba prijateljev ČKZ - Morija vzdolž juga EU.webm 1773.0 1080p.webm 153
File:Kašelj - Orle - Rudnik.webm 3237.5 1080p.ogv 153
File:Kašelj - Rudnik via Orle.webm 4079.3 1080p.ogv 153
File:Marko Kržan - Skica aktualnega družbeno-ekonomskega stanja v Sloveniji.webm 1342.2 1080p.webm 153
File:Mela (1948).webm 2086.3 1080p.webm 153
File:Moscow Ring Railway full trip - view from ES2G train.webm 2632.6 1080p.ogv, 720p.ogv 153
File:Mr & Mrs 55 (1955).webm 2264.8 1080p.webm 153
File:Munimji (1955).webm 2115.3 1080p.webm 153
File:Nairb's Dash Cam- 2015-12-05 Over the bay bridge and back.webm 3526.0 1080p.ogv 153
File:Okrogla miza o Impro sceni na slovenskem.webm 1028.5 1080p.webm 153
File:Pance.webm 3657.4 1080p.ogv 153
File:Pres. Clinton at WH Conf. on Childhood Development (1997).webm 1366.8 480p.ogv 153
File:Preventivna prireditev za motoriste na Koroškem 2015 - Relaxov poligon v Dravogradu.webm 2298.2 1080p.ogv 153
File:Q&A-Muslim’s Choice Dawah or Destruction-by dr. zakir naik.webm 560.8 1080p.webm 153
File:Rail tunnels in Sochi, view from cabin of 2ES4K.webm 1828.6 1080p.ogv 153
File:Rudnik - Kašelj via Orle.webm 3211.3 1080p.ogv 153
File:Rudnik - Orle.webm 2849.3 1080p.ogv 153
File:Sašo Furlan - Kriza evroobmočja v kontekstu krize kapitalizma.webm 1250.2 1080p.webm 153
File:Shree 420, Hindi film.webm 3504.8 1080p.ogv, 1080p.webm 153
File:Strokovni posvet- Priložnost in pasti e-revij.webm 3169.1 1080p.webm, 720p.webm 153
File:TEVA GRC - CALCIT KAMNIK (2012-12-14).webm 3679.5 1080p.ogv 153
File:The Inaugural Parade - 2017-01-22.webm 3484.5 720p.ogv 153
File:United States Senate - Thursday, Feb 9, 2017.webm 2880.0 360p.ogv 153
File:United States Senate Floor - 2017-02-15.webm 1911.6 360p.ogv 153
File:Vladimir Putin's press conference on 2012-12-20.webm 990.0 480p.ogv 153
File:Vzpon na Javor.webm 2896.2 1080p.ogv 153
File:Za Slovenijo brez zavržene hrane - kako naprej- - Prenos V ŽIVO - live streaming.webm 1495.6 1080p.webm 153
File:День города Донецка 2016 . Мотопробег из Луганска и назад по прифронтовым городам ЛНР и ДНР.webm 2935.9 1080p.ogv 153
File:【哲學星期五@台北】如何喚醒一個沉睡的民族─台灣獨立運動的歷史與展望 20160311.webm 2183.6 1080p.webm 153
File:특집 2017 서울국제모터쇼 프레스데이 현장스케치 (수정).webm 2853.0 1080p.ogv 153
File:Chained streams.ogv 2.4 160p.webm, 240p.webm 69
File:Rakonto 04 eng.ogv 16.5 160p.webm, 240p.webm 69
File:Autonomous bus trials South Perth - 3.ogv 47.1 1080p.ogv, 1080p.webm, 160p.ogv, 160p.webm, 240p.ogv, 240p.webm, 360p.ogv, 360p.webm, 480p.ogv, 480p.webm, 720p.ogv, 720p.webm Source not found