How to check the databases integrity?

[Rui Lopes]

Hello,

I'm trying to check all the nexus orientdb databases integrity. For that I'm using:

# see https://support.sonatype.com/hc/en-us/articles/115002930827-Accessing-the-OrientDB-Console

# see http://orientdb.com/docs/last/Console-Command-Connect.html

systemctl stop nexus

su -s /bin/bash nexus # use the nexus user.

nexus_home=/opt/nexus/nexus-3.13.0-01

nexus_data=$nexus_home/../sonatype-work/nexus3

function orientdb-console {

java -jar $nexus_home/lib/support/nexus-orient-console.jar $*

}

cd $nexus_data

# list the databases.

ls -laF db

# check the databases.

orientdb-console 'CONNECT PLOCAL:db/accesslog admin admin; CHECK DATABASE;'

orientdb-console 'CONNECT PLOCAL:db/analytics admin admin; CHECK DATABASE;'

orientdb-console 'CONNECT PLOCAL:db/audit admin admin; CHECK DATABASE;'

orientdb-console 'CONNECT PLOCAL:db/component admin admin; CHECK DATABASE;'

orientdb-console 'CONNECT PLOCAL:db/config admin admin; CHECK DATABASE;'

orientdb-console 'CONNECT PLOCAL:db/security admin admin; CHECK DATABASE;'

But, I cannot connect the OSystem database because it fails with:

$ orientdb-console 'CONNECT PLOCAL:db/OSystem admin admin; CHECK DATABASE;'

OrientDB console v.2.2.36 (build d3beb772c02098ceaea89779a7afd4b7305d3788, branch 2.2.x) https://www.orientdb.com

Type 'help' to display all the supported commands.

orientdb> CONNECT PLOCAL:db/OSystem admin admin

Connecting to database [PLOCAL:db/OSystem] with user 'admin'...

2018-10-03 18:03:40:774 WARNI Not enough physical memory available for DISKCACHE: 1,993MB (heap=444MB direct=444MB). Set lower Maximum Heap (-Xmx setting on JVM) and restart OrientDB. Now running with DISKCACHE=256MB [OMemoryAndLocalPaginatedEnginesInitializer]

Error: com.orientechnologies.orient.core.exception.OSecurityAccessException: User or password not valid for database: 'OSystem'

        DB name="OSystem"

Do have any idea why is this failing? How to overcome this problem?

Thank You.