6 Replies Latest reply on May 2, 2007 1:46 PM by dolan.halbrook

    Issue logging into admin console after upgrade to 1.1

      Hi all,

       

      I'm seeing the following stack trace in the logs after upgrading to 1.1:

      com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'd.versionID' in 'where clause'

              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)

              at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)

              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)

              at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)

              at com.jivesoftware.community.impl.QueryCache.getCount(QueryCache.java:411)

              at com.jivesoftware.community.impl.DbDocumentManager.getUserDocumentCount(DbDocumentManager.java:249)

              at com.jivesoftware.community.proxy.DocumentManagerProxy.getUserDocumentCount(DocumentManagerProxy.java:128)

              at com.jivesoftware.community.action.UserBar.execute(UserBar.java:43)

              at sun.reflect.GeneratedMethodAccessor1263.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:585)

              at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:364)

              at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:216)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

              at com.jivesoftware.community.web.webwork.FlashInterceptor.intercept(FlashInterceptor.java:41)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168)

              at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)

              at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.jivesoftware.community.web.webwork.JiveObjectLoaderInterceptor.intercept(JiveObjectLoaderInterceptor.java:55)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.jivesoftware.community.web.webwork.JiveIOCInterceptor.intercept(JiveIOCInterceptor.java:640)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.jivesoftware.community.web.webwork.AuthInterceptor.intercept(AuthInterceptor.java:46)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.jivesoftware.community.action.LocaleInterceptor.intercept(LocaleInterceptor.java:92)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.jivesoftware.community.web.webwork.ModuleCheckInterceptor.intercept(ModuleCheckInterceptor.java:49)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:188)

              at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113)

              at com.opensymphony.webwork.components.ActionComponent.executeAction(ActionComponent.java:226)

              at com.opensymphony.webwork.components.ActionComponent.end(ActionComponent.java:124)

              at com.opensymphony.webwork.views.freemarker.tags.CallbackWriter.afterBody(CallbackWriter.java:65)

              at freemarker.core.Environment.visit(Environment.java:235)

              at freemarker.core.UnifiedCall.accept(UnifiedCall.java:116)

              at freemarker.core.Environment.visit(Environment.java:196)

              at freemarker.core.MixedContent.accept(MixedContent.java:92)

              at freemarker.core.Environment.visit(Environment.java:196)

              at freemarker.core.Environment.process(Environment.java:176)

              at freemarker.template.Template.process(Template.java:232)

              at com.jivesoftware.community.theme.ThemeFilter.loadDefaultDecorator(ThemeFilter.java:118)

              at com.jivesoftware.community.theme.ThemeFilter.applyDecorator(ThemeFilter.java:90)

              at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:59)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at com.jivesoftware.community.web.JiveActionContextCleanUp.doFilter(JiveActionContextCleanUp.java:46)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at com.jivesoftware.community.web.filter.PresenceFilter.doFilter(PresenceFilter.java:106)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at com.jivesoftware.community.web.filter.SetRequestCharacterEncodingFilter.doFilter(SetRequestCharacterEncodingFilter.java:73)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at com.jivesoftware.community.upgrade.UpgradeFilter.doFilter(UpgradeFilter.java:43)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:71)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at com.jivesoftware.community.web.filter.ApplicationInitializedFilter.doFilter(ApplicationInitializedFilter.java:95)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at com.jivesoftware.base.database.dao.DAOContextCleanUpFilter.doFilter(DAOContextCleanUpFilter.java:32)

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

              at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

              at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

              at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

              at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

              at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

              at java.lang.Thread.run(Thread.java:595)

       

      At that point, I get a stack trace on the screen like so:

       

       

      System Error

       

      We're sorry but a serious error has occurred in the system. If you are a system administrator please click "more details" below for more information about this error.

      More Details

       

           

      • Status Code: 500

           

      • Exception Type: null

           

      • Error Message:

           

      • Request URI: /clearspace/admin/main.jsp

           

      • Stack Trace:

                o org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)

                o org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)

                o org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

                o org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

                o javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)

                o org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)

                o org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)

                o com.opensymphony.module.sitemesh.filter.PageFilter.applyDecorator(PageFilter.java:156)

                o com.jivesoftware.community.theme.ThemeFilter.applyDecorator(ThemeFilter.java:88)

                o com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:59)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.JiveActionContextCleanUp.doFilter(JiveActionContextCleanUp.java:46)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.SetRequestCharacterEncodingFilter.doFilter(SetRequestCharacterEncodingFilter.java:73)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.upgrade.UpgradeFilter.doFilter(UpgradeFilter.java:43)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:71)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.ApplicationInitializedFilter.doFilter(ApplicationInitializedFilter.java:95)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.base.database.dao.DAOContextCleanUpFilter.doFilter(DAOContextCleanUpFilter.java:32)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

                o org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

                o org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

                o org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

                o org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

                o org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

                o org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

                o org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

                o org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

                o org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

                o org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

                o java.lang.Thread.run(Thread.java:595)

           

      • org.apache.jasper.JasperException: com/jivesoftware/base/admin/AdminConsole

       

      Any help would be greatly appreciated.

       

      Thanks,

      Dolan

        • Re: Issue logging into admin console after upgrade to 1.1

          hi Dolan,

           

          Looks like the versionID column didn't get created by the upgrade task: when you went through the upgrade task did it report any errors?  Can you do this from the command line against your mySQL instance:

           

          desc jiveDocument

           

          You should see something like this:

           

          ----


          --
          +
          --+-+
          +
          -----+

          Field

          Type

          Null

          Key

          Default

          Extra

          ----


          --
          +
          --+-+
          +
          -----+

          internalDocID

          bigint(20)

          NO

          PRI

          userID

          bigint(20)

          NO

          documentID

          varchar(255)

          NO

          UNI

          communityID

          bigint(20)

          NO

          typeID

          bigint(20)

          NO

          editPolicy

          int(11)

          NO

          creationDate

          bigint(20)

          NO

          expirationDate

          bigint(20)

          NO

          MUL

          recommended

          smallint(6)

          NO

          meanRating

          int(11)

          NO

          readCount

          int(11)

          NO

          commentStatus

          int(11)

          NO

          trackbacksEnabled

          smallint(6)

          NO

          workflowID

          bigint(20)

          YES

          versionID

          int(11)

          NO

          ----


          --
          +
          --+-+
          +
          -----+

          15 rows in set (0.08 sec)

           

          Note the last column is 'versionID'.

           

          Did you get any errors while going through the upgrade process?

           

          Cheers,

           

          AJ

            • Re: Issue logging into admin console after upgrade to 1.1

              Thanks AJ,

               

              I think the process hung, so I restarted the JVM, then it worked as expected (apparently not).  The versionID column is missing.

               

              Can you post a diff of the DB between 1.0.4 and 1.1 so I can verify the tables?

               

              Thanks again,

              Dolan

                • Re: Issue logging into admin console after upgrade to 1.1

                  hi Dolan,

                   

                  The upgrade tasks do more than just modify the schema so the best plan of action would be to restore your 1.0.4 database, restart the app server and then let the upgrade tasks do their work. 

                   

                  If you didn't backup your 1.0.4 database, you can try updating a value in the jiveVersion table:

                   

                  UPDATE jiveVersion SET version = 104001 WHERE name = 'clearspace';

                   

                  and then restart your app server and let the upgrade tasks run again. If any of the tasks previous to the task that upgrades the jiveDocument table with the versionID column ran, they might fail but you can safely ignore those. 

                   

                  Cheers,

                   

                  AJ

                    • Re: Issue logging into admin console after upgrade to 1.1

                      Hi AJ,

                       

                      I re-ran the upgrade taks and it did it's thing -- green lights throughout and no problems.

                       

                      However, i'm still getting an error while logging into the admin console.  It takes a while (over two minutes) before throwing the error:

                       

                           

                      •   Status Code: 500

                           

                      • Exception Type: null

                           

                      • Error Message:

                           

                      • Request URI: /clearspace/admin/main.jsp

                           

                      • Stack Trace:

                                o org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)

                                o org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)

                                o org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

                                o org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

                                o javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)

                                o org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)

                                o org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)

                                o com.opensymphony.module.sitemesh.filter.PageFilter.applyDecorator(PageFilter.java:156)

                                o com.jivesoftware.community.theme.ThemeFilter.applyDecorator(ThemeFilter.java:88)

                                o com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:59)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o com.jivesoftware.community.web.JiveActionContextCleanUp.doFilter(JiveActionContextCleanUp.java:46)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o com.jivesoftware.community.web.filter.SetRequestCharacterEncodingFilter.doFilter(SetRequestCharacterEncodingFilter.java:73)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o com.jivesoftware.community.upgrade.UpgradeFilter.doFilter(UpgradeFilter.java:43)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:71)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o com.jivesoftware.community.web.filter.ApplicationInitializedFilter.doFilter(ApplicationInitializedFilter.java:95)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o com.jivesoftware.base.database.dao.DAOContextCleanUpFilter.doFilter(DAOContextCleanUpFilter.java:32)

                                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                                o org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

                                o org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

                                o org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

                                o org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

                                o org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

                                o org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

                                o org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

                                o org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

                                o org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

                                o org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

                                o org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

                                o java.lang.Thread.run(Thread.java:595)

                           

                      • org.apache.jasper.JasperException: com/jivesoftware/base/admin/AdminConsole

                       

                      In the logs, I see:

                       

                          SEVERE: XML properties file does not exist: /opt/clearspaceHome/null

                      java.io.FileNotFoundException: XML properties file does not exist: /opt/clearspaceHome/null

                              at com.jivesoftware.community.impl.XMLJiveProperties.<init>(XMLJiveProperties.java:85)

                              at com.jivesoftware.community.JiveGlobals.loadSetupProperties(JiveGlobals.java:1520)

                              at com.jivesoftware.community.JiveGlobals.getLocalProperty(JiveGlobals.java:1080)

                              at com.jivesoftware.base.database.ConnectionManager.getConnection(ConnectionManager.java:92)

                              at com.jivesoftware.community.impl.DbJiveProperties.loadProperties(DbJiveProperties.java:461)

                              at com.jivesoftware.community.impl.DbJiveProperties.init(DbJiveProperties.java:100)

                              at com.jivesoftware.community.impl.DbJiveProperties.<init>(DbJiveProperties.java:85)

                              at com.jivesoftware.community.impl.DbJiveProperties.getInstance(DbJiveProperties.java:66)

                              at com.jivesoftware.community.JiveGlobals.getJivePropertyNames(JiveGlobals.java:1268)

                              at com.jivesoftware.community.search.analyzer.SynonymFilter.createSynonymMap(SynonymFilter.java:281)

                              at com.jivesoftware.community.search.analyzer.SynonymFilter.<clinit>(SynonymFilter.java:43)

                              at sun.misc.Unsafe.ensureClassInitialized(Native Method)

                              at sun.reflect.UnsafeFieldAccessorFactory.newFieldAccessor(UnsafeFieldAccessorFactory.java:25)

                              at sun.reflect.ReflectionFactory.newFieldAccessor(ReflectionFactory.java:122)

                              at java.lang.reflect.Field.acquireFieldAccessor(Field.java:917)

                              at java.lang.reflect.Field.getFieldAccessor(Field.java:898)

                              at java.lang.reflect.Field.set(Field.java:656)

                              at org.apache.catalina.loader.WebappClassLoader.clearReferences(WebappClassLoader.java:1608)

                              at org.apache.catalina.loader.WebappClassLoader.stop(WebappClassLoader.java:1489)

                              at org.apache.catalina.loader.WebappLoader.stop(WebappLoader.java:706)

                              at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4387)

                              at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:892)

                              at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1164)

                              at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1135)

                              at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:312)

                              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

                              at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1054)

                              at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1066)

                              at org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:447)

                              at org.apache.catalina.core.StandardService.stop(StandardService.java:512)

                              at org.apache.catalina.core.StandardServer.stop(StandardServer.java:743)

                              at org.apache.catalina.startup.Catalina.stop(Catalina.java:601)

                              at org.apache.catalina.startup.Catalina.start(Catalina.java:576)

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                              at java.lang.reflect.Method.invoke(Method.java:585)

                              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)

                              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)

                      May 1, 2007 6:03:53 PM org.apache.coyote.http11.Http11BaseProtocol destroy

                      INFO: Stopping Coyote HTTP/1.1 on http-8080

                      May 1, 2007 6:03:53 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent

                      INFO: Failed shutdown of Apache Portable Runtime

                       

                      but I only see this on server shutdown.

                       

                      I'll try running it locally against the same DB to see if the issue is at the DB level or in the clearspaceHome directory.