You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 8
Next »
Jira ticket reference :
POLICY-4109
-
Getting issue details...
STATUS
Problem: Policy Framework includes database-managed statistics, which are currently not being utilized as we have chosen to prioritize the use of Prometheus that offers seamless integration with Grafana for data visualization and analysis.
Deciding to remove the unused code will streamline our codebase and improve maintainability. Even unused code can sometimes have dependencies or unintended consequences that may affect other parts of the system, therefore a careful review and testing are needed.
Affected DB tables:
MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| clampacm |
| information_schema |
| migration |
| mysql |
| operationshistory |
| performance_schema |
| policyadmin |
| policyclamp |
| pooling |
| sys |
+--------------------+
10 rows in set (0.005 sec) | MariaDB [policyadmin]> SHOW TABLES;
+------------------------------------------------------+
| Tables_in_policyadmin |
+------------------------------------------------------+
| jpapdpgroup_properties |
| jpapdpstatistics_enginestats |
| jpapdpsubgroup_policies |
| jpapdpsubgroup_properties |
| jpapdpsubgroup_supportedpolicytypes |
| jpapolicyaudit |
| jpatoscacapabilityassignment_attributes |
| jpatoscacapabilityassignment_metadata |
| jpatoscacapabilityassignment_occurrences |
| jpatoscacapabilityassignment_properties |
| jpatoscacapabilitytype_metadata |
| jpatoscacapabilitytype_properties |
| jpatoscadatatype_constraints |
| jpatoscadatatype_metadata |
| jpatoscadatatype_properties |
| jpatoscanodetemplate_metadata |
| jpatoscanodetemplate_properties |
| jpatoscanodetype_metadata |
| jpatoscanodetype_properties |
| jpatoscapolicy_metadata |
| jpatoscapolicy_properties |
| jpatoscapolicy_targets |
| jpatoscapolicytype_metadata |
| jpatoscapolicytype_properties |
| jpatoscapolicytype_targets |
| jpatoscapolicytype_triggers |
| jpatoscarelationshiptype_metadata |
| jpatoscarelationshiptype_properties |
| jpatoscarequirement_metadata |
| jpatoscarequirement_occurrences |
| jpatoscarequirement_properties |
| jpatoscaservicetemplate_metadata |
| jpatoscatopologytemplate_inputs |
| pdp |
| pdpgroup |
| pdpgroup_pdpsubgroup |
| pdppolicystatus |
| pdpstatistics |
| pdpsubgroup |
| pdpsubgroup_pdp |
| sequence |
| toscacapabilityassignment |
| toscacapabilityassignments |
| toscacapabilityassignments_toscacapabilityassignment |
| toscacapabilitytype |
| toscacapabilitytypes |
| toscacapabilitytypes_toscacapabilitytype |
| toscadatatype |
| toscadatatypes |
| toscadatatypes_toscadatatype |
| toscanodetemplate |
| toscanodetemplates |
| toscanodetemplates_toscanodetemplate |
| toscanodetype |
| toscanodetypes |
| toscanodetypes_toscanodetype |
| toscapolicies |
| toscapolicies_toscapolicy |
| toscapolicy |
| toscapolicytype |
| toscapolicytypes |
| toscapolicytypes_toscapolicytype |
| toscarelationshiptype |
| toscarelationshiptypes |
| toscarelationshiptypes_toscarelationshiptype |
| toscarequirement |
| toscarequirements |
| toscarequirements_toscarequirement |
| toscaservicetemplate |
| toscatopologytemplate |
+------------------------------------------------------+
70 rows in set (0.052 sec) | MariaDB [policyadmin]> SELECT * FROM `pdpstatistics`;
ID
name
version
timeStamp
pdpGroupName
pdpSubGroupName
policyDeployCount
policyDeploySuccessCount
policyDeployFailCount
policyUndeployCount
policyUndeploySuccessCount
policyUndeployFailCount
policyExecutedCount
policyExecutedSuccessCount
policyExecutedFailCount |
jpapdpstatistics_enginestats;
ID
name
version
AVERAGEEXECUTIONTIME
ENGINEID
ENGINETIMESTAMP
ENGINEWORKERSTATE
EVENTCOUNT
LASTENTERTIME
LASTEXECUTIONTIME
LASTSTART
UPTIME
|
|---|
Affected Components:
Models PdpStatistics , JpaPdpStatistics
Api ApiStatisticsManager (Spring)
Distribution DistributionStatisticsManager (Prometheus)
Pap PdpStatisticsService (*)
Xacml XacmlPdpStatisticsManager (*)
Apex-pdp ApexPolicyStatisticsManager (Prometheus)
Drools-pdp PolicyStatsManager (drools/metrics/Metric.java)
