Browsing Assets and Components in Nexus-3.2.1-01 returns no result for some Repositories

[Bashar Hoque]

We have upgraded Nexus 2.14.3-02 to Nexus-3.2.1-01 with repository size of 1.8TB. While browsing in Nexus-3.2.1-01, some of the large repositories are not returning any result. 

On the Nexus OSS GUI, the search continues for a few minutes, then an error message shows "Operation failed, could not connect to server". 

Nexus.log shows 

{code}

ERROR [qtp1796114345-123] <ID> org.sonatype.nexus.extdirect.internal.ExtDirectServlet - Failed to invoke action method: coreui_Component.read, java-method: org.sonatype.nexus.coreui.ComponentComponent.read

java.lang.IllegalArgumentException: expected one element but was: <null, #-2:0{COUNT:143344} v0>

{code}

For Maven2 and a few others, the log shows

{code}

 INFO  [Thread-60] <ID> com.orientechnologies.common.profiler.OProfilerStub - $ANSI{green {db=component}} [TIP] Query 'SELECT COUNT(DISTINCT(component)) FROM asset WHERE (contentAuth(@this, "maven2") == true ) AND (bucket = #11:7 OR bucket = #11:9 OR bucket = #11:8 OR bucket = #11:13 OR bucket = #11:44 OR bucket = #11:19 OR bucket = #11:20 OR bucket = #11:10 OR bucket = #11:21 OR bucket = #11:22 OR bucket = #11:23 OR bucket = #11:14 OR bucket = #11:24 OR bucket = #11:12 OR bucket = #11:25 OR bucket = #11:26 OR bucket = #11:27 OR bucket = #11:28 OR bucket = #11:29 OR bucket = #11:30 OR bucket = #11:31 OR bucket = #11:15 OR bucket = #11:32 OR bucket = #11:33 OR bucket = #11:16 OR bucket = #11:34 ) AND (component IS NOT NULL )' fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index

{code}

There is no way to add index in N3 Repositories.

[Rok Prodan]

Hi Bashar,

just update your Nexus Repository to the latest version i. e. 3.3.1.

Issues with slow search through components and assets was fixed in 3.3.0 as far as I know.

Kind regards,

Rok Prodan

--
You received this message because you are subscribed to the Google Groups "Nexus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nexus-users...@glists.sonatype.com.
To post to this group, send email to nexus...@glists.sonatype.com.
To view this discussion on the web visit https://groups.google.com/a/glists.sonatype.com/d/msgid/nexus-users/68f1e694-ba71-4fdf-9ffc-b85e8c5a131a%40glists.sonatype.com.
For more options, visit https://groups.google.com/a/glists.sonatype.com/d/optout.

[Bashar Hoque]

Hi Rok,

Thank you very much for suggestion.

Upgraded to nexus-3.3.1-01. After upgrading to 3.3.1-01, browsing improved for most of the Repos except for 2.  Browsing still times out for releases(components), and maven-public(assets).

Regards,

Bashar Hoque 

On Wed, May 17, 2017 at 4:39 PM, Rok Prodan <rok.p...@gmail.com> wrote:

Hi Bashar,

just update your Nexus Repository to the latest version i. e. 3.3.1.

Issues with slow search through components and assets was fixed in 3.3.0 as far as I know.

Kind regards,

Rok Prodan

On Wed, 17 May 2017 at 20:41, 'Bashar Hoque' via Nexus Users <nexus...@glists.sonatype.com> wrote:

We have upgraded Nexus 2.14.3-02 to Nexus-3.2.1-01 with repository size of 1.8TB. While browsing in Nexus-3.2.1-01, some of the large repositories are not returning any result. 

On the Nexus OSS GUI, the search continues for a few minutes, then an error message shows "Operation failed, could not connect to server". 

Nexus.log shows 

{code}

ERROR [qtp1796114345-123] <ID> org.sonatype.nexus.extdirect.internal.ExtDirectServlet - Failed to invoke action method: coreui_Component.read, java-method: org.sonatype.nexus.coreui.ComponentComponent.read

java.lang.IllegalArgumentException: expected one element but was: <null, #-2:0{COUNT:143344} v0>

{code}

For Maven2 and a few others, the log shows

{code}

 INFO  [Thread-60] <ID> com.orientechnologies.common.profiler.OProfilerStub - $ANSI{green {db=component}} [TIP] Query 'SELECT COUNT(DISTINCT(component)) FROM asset WHERE (contentAuth(@this, "maven2") == true ) AND (bucket = #11:7 OR bucket = #11:9 OR bucket = #11:8 OR bucket = #11:13 OR bucket = #11:44 OR bucket = #11:19 OR bucket = #11:20 OR bucket = #11:10 OR bucket = #11:21 OR bucket = #11:22 OR bucket = #11:23 OR bucket = #11:14 OR bucket = #11:24 OR bucket = #11:12 OR bucket = #11:25 OR bucket = #11:26 OR bucket = #11:27 OR bucket = #11:28 OR bucket = #11:29 OR bucket = #11:30 OR bucket = #11:31 OR bucket = #11:15 OR bucket = #11:32 OR bucket = #11:33 OR bucket = #11:16 OR bucket = #11:34 ) AND (component IS NOT NULL )' fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index

{code}

There is no way to add index in N3 Repositories.

--
You received this message because you are subscribed to the Google Groups "Nexus Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to nexus-users+unsubscribe@glists.sonatype.com.

[rok.p...@gmail.com]

Hi Bashar,

have you tried to schedule Rebuild repository indexes and Rebuild Maven metadata tasks on all repositories?
Or at least on those two problematic?


Regards,

Rok Prodan

Bashar Hoque 

 

 

To unsubscribe from this group and stop receiving emails from it, send an email to nexus-users...@glists.sonatype.com.

[Bashar Hoque]

Hi Rok,

Thanks for the suggestion. Upon your suggestion, I created  and ran tasks to rebuild Repo index and rebuild Repo metadata for one of the Repos (releases). After that  browsing components of that Repo still times out after 1 minute. Browsing the Assets is ok for that same repo. For the other Reop (maven-public), I could not create the tasks since that Repo does not show up as an option in the Repo selection drop-down list in the task creation. 

I will be creating a issue jira with sonatype.

Regards,

Bashar Hoque 

Bashar Hoque 

 

 

To unsubscribe from this group and stop receiving emails from it, send an email to nexus-users+unsubscribe@glists.sonatype.com.

To post to this group, send email to nexus...@glists.sonatype.com.
To view this discussion on the web visit https://groups.google.com/a/glists.sonatype.com/d/msgid/nexus-users/68f1e694-ba71-4fdf-9ffc-b85e8c5a131a%40glists.sonatype.com.
For more options, visit https://groups.google.com/a/glists.sonatype.com/d/optout.

 

 

--

You received this message because you are subscribed to the Google Groups "Nexus Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to nexus-users+unsubscribe@glists.sonatype.com.

To post to this group, send email to nexus...@glists.sonatype.com.

To view this discussion on the web visit https://groups.google.com/a/glists.sonatype.com/d/msgid/nexus-users/591db2b0.d28bdf0a.7f3c2.0178%40mx.google.com.

For more options, visit https://groups.google.com/a/glists.sonatype.com/d/optout.

--

[Kelly Robinson]

Hi Bashar,

This is actually a known issue, and we have someone working on it right now: https://issues.sonatype.org/browse/NEXUS-13095

In the meantime, sorry for the pain and we'll try to have a release with better performance for this view asap.

To view this discussion on the web visit https://groups.google.com/a/glists.sonatype.com/d/msgid/nexus-users/CAMq6Kx2SgQZ8qPjzF4u03sQCq%2BLr66ZTxuyAOhMJYdvV7984hg%40mail.gmail.com.

[Bashar Hoque]

Hello Kelly,

Thank you very much for sharing the information. 

Regards,

Bashar Hoque