Keong Lim

Message to discuss list: https://lists.onap.org/g/onap-discuss/topic/32859796

We have a Dublin environment that had a Cassandra problem which caused the graphadmin-create-db-schema job to fail repeatedly.

Question 1. Is there an ONAP-built-in monitoring solution for the shared Cassandra database?

The Cassandra problem was a combination of:
- node-0 had Out of Memory error in JVM
- node-1 had error in commit log processing
- node-2 had Out of Disk Space error on filesystem

However, Kubernetes showed node-0 and node-2 still "Running" and apparently healthy (zero restarts), with node-1 in CrashLoopBackOff (many restarts).
The failed Cassandra nodes caused the graphadmin-create-db-schema job to fail (many restarts), which causes all other AAI pods to wait in Init state.

The Cassandra problems have been manually fixed now, but should ONAP have a monitoring solution built-in to detect it?

Question 2. How can we re-run that kubernetes job?

Deleting the failed job pods cleaned up the list but did not prompt any new job pods to be created.
Deleting the graphadmin pod caused it to restart and wait for the job completion, but did not trigger a new job to start.

I think the job has now hit its backoff limit, so it no longer runs, even though we have since fixed the Cassandra problem.
Can we reset some parameter so that it will finally run to completion?
Is there an appropriate helm command or kubectl command to re-run the job?

The rest of AAI pods are obviously waiting for that job to complete before they can progress out of Init state.

Update:

• re-running the graphadmin-create-db-schema job (done!)
• fixing the readiness-check that is waiting for cassandra
• Put a message onto the rocketchat also, hoping that FREEMAN, BRIAN D  or another expert on ready.py script in readiness-check pod can assist.
• Mahendra Raghuwanshi do you know if there is a better way to monitor Cassandra?
• Discussed at OOM Meeting Notes - 2019-08-14 Mike Elliott is trying to get some resources to look at the JIRA case

  Jira Legacy
  server System Jira serverId 4733707d-2057-3a0f-ae5e-4fd8aff50176 key OOM-2057

Keong Lim

Referring to https://wiki.onap.org/display/DW/cloud-region-fromVnf

and https://gerrit.onap.org/r/gitweb?p=aai/schema-service.git;a=blob;f=aai-queries/src/main/resources/schema/onap/query/stored-queries.json;hb=HEAD#l3

Wiki page says that output is:

vserver
vnfc
tenant
cloud-region

but stored-queries.json definition includes:

.createEdgeTraversal(EdgeType.COUSIN, 'vserver', 'pserver').store('x')

So the output should also include "pserver"?

Keong Lim

James Forsyth

2019-08-12 AAI Information Model Reverse Engineering

•  2019-08-08: Former user (Deleted) to attempt generating XMI format file for a small AAI example. Standards definition here: https://www.omg.org/spec/XMI/About-XMI/

Keong Lim

Keong Lim

Just in case Zoom problems continue, try this instead:

https://meet.jit.si/onapaai

James Forsyth

AAI Epics/Stories in JIRA:

Former user (Deleted)

There are 2 types of logging in the services

• one read from EELFManager
• the other Logger log = Logger.getLogger( ...

Is that correct? Shouldn't there be just 1 type?

1st Nov:

After Casablanca release investigate logging guidelines and figure out what library to use in order to unify logging within A&AI

26th Nov: See also ONAP Application Logging Specification - Post Dublin

29th Nov: how does this fit with

28th May: Stela Stoykova is fixing

Thamlur Raju (Unlicensed)

Francis Paquette

James Forsyth

• In casablanca environment without Sparky-fe, how we are able to access the AAI-UI?
• In standalone AAI setup, how can i access the AAI UI? i am running the resources, traversal, elastic-search, search-data-service and sparky-be. but not able to access the UI, need to run any other services to access the UI?

tried with below URL,

http://<IP>:9517/services/aai/webapp/index.html

response:

James Forsyth

A 5-10 minute demo of GraphGraph

Feedback needed!

Keong Lim

From https://lists.onap.org/g/onap-discuss/topic/31317665

Discussion:

•  The cloud-region schema element is unusual in that it has a two-part key i.e. "cloud-owner" and "cloud-region-id". There are not many other usages of it ("ctag-pool" , "service-capability" and "route-target" are three others, out of over 100 other schema elements)
•  Is it possible to enhance the error message to indicate that part of the key value is missing from the relationship-data? 

  Jira Legacy
  server System Jira columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 4733707d-2057-3a0f-ae5e-4fd8aff50176 key AAI-2391

•  Is it time to deprecate the relationship-data and switch over to using the related-link only?
•  Is there any modeling guidance that would steer new designs away from using multi-part key for schema elements?
•  Are there other caveats to using the multi-part key design for schema elements?
•  Can we get feedback from Chandra Cinthalaon the key design for multi-part keys and whether this will be more common going forward?
  

  From: CINTHALA, CHANDRA [mailto:cc1196@att.com]
  Sent: Tuesday, April 30, 2019 12:16 AM
  To: Keong Lim <Keong.Lim@huawei.com>; FORSYTH, JAMES <jf2512@att.com>
  Cc: AGGARWAL, MANISHA <amanisha@att.com>
  Subject: Re: [confluence] Keong Lim has assigned tasks to you in "2019-05-02 AAI Developers Meeting"

  
  

  Keong,

  
  

  I think we have no plans to deprecate the relation-data option the in the A&AI relationship payload.

  It's another option for the client to specify the relationship.

  
  

  Thanks

  Chandra

•  See also email from Marco Platania in https://lists.onap.org/g/onap-discuss/topic/31385256

Former user (Deleted)

Is there a guide for the description of the error message and the error codes? How are new error states (message + code) added?

•  William LaMont will send James Forsyth the output of a script that formats the error.properties file to make a wiki page and readthedocs
•  James Forsyth should commit that script and create a wiki for the error properties
  

Dénes Németh wrote in

In think it would be good to answer what is the meaning of the field (collection of PEMs of the CA xor URL)

Questions:

1. Is AAI intended to strictly prescribe how the fields are used and what contents are in the values?
2. Or does AAI simply reflect the wishes of all the client projects that use it to store and retrieve data?

Even if (1) is true, AAI is not really in any position to enforce how clients use the data, so really (2) is always true and we need to consult the original producers of the data and the ultimate consumers of the data to document their intended meanings.

How do we push to have documentation on the purpose and meaning of the fields in AAI?

Where does all this documentation go?

Should the documentation be backed up by validation code?

See also discussion about AAI in 2018-11-28 ExtAPI Meeting notes

29th Nov: Started on new wiki page AAI Schema Producer-Consumer Pairings

18th Apr: Can we have this documentation go into ONAP in a generic way?

24th Apr: See also questions about "sw-version" in https://wikilf-onap.onapatlassian.orgnet/wiki/display/DW/5G+-+PNF+Plug+and+Play?focusedCommentId=63996633#comment-6399663316367935

Keong Lim

• if I had some AAI data with attributes that are strings but nominally contain date/timestamps, is there a way to query for a particular range of values?

• is there a way to do partial match? regex?
  PUT /aai/v13/query?format=raw

  Code Block
  {"gremlin": "g.V().has('aai-ts', org.janusgraph.core.attribute.Text.textContains('URL'))"}

  
  

  https://github.com/JanusGraph/janusgraph/blob/master/janusgraph-core/src/main/java/org/janusgraph/core/attribute/Text.java

  
  

•  Invite Arul Nambi and CT Paterson to next week's dev call to talk about how sparky/elastic does partial/range matches

James Forsyth

Former user (Deleted)

31st Jan 2019:

The schema-service is ready. Currently it provides file-sharing capabilities in terms of schema/edgerule files.

In order for GraphGraph to take advantage of the schema parsing/processing in schema-service additional abstractions have to be implemented on top of the crude file2string functionality currently in schema-service.

•  Venkata Harish Kajurwill ask Manisha Aggarwalif the current functionality of the schema-service is the final version for Dublin and if there will be further enhancements in next releases. 
  

GraphGraph needs the following functionality:

Venkata Harish Kajur  and Manisha Aggarwal What is missing in schema service that is needed in graphgraph is the following:

• rest call to get available schemas
• list of all schema nodes/items (like vserver, tenant, p-interfaces..) for example on a REST path /schemas/{schema}/nodes
• all relevant attributes of a given node/item for example on REST path /schemas/{schema}/nodes/{node}
• edges/relationships with their attributes between schema nodes/items (for example on REST path /schemas/{schema}/edges where you specify a "from" "to" schema items as query params)
• subgraph of the schema, where you specify 1. initial (root) items/node (like tenant or vserver) 2. schema version and 3. number of parent/cousin/child hops from the initial item/node
• all paths in a given schema graph between 2 items/nodes (like vserver and tenant) for a given schema version
• edges in the schema graph should be composed of edges in the schema file + edges created from the edgerules file
• edges should contain basic attributes when delivered via the subgraph call (like parent/child relationship and important properties from edgerules) and have additional (or all) attributes when queries via /schemas/{schema}/edges REST endpoint.

20. Mar 2019:

Open questions for schema-service:

1. what is the current implemented functionality?
2. what are the business use-cases in ONAP for schema-service? Description of functionality in relation to other services/projects is needed. In other words who needs it and why?
3. if no business use-cases can be formulated we should consider removing schema-service from A&AI and replacing it with standard file-sharing mechanisms.

21st Mar 2019:

Based on William Reehil comments

https://wikilf-onap.onapatlassian.orgnet/wiki/display/DW/AAI+Schema+Service?focusedCommentId=45299262#comment-4529926216325457 what is "our future proposed functionality"?

AAF will generate certificates to the be used by the containers at startup; AAI services should use the run-time generated certs instead of the ones that are in the repos or oom charts.

In dublin the services will mount a volume with certificates. This is on the roadmap for Dublin as a feature.

• is this for all service and/or HAProxy?
• Where are the certificates coming from (OOM/gerrit/generated by AAF)

12th June 2019: Jonathan Gathman demonstrated aaf-hello functionality at DDF event

Technical solution to either decommission the proxy or make design changes to AAF to enable client side certificates.

After VF2F we will know if this is a requirement in Dublin. We discuss after this date.

question raised: MSB - would client authentication be supported?

15th Dec: https://wikilf-onap.onapatlassian.orgnet/wiki/display/DW/Pluggable+Security#PluggableSecurity-7.10Identifiedandsupportedpatternsandfeatures

•  James Forsythcreates a task for encryption of communication between A&AI services and Cassandra 24 Jan 2019
  
•  Tian Lee and Steve Blimkie to report on the Amdocs managed A&AI microservice wheter they support criteria from the Dublin S3P requirements 31 Jan 2019 
  

Keong Lim

FREEMAN, BRIAN D asked on Re: Backup and Restore Solution: ONAP-OOM :

what would be the approach to backup an entire ONAP instance particualarly SDC, AAI, SDNC data ? would it be a script with all the references to the helm deploy releases or something that does a helm list and then for each entry does  the ark backup ?

What is the AAI strategy for backup and restore?

What is the overall ONAP strategy for backup and restore?

Should it be unified with the data migration strategy as per "Hbase to Cassandra migration" on 2018-11-14 AAI Meeting Notes?

•  James Forsythwill raise the topic of having backups and restore functionality in ONAP - if it is feasible, on the roadmap and what others PTL think

Jimmy didn't directly raise the topic but there was movement - Keong Lim asked "if istio service mesh is a no-go, is there a replacement for secure onap communications?
is backup/restore/upgradability included in s3p?"

Michael O'Brien replied that a reference tool set for backup and restore was introduced in Casablanca:  Backup and Restore Solution: ONAP-OOM

Mike Elliott said he would look at Brian's question, AAI will provide support as needed.