...
Data for the different actions must be loaded into the PROTOCOL_REFERENCE table whenever a new instance of the APPC DB is instantiated or cleaned. In order to load the Stability Tests VNFs use the following:
| Code Block |
|---|
1. kubectl exec -ti onap-appc-db-0 -c appc-db -n onap bash
2. mysql -u sdnctl -p
3. Enter the following SQL command to insert the data (First column is the unique key for each record...number is not as important as the fact it should be unique within the table):
INSERT INTO `PROTOCOL_REFERENCE` VALUES (1,'Stop','vTESTVM','OS',now(),'NO','vm');
INSERT INTO `PROTOCOL_REFERENCE` VALUES (2,'Start','vTESTVM','OS',now(),'NO','vm');
INSERT INTO `PROTOCOL_REFERENCE` VALUES (4,'Rebuild','vTESTVM','OS',now(),'NO','vm');
INSERT INTO `PROTOCOL_REFERENCE` VALUES (3,'Restart','vTESTVM','OS',now(),'NO','vnf');
INSERT INTO `PROTOCOL_REFERENCE` VALUES (5,'Restart','vTESTVM','OS',now(),'NO','vm');
INSERT INTO `PROTOCOL_REFERENCE` VALUES (18,'Snapshot','vTESTVM','OS',now(),'NO','vm'); |
KIbana Queries
- Querying for a specific string in the Message filed:
- message:"REBUILD_STATUS -- SUCCESS"
- Querying for all transactions for a RequestId:
- RequestId:"RequestId you are searching for"
- View for Restart and Rebuilds can be found here.
...