0 Replies Latest reply on Apr 23, 2014 4:23 PM by Jhon Cuzcano

    Database exception when drools-guvnor use mysql

    Jhon Cuzcano Newbie

      We have drools-guvnor 5.5.0.Final version, application server Jboss 7.1.1. Guvnor was configured with an external RDBMS in our case is mysql, the files were modfied according with the documentation, but when the application is started the log showing this error

       

      01:01:19,884 ERROR [org.apache.jackrabbit.core.util.db.ConnectionHelper] (http--10.10.0.191-8080-14) Failed to execute SQL (stacktrace on DEBUG log level): java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

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

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

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

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

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

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)

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

        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)

        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

        at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:438) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:284) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:267) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:263) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:458) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:263) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.data.db.DbDataStore.addRecord(DbDataStore.java:361) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.value.BLOBInDataStore.getInstance(BLOBInDataStore.java:119) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.value.InternalValue.getBLOBFileValue(InternalValue.java:619) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.value.InternalValue.create(InternalValue.java:369) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.value.InternalValueFactory.create(InternalValueFactory.java:94) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.apache.jackrabbit.core.value.ValueFactoryImpl.createBinary(ValueFactoryImpl.java:74) [jackrabbit-core-2.2.8.jar:2.2.8]

        at org.drools.repository.ModuleItem.updateCompiledBinary(ModuleItem.java:1027) [guvnor-repository-5.5.0.Final.jar:5.5.0.Final]

        at org.drools.guvnor.server.builder.PackageAssembler.compile(PackageAssembler.java:76) [guvnor-webapp-core-5.5.0.Final.jar:5.5.0.Final]

        at org.drools.guvnor.server.RepositoryModuleOperations.buildModule(RepositoryModuleOperations.java:547) [guvnor-webapp-core-5.5.0.Final.jar:5.5.0.Final]

        at org.drools.guvnor.server.RepositoryModuleOperations.buildModule(RepositoryModuleOperations.java:519) [guvnor-webapp-core-5.5.0.Final.jar:5.5.0.Final]

        at org.drools.guvnor.server.RepositoryModuleOperations$Proxy$_$$_WeldClientProxy.buildModule(RepositoryModuleOperations$Proxy$_$$_WeldClientProxy.java) [guvnor-webapp-core-5.5.0.Final.jar:5.5.0.Final]

        at org.drools.guvnor.server.RepositoryModuleService.buildPackage(RepositoryModuleService.java:302) [guvnor-webapp-core-5.5.0.Final.jar:5.5.0.Final]

        at org.drools.guvnor.server.RepositoryModuleService$Proxy$_$$_WeldClientProxy.buildPackage(RepositoryModuleService$Proxy$_$$_WeldClientProxy.java) [guvnor-webapp-core-5.5.0.Final.jar:5.5.0.Final]

        at org.drools.guvnor.server.ModuleServiceServlet.buildPackage(ModuleServiceServlet.java:104) [guvnor-webapp-core-5.5.0.Final.jar:5.5.0.Final]

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_33]

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_33]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_33]

        at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_33]

        at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569) [gwt-servlet-2.4.0.jar:]

        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208) [gwt-servlet-2.4.0.jar:]

        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]

        at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

        at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

        at org.jboss.solder.servlet.exception.CatchExceptionFilter.doFilter(CatchExceptionFilter.java:65) [solder-impl-3.1.1.Final.jar:3.1.1.Final]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

        at org.jboss.solder.servlet.event.ServletEventBridgeFilter.doFilter(ServletEventBridgeFilter.java:74) [solder-impl-3.1.1.Final.jar:3.1.1.Final]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.10.Final.jar:]

        at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:154) [jboss-as-web-7.1.0.Final.jar:7.1.0.Final]

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.10.Final.jar:]

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.10.Final.jar:]

        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897) [jbossweb-7.0.10.Final.jar:]

        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626) [jbossweb-7.0.10.Final.jar:]

        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033) [jbossweb-7.0.10.Final.jar:]

        at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_33]

       

      in the database showing this query

       

      UPDATE datastore_DATASTORE SET DATA=_binary'READ COMMITTEDLOCK WAIT

       

      The parameter innodb_lock_wait_timeout was updated but the error persist.

       

      Please can you help us in order to identified if any configuration is missing

       

      Thank you.