# OrientDB migration: Database integrity: BROKEN

**URL:** <https://community.sonatype.com/t/orientdb-migration-database-integrity-broken/13091>\
**Category:** Sonatype Nexus Repository\
**Tags:** nexus-repository\
**Created:** [August 21, 2024, 9:25am UTC](https://community.sonatype.com/t/orientdb-migration-database-integrity-broken/13091 "2024-08-21T09:25:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![know-center](https://avatars.discourse-cdn.com/v4/letter/k/9fc29f/32.png) [@know-center](https://community.sonatype.com/u/know-center)\
**Post date:** [August 21, 2024, 9:25am UTC](https://community.sonatype.com/t/orientdb-migration-database-integrity-broken/13091/1 "2024-08-21T09:25:29Z")

</div>

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:

```auto
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!

---

<div class="post-metadata">

**Author:** ![know-center](https://avatars.discourse-cdn.com/v4/letter/k/9fc29f/32.png) [@know-center](https://community.sonatype.com/u/know-center)\
**Post date:** [August 21, 2024, 11:16am UTC](https://community.sonatype.com/t/orientdb-migration-database-integrity-broken/13091/2 "2024-08-21T11:16:07Z")

</div>

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:

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

```