OrientDB migration: Database integrity: BROKEN

post by know-center on Aug 21, 2024

KC Admin

know-center

Aug 2024

Hi!

We’re running 2 standalone Nexus OSS installations.

Currently it is Nexus/3.70.1-02 (OSS).

I ran the following command to check the health status of the database before I can try the Migration to H2:

java --add-exports=java.base/sun.nio.ch=ALL-UNNAMED -Xmx16G -Xms16G -XX:+UseG1GC -XX:MaxDirectMemorySize=28672M -jar nexus-db-migrator-3.70.1-03.jar --healthcheck --debug --yes

The check finishes, but leaves me errors:

11:08:11 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - Check of storage completed in 9606ms.  without errors.
11:08:11 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - Checking db cluster consistency for errors...
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - Check storage: OK
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - Check clusters consistency: OK
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - 0 component duplicates found
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - 41 asset duplicates found
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - 0 browse nodes duplicates found
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - ------------------------------------------------------------
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - Database integrity: BROKEN
11:08:15 [main] INFO  c.s.n.d.m.tasklet.HealthCheckTasklet - ------------------------------------------------------------

The second installation has even more duplicates in ‘asset’.

Now I’m stuck here, any advice how to proceed would be much appreciated!

post by know-center on Aug 21, 2024

KC Admin

know-center

Aug 2024

Funny, the migration itself worked.

I didn’t try to do the migration after this health check result in the first place, but obviously it was successful:

12:52:17 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Migration job finished at Wed Aug 21 12:52:17 CEST 2024
12:52:17 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Migration job took 4 minutes to execute
12:52:17 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 982088 records were processed
12:52:17 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 5 records were filtered
12:52:17 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 47 records were skipped
12:52:17 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 982036 records were migrated
12:52:17 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Created 'Rebuild repository browse' and 'Rebuild repository search' tasks. They will automatically one-time run after starting your Nexus Repository instance.