Bug 856152
Summary: | host_interface_samples table is not cleaned properly - log entries over 1000 lines and 30 days old stay in the db | |||
---|---|---|---|---|
Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Tomas Dosek <tdosek> | |
Component: | ovirt-engine-dwh | Assignee: | Yaniv Lavi <ylavi> | |
Status: | CLOSED CURRENTRELEASE | QA Contact: | David Botzer <dbotzer> | |
Severity: | high | Docs Contact: | ||
Priority: | urgent | |||
Version: | 3.0.7 | CC: | acathrow, cpelland, dyasny, iheim, italkohe, jwest, mkalinin, pablo.iranzo, pstehlik, Rhev-m-bugs, sgordon, sputhenp, tvvcox, ykaul | |
Target Milestone: | --- | Keywords: | ZStream | |
Target Release: | 3.0.8 | |||
Hardware: | Unspecified | |||
OS: | Unspecified | |||
Whiteboard: | infra | |||
Fixed In Version: | Doc Type: | Bug Fix | ||
Doc Text: |
Once records in the history tables reach a certain (configurable) age they are removed. This cleanup activity was previously not being performed for the "host_interface_samples_history" table. This resulted in the table growing in size over time and taking up excessive amounts of disk space. The ETL process has been updated and now removes old records from the table correctly.
|
Story Points: | --- | |
Clone Of: | ||||
: | 861430 (view as bug list) | Environment: | ||
Last Closed: | 2012-12-04 19:58:35 UTC | Type: | Bug | |
Regression: | --- | Mount Type: | --- | |
Documentation: | --- | CRM: | ||
Verified Versions: | Category: | --- | ||
oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | ||
Cloudforms Team: | --- | Target Upstream Version: | ||
Embargoed: | ||||
Bug Depends On: | ||||
Bug Blocks: | 861430 |
Description
Tomas Dosek
2012-09-11 10:25:32 UTC
This bug is fixed on 3.1 on BZ#783787. I would like to request this for 3.0.z. Current workaround provided to the customer: Run the script from comment 1 as a cron job on a weekly basis. On what build should I verify the BZ ? Who in Pre-integration tested this ? BZ was found on ic157 - rhevm 3.0.7 we dont have anything later than ic157... Fixed 3.1/si18.1 v3_1_host_interface_samples_history_view shows correct age (1 days, I configure 24H) whereas other tables shows more than 5 days of data Fixed 3.1/si18.1 |