Several times today transactions from videoscalers tmh100 have piled up on db1040. They apparently run this sort of query:
INSERT /* WebVideoTranscodeJob::run */ IGNORE INTO transcode (transcode_image_name, transcode_key, transcode_time_startwork, transcode_error, transcode_final_bitrate) VALUES ('Night_of_the_Living_Dead_(1968_film).webm', '160p.ogv', '20150430131138', '', '0')
Then hang around blocking stuff without committing until icinga alerts go off and they risk getting killed. Do we expect to hold locks for the duration of the transcoding? Is this a recent change? If not, why it this suddenly happening now?
EDIT: Transactions do not seem to keep being open right now, but connections does, until they timeout on the database.