-
1. Re: MySQL 5.1 with JBoss ESB 5.0.0
peterj Mar 11, 2010 2:32 PM (in response to fatllama)Looking at that link, it appears that they are giving the steps for replacing HSQL with MySQL for all of the services, not just for strictly the ESB portions. Though I guess that in a production environment that is really what you want to do anyway. But that leaves a lot of possibilities as to what wen wrong. You might want to try things one step at a time. I recommend doing the basic JBoss AS services first, well everything except JBoss Messaging. Then do Messaging, And finally tackle ESB.
Here is a prior disucssion on moving JBoss AS to MySQL:
http://community.jboss.org/message/204473
Here are some links that might also help:
http://community.jboss.org/wiki/JBossESB47switchfromHSQLDBtoPotsgresqlonJBoss423GA
If none of this helps, please post the first exception stack trace that you are seeing in the console log.
-
2. Re: MySQL 5.1 with JBoss ESB 5.0.0
tonybryan Mar 17, 2010 4:56 AM (in response to peterj)Hi Peter, thanks for the response. We have a little progress, but I'm cautious to not change too many things at once.
1. I have created a MySQL database called "jboss_soa" with user "jboss". Host setup, and grant priviliges are all correct.
2. Create a mysql-ds.xml file in the deploy directory:
<?xml version="1.0" encoding="UTF-8"?> <!-- $Id: mysql-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ --> <!-- Datasource config for MySQL using 3.0.9 available from: http://www.mysql.com/downloads/api-jdbc-stable.html --> <datasources> <local-tx-datasource> <jndi-name>DefaultDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/jboss_soa</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>jboss</user-name> <password>jboss</password> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <min-pool-size>1</min-pool-size> <max-pool-size>20</max-pool-size> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
3. Copied in the mysql-persistence-service.xml file into the deploy directory.
4. Started the service.
Results:
a) I now have a number of tables created in the database:
mysql> show tables from jboss_soa;
+---------------------+
| Tables_in_jboss_soa |
+---------------------+
| HILOSEQUENCES |
| JBM_COUNTER |
| JBM_DUAL |
| JBM_ID_CACHE |
| JBM_MSG_REF |
| JBM_ROLE |
| JBM_TX |
| JBM_USER |
| TIMERS |
+---------------------+
9 rows in set (0.00 sec)b) Errors appearing in the console log (edited for just WARN and ERROR mesages)
2010-03-16 08:55:48,519 WARN [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=PersistenceManager
javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=PersistenceManager",type=Component already registered.
" at org.jboss.mx.server.registry.BasicMBeanRegistry.add(BasicMBeanRegistry.java:756)"
(Stack trace removed)
" at java.lang.Thread.run(Thread.java:619)"
2010-03-16 08:55:48,523 WARN [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=PostOffice
javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=PostOffice",type=Component already registered.
" at org.jboss.mx.server.registry.BasicMBeanRegistry.add(BasicMBeanRegistry.java:756)"
(Stack trace removed)
" at java.lang.Thread.run(Thread.java:619)"
2010-03-16 08:55:48,525 WARN [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=JMSUserManager
javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=JMSUserManager",type=Component already registered.
" at org.jboss.mx.server.registry.BasicMBeanRegistry.add(BasicMBeanRegistry.java:756)"
(Stack trace removed)
" at java.lang.Thread.run(Thread.java:619)"
2010-03-16 08:55:48,551 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/usr/jboss/jboss-as/server/default/deploy/mysql-persistence-service.xml state=PreReal mode=Manual requiredState=Real
org.jboss.deployers.spi.DeploymentException: Error deploying: jboss.messaging:service=PersistenceManager
" at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)"
(Stack trace removed)
" at java.lang.Thread.run(Thread.java:619)"
Caused by: java.lang.IllegalStateException: jboss.messaging:service=PersistenceManager is already installed.
2010-03-16 08:55:52,278 WARN [org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStore] (main) WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
2010-03-16 08:55:59,442 WARN [org.hibernate.ejb.Ejb3Configuration] (main) Persistence provider caller does not implement the EJB3 spec correctly. PersistenceUnitInfo.getNewTempClassLoader() is null.
2010-03-16 08:56:06,020 WARN [org.hibernate.impl.SessionFactoryObjectFactory] (main) InitialContext did not implement EventContext
2010-03-16 08:56:08,231 WARN [org.hibernate.impl.SessionFactoryImpl] (main) JTASessionContext being used with JDBCTransactionFactory; auto-flush will not operate correctly with getCurrentSession()
2010-03-16 08:56:18,212 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1
" at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)"
" at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)"
" at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)"
" at java.lang.reflect.Constructor.newInstance(Constructor.java:513)"
" at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)"
" at com.mysql.jdbc.Util.getInstance(Util.java:381)"
" at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)"
" at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)"
" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)"
" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)"
" at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)"
" at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)"
" at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2643)"
" at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)"
" at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)"
" at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2647)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2630)"
" at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.execute(JDBCSupport.java:394)"
" at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:416)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2698)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:369)"
" at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:462)"
" at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)"
" at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)"
" 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: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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)"
" at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)"
" at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)"
" at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)"
" 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:206)"
" 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:1633)"
" at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:935)"
" at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1083)"
" at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:985)"
" at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:823)"
" at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)"
" 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:50)"
" at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)"
" at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1440)"
" at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1158)"
" at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1179)"
" at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1099)"
" at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)"
" at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1633)"
" at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:935)"
" at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1083)"
" at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:985)"
" at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:823)"
" at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)"
" at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:782)"
" at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)"
" 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:1633)"
" at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:935)"
" at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1083)"
" at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:985)"
" at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:775)"
" at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:540)"
" 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:619)"
2010-03-16 08:56:18,216 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) Trying again after a pause
2010-03-16 08:56:18,331 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:2
2010-03-16 08:56:18,773 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:3
2010-03-16 08:56:18,878 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:4
2010-03-16 08:56:19,366 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:5
2010-03-16 08:56:19,457 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:6
2010-03-16 08:56:19,691 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:7
2010-03-16 08:56:19,995 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:8
2010-03-16 08:56:20,448 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:9
2010-03-16 08:56:20,945 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:10
2010-03-16 08:56:21,328 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:11
2010-03-16 08:56:21,433 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:12
2010-03-16 08:56:21,732 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:13
2010-03-16 08:56:22,032 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:14
2010-03-16 08:56:22,112 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:15
2010-03-16 08:56:22,615 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:16
2010-03-16 08:56:22,658 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:17
2010-03-16 08:56:22,791 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:18
2010-03-16 08:56:22,828 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:19
2010-03-16 08:56:22,862 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:20
2010-03-16 08:56:23,108 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:21
2010-03-16 08:56:23,166 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:22
2010-03-16 08:56:23,222 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:23
2010-03-16 08:56:23,255 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:24
2010-03-16 08:56:23,280 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:25
2010-03-16 08:56:23,300 ERROR [org.jboss.messaging.core.impl.JDBCSupport] (main) Retried 25 times, now giving up
2010-03-16 08:56:23,321 ERROR [org.jboss.messaging.util.ExceptionUtil] (main) org.jboss.messaging.core.jmx.MessagingPostOfficeService@1a64c3b startService
java.lang.IllegalStateException: Failed to excecute transaction
" at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:432)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2698)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:369)"
" at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:462)"
(Stack trace removed)
2010-03-16 08:56:23,347 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.messaging:service=PostOffice state=Create mode=Manual requiredState=Installed
java.lang.IllegalStateException: Failed to excecute transaction
" at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:432)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2698)"
" at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:369)"
" at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:462)"
(Stack trace removed)
2010-03-16 08:56:33,966 ERROR [org.jboss.messaging.util.ExceptionUtil] (main) Queue[null, name=DeadMessageQueue] startService
java.lang.NullPointerException
" at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
" at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
(Stack trace removed)
2010-03-16 08:56:33,982 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb.destination:name=DeadMessageQueue,service=Queue state=Create mode=Manual requiredState=Installed
java.lang.NullPointerException
" at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
" at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
(Stack trace removed)
2010-03-16 08:56:34,608 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbossesb.esb/ state=PreReal mode=Manual requiredState=Real
org.jboss.deployers.spi.DeploymentException: Error deploying: jboss.esb.destination:service=Queue,name=DeadMessageQueue
" at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)"
" at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:118)"
" at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)"
(Stack trace removed)
2010-03-16 08:56:36,393 ERROR [org.jboss.messaging.util.ExceptionUtil] (main) Queue[null, name=CallbackQueue] startService
java.lang.NullPointerException
" at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
" at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
(Stack trace removed)
2010-03-16 08:56:36,400 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb.destination:name=CallbackQueue,service=Queue state=Create mode=Manual requiredState=Installed
java.lang.NullPointerException
" at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
" at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
" at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
(Stack trace removed)
2010-03-16 08:56:36,553 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbpm.esb/ state=PreReal mode=Manual requiredState=Real
org.jboss.deployers.spi.DeploymentException: Error deploying: jboss.esb.destination:service=Queue,name=CallbackQueue
" at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)"
" at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:118)"
" at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)"
(Stack trace removed)
2010-03-16 08:56:42,860 ERROR [org.jboss.system.server.profileservice.ProfileServiceBootstrap] (main) Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbrules.esb/" is missing the following dependencies:
Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbrules.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/slsb.esb/" is missing the following dependencies:
Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/slsb.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/smooks.esb/" is missing the following dependencies:
Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/smooks.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/soap.esb/" is missing the following dependencies:
Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/soap.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/spring.esb/" is missing the following dependencies:
Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/spring.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
Deployment "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Dependency "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" (should be in state "Create", but is actually in state "Configured")
Deployment "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Deployment "jboss.messaging.connectionfactory:service=ConnectionFactory" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
Deployment "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is missing the following dependencies:
Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")DEPLOYMENTS IN ERROR:
Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/slsb.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/smooks.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/spring.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
Deployment "vfsfile:/usr/jboss/jboss-as/server/default/deploy/mysql-persistence-service.xml" is in error due to the following reason(s): java.lang.IllegalStateException: jboss.messaging:service=PersistenceManager is already installed.
Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbrules.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
Deployment "vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbossesb.esb/" is in error due to the following reason(s): java.lang.NullPointerException
Deployment "jboss.messaging:service=PostOffice" is in error due to the following reason(s): java.lang.IllegalStateException: Failed to excecute transaction, **ERROR**
Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/soap.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
Deployment "vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbpm.esb/" is in error due to the following reason(s): java.lang.NullPointerException2010-03-16 08:56:42,945 INFO [org.apache.coyote.http11.Http11Protocol] (main) Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
2010-03-16 08:56:43,018 INFO [org.apache.coyote.ajp.AjpProtocol] (main) Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
2010-03-16 08:56:43,166 INFO [org.jboss.bootstrap.microcontainer.ServerImpl] (main) JBoss (Microcontainer) [5.0.0.Beta1_SOA (build: SVNTag=5.0.0.Beta1_SOA date=200912141601)] Started in 2m:8s:62msDoesn't look very healthy! Can you see what else I've got wrong?
-
3. Re: MySQL 5.1 with JBoss ESB 5.0.0
peterj Mar 17, 2010 9:36 AM (in response to tonybryan)2010-03-16 08:55:48,519 WARN [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=PersistenceManager
javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=PersistenceManager",type=Component already registered.I'm not sure if that is a probllem or not. Try grepping the config files for jboss.messaging:service=PersistenceManager to see if you have multiple of them declared.
2010-03-16 08:56:18,212 WARN [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1This sounds like you did not replace the server/xxx/deploy/messaging/hsqldb-persistence-service.xml with the one for MySQL, which you can find at docs/examples/jms/mysql-persistence-service.xml. (Or do you have both files in .../deploy/messaging? That could explain the first warning - you should have only one of these files.)
-
4. Re: MySQL 5.1 with JBoss ESB 5.0.0
tonybryan May 20, 2010 5:31 AM (in response to peterj)Just closing the loop on this even though its been a couple of months. Thanks for all the help - I basically reinstalled the whole thing, and methodically went back through all of the config and datasources one by one, making sure they worked with MySQL before doing the next one. It took me about an hour to get everything right, and I now have all the services using MySQL.
Dumb user error!
Thanks again, problem solved!
-
5. Re: MySQL 5.1 with JBoss ESB 5.0.0
sathyaprakash Aug 25, 2010 12:25 PM (in response to tonybryan)Hi ,
I have created mysql Datasoucre.xml and copied to deploy folder and hsql datasoucre.xml.
<datasources>
<local-tx-datasource>
<jndi-name>DefaultJNDI</jndi-name>
<connection-url>jdbc:mysql://10.10.10.10:3306;DatabaseName=spc</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>tp_user</user-name>
<password>tp_user</password>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<min-pool-size>1</min-pool-size>
<max-pool-size>20</max-pool-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>Is there any more to do changes?
-
6. Re: MySQL 5.1 with JBoss ESB 5.0.0
sathyaprakash Aug 25, 2010 12:29 PM (in response to tonybryan)Hi Tony,
Have you did only the four step for migrating to mysql.
I have one question as you said point no 3.Copied in the mysql-persistence-service.xml file into the deploy directory.
from where you have Copied the mysql-persistence-service.xml.
Any changes in mysql-persistence-service.xml is required.
Many Thanks in Advance.