[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [xmlblaster] Strange error when unsubscribing



In the logfile portion I sent, it throws a warning that a prepared statement is being closed with autocomplete false. Should we configure access to the postgresql database for autocomplete true?
Thanks, David

----- Original Message -----
From: Marcel Ruff [mailto:mr at marcelruff.info]
To: xmlblaster at server.xmlBlaster.org
Subject: Re: [xmlblaster] Strange error when unsubscribing


> Hi again,
> 
> our persistent entries should be marked with capital letters
>  
>  public static final String ENTRY_TYPE_SUBSCRIBE = "SUBSCRIBE";
> 
> which does not match to the type of your logging output:
> 
> 'subscribe'
> 
> I have no idea how this small notation can appear, i believe it must be 
> somewhere
> in your database?
> 
> I have commited to the current svn a version which ignores case during
> persistence lookup, but this is just a temporary workaround,
> 
> regards
> Marcel
> 
> 
> 
> 
> David Robison wrote:
> > We are experiencing a problem running xmlBlaster 1.5.1. After running for
> several weeks, two nodes in our cluster start reporting the same types of
> errors:
> >
> > May 23, 2007 12:08:52 PM WARNING 6901718-pool-1-thread-4878 RL10
> org.xmlBlaster.util.queue.jdbc.PreparedQuery close: close with autocommit
> 'false': rollback
> > May 23, 2007 12:08:52 PM SEVERE  6901718-pool-1-thread-4878 RL10
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin
> loadFromPersistence: connection:/node/StauntonSTC/client/StauntonSTC/1:
> Could not read back data from persistence: XmlBlasterException
> serverSideException=true node=[StauntonSTC] location=[ServerEntryFactory]
> >  
> > stackTrace=errorCode=internal.notImplemented message=#exported Persistent
> object 'subscribe' is not implemented
> >  	at
> org.xmlBlaster.engine.queuemsg.ServerEntryFactory.createEntry(ServerEntryFactory.java:289)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.processResultSet(JdbcManagerCommonTable.java:1181)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.getEntries(JdbcManagerCommonTable.java:2017)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.peek(JdbcQueueCommonTablePlugin.java:576)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.loadFromPersistence(CacheQueueInterceptorPlugin.java:1042)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:545)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:447)
> >  	at
> org.xmlBlaster.client.XmlBlasterAccess.queueMessage(XmlBlasterAccess.java:792)
> >  	at
> org.xmlBlaster.client.XmlBlasterAccess.unSubscribe(XmlBlasterAccess.java:931)
> >  	at
> org.xmlBlaster.engine.cluster.ClusterManager.forwardUnSubscribe(ClusterManager.java:537)
> >  	at
> org.xmlBlaster.engine.RequestBroker.unSubscribe(RequestBroker.java:1167)
> >  	at
> org.xmlBlaster.engine.XmlBlasterImpl.unSubscribe(XmlBlasterImpl.java:131)
> >  	at
> org.xmlBlaster.util.protocol.RequestReplyExecutor.receiveReply(RequestReplyExecutor.java:490)
> >  	at
> org.xmlBlaster.protocol.socket.HandleClient.handleMessage(HandleClient.java:227)
> >  	at
> org.xmlBlaster.protocol.socket.HandleClient$1.run(HandleClient.java:376)
> >  	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
> >  	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
> >  	at java.lang.Thread.run(Unknown Source)
> > versionInfo=version=1.5.1,revision=exported,os.name=Windows
> 2003,os.version=5.2,java.vm.vendor=Sun Microsystems
> Inc.,java.vm.version=1.5.0_10-b03,os.arch=x86,build.timestamp=02/26/2007
> 08:00 AM,build.java.vendor=Sun Microsystems Inc.,build.java.version=1.4.2_06
> > errorCode
> description=http://www.xmlblaster.org/xmlBlaster/doc/requirements/admin.errorcodes.listing.html#internal.notImplemented
> >  
> > errorCode=internal.notImplemented message=#exported Persistent object
> 'subscribe' is not implemented
> >  	at
> org.xmlBlaster.engine.queuemsg.ServerEntryFactory.createEntry(ServerEntryFactory.java:289)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.processResultSet(JdbcManagerCommonTable.java:1181)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.getEntries(JdbcManagerCommonTable.java:2017)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.peek(JdbcQueueCommonTablePlugin.java:576)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.loadFromPersistence(CacheQueueInterceptorPlugin.java:1042)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:545)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:447)
> >  	at
> org.xmlBlaster.client.XmlBlasterAccess.queueMessage(XmlBlasterAccess.java:792)
> >  	at
> org.xmlBlaster.client.XmlBlasterAccess.unSubscribe(XmlBlasterAccess.java:931)
> >  	at
> org.xmlBlaster.engine.cluster.ClusterManager.forwardUnSubscribe(ClusterManager.java:537)
> >  	at
> org.xmlBlaster.engine.RequestBroker.unSubscribe(RequestBroker.java:1167)
> >  	at
> org.xmlBlaster.engine.XmlBlasterImpl.unSubscribe(XmlBlasterImpl.java:131)
> >  	at
> org.xmlBlaster.util.protocol.RequestReplyExecutor.receiveReply(RequestReplyExecutor.java:490)
> >  	at
> org.xmlBlaster.protocol.socket.HandleClient.handleMessage(HandleClient.java:227)
> >  	at
> org.xmlBlaster.protocol.socket.HandleClient$1.run(HandleClient.java:376)
> >  	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
> >  	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
> >  	at java.lang.Thread.run(Unknown Source)
> > May 23, 2007 12:08:52 PM  INFO   6901718-pool-1-thread-4878 RL10
> org.xmlBlaster.engine.RequestBroker unSubscribe: unSubscribe of
> '__subId:StauntonSTC-XPATH1179936462585000000' matched 1 entries in remote
> cluster
> > May 23, 2007 12:08:52 PM WARNING 6901718-pool-1-thread-4878 RL10
> org.xmlBlaster.util.queue.jdbc.PreparedQuery close: close with autocommit
> 'false': rollback
> > May 23, 2007 12:08:52 PM SEVERE  6901718-pool-1-thread-4878 RL10
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin
> loadFromPersistence: connection:/node/StauntonSTC/client/StauntonSTC/1:
> Could not read back data from persistence: XmlBlasterException
> serverSideException=true node=[StauntonSTC] location=[ServerEntryFactory]
> >
> > stackTrace=errorCode=internal.notImplemented message=#exported Persistent
> object 'subscribe' is not implemented
> > 	at
> org.xmlBlaster.engine.queuemsg.ServerEntryFactory.createEntry(ServerEntryFactory.java:289)
> > 	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.processResultSet(JdbcManagerCommonTable.java:1181)
> > 	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.getEntries(JdbcManagerCommonTable.java:2017)
> > 	at
> org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.peek(JdbcQueueCommonTablePlugin.java:576)
> > 	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.loadFromPersistence(CacheQueueInterceptorPlugin.java:1042)
> > 	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:545)
> > 	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:447)
> > 	at
> org.xmlBlaster.client.XmlBlasterAccess.queueMessage(XmlBlasterAccess.java:792)
> > 	at
> org.xmlBlaster.client.XmlBlasterAccess.unSubscribe(XmlBlasterAccess.java:931)
> > 	at
> org.xmlBlaster.engine.cluster.ClusterManager.forwardUnSubscribe(ClusterManager.java:537)
> > 	at
> org.xmlBlaster.engine.RequestBroker.unSubscribe(RequestBroker.java:1167)
> > 	at
> org.xmlBlaster.engine.XmlBlasterImpl.unSubscribe(XmlBlasterImpl.java:131)
> > 	at
> org.xmlBlaster.util.protocol.RequestReplyExecutor.receiveReply(RequestReplyExecutor.java:490)
> > 	at
> org.xmlBlaster.protocol.socket.HandleClient.handleMessage(HandleClient.java:227)
> > 	at
> org.xmlBlaster.protocol.socket.HandleClient$1.run(HandleClient.java:376)
> > 	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
> > 	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
> > 	at java.lang.Thread.run(Unknown Source)
> > versionInfo=version=1.5.1,revision=exported,os.name=Windows
> 2003,os.version=5.2,java.vm.vendor=Sun Microsystems
> Inc.,java.vm.version=1.5.0_10-b03,os.arch=x86,build.timestamp=02/26/2007
> 08:00 AM,build.java.vendor=Sun Microsystems Inc.,build.java.version=1.4.2_06
> > errorCode
> description=http://www.xmlblaster.org/xmlBlaster/doc/requirements/admin.errorcodes.listing.html#internal.notImplemented
> >  
> > errorCode=internal.notImplemented message=#exported Persistent object
> 'subscribe' is not implemented
> > 	at
> org.xmlBlaster.engine.queuemsg.ServerEntryFactory.createEntry(ServerEntryFactory.java:289)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.processResultSet(JdbcManagerCommonTable.java:1181)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcManagerCommonTable.getEntries(JdbcManagerCommonTable.java:2017)
> >  	at
> org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.peek(JdbcQueueCommonTablePlugin.java:576)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.loadFromPersistence(CacheQueueInterceptorPlugin.java:1042)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:545)
> >  	at
> org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.put(CacheQueueInterceptorPlugin.java:447)
> >  	at
> org.xmlBlaster.client.XmlBlasterAccess.queueMessage(XmlBlasterAccess.java:792)
> >  	at
> org.xmlBlaster.client.XmlBlasterAccess.unSubscribe(XmlBlasterAccess.java:931)
> >  	at
> org.xmlBlaster.engine.cluster.ClusterManager.forwardUnSubscribe(ClusterManager.java:537)
> >  	at
> org.xmlBlaster.engine.RequestBroker.unSubscribe(RequestBroker.java:1167)
> >  	at
> org.xmlBlaster.engine.XmlBlasterImpl.unSubscribe(XmlBlasterImpl.java:131)
> >  	at
> org.xmlBlaster.util.protocol.RequestReplyExecutor.receiveReply(RequestReplyExecutor.java:490)
> >  	at
> org.xmlBlaster.protocol.socket.HandleClient.handleMessage(HandleClient.java:227)
> >  	at
> org.xmlBlaster.protocol.socket.HandleClient$1.run(HandleClient.java:376)
> >  	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
> >  	at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
> >  	at java.lang.Thread.run(Unknown Source)
> > May 23, 2007 12:08:52 PM  INFO   6901718-pool-1-thread-4878 RL10
> org.xmlBlaster.engine.RequestBroker unSubscribe: unSubscribe of
> '__subId:StauntonSTC-XPATH1179936462757000000' matched 1 entries in remote
> cluster
> >
> >
> > It appears that there is a problem unsubscribing but I am unsure what the
> problem might be. Any thoughts or hints on how to proceed with debugging
> this problem?
> >
> > Thanks in advance, 
> > David Robison
> >
> >   
> 
> 
> -- 
> Marcel Ruff
> http://www.xmlBlaster.org
> 
>