JBOSS error invalid column index while server startup

[ravikanth reddy]

Hello,

I am using JBOSS-4.2.3GA with clustering. java version 1.5
After upgrading MESSAGING version 1.4.4GA to 1.4.5GA I am facing below problems while server start up.
If I truncate the tables jbm_msg and jbm_msg_ref before server startup, server is starting without any problems.

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

  JBoss Bootstrap Environment

  JBOSS_HOME: /xxxxx/jboss-4.2.3.GA

  JAVA: /usr/java/bin/java

  JAVA_OPTS: -Dprogram.name=run.sh -server -d64 -Xms4096m -Xmx4096m -XX:PermSize=512m -XX:MaxPermSize=512m -Dsun.rmi.dgc.client.gcInterval=1800000 -Dsun.rmi.
dgc.server.gcInterval=1800000 -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.PollSelectorProvider

  CLASSPATH: /xxxxx/jboss-4.2.3.GA/bin/run.jar:/usr/java/lib/tools.jar

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

10:17:58,046 INFO  [Server] Starting JBoss (MX MicroKernel)...
10:17:58,047 INFO  [Server] Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181417)
10:17:58,063 INFO  [Server] Home Dir: xxxxx:/jboss-4.2.3.GA
10:17:58,063 INFO  [Server] Home URL: file:xxxxx:/jboss-4.2.3.GA/
10:17:58,065 INFO  [Server] Patch URL: null
10:17:58,065 INFO  [Server] Server Name: TAMAServer
10:17:58,066 INFO  [Server] Server Home Dir: xxxxx:/jboss-4.2.3.GA/server/TAMAServer
10:17:58,066 INFO  [Server] Server Home URL: file:xxxxx:/jboss-4.2.3.GA/server/TAMAServer/
10:17:58,066 INFO  [Server] Server Log Dir: xxxxx:/jboss-4.2.3.GA/server/TAMAServer/log
10:17:58,073 INFO  [Server] Server Temp Dir: xxxxx:/jboss-4.2.3.GA/server/TAMAServer/tmp
10:17:58,074 INFO  [Server] Root Deployment Filename: jboss-service.xml
10:17:58,753 INFO  [ServerInfo] Java version: 1.5.0_24,Sun Microsystems Inc.
10:17:58,754 INFO  [ServerInfo] Java VM: Java HotSpot(TM) 64-Bit Server VM 1.5.0_24-b02,Sun Microsystems Inc.
10:17:58,754 INFO  [ServerInfo] OS-System: SunOS 5.10,sparcv9
10:18:03,629 INFO  [Server] Core system initialized
10:18:10,140 INFO  [WebService] Using RMI server codebase: http://xxxxx:2083/
10:18:10,144 INFO  [Log4jService$URLWatchTimerTask] Configuring from URL: resource:jboss-log4j.xml
10:18:10,710 WARN  [NamingBeanImpl] Context.PROVIDER_URL in server jndi.properties, url=jnp://xxxxx:2099,jnp://xxxxx:2100
10:18:11,218 INFO  [TransactionManagerService] JBossTS Transaction Service (JTA version) - JBoss Inc.
10:18:11,218 INFO  [TransactionManagerService] Setting up property manager MBean and JMX layer
10:18:11,521 INFO  [TransactionManagerService] Starting recovery manager
10:18:11,675 INFO  [TransactionManagerService] Recovery manager started
10:18:11,676 INFO  [TransactionManagerService] Binding TransactionManager JNDI Reference
10:18:16,508 INFO  [EJB3Deployer] Starting java:comp multiplexer
10:18:20,779 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is xxxxx.183:56098
-------------------------------------------------------
10:18:22,827 INFO  [TreeCache] viewAccepted(): [xxxxx.183:56098|0] [xxxxx.183:56098]
10:18:22,857 INFO  [TreeCache] TreeCache local address is xxxxx.183:56098
10:18:22,857 INFO  [TreeCache] State could not be retrieved (we are the first member in group)
10:18:22,857 INFO  [TreeCache] parseConfig(): PojoCacheConfig is empty
10:18:27,024 INFO  [NativeServerConfig] JBoss Web Services - Native
10:18:27,024 INFO  [NativeServerConfig] jbossws-3.0.1-native-2.0.4.GA (build=200803312044)
10:18:29,056 INFO  [SnmpAgentService] SNMP agent going active
10:18:29,820 INFO  [E2E2TAMA] Initializing
10:18:29,898 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is xxxxx.183:56120
-------------------------------------------------------
10:18:31,939 INFO  [E2E2TAMA] Number of cluster members: 1
10:18:31,940 INFO  [E2E2TAMA] Other members: 0
10:18:31,940 INFO  [E2E2TAMA] Fetching state (will wait for 30000 milliseconds):
10:18:31,940 INFO  [E2E2TAMA] State could not be retrieved (we are the first member in group)
10:18:32,063 INFO  [HANamingService] Started ha-jndi bootstrap jnpPort=2100, backlog=50, bindAddress=xxxxx/xxxxx.183
10:18:32,072 INFO  [DetachedHANamingService$AutomaticDiscovery] Listening on /xxxxx.183:2102, group=228.0.0.3, HA-JNDI address=xxxxx.183:2100
10:18:32,329 INFO  [TreeCache] No transaction manager lookup class has been defined. Transactions cannot be used
10:18:32,572 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is xxxxx.183:56134
-------------------------------------------------------
10:18:34,589 INFO  [TreeCache] viewAccepted(): [xxxxx.183:56134|0] [xxxxx.183:56134]
10:18:34,591 INFO  [TreeCache] TreeCache local address is xxxxx.183:56134
10:18:34,802 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is xxxxx.183:56141
-------------------------------------------------------
10:18:36,830 INFO  [TreeCache] viewAccepted(): [xxxxx.183:56141|0] [xxxxx.183:56141]
10:18:36,831 INFO  [TreeCache] TreeCache local address is xxxxx.183:56141
10:18:37,679 INFO  [CorbaNamingService] Naming: [IOR:000000000000002B49444C3A6F6D672E6F72672F436F734E616D696E672F4E616D696E67436F6E746578744578743A312E300000
000000020000000000000100000102000000000F31302E3132372E3135382E31383300000DC80000000000114A426F73732F4E616D696E672F726F6F7400000000000005000000000000000800000
0004A414300000000010000001C00000000000100010000000105010001000101090000000105010001000000210000007400000000000000010000000000000024000000220000007E0000000000
0000010000000F31302E3132372E3135382E31353700000DC9004000000000000000080606678102010101000000170401000806066781020101010000000764656661756C7400000000000000000
000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F0000000400000003]
10:18:37,854 INFO  [CorbaTransactionService] TransactionFactory: [IOR:000000000000003049444C3A6F72672F6A626F73732F746D2F69696F702F5472616E73616374696F6E46616
3746F72794578743A312E3000000000020000000000000100000102000000000F31302E3132372E3135382E31383300000DC80000000000144A426F73732F5472616E73616374696F6E732F460000
00050000000000000008000000004A414300000000010000001C000000000001000100000001050100010001010900000001050100010000002100000074000000000000000100000000000000240
00000220000007E00000000000000010000000F31302E3132372E3135382E31353700000DC90040000000000000000806066781020101010000001704010008060667810201010100000007646566
61756C7400000000000000000000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F000
0000400000003]
10:18:38,599 INFO  [Embedded] Catalina naming disabled
10:18:38,889 INFO  [AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the j
ava.library.path: /usr/jdk/instances/jdk1.5.0/jre/lib/sparcv9/server:/usr/jdk/instances/jdk1.5.0/jre/lib/sparcv9:/usr/jdk/instances/jdk1.5.0/jre/../lib/sparc
v9:/usr/dt/lib:/usr/local/lib:/usr/lib
10:18:39,017 INFO  [Http11Protocol] Initializing Coyote HTTP/1.1 on http-xxxxx%2Fxxxxx.183-50520
10:18:39,018 INFO  [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-xxxxx%2Fxxxxx.183-2009
10:18:39,019 INFO  [Catalina] Initialization processed in 419 ms
10:18:39,019 INFO  [StandardService] Starting service jboss.web
10:18:39,024 INFO  [StandardEngine] Starting Servlet Engine: JBossWeb/2.0.1.GA
10:18:39,138 INFO  [Catalina] Server startup in 119 ms
10:18:39,345 INFO  [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jboss-web.deployer/ROOT.war/
10:18:40,516 INFO  [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/httpha-invoker.sar/invoker.war/
10:18:40,841 INFO  [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../deploy/jbossws.sar/jbossws-context.war/
10:18:41,032 INFO  [TomcatDeployer] deploy, ctxPath=/juddi, warUrl=.../deploy/juddi-service.sar/juddi.war/
10:18:41,221 INFO  [RegistryServlet] Loading jUDDI configuration.
10:18:41,225 INFO  [RegistryServlet] Resources loaded from: /WEB-INF/juddi.properties
10:18:41,225 INFO  [RegistryServlet] Initializing jUDDI components.
10:18:42,203 INFO  [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
10:18:42,927 INFO  [MailService] Mail Service bound to java:/Mail
10:18:43,202 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
10:18:43,261 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
10:18:43,318 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
10:18:43,370 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
10:18:43,508 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms-ra.rar
10:18:43,569 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar
10:18:44,705 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/quartz-ra.rar
10:18:44,722 INFO  [QuartzResourceAdapter] start quartz!!!
10:18:44,848 INFO  [SimpleThreadPool] Job execution threads will use class loader of thread: main
10:18:44,887 INFO  [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
10:18:44,891 INFO  [RAMJobStore] RAMJobStore initialized.
10:18:44,891 INFO  [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properti
es'
10:18:44,891 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2
10:18:44,892 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
10:18:48,632 INFO  [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=OracleDS' to JNDI name 'OracleDS'
10:18:50,226 WARN  [SecurityMetadataStore] 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 t
his.
10:18:50,330 INFO  [ServerPeer] JBoss Messaging 1.4.5.GA server [3] started
10:18:50,604 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is xxxxx.183:56190
-------------------------------------------------------
10:18:50,662 INFO  [STDOUT]
-------------------------------------------------------
GMS: address is xxxxx.183:7900
-------------------------------------------------------
10:18:52,633 INFO  [GroupMember] org.jboss.messaging.core.impl.postoffice.GroupMember$ControlMembershipListener@36be0ffe got new view [xxxxx.183:56190|0
] [xxxxx.183:56190], old view is null
10:18:52,633 INFO  [GroupMember] I am (xxxxx.183:56190)
10:18:52,634 INFO  [GroupMember] New Members : 1 ([xxxxx.183:56190])
10:18:52,634 INFO  [GroupMember] All Members : 1 ([xxxxx.183:56190])
10:18:55,234 INFO  [ConnectionFactory] Connector bisocket://xxxxx:2557 has leasing enabled, lease period 10000 milliseconds
10:18:55,235 INFO  [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@362957a4 started
10:18:55,386 INFO  [ConnectionFactory] Connector bisocket://xxxxx:2557 has leasing enabled, lease period 10000 milliseconds
10:18:55,387 INFO  [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@26514577 started
10:18:56,124 WARN  [SecurityMetadataStore] 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 t
his.
10:18:57,789 INFO  [ConnectionFactory] Connector bisocket://xxxxx:2557 has leasing enabled, lease period 10000 milliseconds
10:18:57,790 INFO  [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@5c219c51 started
10:18:57,801 INFO  [ConnectionFactory] Connector bisocket://xxxxx:2557 has leasing enabled, lease period 10000 milliseconds
10:18:57,802 INFO  [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@38351fbf started
10:18:57,817 INFO  [ConnectionFactory] Connector bisocket://xxxxx:2557 has leasing enabled, lease period 10000 milliseconds
10:18:57,817 INFO  [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@7c8e3f75 started
10:18:57,824 INFO  [ConnectionFactory] Connector bisocket://xxxxx:2557 has leasing enabled, lease period 10000 milliseconds
10:18:57,824 INFO  [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@55acc1c2 started
10:18:57,832 INFO  [ConnectionFactory] Connector bisocket://xxxxx:2557 has leasing enabled, lease period 10000 milliseconds
10:18:57,832 INFO  [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@402d659 started
10:18:57,931 ERROR [ExceptionUtil] Queue[null, name=DLQ] startService
10:18:57,931 ERROR [ExceptionUtil] Queue[null, name=DLQ] startService
java.sql.SQLException: Invalid column index
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:897)
        at org.jboss.resource.adapter.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:750)
        at org.jboss.messaging.core.impl.JDBCPersistenceManager.loadFromStart(JDBCPersistenceManager.java:999)
        at org.jboss.messaging.core.impl.PagingChannelSupport.load(PagingChannelSupport.java:211)
        at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:105)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
        at sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        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:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at org.jboss.system.ServiceController.start(ServiceController.java:435)
        at org.jboss.system.ServiceController.start(ServiceController.java:435)
        at org.jboss.system.ServiceController.start(ServiceController.java:435)
        at org.jboss.system.ServiceController.start(ServiceController.java:435)
        at org.jboss.system.ServiceController.start(ServiceController.java:435)
        at org.jboss.system.ServiceController.start(ServiceController.java:435)
        at org.jboss.system.ServiceController.start(ServiceController.java:435)
        at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy4.start(Unknown Source)
        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
        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:592)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        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:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy51.start(Unknown Source)
        at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        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:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy9.deploy(Unknown Source)
        at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
        at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy4.start(Unknown Source)
        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
        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:592)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        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:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy5.deploy(Unknown Source)
        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
        at org.jboss.Main.boot(Main.java:200)
        at org.jboss.Main$1.run(Main.java:508)
        at java.lang.Thread.run(Thread.java:595)
10:18:57,975 INFO  [QueueService] Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:57,990 INFO  [TopicService] Topic[/topic/testTopic] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,001 INFO  [TopicService] Topic[/topic/securedTopic] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,019 INFO  [TopicService] Topic[/topic/testDurableTopic] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,042 INFO  [QueueService] Queue[/queue/testQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,062 INFO  [QueueService] Queue[/queue/A] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,096 INFO  [QueueService] Queue[/queue/B] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,112 INFO  [QueueService] Queue[/queue/C] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,132 INFO  [QueueService] Queue[/queue/D] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,155 INFO  [QueueService] Queue[/queue/ex] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,171 INFO  [QueueService] Queue[/queue/PrivateDLQ] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,187 INFO  [QueueService] Queue[/queue/PrivateExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,201 INFO  [QueueService] Queue[/queue/QueueWithOwnDLQAndExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,212 INFO  [TopicService] Topic[/topic/TopicWithOwnDLQAndExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,228 INFO  [QueueService] Queue[/queue/QueueWithOwnRedeliveryDelay] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,239 INFO  [TopicService] Topic[/topic/TopicWithOwnRedeliveryDelay] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,254 INFO  [QueueService] Queue[/queue/testDistributedQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
10:18:58,267 INFO  [TopicService] Topic[/topic/testDistributedTopic] started, fullSize=200000, pageSize=2000, downCacheSize=200
----
----
	

Could you please let me know what mistake I have done?
If I replace messaging 1.4.5 jars with 1.4.4 it is working fine.

[uttam kumar]

Looks like JMS tables are not being created during server startup. Have you made any changes to existing JBoss application server?

[uttam kumar]

Looks like you have removed hsqldb-ds.xml as I can't see 'DefaultDS' JNDI bound to datasource,ie, following line is not present in your server log

Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'DefaultDS'

[ravikanth reddy]

Thanks Uttam for your reply.

I am using OracleDB. I have oracle-ds.xml isntead hsqldb-ds.xml.

And I configured DefaultDS as OracleDS in my *-ds.xml

10:18:44,891 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2  
10:18:44,892 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.   
10:18:48,632 INFO  [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=OracleDS' to JNDI name 'OracleDS'  
10:18:50,226 WARN  [SecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from   

This problem is not coming if I truncate jbm_msg and jbm_msg_ref or jbm_postoffice tables. If I go back to 1.4.4GA version everything is smooth.

[Jaikiran Pai]

Why are you changing those jars, by the way?

[uttam kumar]

Please post the contents of your oracle-ds.xml

[ravikanth reddy]

Hello,

@Jaikiran: We are upgrading messaging version from 1.4.4GA to 1.4.5GA.

@Uttam: Please find below files.

oracle-ds.xml

<datasources>

   <!-- OracleDataSource -->
   <local-tx-datasource>
        <jndi-name>OracleDS</jndi-name>
        <use-java-context>false</use-java-context>
        <connection-url>jdbc:oracle:thin:@vdcf6:1521:VDCF6</connection-url>
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <user-name>tm_internal</user-name>
        <password>change</password>
        <connection-property name="char.encoding">UTF-8</connection-property>
        <min-pool-size>25</min-pool-size>
        <max-pool-size>50</max-pool-size>
        <prepared-statement-cache-size>50</prepared-statement-cache-size>
        <connection-property name="autoReconnect">false</connection-property>
        <metadata>
                <type-mapping>Oracle9i</type-mapping>
        </metadata>
   </local-tx-datasource>
----
---


oracle-persistance-service.xml


 <mbean code="org.jboss.messaging.core.jmx.JDBCPersistenceManagerService"
      name="jboss.messaging:service=PersistenceManager"
      xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml">

      <depends>jboss.jca:service=DataSourceBinding,name=OracleDS</depends>
      <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>

      <!-- The datasource to use for the persistence manager -->
      <attribute name="DataSource">OracleDS</attribute>

      <!-- If true will attempt to create tables and indexes on every start-up -->
      <attribute name="CreateTablesOnStartup">false</attribute>

      <!-- If true then will use JDBC batch updates -->
      <attribute name="UsingBatchUpdates">true</attribute>

      <!-- Some databases don't support inserting blobs using INSERT INTO ... SELECT FROM -->
      <attribute name="SupportsBlobOnSelect">false</attribute>
----
----
----

[Jaikiran Pai]

The upgrade to 1.4.5 version doesn't appear to be just a jar file replacement. New column has been added to some table(s) which means that the *-persistence-service.xml too need updates. Also read the Readme that comes with this version. It also mentions some required changes to some other jar files. Overall, just dropping in new jars isn't a good idea.

[ravikanth reddy]

Hello,

Thanks a lot for your suggestion Jaikiran. Yes in one of the node I have not updated *-persistance-service.xml.

Now problem is resolved.



Thanks.