2 Replies Latest reply on Jan 8, 2009 9:15 AM by Will Tatam

    4.0.5GA cluster with mySQL

    gerald zhou Newbie

      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>

        • 1. Re: 4.0.5GA cluster with mySQL
          gerald zhou Newbie

          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


          • 2. Re: 4.0.5GA cluster with mySQL
            Will Tatam Newbie

            what was the solution ?