R repositories not browsable with a H2 database backend

post by dj674 on Mar 10, 2025

We successfully migrated from OrientDB to H2 database on version 3.70.3 and upgraded all the say up to 3.76.0 without seeing this issue.

Then we upgraded to version 3.77-0 and was unable to see our R repositories in the Nexus interface. It would simply read “A Database Error occured”.

We have upgraded to 3.77-1 and the issue still remains.

Could only see the below in the logs.

2025-02-17 17:26:41,846+0000 ERROR [qtp919751032-534] *UNKNOWN org.sonatype.nexus.extdirect.internal.ExtDirectExceptionHandler - Failed to invoke action method: coreui_Browse.read, java-method: org.sonatype.nexus.coreui.BrowseComponent.read

org.sonatype.nexus.datastore.api.DataAccessException:

Error querying database. Cause: java.lang.NumberFormatException: For input string: “conan”

at org.sonatype.nexus.datastore.mybatis.DataAccessSqlSession.unwrapMyBatisException(DataAccessSqlSession.java:125)

at org.sonatype.nexus.datastore.mybatis.DataAccessSqlSession.selectList(DataAccessSqlSession.java:76)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)

at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)

at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)

at org.sonatype.nexus.repository.content.browse.store.BrowseNodeStore.getByDisplayPath(BrowseNodeStore.java:64)

at org.sonatype.nexus.transaction.TransactionalWrapper.proceedWithTransaction(TransactionalWrapper.java:58)

at org.sonatype.nexus.transaction.TransactionInterceptor.proceedWithTransaction(TransactionInterceptor.java:66)

at org.sonatype.nexus.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55)

at org.sonatype.nexus.repository.content.browse.store.BrowseNodeManager.getByDisplayPath(BrowseNodeManager.java:67)

at org.sonatype.nexus.repository.content.browse.BrowseFacetImpl.getByDisplayPath(BrowseFacetImpl.java:125)

at org.sonatype.nexus.common.stateguard.MethodInvocationAction.run(MethodInvocationAction.java:39)

at org.sonatype.nexus.common.stateguard.StateGuard$GuardImpl.run(StateGuard$GuardImpl.java:298)

at org.sonatype.nexus.common.stateguard.GuardedInterceptor.invoke(GuardedInterceptor.java:54)

at org.sonatype.nexus.repository.content.browse.store.BrowseNodeQueryServiceImpl.lambda$selectByPath$3(BrowseNodeQueryServiceImpl.java:184)

at java.base/java.util.Optional.map(Optional.java:260)

at org.sonatype.nexus.repository.content.browse.store.BrowseNodeQueryServiceImpl.selectByPath(BrowseNodeQueryServiceImpl.java:184)

at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)

at java.base/java.util.ArrayList$ArrayListSpliterator.tryAdvance(ArrayList.java:1602)

at java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:129)

at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1158)

Has anybody else seen this issue?

I saw a post saying someone had the same issue with a postgresql backend but not a H2.

96 views

post by mpiggott on Mar 11, 2025

This should be fixed in 3.79.

post by dj674 on Mar 11, 2025

Great - thank you for the update. Here’s to version 3.79!