Enabling Pipelines emails caused the 'services' table to increase by 200GB in one hour
<!--- Please read this! Before you create a new issue, please make sure that you already ran enabling 'Pipelines emails' caused the 'services' table to increase by 200GB in one hour `sudo gitlab-ctl reconfigure` Also make sure to search in https://gitlab.com/gitlab-org/omnibus-gitlab/issues, to verify the issue you're about to submit isn't a duplicate. ---> ### Summary <!-- Describe in short the bug you've encountered --> Enabling Pipelines emails caused the 'services' table to increase by 200GB in one hour. How can I safely clear the 'services' table now ? ### Steps to reproduce Admin Area > Service Templates > Pipelines emails:( Active: + , Recipients: my email) <!-- How one can reproduce the issue - this is very important --> ### What is the current *bug* behavior? <!-- What actually happens --> After enabling the "services" table, it started growing with this data: `921780211 | PipelinesEmailService | Pipelines emails | 596 | 2019-10-17 11:21:45.618876 | 2020-05-27 16:05:15.876159 | t | {"notify_only_broken_pipelines":"1","notify_only_default_branch ":"1","recipients":"my_mail@exemple.com"} ` several hundred lines per second ### What is the expected *correct* behavior? <!-- What you should see instead --> ### Relevant logs <details> <summary> Relevant logs </summary> <pre> <!-- Paste any relevant logs. Live log output can be found with `sudo gitlab-ctl tail`. Log files live in `/var/log/gitlab` by default. --> </pre> </details> ### Details of package version <details> <summary>ii gitlab-ce 12.0.0-ce.0 amd64 GitLab Community Edition (including NGINX, Postgres, Redis)</summary> <pre> <!-- For Debian, Ubuntu based systems, paste the output of: `dpkg-query -l "gitlab-*"` For RHEL based systems (CentOS, RHEL, OL, Scientific, OpenSUSE, SLES), paste the output of: `rpm -qa | grep 'gitlab'` If you can't provide these details, see https://about.gitlab.com/getting-help/ page on where to ask your question. --> </pre> </details> ### Environment details * Operating System: `Ubuntu 18.04.3 LTS` * Installation Target, remove incorrect values: * VM: GCP * Installation Type, remove incorrect values: * Upgrade from version `12.0.0` * Is there any other software running on the machine: `no` * Is this a single or multiple node installation? `Geo setup, though this was the primary` * Resources * CPU: `2 core` * Memory total: `8 GB` ### Configuration details <details> <summary> Provide the relevant sections of `/etc/gitlab/gitlab.rb` </summary> <pre> <!-- Paste the details but omit lines starting with `#`. Relevant lines can be retrieved by running `grep -v -e '^#' -e '^$' /etc/gitlab/gitlab.rb`. Be certain to sanitize sensitive configuration such as passwords and secrets. --> </pre> </details>
issue