Support Support Downloads Knowledge Base Case Manager My Juniper Community

Knowledge Base

Search our Knowledge Base sites to find answers to your questions.

Ask All Knowledge Base Sites All Knowledge Base Sites JunosE Defect (KA)Knowledge BaseSecurity AdvisoriesTechnical BulletinsTechnotes Sign in to display secure content and recently viewed articles

[CSO] How to find and clear stale entries in Arango DB

0

0

Article ID: KB34631 KB Last Updated: 22 Jul 2019Version: 1.0
Summary:

This article explains how to find and clear stale entries in Arango DB.

 

Symptoms:
  • Symptoms 1: I am unable to delete the site, and checking the tssm logs and kibana logs indicate that the error is received from the topology-service (note: the topology service data is saved in Arango DB).

  • Symptoms 2: When trying to list departments under Admin Portal > Resources > Shared Object > Departments, I receive the 500 Internal Error and the department is not listed (the list department request is also served from Arango DB).

 

Cause:

It is seen that stale/null entries in Arango DB may result in the above symptoms.

 

Solution:

To find and clear stale or null entries in Arango DB, perform the following steps:

  1. Download the attached script to any central/regional infra VM: query_null_refs_pr35987_sh.zip
  2. Copy the above script to any of the central/regional infra VMs in the /tmp location. Execute and run the script as follows:

chmod +x query_null_refs_pr35987.sh 
./query_null_refs_pr35987.sh 
  1. When prompted, supply the Arango DB password for the system. (To obtain the Arango DB password, log in to the installer VM, navigate to the CSO installer directory, and type the command ./python.sh deploy_manager/utils/decrypt_password.py.) 

  2. The script will find any null entries and display the output on the screen:

  1. Edit the above script by using the vi editor and set const REMOVE_NULL_REFS = true to remove the null references.
  2. Run the script again to remove the null references by using the ./query_null_refs_pr35987.sh command.

  3. The script will find and remove the null entries and display the output on the screen.

Note: No downtime is required to run this script.

 

Comment on this article > Affected Products Browse the Knowledge Base for more articles related to these product categories. Select a category to begin.

Getting Up and Running with Junos

Getting Up and Running with Junos Security Alerts and Vulnerabilities Product Alerts and Software Release Notices Problem Report (PR) Search Tool EOL Notices and Bulletins JTAC User Guide Customer Care User Guide Pathfinder SRX High Availability Configurator SRX VPN Configurator Training Courses and Videos End User Licence Agreement Global Search