Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-22241

OCommandExecutionException: Class 'BROWSE_NODE' was not found in database 'component'

    XMLWordPrintable

    Details

      Description

      Upgrading NXRM 3.16.1-02 to 3.20.0-04 fails with below exception:

      - - - - - - - - - - - - - - - - - - - - - - - - -
      Apply upgrade
      - - - - - - - - - - - - - - - - - - - - - - - - -
      2019-12-16 01:49:27,185-0600 INFO  [FelixStartLevel]  *SYSTEM org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl - Upgrade usertoken from 1.0 to 1.1
      2019-12-16 01:49:27,296-0600 INFO  [FelixStartLevel]  *SYSTEM org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl - Upgrade component from 1.13 to 1.14
      2019-12-16 01:49:27,766-0600 INFO  [FelixStartLevel]  *SYSTEM org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl - Upgrade config from 1.6 to 1.7
      2019-12-16 01:49:27,865-0600 INFO  [FelixStartLevel]  *SYSTEM org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl - Upgrade config from 1.7 to 1.8
      2019-12-16 01:49:28,163-0600 INFO  [FelixStartLevel]  *SYSTEM org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl - Upgrade pypi from 1.0 to 1.1
      2019-12-16 01:49:28,209-0600 INFO  [FelixStartLevel]  *SYSTEM org.sonatype.nexus.repository.pypi.upgrade.PypiUpgrade_1_1 - Scanning pypi repository pypi-hosted for index file assets
      2019-12-16 01:49:28,246-0600 ERROR [FelixStartLevel <command>sql.delete from browse_node where repository_name = ?</command>]  *SYSTEM com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage - Exception `20B2C968` in storage `plocal:/data/sonatype-work/nexus3/db/component`: 2.2.36 (build d3beb772c02098ceaea89779a7afd4b7305d3788, branch 2.2.x)
      com.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing query at position #12: Error on parsing query
      Query:  browse_node WHERE repository_name = "pypi-hosted"
      -----------------^^M
              DB name="component"
              at com.orientechnologies.orient.core.sql.filter.OSQLTarget.<init>(OSQLTarget.java:74)
              at com.orientechnologies.orient.core.sql.OSQLEngine.parseTarget(OSQLEngine.java:464)
              at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:278)
              at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:93)
              at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:53)
              at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:34)
              at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.command(OAbstractPaginatedStorage.java:3302)
              at com.orientechnologies.orient.core.sql.query.OSQLQuery.run(OSQLQuery.java:78)
              at com.orientechnologies.orient.core.sql.query.OSQLAsynchQuery.run(OSQLAsynchQuery.java:74)
              at com.orientechnologies.orient.core.query.OQueryAbstract.execute(OQueryAbstract.java:33)
              at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelete.execute(OCommandExecutorSQLDelete.java:200)
              at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OCommandExecutorSQLDelegate.java:70)
              at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.executeCommand(OAbstractPaginatedStorage.java:3400)
              at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.command(OAbstractPaginatedStorage.java:3318)
              at com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:69)
              at org.sonatype.nexus.repository.pypi.upgrade.PypiUpgrade_1_1.lambda$1(PypiUpgrade_1_1.java:118)
              at java.util.ArrayList.forEach(ArrayList.java:1257)
              at org.sonatype.nexus.repository.pypi.upgrade.PypiUpgrade_1_1.deleteIndexes(PypiUpgrade_1_1.java:104)
              at org.sonatype.nexus.repository.pypi.upgrade.PypiUpgrade_1_1.apply(PypiUpgrade_1_1.java:87)
              at org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl.lambda$2(UpgradeServiceImpl.java:183)
              at java.util.ArrayList.forEach(ArrayList.java:1257)
              at org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl.doUpgrade(UpgradeServiceImpl.java:125)
              at org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl.doStart(UpgradeServiceImpl.java:90)
              at org.sonatype.nexus.common.stateguard.StateGuardLifecycleSupport.start(StateGuardLifecycleSupport.java:67)
              at org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl$$EnhancerByGuice$$dbe05174.CGLIB$start$4(<generated>)
              at org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl$$EnhancerByGuice$$dbe05174$$FastClassByGuice$$2ae549d6.invoke(<generated>)
              at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
              at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76)
              at org.sonatype.nexus.common.stateguard.MethodInvocationAction.run(MethodInvocationAction.java:39)
              at org.sonatype.nexus.common.stateguard.StateGuard$TransitionImpl.run(StateGuard.java:193)
              at org.sonatype.nexus.common.stateguard.TransitionsInterceptor.invoke(TransitionsInterceptor.java:56)
              at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:77)
              at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:55)
              at org.sonatype.nexus.upgrade.internal.UpgradeServiceImpl$$EnhancerByGuice$$dbe05174.start(<generated>)
              at org.sonatype.nexus.extender.NexusLifecycleManager.startComponent(NexusLifecycleManager.java:199)
              at org.sonatype.nexus.extender.NexusLifecycleManager.to(NexusLifecycleManager.java:111)
              at org.sonatype.nexus.extender.NexusContextListener.moveToPhase(NexusContextListener.java:312)
              at org.sonatype.nexus.extender.NexusContextListener.frameworkEvent(NexusContextListener.java:209)
              at org.apache.felix.framework.Felix.setActiveStartLevel(Felix.java:1431)
              at org.apache.felix.framework.FrameworkStartLevelImpl.run(FrameworkStartLevelImpl.java:308)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: com.orientechnologies.orient.core.exception.OCommandExecutionException: Class 'BROWSE_NODE' was not found in database 'component'^M
              DB name="component"
              at com.orientechnologies.orient.core.sql.filter.OSQLTarget.extractTargets(OSQLTarget.java:273)
              at com.orientechnologies.orient.core.sql.filter.OSQLTarget.<init>(OSQLTarget.java:64)
              ... 40 common frames omitted
      

      WORKAROUND:

      Upgrading to 3.19.1 (not 3.19.0) first, then upgrade to 3.20.0.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              hosako Hajime Osako
              CC:
              Hudson Huang
              Last Updated By:
              Michael Prescott Michael Prescott
              Team:
              NXRM - Groot
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response:

                  tigCommentSecurity.panel-title