The rebuild metadata build has been failed

The rebuild metadata build has been failed with a log as below.
We would appreciate any guidance on why this error occurs and how to avoid it.

  • This task is performed every Sunday at 01:00.
2023-05-28 01:00:00,090+0900 INFO  [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask - Task information:
2023-05-28 01:00:00,091+0900 INFO  [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask -  ID: 75917dc1-dfc1-4602-ade4-cdd641ca7665
2023-05-28 01:00:00,091+0900 INFO  [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask -  Type: repository.maven.rebuild-metadata
2023-05-28 01:00:00,091+0900 INFO  [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask -  Name: Rebuild Maven repository metadata (all)
2023-05-28 01:00:00,091+0900 INFO  [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask -  Description: Rebuilding Maven Metadata of nightly
2023-05-28 01:01:00,149+0900 ERROR [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask - Failed to run task 'Rebuilding Maven Metadata of nightly' on repository 'nightly'
java.lang.IllegalStateException: Timed out reading query result from queue 6c227267 after 60 seconds
	at org.sonatype.nexus.repository.storage.OrientAsyncHelper$QueueConsumingIterable.hasNext(OrientAsyncHelper.java:201)
	at java.util.Iterator.forEachRemaining(Iterator.java:115)
	at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)
	at org.sonatype.nexus.repository.maven.internal.orient.OrientMetadataRebuilder$OrientWorker.browseGAVs(OrientMetadataRebuilder.java:286)
	at org.sonatype.nexus.repository.maven.internal.hosted.metadata.AbstractMetadataRebuilder$Worker.rebuildMetadata(AbstractMetadataRebuilder.java:208)
	at org.sonatype.nexus.repository.maven.internal.orient.OrientMetadataRebuilder.rebuildInTransaction(OrientMetadataRebuilder.java:130)
	at org.sonatype.nexus.repository.maven.internal.orient.OrientMetadataRebuilder.rebuild(OrientMetadataRebuilder.java:112)
	at org.sonatype.nexus.repository.maven.internal.orient.MavenHostedFacetImpl.rebuildMetadata(MavenHostedFacetImpl.java:118)
	at org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask.execute(RebuildMaven2MetadataTask.java:60)
	at org.sonatype.nexus.repository.RepositoryTaskSupport.execute(RepositoryTaskSupport.java:79)
	at org.sonatype.nexus.scheduling.TaskSupport.call(TaskSupport.java:100)
	at org.sonatype.nexus.quartz.internal.task.QuartzTaskJob.doExecute(QuartzTaskJob.java:143)
	at org.sonatype.nexus.quartz.internal.task.QuartzTaskJob.execute(QuartzTaskJob.java:106)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	at org.sonatype.nexus.quartz.internal.QuartzThreadPool.lambda$0(QuartzThreadPool.java:145)
	at org.sonatype.nexus.thread.internal.MDCAwareRunnable.run(MDCAwareRunnable.java:40)
	at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120)
	at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
2023-05-28 01:01:00,257+0900 ERROR [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask - Failed to run task 'Rebuilding Maven Metadata of nightly'
org.sonatype.goodies.common.MultipleFailures$MultipleFailuresException: Failed to run task 'Rebuilding Maven Metadata of nightly'; 1 failure
	at org.sonatype.goodies.common.MultipleFailures.maybePropagate(MultipleFailures.java:95)
	at org.sonatype.nexus.repository.RepositoryTaskSupport.execute(RepositoryTaskSupport.java:90)
	at org.sonatype.nexus.scheduling.TaskSupport.call(TaskSupport.java:100)
	at org.sonatype.nexus.quartz.internal.task.QuartzTaskJob.doExecute(QuartzTaskJob.java:143)
	at org.sonatype.nexus.quartz.internal.task.QuartzTaskJob.execute(QuartzTaskJob.java:106)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	at org.sonatype.nexus.quartz.internal.QuartzThreadPool.lambda$0(QuartzThreadPool.java:145)
	at org.sonatype.nexus.thread.internal.MDCAwareRunnable.run(MDCAwareRunnable.java:40)
	at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120)
	at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
	Suppressed: java.lang.IllegalStateException: Timed out reading query result from queue 6c227267 after 60 seconds
		at org.sonatype.nexus.repository.storage.OrientAsyncHelper$QueueConsumingIterable.hasNext(OrientAsyncHelper.java:201)
		at java.util.Iterator.forEachRemaining(Iterator.java:115)
		at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
		at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
		at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
		at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
		at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)
		at org.sonatype.nexus.repository.maven.internal.orient.OrientMetadataRebuilder$OrientWorker.browseGAVs(OrientMetadataRebuilder.java:286)
		at org.sonatype.nexus.repository.maven.internal.hosted.metadata.AbstractMetadataRebuilder$Worker.rebuildMetadata(AbstractMetadataRebuilder.java:208)
		at org.sonatype.nexus.repository.maven.internal.orient.OrientMetadataRebuilder.rebuildInTransaction(OrientMetadataRebuilder.java:130)
		at org.sonatype.nexus.repository.maven.internal.orient.OrientMetadataRebuilder.rebuild(OrientMetadataRebuilder.java:112)
		at org.sonatype.nexus.repository.maven.internal.orient.MavenHostedFacetImpl.rebuildMetadata(MavenHostedFacetImpl.java:118)
		at org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask.execute(RebuildMaven2MetadataTask.java:60)
		at org.sonatype.nexus.repository.RepositoryTaskSupport.execute(RepositoryTaskSupport.java:79)
		... 13 common frames omitted
2023-05-28 01:01:00,257+0900 INFO  [quartz-12-thread-18]  *SYSTEM org.sonatype.nexus.repository.maven.tasks.RebuildMaven2MetadataTask - Task complete
2023-05-28 01:02:07,632+0900 WARN  [Thread-9338485 <command>sql.SELECT group as groupId, name as artifactId, set(attributes.maven2.baseVersion) as baseVersions FROM component WHERE bucket=:bucket GROUP BY group, name</command>]  *SYSTEM org.sonatype.nexus.repository.storage.OrientAsyncHelper$QueueFeedingResultListener - Timed out adding query result to queue 6c227267 after 60 seconds, aborting query
2023-05-28 01:03:07,644+0900 WARN  [Thread-9338485 <command>sql.SELECT group as groupId, name as artifactId, set(attributes.maven2.baseVersion) as baseVersions FROM component WHERE bucket=:bucket GROUP BY group, name</command>]  *SYSTEM org.sonatype.nexus.repository.storage.OrientAsyncHelper$QueueFeedingResultListener - Timed out adding end marker to queue 6c227267 after 60 seconds

Your Nexus instance may be under resourced for the load, or you may be missing indices.

Checking the metrics data, it appears that we are not running out of resources.
If it says missing indexes, how do I recover from this?