Clish in Gaia OS is very slow when making any changes in Gaia OS configuration

Support Center > Search Results > SecureKnowledge Details

Solution ID	sk102994
Product	Security Gateway, Security Management, Multi-Domain Management
Version	R75.40, R75.40VS, R75.45, R75.46, R75.47, R76, R77, R77.10, R77.20
OS	Gaia
Platform / Model	All
Date Created	14-Oct-2014
Last Modified	02-Jun-2018

Symptoms

Clish in Gaia OS is very slow when making any changes in Gaia OS configuration.
Output of 'top' command shows that confd daemon consumes CPU at high level when saving the changes in Gaia OS configuration database (either from Clish, or in Gaia Portal).
Gaia OS might not respond to SNMP queries, pings, etc. when saving the changes in Gaia OS configuration database (either from Clish, or in Gaia Portal).

Cause

Corruption in the Gaia configuration database.

To verify that this is indeed the issue:

Log in to Expert mode.
Backup the current Gaia configuration database:
[Expert@HostName]# cp /config/db/initial_db /config/db/initial_db_backup
Connect to the Gaia configuration database:
[Expert@HostName]# sqlite3 /config/db/initial_db
Query the database using the SQLite to identify the issue:

sqlite> select * from revisions where time like "%1969%";
If any entries are returned, the system is likely experiencing this issue.
Exit from SQLite:
sqlite> .exit

Solution

Note: To view this solution you need to Sign In .