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

Marco Rietveld (JIRA) jira-events at lists.jboss.org
Wed Jul 13 06:43:23 EDT 2011 

    [ https://issues.jboss.org/browse/JBESB-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12613888#comment-12613888 ] 

Marco Rietveld commented on JBESB-3633:
---------------------------------------

This may very well be a jBPM issue, but would it be possible to first check the MaxNoOfAttributes config?
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-maxnoofattributes
(MySQL 5.1 is apparently the basis for MySQL cluster 7.x)

The jBPM schema scripts do have a number of alter table statements, which apparently generate "3 times the number of attributes as in the original table are used". 

If you've already checked this and determined that it's not the case, please let me know. I will gladly see if I can do anything on the jBPM side. 

> 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