Bug 642799
Summary: | Unable to delete systems or probes with large # of rows (e.g., 180 million) in time_series table | |||
---|---|---|---|---|
Product: | Red Hat Satellite 5 | Reporter: | Xixi <xdmoon> | |
Component: | Monitoring | Assignee: | Milan Zázrivec <mzazrivec> | |
Status: | CLOSED EOL | QA Contact: | Jan Hutař <jhutar> | |
Severity: | high | Docs Contact: | ||
Priority: | medium | |||
Version: | 530 | CC: | cperry, jhutar, mmraka, msuchy, mzazrivec, xdmoon | |
Target Milestone: | --- | |||
Target Release: | --- | |||
Hardware: | All | |||
OS: | Linux | |||
Whiteboard: | ||||
Fixed In Version: | spacewalk-schema-1.7.55-31 spacewalk-java-1.7.54-90 | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | ||
Clone Of: | ||||
: | 651383 (view as bug list) | Environment: | ||
Last Closed: | 2015-07-13 09:17:56 UTC | Type: | --- | |
Regression: | --- | Mount Type: | --- | |
Documentation: | --- | CRM: | ||
Verified Versions: | Category: | --- | ||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
Cloudforms Team: | --- | Target Upstream Version: | ||
Embargoed: | ||||
Bug Depends On: | ||||
Bug Blocks: | 462714 |
Description
Xixi
2010-10-13 20:33:38 UTC
FYI, in current Spacewalk nightly (soon to be Spacewalk 1.7) we implemented fully asynchronous deletion of monitoring data. In particular, we re-structured time_series table to be normalized (foreign keys, no function based indexes) while allowing fully asynchronous deletion of monitoring data. This would mean that for example probe or server deletion would not block until all the monitoring data from time_series would be all cleared up, but the monitoring data would be left in place and be cleared later (and automatically) by a dedicated taskomatic job. |