Bug 1630257 - Old and failed builds are not deleted
Summary: Old and failed builds are not deleted
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Copr
Classification: Community
Component: backend
Version: unspecified
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Miroslav Suchý
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-09-18 09:35 UTC by Martin Kyral
Modified: 2019-07-26 09:03 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-07-26 09:03:02 UTC
Embargoed:


Attachments (Terms of Use)

Description Martin Kyral 2018-09-18 09:35:17 UTC
Description of problem:
Copr documetation says "We keep the last successful build from each package indefinitely. All other builds (old packages, failed builds) are deleted after 14 days." However in my copr projects, old and failed builds are kept rendering the copr Builds page slower and slower to load:

https://copr.fedorainfracloud.org/coprs/mkyral/plasma-unstable/builds/
https://copr.fedorainfracloud.org/coprs/mkyral/kf5-unstable/builds/

Version-Release number of selected component (if applicable):
Whatever version is deployed at https://copr.fedorainfracloud.org

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:
Possibility to batch delete old/failed builds would be much appreciated

Comment 1 clime 2018-09-26 07:22:33 UTC
Hello Martin,

> Copr documetation says "We keep the last successful build from each package indefinitely. All other builds (old packages, failed builds) are deleted after 14 days." However in my copr projects, old and failed builds are kept rendering the copr Builds page slower and slower to load:

to explain, right now, we are only removing build results from backend, not the actual records from db - those stay.

Comment 2 Martin Kyral 2019-02-25 15:12:05 UTC
Hello,

from wherever you do delete old build, they are visible in the COPR GUI (making the Builds tab painfully slow) and, moreover, in case of broken dependencies the old builds are shown up among the packages having problem being updated, which affect readibility of the problem log:

Skipping packages with conflicts:
(add '--best --allowerasing' to command line to force their upgrade):
 kwin-libs                                             x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      1.4 M
 libksysguard                                          x86_64                     5.13.5-1.fc29                                            fedora                                      676 k
 libksysguard                                          x86_64                     5.14.4-1.fc29                                            updates                                     682 k
 libksysguard-common                                   x86_64                     5.13.5-1.fc29                                            fedora                                       40 k
 libksysguard-common                                   x86_64                     5.14.4-1.fc29                                            updates                                      41 k
 libkworkspace5                                        x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       77 k
 libreoffice-gtk3                                      x86_64                     1:6.1.4.2-1.fc29.1.kf5                                   rdieter-libreoffice-kf5                     323 k
 libreoffice-gtk3                                      x86_64                     1:6.1.5.2-2.fc29                                         updates                                     322 k
 plasma-workspace-common                               x86_64                     5.13.5-1.fc29                                            fedora                                       31 k
 plasma-workspace-common                               x86_64                     5.13.90-1.fc29                                           mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.1-1.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.1-1.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.2-2.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.3-1.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.14.4-1.fc29                                            updates                                      30 k
 plasma-workspace-common                               x86_64                     5.14.90-1.fc29                                           mkyral-plasma-unstable                       30 k
 plasma-workspace-common                               x86_64                     5.14.90-5.fc29                                           mkyral-plasma-unstable                       30 k
 plasma-workspace-common                               x86_64                     5.14.90-5.fc29                                           mkyral-plasma-unstable                       31 k
 plasma-workspace-common                               x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       31 k
 plasma-workspace-libs                                 x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      1.3 M
Skipping packages with broken dependencies:
 kde-cli-tools                                         x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      936 k
 kf5-ktexteditor                                       i686                       5.50.0-1.fc29                                            fedora                                      2.6 M
 kf5-ktexteditor                                       i686                       5.54.0-1.fc29                                            updates                                     2.6 M
 kwin                                                  x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       34 k
 kwin-common                                           x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      2.7 M
 kwin-devel                                            x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       63 k
 kwin-doc                                              noarch                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      2.5 M
 libksysguard                                          i686                       5.13.5-1.fc29                                            fedora                                      700 k
 libksysguard                                          i686                       5.14.4-1.fc29                                            updates                                     707 k
 plasma-desktop                                        i686                       5.13.5-1.fc29                                            fedora                                      5.9 M
 plasma-desktop                                        x86_64                     5.13.5-1.fc29                                            fedora                                      5.6 M
 plasma-desktop                                        x86_64                     5.13.90-1.fc29                                           mkyral-plasma-unstable                      5.6 M
 plasma-desktop                                        x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                      5.6 M
 plasma-desktop                                        x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                      5.6 M
 plasma-desktop                                        x86_64                     5.14.1-1.fc29                                            mkyral-plasma-unstable                      5.6 M
 plasma-desktop                                        x86_64                     5.14.2-1.fc29                                            mkyral-plasma-unstable                      5.6 M
 plasma-desktop                                        x86_64                     5.14.3-1.fc29                                            mkyral-plasma-unstable                      5.6 M
 plasma-desktop                                        i686                       5.14.4-2.fc29                                            updates                                     5.9 M
 plasma-desktop                                        x86_64                     5.14.4-2.fc29                                            updates                                     5.6 M
 plasma-desktop                                        x86_64                     5.14.90-1.fc29                                           mkyral-plasma-unstable                      5.6 M
 plasma-desktop                                        x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      5.6 M
 plasma-desktop-kimpanel-scim                          x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       52 k
 plasma-lookandfeel-fedora                             noarch                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       13 M
 plasma-systemsettings                                 x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      357 k
 plasma-workspace                                      i686                       5.13.5-1.fc29                                            fedora                                      5.0 M
 plasma-workspace                                      x86_64                     5.13.5-1.fc29                                            fedora                                      4.9 M
 plasma-workspace                                      x86_64                     5.13.90-1.fc29                                           mkyral-plasma-unstable                      4.8 M
 plasma-workspace                                      x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                      4.8 M
 plasma-workspace                                      x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                      4.8 M
 plasma-workspace                                      x86_64                     5.14.0-1.fc29                                            mkyral-plasma-unstable                      4.8 M
 plasma-workspace                                      x86_64                     5.14.1-1.fc29                                            mkyral-plasma-unstable                      4.9 M
 plasma-workspace                                      x86_64                     5.14.1-1.fc29                                            mkyral-plasma-unstable                      4.9 M
 plasma-workspace                                      x86_64                     5.14.2-2.fc29                                            mkyral-plasma-unstable                      4.9 M
 plasma-workspace                                      x86_64                     5.14.3-1.fc29                                            mkyral-plasma-unstable                      4.9 M
 plasma-workspace                                      i686                       5.14.4-1.fc29                                            updates                                     5.0 M
 plasma-workspace                                      x86_64                     5.14.4-1.fc29                                            updates                                     4.9 M
 plasma-workspace                                      x86_64                     5.14.90-1.fc29                                           mkyral-plasma-unstable                      4.9 M
 plasma-workspace                                      x86_64                     5.14.90-5.fc29                                           mkyral-plasma-unstable                      4.9 M
 plasma-workspace                                      x86_64                     5.14.90-5.fc29                                           mkyral-plasma-unstable                      4.9 M
 plasma-workspace                                      x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      5.0 M
 plasma-workspace-devel                                x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       59 k
 plasma-workspace-doc                                  noarch                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      648 k
 plasma-workspace-geolocation-libs                     x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                       28 k
 plasma-workspace-libs                                 i686                       5.13.5-1.fc29                                            fedora                                      1.4 M
 plasma-workspace-libs                                 i686                       5.14.4-1.fc29                                            updates                                     1.4 M
 powerdevil                                            x86_64                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      902 k
 sddm-breeze                                           noarch                     5.15.1-1.fc29                                            mkyral-plasma-unstable                      443 k

Thus, it would help a lot if the old build were deleted automatically or, if there was at least some easy way to bulk delete them.

Comment 3 Martin Kyral 2019-03-13 12:10:37 UTC
I resolved my problem with a script eventually. Today I noticed there is an option to mark multiple builds and delete them all in the COPR UI. Thanks for it. It's very much appreciated.

Comment 4 Pavel Raiskup 2019-07-26 09:03:02 UTC
You can nowadays setup "max package builds" in web-ui/cli:
copr edit-package-* --max-builds ...

Having this configured, your builds get removed overnight so only
the specified number of builds stays in database.


Note You need to log in before you can comment on or make changes to this bug.