summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-07 08:40:09 +0200
committerErich Eckner <git@eckner.net>2018-05-07 08:40:09 +0200
commit684e100df759d509d615a0e711b3750c6d4d2211 (patch)
treeef6b08e0cffee0286443dccdd11cd2b8edc11050 /lib/mysql-functions
parent5abcb8927e118afc94ed56006a189190a8cf7679 (diff)
downloadbuilder-684e100df759d509d615a0e711b3750c6d4d2211.tar.xz
lib/mysql-functions: mysql_cleanup: remove unnecessary cleanups which are handled by foreign keys (and tend to create deadlocks)
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions32
1 files changed, 0 insertions, 32 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 71097cb..a027b2f 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -780,30 +780,6 @@ mysql_cleanup() {
printf 'FROM `binary_packages`'
mysql_join_binary_packages_repositories
printf ' WHERE `repositories`.`name`="to-be-decided";\n'
- # remove dependencies w/o binary_package or install_target
- printf '%s FROM `dependencies` ' \
- "${operator}"
- printf 'WHERE NOT EXISTS '
- printf '('
- printf 'SELECT * FROM `binary_packages` '
- printf 'WHERE `dependencies`.`dependent`=`binary_packages`.`id`'
- printf ') OR NOT EXISTS '
- printf '('
- printf 'SELECT * FROM `install_targets` '
- printf 'WHERE `dependencies`.`depending_on`=`install_targets`.`id`'
- printf ');\n'
- # remove install_target_providers w/o binary_package or install_target
- printf '%s FROM `install_target_providers` ' \
- "${operator}"
- printf 'WHERE NOT EXISTS '
- printf '('
- printf 'SELECT * FROM `binary_packages` '
- printf 'WHERE `install_target_providers`.`package`=`binary_packages`.`id`'
- printf ') OR NOT EXISTS '
- printf '('
- printf 'SELECT * FROM `install_targets` '
- printf 'WHERE `install_target_providers`.`install_target`=`install_targets`.`id`'
- printf ');\n'
# remove build_assignments w/o binary_package
printf '%s FROM `build_assignments` ' \
"${operator}"
@@ -822,14 +798,6 @@ mysql_cleanup() {
mysql_join_failed_builds_build_assignments
printf 'WHERE NOT `build_assignments`.`is_broken`'
printf ';\n'
- # remove failed_builds w/o build_assignment
- printf '%s FROM `failed_builds` ' \
- "${operator}"
- printf 'WHERE NOT EXISTS '
- printf '('
- printf 'SELECT * FROM `build_assignments` '
- printf 'WHERE `build_assignments`.`id`=`failed_builds`.`build_assignment`'
- printf ');\n'
# remove package_sources w/o build_assignment
printf '%s FROM `package_sources` ' \
"${operator}"