2 Replies Latest reply on Jan 8, 2009 9:15 AM by will.tatam

    4.0.5GA cluster with mySQL

    geniusfox
    geniusfox Mar 14, 2007 6:18 AM

      Hi
      I have configure 2 jboss server with an mysql database server. But when i start occure this message:
      18:12:28,437 INFO [RegistryServlet] Initializing jUDDI components.
      18:12:29,031 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../
      deploy-hasingleton/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
      18:12:29,375 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../dep
      loy/management/console-mgr.sar/web-console.war/
      18:12:30,468 INFO [MailService] Mail Service bound to java:/Mail
      18:12:30,687 INFO [RARDeployment] Required license terms exist, view META-INF/r
      a.xml in .../deploy/jboss-ha-local-jdbc.rar
      18:12:30,734 INFO [RARDeployment] Required license terms exist, view META-INF/r
      a.xml in .../deploy/jboss-ha-xa-jdbc.rar
      18:12:30,765 INFO [RARDeployment] Required license terms exist, view META-INF/r
      a.xml in .../deploy/jboss-local-jdbc.rar
      18:12:30,796 INFO [RARDeployment] Required license terms exist, view META-INF/r
      a.xml in .../deploy/jboss-xa-jdbc.rar
      18:12:30,859 INFO [RARDeployment] Required license terms exist, view META-INF/r
      a.xml in .../deploy/jms/jms-ra.rar
      18:12:30,890 INFO [RARDeployment] Required license terms exist, view META-INF/r
      a.xml in .../deploy/mail-ra.rar
      18:12:31,359 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jb
      oss.jca:name=JmsXA,service=ConnectionFactoryBinding' to JNDI name 'java:JmsXA'
      18:12:31,609 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca
      :name=DefaultDS,service=DataSourceBinding' to JNDI name 'java:DefaultDS'
      18:12:32,078 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../dep
      loy/jmx-console.war/
      18:12:32,625 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

      --- MBeans waiting for other MBeans ---
      ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=Invoker
      jboss.web:service=WebServer

      ObjectName: jboss.mq.destination:name=testTopic,service=Topic
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:name=securedTopic,service=Topic
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:name=testDurableTopic,service=Topic
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:name=testQueue,service=Queue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq.destination:name=A,service=Queue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:name=B,service=Queue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:name=C,service=Queue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:name=D,service=Queue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq.destination:name=ex,service=Queue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager

      ObjectName: jboss.mq:service=Invoker
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=TracingInterceptor
      jboss:service=Naming
      Depends On Me:
      jboss.mq:service=InvocationLayer,type=HTTP
      jboss.mq:service=InvocationLayer,type=JVM
      jboss.mq:service=InvocationLayer,type=UIL2

      ObjectName: jboss.mq:service=TracingInterceptor
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=SecurityManager
      Depends On Me:
      jboss.mq:service=Invoker

      ObjectName: jboss.mq:service=SecurityManager
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      Depends On Me:
      jboss.mq.destination:name=testTopic,service=Topic
      jboss.mq.destination:name=securedTopic,service=Topic
      jboss.mq.destination:name=testDurableTopic,service=Topic
      jboss.mq.destination:name=testQueue,service=Queue
      jboss.mq:service=TracingInterceptor
      jboss.mq.destination:name=DLQ,service=Queue

      ObjectName: jboss.mq.destination:name=DLQ,service=Queue
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      ObjectName: jboss.mq:service=InvocationLayer,type=JVM
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=Invoker

      ObjectName: jboss.mq:service=DestinationManager
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=MessageCache
      jboss.mq:service=PersistenceManager
      jboss.mq:service=StateManager
      Depends On Me:
      jboss.mq.destination:name=testTopic,service=Topic
      jboss.mq.destination:name=securedTopic,service=Topic
      jboss.mq.destination:name=testDurableTopic,service=Topic
      jboss.mq.destination:name=testQueue,service=Queue
      jboss.mq.destination:name=A,service=Queue
      jboss.mq.destination:name=B,service=Queue
      jboss.mq.destination:name=C,service=Queue
      jboss.mq.destination:name=D,service=Queue
      jboss.mq.destination:name=ex,service=Queue
      jboss.mq:service=SecurityManager
      jboss.mq.destination:name=DLQ,service=Queue

      ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
      State: CONFIGURED
      I Depend On:
      jboss.mq:service=Invoker

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.mq:service=StateManager
      State: NOTYETINSTALLED
      Depends On Me:
      jboss.mq:service=DestinationManager


      18:12:32,765 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0
      -8080
      18:12:32,843 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      18:12:32,875 INFO [JkMain] Jk running ID=0 time=0/79 config=null
      18:12:32,890 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Bran
      ch_4_0 date=200610162339)] Started in 24s:453ms

      Then, i can't looking XAConnecitonFactory form JNDI tree. What's the problem with it? My mysql-ds.xml content as:

      <local-tx-datasource>
      <jndi-name>DefaultDS</jndi-name>
      <connection-url>jdbc:mysql://192.168.0.163:3306/jboss</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>jboss</user-name>
      jboss
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
      <!-- should only be used on drivers after 3.22.1 with "ping" support
      <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
      -->
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
      <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
      <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

      <type-mapping>mySQL</type-mapping>

      </local-tx-datasource>

      • 2153 Views
      • Tags:
        • 1. Re: 4.0.5GA cluster with mySQL
          geniusfox
          geniusfox Mar 14, 2007 6:25 AM (in response to geniusfox)

          Sorry, i rewrite with code tag.

          ===============================================================================

 JBoss Bootstrap Environment

 JBOSS_HOME: D:\API\jboss-4.0.5.GA\bin\\..

 JAVA: C:\j2sdk1.4.2_07\bin\java

 JAVA_OPTS: -Dprogram.name=run.bat -server -Xms128m -Xmx512m -Dsun.rmi.dgc.cli
ent.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000

 CLASSPATH: C:\j2sdk1.4.2_07\lib\tools.jar;D:\API\jboss-4.0.5.GA\bin\\run.jar

===============================================================================

18:12:08,437 INFO [Server] Starting JBoss (MX MicroKernel)...
18:12:08,437 INFO [Server] Release ID: JBoss [Zion] 4.0.5.GA (build: CVSTag=Bra
nch_4_0 date=200610162339)
18:12:08,437 INFO [Server] Home Dir: D:\API\jboss-4.0.5.GA
18:12:08,437 INFO [Server] Home URL: file:/D:/API/jboss-4.0.5.GA/
18:12:08,437 INFO [Server] Patch URL: null
18:12:08,437 INFO [Server] Server Name: clusterA
18:12:08,437 INFO [Server] Server Home Dir: D:\API\jboss-4.0.5.GA\server\cluste
rA
18:12:08,437 INFO [Server] Server Home URL: file:/D:/API/jboss-4.0.5.GA/server/
clusterA/
18:12:08,437 INFO [Server] Server Log Dir: D:\API\jboss-4.0.5.GA\server\cluster
A\log
18:12:08,437 INFO [Server] Server Temp Dir: D:\API\jboss-4.0.5.GA\server\cluste
rA\tmp
18:12:08,437 INFO [Server] Root Deployment Filename: jboss-service.xml
18:12:08,734 INFO [ServerInfo] Java version: 1.4.2_07,Sun Microsystems Inc.
18:12:08,734 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.4.2_07-b05
,Sun Microsystems Inc.
18:12:08,734 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
18:12:09,203 INFO [Server] Core system initialized
18:12:12,156 INFO [WebService] Using RMI server codebase: http://ZhouQiang:8083
/
18:12:12,171 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resour
ce:log4j.xml
18:12:16,671 INFO [ServiceEndpointManager] WebServices: jbossws-1.0.3.SP1 (date
=200609291417)
18:12:17,703 INFO [SnmpAgentService] SNMP agent going active
18:12:18,093 INFO [InterceptorChainFactory] interceptor chain is:
class org.jboss.cache.interceptors.CallInterceptor
class org.jboss.cache.interceptors.PessimisticLockInterceptor
class org.jboss.cache.interceptors.UnlockInterceptor
class org.jboss.cache.interceptors.ReplicationInterceptor
class org.jboss.cache.interceptors.TxInterceptor
class org.jboss.cache.interceptors.CacheMgmtInterceptor
18:12:18,406 INFO [STDOUT]
-------------------------------------------------------
GMS: address is ZhouQiang:3352
-------------------------------------------------------
18:12:20,437 INFO [TreeCache] viewAccepted(): [ZhouQiang:3352|0] [ZhouQiang:335
2]
18:12:20,437 INFO [TreeCache] TreeCache local address is ZhouQiang:3352
18:12:20,453 INFO [TreeCache] State could not be retrieved (we are the first me
mber in group)
18:12:20,453 INFO [TreeCache] parseConfig(): PojoCacheConfig is empty
18:12:20,781 INFO [DefaultPartition] Initializing
18:12:20,843 INFO [STDOUT]
-------------------------------------------------------
GMS: address is ZhouQiang:3355 (additional data: 17 bytes)
-------------------------------------------------------
18:12:22,843 INFO [DefaultPartition] Number of cluster members: 1
18:12:22,843 INFO [DefaultPartition] Other members: 0
18:12:22,843 INFO [DefaultPartition] Fetching state (will wait for 30000 millis
econds):
18:12:22,843 INFO [DefaultPartition] State could not be retrieved (we are the f
irst member in group)
18:12:22,843 INFO [DefaultPartition] New cluster view for partition DefaultPart
ition (id: 0, delta: 0) : [192.168.0.51:1099]
18:12:22,875 INFO [DefaultPartition] I am (192.168.0.51:1099) received membersh
ipChanged event:
18:12:22,875 INFO [DefaultPartition] Dead members: 0 ([])
18:12:22,875 INFO [DefaultPartition] New Members : 0 ([])
18:12:22,875 INFO [DefaultPartition] All Members : 1 ([192.168.0.51:1099])
18:12:22,921 INFO [HANamingService] Started ha-jndi bootstrap jnpPort=1100, bac
klog=50, bindAddress=/0.0.0.0
18:12:22,921 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on /0.
0.0.0:1102, group=230.0.0.4, HA-JNDI address=192.168.0.51:1100
18:12:24,875 INFO [CorbaNamingService] Naming: [IOR:000000000000002B49444C3A6F6
D672E6F72672F436F734E616D696E672F4E616D696E67436F6E746578744578743A312E300000000
0000200000000000000E8000102000000000D3139322E3136382E302E353100000DC8000000114A4
26F73732F4E616D696E672F726F6F74000000000000050000000000000008000000004A414300000
000010000001C0000000000010001000000010501000100010109000000010501000100000021000
0006000000000000000010000000000000024000000200000007E00000000000000010000000D313
9322E3136382E302E353100000DC9004000000000000000000010040100080606678102010101000
00000000000000000000000000000000000000000002000000004000000000000001F00000004000
00003000000010000002000000000000000020000002000000004000000000000001F00000004000
00003]
18:12:24,968 INFO [CorbaTransactionService] TransactionFactory: [IOR:0000000000
00003049444C3A6F72672F6A626F73732F746D2F69696F702F5472616E73616374696F6E46616374
6F72794578743A312E30000000000200000000000000E8000102000000000D3139322E3136382E30
2E353100000DC8000000144A426F73732F5472616E73616374696F6E732F46000000050000000000
000008000000004A414300000000010000001C000000000001000100000001050100010001010900
00000105010001000000210000006000000000000000010000000000000024000000200000007E00
000000000000010000000D3139322E3136382E302E353100000DC900400000000000000000001004
01000806066781020101010000000000000000000000000000000000000000000000200000000400
0000000000001F000000040000000300000001000000200000000000000002000000200000000400
0000000000001F0000000400000003]
18:12:25,593 INFO [Embedded] Catalina naming disabled
18:12:25,718 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in
the classpath. Will load the default rule set.
18:12:25,718 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in
the classpath. Will load the default rule set.
18:12:26,078 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-0.0
.0.0-8080
18:12:26,078 INFO [Catalina] Initialization processed in 360 ms
18:12:26,078 INFO [StandardService] Starting service jboss.web
18:12:26,078 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5.2
0
18:12:26,109 INFO [StandardHost] XML validation disabled
18:12:26,125 INFO [Catalina] Server startup in 47 ms
18:12:26,328 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/
httpha-invoker.sar/invoker.war/
18:12:26,718 INFO [WebappLoader] Dual registration of jndi stream handler: fact
ory already defined
18:12:27,656 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbosswe
b-tomcat55.sar/ROOT.war/
18:12:27,984 INFO [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../tmp/dep
loy/tmp35506jbossws-context-exp.war/
18:12:28,250 INFO [TomcatDeployer] deploy, ctxPath=/juddi, warUrl=.../deploy/ju
ddi-service.sar/juddiws.war/
18:12:28,421 INFO [RegistryServlet] Loading jUDDI configuration.
18:12:28,437 INFO [RegistryServlet] Resources loaded from: /WEB-INF/juddi.prope
rties
18:12:28,437 INFO [RegistryServlet] Initializing jUDDI components.
18:12:29,031 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../
deploy-hasingleton/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
18:12:29,375 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../dep
loy/management/console-mgr.sar/web-console.war/
18:12:30,468 INFO [MailService] Mail Service bound to java:/Mail
18:12:30,687 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-ha-local-jdbc.rar
18:12:30,734 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-ha-xa-jdbc.rar
18:12:30,765 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-local-jdbc.rar
18:12:30,796 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-xa-jdbc.rar
18:12:30,859 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jms/jms-ra.rar
18:12:30,890 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/mail-ra.rar
18:12:31,359 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jb
oss.jca:name=JmsXA,service=ConnectionFactoryBinding' to JNDI name 'java:JmsXA'
18:12:31,609 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca
:name=DefaultDS,service=DataSourceBinding' to JNDI name 'java:DefaultDS'
18:12:32,078 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../dep
loy/jmx-console.war/
18:12:32,625 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=Invoker
 jboss.web:service=WebServer

ObjectName: jboss.mq.destination:name=testTopic,service=Topic
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager
 jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:name=securedTopic,service=Topic
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager
 jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:name=testDurableTopic,service=Topic
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager
 jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:name=testQueue,service=Queue
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager
 jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:name=A,service=Queue
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:name=B,service=Queue
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:name=C,service=Queue
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:name=D,service=Queue
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:name=ex,service=Queue
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager

ObjectName: jboss.mq:service=Invoker
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=TracingInterceptor
 jboss:service=Naming
 Depends On Me:
 jboss.mq:service=InvocationLayer,type=HTTP
 jboss.mq:service=InvocationLayer,type=JVM
 jboss.mq:service=InvocationLayer,type=UIL2

ObjectName: jboss.mq:service=TracingInterceptor
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=SecurityManager
 Depends On Me:
 jboss.mq:service=Invoker

ObjectName: jboss.mq:service=SecurityManager
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager
 Depends On Me:
 jboss.mq.destination:name=testTopic,service=Topic
 jboss.mq.destination:name=securedTopic,service=Topic
 jboss.mq.destination:name=testDurableTopic,service=Topic
 jboss.mq.destination:name=testQueue,service=Queue
 jboss.mq:service=TracingInterceptor
 jboss.mq.destination:name=DLQ,service=Queue

ObjectName: jboss.mq.destination:name=DLQ,service=Queue
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager
 jboss.mq:service=SecurityManager

ObjectName: jboss.mq:service=InvocationLayer,type=JVM
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=Invoker

ObjectName: jboss.mq:service=DestinationManager
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=MessageCache
 jboss.mq:service=PersistenceManager
 jboss.mq:service=StateManager
 Depends On Me:
 jboss.mq.destination:name=testTopic,service=Topic
 jboss.mq.destination:name=securedTopic,service=Topic
 jboss.mq.destination:name=testDurableTopic,service=Topic
 jboss.mq.destination:name=testQueue,service=Queue
 jboss.mq.destination:name=A,service=Queue
 jboss.mq.destination:name=B,service=Queue
 jboss.mq.destination:name=C,service=Queue
 jboss.mq.destination:name=D,service=Queue
 jboss.mq.destination:name=ex,service=Queue
 jboss.mq:service=SecurityManager
 jboss.mq.destination:name=DLQ,service=Queue

ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=Invoker

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.mq:service=StateManager
 State: NOTYETINSTALLED
 Depends On Me:
 jboss.mq:service=DestinationManager


18:12:32,765 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0
-8080
18:12:32,843 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
18:12:32,875 INFO [JkMain] Jk running ID=0 time=0/79 config=null
18:12:32,890 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Bran
ch_4_0 date=200610162339)] Started in 24s:453ms


            • Actions
          • 2. Re: 4.0.5GA cluster with mySQL
            will.tatam
            will.tatam Jan 8, 2009 9:15 AM (in response to geniusfox)

            what was the solution ?

              • Actions