CREATE TEMPORARY TABLE `failures` (`date` TIMESTAMP,`reason` SMALLINT,`log_file` VARCHAR(512));
INSERT IGNORE INTO `failures` (`date`,`reason`,`log_file`) VALUES  (from_base64("MjAyMy0wNy0xM1QwNDo1MjozOQ=="),4,from_base64("bGludXgtZ2FsaWxlby1nZW4yLjAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAuMzc2NTc2NTk4NjkxNjQyZDZjYWQ3NDg1ZDNhNjlkODVmMzhhM2IwMi5leHRyYS5pNjg2LjIwMjMtMDctMTNUMDQ6NTI6MzkuYnVpbGQtbG9nLmd6")), (from_base64("MjAyMy0wNy0xM1QwNDo1MzozOA=="),4,from_base64("bGludXgtZ2FsaWxlby1nZW4yLjAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAuMzc2NTc2NTk4NjkxNjQyZDZjYWQ3NDg1ZDNhNjlkODVmMzhhM2IwMi5leHRyYS5pNjg2LjIwMjMtMDctMTNUMDQ6NTM6MzguYnVpbGQtbG9nLmd6")), (from_base64("MjAyMy0wNy0xM1QwNDo1NTowMw=="),4,from_base64("bGludXgtZ2FsaWxlby1nZW4yLjAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAuMzc2NTc2NTk4NjkxNjQyZDZjYWQ3NDg1ZDNhNjlkODVmMzhhM2IwMi5leHRyYS5pNjg2LjIwMjMtMDctMTNUMDQ6NTU6MDMuYnVpbGQtbG9nLmd6")), (from_base64("MjAyMy0wNy0xM1QwNDo1NTo1OA=="),4,from_base64("bGludXgtZ2FsaWxlby1nZW4yLjAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAuMzc2NTc2NTk4NjkxNjQyZDZjYWQ3NDg1ZDNhNjlkODVmMzhhM2IwMi5leHRyYS5pNjg2LjIwMjMtMDctMTNUMDQ6NTU6NTguYnVpbGQtbG9nLmd6"));
INSERT IGNORE INTO `failed_builds` (`build_slave`,`build_assignment`,`date`,`reason`,`log_file`,`log_file_exists`) SELECT from_base64("Mjg="),from_base64("MTg3NzU2OQ=="),`failures`.`date`,`failures`.`reason`,`failures`.`log_file`,1 FROM `failures`;
DROP TEMPORARY TABLE `failures`;
COMMIT;
UPDATE `build_assignments` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` SET `build_assignments`.`is_broken`=1,`build_assignments`.`priority`=0,`package_sources`.`upstream_flag_date`=from_base64("MDAwMC0wMC0wMCAwMDowMDowMA==") WHERE `build_assignments`.`id`=from_base64("MTg3NzU2OQ==");
COMMIT;
UPDATE `build_slaves` SET `build_slaves`.`currently_building`=NULL, `build_slaves`.`last_action`=NULL, `build_slaves`.`logged_lines`=NULL, `build_slaves`.`trials`=NULL WHERE `build_slaves`.`id`=from_base64("Mjg=");