Upgrade to 6.3 Community FAIL

[JackRogers]

I was running OpenKM Community 6.2.5 on CentOS 6.5, installed with the "Quick Install" method.

When OpenKM 6.3 was released, it had a feature I needed, so I just followed these migration instructions:
http://wiki.openkm.com/index.php/Migrat ... 5_to_6.2.6
and
http://wiki.openkm.com/index.php/Migrat ... 2.6_to_6.3

The new feature I was expecting that did not show up. So I checked the OpenKM version (Help | About) and it still says it's 6.2.5. I've cleared my cache, and followed all the steps I can find--but it appears I'm still on 6.2.5.

Any suggestions?

Thanks.
Jack

[jllort]

If you still showing 6.2.5 that indicates really has not been upgraded. Be sure you've removed $TOMCAT/webapps/OpenKM and $TOMCAT/work/Catalina/localhost folders and you've replaced OpenKM.war file. If you've done it sure you must see 6.3 in about popup

[JackRogers]

If you still showing 6.2.5 that indicates really has not been upgraded. Be sure you've removed $TOMCAT/webapps/OpenKM and $TOMCAT/work/Catalina/localhost folders and you've replaced OpenKM.war file. If you've done it sure you must see 6.3 in about popup

Okay:

• removed the $TOMCAT/webapps/OpenKM and $TOMCAT/work/Catalina/localhost folders
• already replaced OpenKM.war
• changed the OpenKM.cfg file to hibernate.hbm2ddl=update (but it changed back to hibernate.hbm2ddl=none after restarting tomcat below)
• then ran $TOMCAT/bin/catalina.sh stop
• then $TOMCAT/bin/catalina.sh start

Now I get a java error:
Application error
Class: org.apache.jasper.JasperException
Message: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date: Tue May 27 08:18:09 CDT 2014

I tailed the catalina.out file:

Code: Select all

# tail -f catalina.out
        at bsh.Name.invokeMethod(Unknown Source)
        at bsh.BSHMethodInvocation.eval(Unknown Source)
        at bsh.BSHPrimaryExpression.eval(Unknown Source)
        at bsh.BSHPrimaryExpression.eval(Unknown Source)
        at bsh.Interpreter.eval(Unknown Source)
        at bsh.Interpreter.eval(Unknown Source)
        at bsh.Interpreter.eval(Unknown Source)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:724)
2014-05-27 16:01:55,881 [http-bio-0.0.0.0-8080-exec-6] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2014-05-27 16:01:55,882 [http-bio-0.0.0.0-8080-exec-6] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@7618a02[file =/opt/openkm-6.2.5-community/tomcat/repository/okmdb.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2014-05-27 21:01:54 heartbeat - read: -951 ms.)
2014-05-27 16:01:55,885 [http-bio-0.0.0.0-8080-exec-6] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM].[jsp] - Servlet.service() for servlet jsp threw exception
org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@7618a02[file =/opt/openkm-6.2.5-community/tomcat/repository/okmdb.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2014-05-27 21:01:54 heartbeat - read: -951 ms.
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
        at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
        at org.hsqldb.persist.Logger.openPersistence(Unknown Source)
        at org.hsqldb.Database.reopen(Unknown Source)
        at org.hsqldb.Database.open(Unknown Source)
        at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
        at org.hsqldb.DatabaseManager.newSession(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
        at org.hibernate.loader.Loader.doQuery(Loader.java:801)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2542)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.openkm.dao.LanguageDAO.findAll(LanguageDAO.java:104)
        at com.openkm.dao.LanguageDAO.findAll(LanguageDAO.java:78)
        at org.apache.jsp.login_005fdesktop_jsp._jspService(login_005fdesktop_jsp.java:167)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530)
        at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
        at org.apache.jsp.login_jsp._jspService(login_jsp.java:63)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:724)
2014-05-27 16:01:55,894 [http-bio-0.0.0.0-8080-exec-6] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM].[jsp] - Servlet.service() for servlet [jsp] in context with path [/OpenKM] threw exception [An exception occurred processing JSP page /login.jsp at line 2

1: <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
2: <jsp:include page="login_desktop.jsp">
3:   <jsp:param name="error" value="${param.error}"/>
4: </jsp:include>
5:

I'll continue to look through this, but if anyone sees an obvious problem, please let me know.

Jack

[jllort]

Seems you've not stopped correctly the application and database seems is locked ?
Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@7618a02[file =/opt/openkm-6.2.5-community/tomcat/repository/okmdb.lck

Stop application and remove this file.

[JackRogers]

Seems you've not stopped correctly the application and database seems is locked ?
Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@7618a02[file =/opt/openkm-6.2.5-community/tomcat/repository/okmdb.lck

Stop application and remove this file.

I ran "catalina.sh stop 20" and it exited before 20 seconds and removed the pid file. I don't know why it failed to remove the db lock file, but you're right--I remember seeing the okmdb.lck file.

Too late now, I've already uninstalled it and wiped out the whole directory. I'm re-installing it without the wizard, so that I will have more control. I'd wanted to have it running as a non-root user (tomcat rather than root). When I'm done, I should have a clean install of 6.3. Maybe the next upgrade will go more smoothly!

Thanks for the help.

Jack

[jllort]

I suggest do not use embeded HSQL in productions, consider migrate to MySQL or other DBMS. Is quite easy bad computer shutdown break HSQL database.

[JackRogers]

I suggest do not use embeded HSQL in productions, consider migrate to MySQL or other DBMS. Is quite easy bad computer shutdown break HSQL database.

I thought I read somewhere that the Community edition did not allow anything but HSQL. But it appears you're correct.

Right now, we're just doing a demo/POC. If the business users like it, and we choose to adopt OpenKM, we'll certainly keep this in mind.

Jack

[jllort]

You can install with Mysql, PostgreSQL or SQL Server. The restrictions are for Oracle what need special source code only available in professional version.