Hello everyone!
Problem:
- discovered the command “foreman-maintain health check”.
- check found paused tasks in the system.
- after checking them from the webUI we have deleted to delete the paused task via the maintenance script (option 2 - “Delete paused tasks”).
- It takes a very long time to run - turns out it’s spending a lot of time bzip2-compressing a huge csv file under /var/lib/foreman-maintain/backup-tasks/paused before updating the database.
Expected outcome:
- faster backup - can we switch to multi-threaded zstd for example?
- the deletes from the database takes a long time as well - is there something that one could do the speed this up?
- can someone point me to the source in GitHub - theforeman/foreman_maintain: The Foreman/Satellite maintenance tool responsible for the “health check” sub-command so I can understand what it is doing?
Thanks for reading this and looking forward to hear from all of you!
Foreman and Proxy versions: 3.12.0
Foreman and Proxy plugin versions:
ansible-collection-theforeman-foreman-4.2.0-1.el8.noarch
candlepin-4.4.19-1.el8.noarch
candlepin-selinux-4.4.19-1.el8.noarch
dynflow-utils-1.6.3-1.el8.x86_64
foreman-3.12.0-1.el8.noarch
foreman-cli-3.12.0-1.el8.noarch
foreman-debug-3.12.0-1.el8.noarch
foreman-dynflow-sidekiq-3.12.0-1.el8.noarch
foreman-installer-3.12.0-1.el8.noarch
foreman-installer-katello-3.12.0-1.el8.noarch
foreman-libvirt-3.12.0-1.el8.noarch
foreman-obsolete-packages-1.10-1.el8.noarch
foreman-postgresql-3.12.0-1.el8.noarch
foreman-proxy-3.12.0-1.el8.noarch
foreman-redis-3.12.0-1.el8.noarch
foreman-release-3.12.0-1.el8.noarch
foreman-selinux-3.12.0-1.el8.noarch
foreman-service-3.12.0-1.el8.noarch
katello-4.14.1-1.el8.noarch
katello-certs-tools-2.10.0-1.el8.noarch
katello-client-bootstrap-1.7.9-2.el8.noarch
katello-common-4.14.1-1.el8.noarch
katello-debug-4.14.1-1.el8.noarch
katello-repos-4.14.1-1.el8.noarch
katello-selinux-5.0.2-1.el8.noarch
pulpcore-obsolete-packages-1.2.0-1.el8.noarch
pulpcore-selinux-2.0.1-1.el8.x86_64
python3.11-pulp-ansible-0.21.8-1.el8.noarch
python3.11-pulp-cli-0.29.2-2.el8.noarch
python3.11-pulp-container-2.20.3-1.el8.noarch
python3.11-pulp-deb-3.2.1-1.el8.noarch
python3.11-pulp-glue-0.29.2-2.el8.noarch
python3.11-pulp-python-3.11.3-1.el8.noarch
python3.11-pulp-rpm-3.26.1-1.el8.noarch
python3.11-pulpcore-3.49.22-1.el8.noarch
rubygem-dynflow-1.9.0-1.el8.noarch
rubygem-foreman-tasks-9.2.3-1.fm3_12.el8.noarch
rubygem-foreman_ansible-14.2.1-1.fm3_12.el8.noarch
rubygem-foreman_discovery-24.0.2-1.fm3_12.el8.noarch
rubygem-foreman_maintain-1.7.6-1.el8.noarch
rubygem-foreman_remote_execution-13.2.5-1.fm3_12.el8.noarch
rubygem-foreman_statistics-2.1.0-3.fm3_11.el8.noarch
rubygem-foreman_webhooks-3.2.3-1.fm3_12.el8.noarch
rubygem-hammer_cli-3.12.0-1.el8.noarch
rubygem-hammer_cli_foreman-3.12.0-1.el8.noarch
rubygem-hammer_cli_foreman_discovery-1.3.0-1.fm3_11.el8.noarch
rubygem-hammer_cli_foreman_remote_execution-0.3.0-1.fm3_10.el8.noarch
rubygem-hammer_cli_foreman_tasks-0.0.21-1.fm3_11.el8.noarch
rubygem-hammer_cli_foreman_webhooks-0.1.0-1.fm3_10.el8.noarch
rubygem-hammer_cli_katello-1.14.3-1.el8.noarch
rubygem-katello-4.14.1-1.el8.noarch
rubygem-pulp_ansible_client-0.21.7-1.el8.noarch
rubygem-pulp_certguard_client-3.49.17-1.el8.noarch
rubygem-pulp_container_client-2.20.2-1.el8.noarch
rubygem-pulp_deb_client-3.2.1-1.el8.noarch
rubygem-pulp_file_client-3.49.17-1.el8.noarch
rubygem-pulp_ostree_client-2.3.2-1.el8.noarch
rubygem-pulp_python_client-3.11.2-1.el8.noarch
rubygem-pulp_rpm_client-3.26.1-1.el8.noarch
rubygem-pulpcore_client-3.49.17-1.el8.noarch
rubygem-smart_proxy_dynflow-0.9.3-1.fm3_12.el8.noarch
rubygem-smart_proxy_pulp-3.3.0-1.fm3_10.el8.noarch
Distribution and version: CentOS Stream 8