Jira ticket reference :
Jira |
---|
server | ONAP Jira |
---|
serverId | 425b2b0a-557c-3c0c-b515-579789cceedb |
---|
key | POLICY-4109 |
---|
|
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)Affected Components:
Models org.onap.policy.models.pdp.concepts , org.onap.policy.models.pdp.persistence.concepts
Api org.onap.policy.api.main.rest.provider.statistics
Distribution org.onap.policy.distribution.main.rest
Pap org.onap.policy.pap.main.service, rest
Xacml org.onap.policy.pdpx.main.rest.provider