# OrientDB migration: Database integrity: BROKEN

## post by know-center on Aug 21, 2024

KC Admin

know-center

[Aug 2024](https://community.sonatype.com/t/orientdb-migration-database-integrity-broken/13091 "Post date")

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:

```bash
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:

```makefile
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](https://community.sonatype.com/t/orientdb-migration-database-integrity-broken/13091 "Post date")

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:

```makefile
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.
```