[esb-issues] [JBoss JIRA] Closed: (JBESB-3633) jBPM fails to start when using MySQL cluster as backing database

Boris Belovic (JIRA) jira-events at lists.jboss.org
Wed Jul 13 10:10:23 EDT 2011 

     [ https://issues.jboss.org/browse/JBESB-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Boris Belovic closed JBESB-3633.
--------------------------------



> jBPM fails to start when using MySQL cluster as backing database
> ----------------------------------------------------------------
>
>                 Key: JBESB-3633
>                 URL: https://issues.jboss.org/browse/JBESB-3633
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Rosetta
>    Affects Versions: 4.9
>         Environment: SOA-P 5.1.GA, jdk1.6u22, MySQL Cluster 7.1.3
>            Reporter: Boris Belovic
>         Attachments: server.log.tar.bz2
>
>
> JBQA-4748 requests certification of SOA-P with MySQL cluster database. I configured SOA-P using schema tool to run against internal MySQL cluster instance. Everything went OK, but when the server tried to initialize (or execute) JBPM related SQL files I got following exception:
>  INFO  [DatabaseInitializer] Initializing java:/JbpmDS from listed sql files
> 14:49:58,186 ERROR [AbstractKernelController] Error installing to Start: name=jboss.esb:service=JBPMDatabaseInitializer state=Create mode=Manual requiredState=Installed
> java.sql.SQLException: Unknown error 708
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562)
> 	at com.mysql.jdbc.LoadBalancedMySQLConnection.execSQL(LoadBalancedMySQLConnection.java:153)
> 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1664)
> 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1583)
> 	at sun.reflect.GeneratedMethodAccessor284.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at com.mysql.jdbc.LoadBalancingConnectionProxy$ConnectionErrorFiringInvocationHandler.invoke(LoadBalancingConnectionProxy.java:103)
> 	at $Proxy262.executeUpdate(Unknown Source)
> 	at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)
> 	at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:145)
> 	at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
> 	at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
> 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
> 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
> 	at sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
> 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
> 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
> 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
> 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
> 	at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
> 	at $Proxy38.start(Unknown Source)
> 	at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
> 	at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
> 	at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
> 	at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
> 	at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
> 	at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
> 	at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297)
> 	at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
> 	at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
> 	at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
> 	at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
> 	at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
> 	at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
> 	at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
> 	at org.jboss.system.ServiceController.start(ServiceController.java:460)
> 	at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
> 	at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
> 	at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
> 	at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
> 	at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
> 	at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
> 	at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454)
> 	at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172)
> 	at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193)
> 	at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113)
> 	at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
> 	at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
> 	at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
> 	at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
> 	at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
> 	at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
> 	at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
> 	at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789)
> 	at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699)
> 	at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
> 	at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
> 	at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
> 	at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)
> 	at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
> 	at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
> 	at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
> 	at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
> 	at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
> 	at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
> 	at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
> 	at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)
> 	at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)
> 	at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
> 	at org.jboss.Main.boot(Main.java:221)
> 	at org.jboss.Main$1.run(Main.java:556)
> 	at java.lang.Thread.run(Thread.java:662)
> It seems to me like ESB-JBPM integration issue, so I put it under ESB JIRA label. 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the esb-issues mailing list