[jboss-user] [JBoss Messaging] New message: "Problem at restart with Postgresql"

Guillaume Bourgois do-not-reply at jboss.com
Fri Feb 12 09:18:40 EST 2010


User development,

A new message was posted in the thread "Problem at restart with Postgresql":

http://community.jboss.org/message/526049#526049

Author  : Guillaume Bourgois
Profile : http://community.jboss.org/people/GuillaumeBourgois

Message:
--------------------------------------------------------------
Hello,
 
I use some queues in jboss ESB (with Jboss AS 4.23GA), declared inside the project in a file jbm-queue-service.xml :
 

<mbean code="org.jboss.jms.server.destination.QueueService"     name="jboss.esb.quickstart.destination:service=Queue,name=my_queue"     xmbean-dd="xmdesc/Queue-xmbean.xml">     <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>     <depends>jboss.messaging:service=PostOffice</depends></mbean>

 
 
(I also tried in the jboss-messaging.sar/destinations-service.xml file)
 
It usually work fine but somes times I keep getting the following exception when I redeploy the project or restart JbossAS :
 

14:24:57,320 ERROR [ExceptionUtil] Queue[null, name=my_queue] startServiceorg.postgresql.util.PSQLException: L'indice de la colonne est hors limiteá: 4, nombre de colonnesá: 3.        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkColumnIndex(AbstractJdbc2ResultSet.java:2680)        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkResultSet(AbstractJdbc2ResultSet.java:2697)        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:2528)        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.GeneratedMethodAccessor77.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.GeneratedMethodAccessor9.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 $Proxy45.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.GeneratedMethodAccessor24.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.GeneratedMethodAccessor3.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.GeneratedMethodAccessor9.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)

 
 
The only workaround I can find is to delete the concerned row in the "jbm_postoffice" database table.
 
I also find a similar problem on this forum : https://community.jboss.org/thread/146487 but the workaround can't be used with PostgreSQL.
 
Any idea where does that come from ?
 
Regards,
Guillaume

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/526049#526049




More information about the jboss-user mailing list