diff options
| author | Erich Eckner <git@eckner.net> | 2019-12-06 09:28:57 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2019-12-06 09:28:57 +0100 |
| commit | ae2f05e4853bc4781635b156a0ade9411187f7d4 (patch) | |
| tree | 1574d101fa13752a2ca48408a75faa1f894153fc /misc | |
| parent | 36564f45e007b4fd832c187bc406574a13d68766 (diff) | |
| download | builder-ae2f05e4853bc4781635b156a0ade9411187f7d4.tar.xz | |
bin/bootstrap-mysql: `calculate_maximal_moveable_set`(): deliberately break packages which did not successfully build for 1 day
Diffstat (limited to 'misc')
| -rw-r--r-- | misc/database-layout.dump | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump index cf75f18..8954513 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -197,6 +197,13 @@ DELETE `replaced_bpir`,`moveable_bpir` ON `replaced_bpir`.`replaced_by`=`moveable_bpir`.`id` JOIN `binary_packages_in_repositories` AS `repl_bpir` ON `repl_bpir`.`id`=`replaced_bpir`.`id` AND NOT `repl_bpir`.`is_to_be_deleted` + JOIN `binary_packages` AS `repl_bp` + ON `repl_bpir`.`package`=`repl_bp`.`id` + JOIN `build_assignments` AS `repl_ba` + ON `repl_bp`.`build_assignment`=`repl_ba`.`id` AND NOT EXISTS ( +SELECT 1 + FROM `failed_builds` + WHERE `failed_builds`.`date`<=ADDTIME(NOW(),"-1 00:00:00") AND `failed_builds`.`build_assignment`=`repl_ba`.`id`) JOIN `install_target_providers` ON `repl_bpir`.`package`=`install_target_providers`.`package` JOIN `repositories` AS `repl_r` |