CREATE TEMPORARY TABLE `pkg_hashes` (`pkgid` BIGINT, `sha512sum` VARCHAR(128));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2019-07-15T15:17:54.NkUSnm.infile.1" INTO TABLE `pkg_hashes`;
UPDATE `binary_packages` JOIN `pkg_hashes` ON `pkg_hashes`.`pkgid`=`binary_packages`.`id` SET `binary_packages`.`sha512sum`=`pkg_hashes`.`sha512sum`;
COMMIT;
CREATE TEMPORARY TABLE `pl` (`pkgid` BIGINT,`lib` VARCHAR(128),`relation` VARCHAR(2),`epoch` MEDIUMINT,`version` VARCHAR(32));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2019-07-15T15:17:54.NkUSnm.infile.2" INTO TABLE `pl`;
INSERT IGNORE INTO `install_targets` (`name`) SELECT DISTINCT `pl`.`lib` FROM `pl`;
COMMIT;
INSERT IGNORE INTO `versions` (`epoch`,`version`) SELECT DISTINCT `pl`.`epoch`,`pl`.`version` FROM `pl`;
COMMIT;
INSERT IGNORE INTO `install_target_providers` (`package`,`install_target`,`install_target_is_group`,`version`) SELECT `pl`.`pkgid`,`install_targets`.`id`,0,`versions`.`id` FROM `install_targets` JOIN `pl` ON `pl`.`lib`=`install_targets`.`name` JOIN `versions` ON `versions`.`epoch`=`pl`.`epoch` AND `versions`.`version`=`pl`.`version`;
COMMIT;
CREATE TEMPORARY TABLE `nl` (`pkgid` BIGINT,`dep_type` VARCHAR(32),`lib` VARCHAR(128),`relation` VARCHAR(2),`epoch` MEDIUMINT,`version` VARCHAR(32));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.query.2019-07-15T15:17:54.NkUSnm.infile.3" INTO TABLE `nl`;
INSERT IGNORE INTO `install_targets` (`name`) SELECT DISTINCT `nl`.`lib` FROM `nl`;
COMMIT;
INSERT IGNORE INTO `versions` (`epoch`,`version`) SELECT DISTINCT `nl`.`epoch`,`nl`.`version` FROM `nl`;
COMMIT;
DELETE `dependencies` FROM `nl` JOIN `dependencies` ON `dependencies`.`depending_on`=`nl`.`pkgid`;
INSERT IGNORE INTO `dependencies` (`dependent`,`depending_on`,`dependency_type`,`version_relation`,`version`) SELECT `nl`.`pkgid`,`install_targets`.`id`,`dependency_types`.`id`,`nl`.`relation`,`versions`.`id` FROM `install_targets` JOIN `dependency_types` ON `dependency_types`.`name`=`nl`.`dep_type` JOIN `nl` ON `nl`.`lib`=`install_targets`.`name` JOIN `versions` ON `versions`.`epoch`=`nl`.`epoch` AND `versions`.`version`=`nl`.`version`;
COMMIT;
UPDATE `build_assignments` SET `build_assignments`.`is_broken`=0, `build_assignments`.`priority`=0, `build_assignments`.`return_date`=NOW() WHERE `build_assignments`.`id`=from_base64("MjgyODAy");
COMMIT;
INSERT INTO `binary_packages_in_repositories` (`package`,`repository`,`is_to_be_deleted`) VALUES (373524,33,0) ON DUPLICATE KEY UPDATE `id`=LAST_INSERT_ID(`binary_packages_in_repositories`.`id`);
SELECT LAST_INSERT_ID();
COMMIT;
INSERT IGNORE INTO `binary_packages` (`build_assignment`,`epoch`,`pkgver`,`pkgrel`,`has_issues`,`is_tested`,`pkgname`,`architecture`,`sub_pkgrel`) SELECT `binary_packages`.`build_assignment`,`binary_packages`.`epoch`,`binary_packages`.`pkgver`,`binary_packages`.`pkgrel`,`binary_packages`.`has_issues`,`binary_packages`.`is_tested`,`binary_packages`.`pkgname`,`binary_packages`.`architecture`,`binary_packages`.`sub_pkgrel`+1 FROM `binary_packages` JOIN `pkg_hashes` ON `pkg_hashes`.`pkgid`=`binary_packages`.`id` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `package_sources` ON `build_assignments`.`package_source`=`package_sources`.`id` JOIN `toolchain_order` AS `late` ON `late`.`pkgbase`=`package_sources`.`pkgbase` JOIN `toolchain_order` AS `early` ON `early`.`number`<`late`.`number` AND `early`.`pkgbase`!=`late`.`pkgbase` JOIN `package_sources` AS `early_ps` ON `early`.`pkgbase`=`early_ps`.`pkgbase` JOIN `build_assignments` AS `early_ba` ON `early_ps`.`id`=`early_ba`.`package_source` JOIN `binary_packages` AS `early_bp` ON `early_ba`.`id`=`early_bp`.`build_assignment` WHERE (`early_bp`.`architecture`=`binary_packages`.`architecture` OR `early_bp`.`architecture`=1 OR `binary_packages`.`architecture`=1) AND NOT EXISTS (SELECT 1 FROM `binary_packages` AS `early_bp` JOIN `binary_packages_in_repositories` AS `early_bpir` ON `early_bp`.`id`=`early_bpir`.`package` JOIN `repositories` AS `early_r` ON `early_bpir`.`repository`=`early_r`.`id` WHERE `early_r`.`is_on_master_mirror` AND `early_bp`.`build_assignment`=`early_ba`.`id`);
INSERT IGNORE INTO `binary_packages_in_repositories` (`package`,`repository`,`is_to_be_deleted`) SELECT `new_bp`.`id`,9,0 FROM `binary_packages` AS `built_bp` JOIN `pkg_hashes` ON `built_bp`.`id`=`pkg_hashes`.`pkgid` JOIN `binary_packages` AS `new_bp` ON `built_bp`.`build_assignment`=`new_bp`.`build_assignment` AND `built_bp`.`epoch`=`new_bp`.`epoch` AND `built_bp`.`pkgver`=`new_bp`.`pkgver` AND `built_bp`.`pkgrel`=`new_bp`.`pkgrel` AND `built_bp`.`has_issues`=`new_bp`.`has_issues` AND `built_bp`.`is_tested`=`new_bp`.`is_tested` AND `built_bp`.`pkgname`=`new_bp`.`pkgname` AND `built_bp`.`architecture`=`new_bp`.`architecture` AND `built_bp`.`sub_pkgrel`+1=`new_bp`.`sub_pkgrel`;
INSERT IGNORE INTO `dependencies` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`) SELECT `new_bp`.`id`,`dependencies`.`depending_on`,`dependencies`.`dependency_type`,`dependencies`.`version`,`dependencies`.`version_relation` FROM `dependencies` JOIN `binary_packages` AS `built_bp` ON `dependencies`.`dependent`=`built_bp`.`id` JOIN `pkg_hashes` ON `built_bp`.`id`=`pkg_hashes`.`pkgid` JOIN `binary_packages` AS `new_bp` ON `built_bp`.`build_assignment`=`new_bp`.`build_assignment` AND `built_bp`.`epoch`=`new_bp`.`epoch` AND `built_bp`.`pkgver`=`new_bp`.`pkgver` AND `built_bp`.`pkgrel`=`new_bp`.`pkgrel` AND `built_bp`.`has_issues`=`new_bp`.`has_issues` AND `built_bp`.`is_tested`=`new_bp`.`is_tested` AND `built_bp`.`pkgname`=`new_bp`.`pkgname` AND `built_bp`.`architecture`=`new_bp`.`architecture` AND `built_bp`.`sub_pkgrel`+1=`new_bp`.`sub_pkgrel`;
INSERT IGNORE INTO `install_target_providers` (`package`,`install_target`) SELECT `new_bp`.`id`,`install_target_providers`.`install_target` FROM `install_target_providers` JOIN `binary_packages` AS `built_bp` ON `install_target_providers`.`package`=`built_bp`.`id` JOIN `pkg_hashes` ON `built_bp`.`id`=`pkg_hashes`.`pkgid` JOIN `binary_packages` AS `new_bp` ON `built_bp`.`build_assignment`=`new_bp`.`build_assignment` AND `built_bp`.`epoch`=`new_bp`.`epoch` AND `built_bp`.`pkgver`=`new_bp`.`pkgver` AND `built_bp`.`pkgrel`=`new_bp`.`pkgrel` AND `built_bp`.`has_issues`=`new_bp`.`has_issues` AND `built_bp`.`is_tested`=`new_bp`.`is_tested` AND `built_bp`.`pkgname`=`new_bp`.`pkgname` AND `built_bp`.`architecture`=`new_bp`.`architecture` AND `built_bp`.`sub_pkgrel`+1=`new_bp`.`sub_pkgrel`;
DELETE `binary_packages_in_repositories` FROM `binary_packages_in_repositories` JOIN `pkg_hashes` ON `pkg_hashes`.`pkgid`=`binary_packages_in_repositories`.`package` WHERE `binary_packages_in_repositories`.`repository`=9;
COMMIT;
UPDATE `binary_packages` SET `binary_packages`.`has_issues`=0, `binary_packages`.`is_tested`=0 WHERE `binary_packages`.`id` IN (from_base64("MzczNTI0")
);
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`.`currently_building`=from_base64("MjgyODAy");
COMMIT;
CREATE TEMPORARY TABLE `loops_to_delete` (`loop` MEDIUMINT);
INSERT IGNORE INTO `loops_to_delete` SELECT `build_dependency_loops`.`loop` FROM `build_dependency_loops` JOIN `binary_packages` ON `build_dependency_loops`.`build_assignment`=`binary_packages`.`build_assignment` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` WHERE NOT `binary_packages_in_repositories`.`repository`=9;
COMMIT;
DELETE FROM `build_dependency_loops` WHERE EXISTS (SELECT 1 FROM `loops_to_delete` WHERE `loops_to_delete`.`loop`=`build_dependency_loops`.`loop`);
DROP TEMPORARY TABLE `loops_to_delete`;