Nuget Groups not working anymore

Hi! We are using Nexus as our private Nuget and NPM repository since a couple of years.

We have created 3 hosted repositories (nuget) and a group to put this hosted repos and nuget.org. Everything was fine until a few days ago when some people noticed problems trying to retrieve packages. If you configure Visual Studio to use the group you can’t find any package. But if you point the configuration to the hosted repo everything seens to work. Any ideas what can be going wrong?

Looking for some logs I find the wrapper.log with lots of exceptions. Maybe the problem is related to this?

jvm 1 | 2020-04-09 08:23:48,456-0300 WARN [qtp45984288-83] anonymous com.sonatype.nexus.plugins.nuget.odata.ODataNugetGallery - Problem updating NuGet package in: nuget_gallery
jvm 1 | org.h2.jdbc.JdbcSQLException: Row not found when trying to delete from index "PUBLIC.BY_TIME: ( /* key:10521903 */ ‘nuget_gallery’, ‘https://www.nuget.org/api/v2/package/AWSSDK.Core/3.3.101.14’, CAST(‘AWSSDK.Core’ AS VARCHAR_IGNORECASE), CAST(‘3.3.101.14’ AS VARCHAR_IGNORECASE), CAST(‘Amazon Web Services’ AS VARCHAR_IGNORECASE), NULL, TIMESTAMP ‘2019-05-22 17:33:23.443’, CAST(’::net35|::net45|Microsoft.Net.Http:[2.2.29, ):portable-net45+win8+wp8+wpa81|PCLStorage:[1.0.2, ):portable-net45+win8+wp8+wpa81|PCLCrypto:[1.0.2.15130, ):portable-net45+win8+wp8+wpa81|PCLStorage:[1.0.2, ):monoandroid10|PCLCrypto:[1.0.2.15130, )

PD: using Nexus 2.14.15 with Windows Server 2012 Datacenter 64 Bits.

Looks like there is a problem with the database… you could try rebuilding it as described here:

1 Like

Thank you! Our repo is working again! :+1: