User:Dispenser/Transcode errors

-- 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(SUBSTRING_INDEX(SUBSTRING_INDEX(transcode_error, "Exitcode: ", -1), "\n", 1),
   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 Exitcode, transcode_image_name;
/* Avoid transcode.transcode_image_name case-insensitive servers */
;-- ' | mysql -ch commonswiki-p.rrdb commonswiki_p --html > ~/public_html/temp/logs/badtranscodes.html; date

Report disabled, use Special:TimedMediaHandler. Report maybe re-enabled when files need to be sorted.

Last modified on 4 April 2014, at 20:24