[JBoss JIRA] Reopened: (TEIID-1420) Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1420?page=com.atlassian.jira.plugin... ]
Van Halbert reopened TEIID-1420:
--------------------------------
This is still an issue in ER7:
2011-01-18 12:22:49,969 ERROR [org.teiid.ADMIN_API] (New I/O server worker #2-2) Unexpected exception for session zW29SU5dkixx
[AdminComponentException]Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
1 [AdminComponentException]Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
2 [UndeclaredThrowableException]Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
3 [IllegalArgumentException]no such item name id for composite type MutableCompositeMetaType{org.teiid.adminapi.impl.TransactionMetadata items=[name=associatedSession type=java.lang.String], [name=createdTime type=long], [name=scope type=java.lang.String], [name=xid type=java.lang.String]}
at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:72)
at org.teiid.jboss.deployers.RuntimeEngineDeployer$2.invoke(RuntimeEngineDeployer.java:309)
at $Proxy379.getTransactions(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:81)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:160)
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:149)
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210)
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:144)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:540)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261)
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:349)
at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:281)
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:201)
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
at org.jboss.netty.util.internal.IoWorkerRunnable.run(IoWorkerRunnable.java:46)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
Caused by: [AdminComponentException]Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
1 [UndeclaredThrowableException]Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
2 [IllegalArgumentException]no such item name id for composite type MutableCompositeMetaType{org.teiid.adminapi.impl.TransactionMetadata items=[name=associatedSession type=java.lang.String], [name=createdTime type=long], [name=scope type=java.lang.String], [name=xid type=java.lang.String]}
at org.teiid.adminapi.jboss.Admin.getTransactions(Admin.java:354)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)
at org.teiid.jboss.deployers.RuntimeEngineDeployer$2.invoke(RuntimeEngineDeployer.java:303)
... 40 more
Caused by: java.lang.reflect.UndeclaredThrowableException: Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
at org.jboss.profileservice.management.KernelBusRuntimeComponentDispatcher.invoke(KernelBusRuntimeComponentDispatcher.java:201)
at org.jboss.profileservice.management.DelegatingComponentDispatcherImpl.invoke(DelegatingComponentDispatcherImpl.java:103)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:121)
at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
at org.jboss.profileservice.remoting.ProfileServiceInvocationHandler.invoke(ProfileServiceInvocationHandler.java:99)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:930)
at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:106)
at org.jboss.remoting.Client.invoke(Client.java:2034)
at org.jboss.remoting.Client.invoke(Client.java:877)
at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:60)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.remoting.MergeMetaDataInterceptor.invoke(MergeMetaDataInterceptor.java:74)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aop.generatedproxies.AOPProxy$1.invoke(AOPProxy$1.java)
at org.jboss.profileservice.management.client.ManagedOperationDelegate.invoke(ManagedOperationDelegate.java:63)
at org.teiid.adminapi.jboss.ManagedUtil.executeOperation(ManagedUtil.java:318)
at org.teiid.adminapi.jboss.Admin.getTransactions(Admin.java:347)
... 46 more
Caused by: java.lang.IllegalArgumentException: no such item name id for composite type MutableCompositeMetaType{org.teiid.adminapi.impl.TransactionMetadata items=[name=associatedSession type=java.lang.String], [name=createdTime type=long], [name=scope type=java.lang.String], [name=xid type=java.lang.String]}
at org.jboss.metatype.api.values.CompositeValueSupport.validateKey(CompositeValueSupport.java:292)
at org.jboss.metatype.api.values.CompositeValueSupport.set(CompositeValueSupport.java:178)
at org.teiid.adminapi.impl.TransactionMetadataMapper.createMetaValue(TransactionMetadataMapper.java:76)
at org.teiid.adminapi.impl.TransactionMetadataMapper.createMetaValue(TransactionMetadataMapper.java:38)
at org.jboss.metatype.plugins.values.DefaultMetaValueFactory.internalCreate(DefaultMetaValueFactory.java:1122)
at org.jboss.metatype.plugins.values.DefaultMetaValueFactory.createCollectionValue(DefaultMetaValueFactory.java:254)
at org.jboss.metatype.plugins.values.DefaultMetaValueFactory.internalCreate(DefaultMetaValueFactory.java:1140)
at org.jboss.metatype.plugins.values.DefaultMetaValueFactory.create(DefaultMetaValueFactory.java:539)
at org.jboss.profileservice.management.AbstractRuntimeComponentDispatcher.create(AbstractRuntimeComponentDispatcher.java:95)
at org.jboss.profileservice.management.KernelBusRuntimeComponentDispatcher.invoke(KernelBusRuntimeComponentDispatcher.java:195)
at org.jboss.profileservice.management.DelegatingComponentDispatcherImpl.invoke(DelegatingComponentDispatcherImpl.java:103)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:121)
at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
at org.jboss.profileservice.remoting.ProfileServiceInvocationHandler.invoke(ProfileServiceInvocationHandler.java:99)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:930)
at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:106)
at org.jboss.remoting.Client.invoke(Client.java:2034)
at org.jboss.remoting.Client.invoke(Client.java:877)
at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:60)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.remoting.MergeMetaDataInterceptor.invoke(MergeMetaDataInterceptor.java:74)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aop.generatedproxies.AOPProxy$1.invoke(AOPProxy$1.java)
at org.jboss.profileservice.management.client.ManagedOperationDelegate.invoke(ManagedOperationDelegate.java:63)
at org.teiid.adminapi.jboss.ManagedUtil.executeOperation(ManagedUtil.java:318)
at org.teiid.adminapi.jboss.Admin.getTransactions(Admin.java:347)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)
at org.teiid.jboss.deployers.RuntimeEngineDeployer$2.invoke(RuntimeEngineDeployer.java:303)
at $Proxy379.getTransactions(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:81)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:160)
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:149)
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210)
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:144)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:540)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261)
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:349)
at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:281)
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:201)
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
at org.jboss.netty.util.internal.IoWorkerRunnable.run(IoWorkerRunnable.java:46)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:72)
... 55 more
> Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-1420
> URL: https://issues.jboss.org/browse/TEIID-1420
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 7.1.1, 7.3
>
>
> With no transaction active - the method returns:
> groovy:000> getTransactions()
> ===> []
> With a transaction open:
> groovy:000> getTransactions()
> ERROR org.teiid.adminapi.AdminComponentException:
> Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
> at org.teiid.client.util.ExceptionUtil.convertException (ExceptionUtil.java:72)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke (SocketServerInstanceImpl.java:365)
> at org.teiid.net.socket.SocketServerConnection$1.invoke (SocketServerConnection.java:216)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminapi.AdminFactory$AdminProxy.invoke (AdminFactory.java:75)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminshell.AdminShell.getTransactions (AdminShell.java:212)
> at org.teiid.adminshell.AdminShell$getTransactions.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Moved: (TEIID-1441) java.lang.NullPointerException - on queries involving lookup (temp table cache does not have buffermanager set on it)
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1441?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-2802 to TEIID-1441:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1441 (was: SOA-2802)
Affects Version/s: 7.1.1
(was: 5.1.0.ER7)
Component/s: Query Engine
(was: EDS)
Security: (was: Public)
> java.lang.NullPointerException - on queries involving lookup (temp table cache does not have buffermanager set on it)
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1441
> URL: https://issues.jboss.org/browse/TEIID-1441
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: Warren Gibson
> Assignee: Van Halbert
> Priority: Blocker
>
> The following java.lang.NullPointerException is received in ER7 when running queries involving lookup...example query: SELECT IntKey, lookup('BQT1.MediumA', 'StringKey', 'IntKey', IntKey) AS Y FROM BQT1.MediumA ORDER BY IntKey
> This seems to only happen when running the production profile. I am getting 57 query failures on most if not all sources and the queries involve lookup.
> 2011-01-18 10:00:26,935 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue8) Loading materialized view table #CODE_BQT1.MEDIUMA.INTKEY.STRINGKEY
> 2011-01-18 10:00:27,154 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue8) Unexpected exception for request 0wHCuxdsAg78.0
> java.lang.NullPointerException
> at org.teiid.dqp.internal.process.CachedResults.prepare(CachedResults.java:115)
> at org.teiid.dqp.internal.process.SessionAwareCache.put(SessionAwareCache.java:166)
> at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:508)
> at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:410)
> at org.teiid.query.tempdata.TempTableDataManager.lookupCodeValue(TempTableDataManager.java:595)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:962)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:633)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:603)
> at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:218)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:181)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96)
> at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:636)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Resolved: (TEIID-1438) Teiid is attempting to push a string concat down.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1438?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1438.
-----------------------------------
Fix Version/s: 7.1.1
Resolution: Done
7.3 already addressed this issue specifically for execs, however I expanded that fix to better ensure that subqueries get evaluated for use with temp tables.
> Teiid is attempting to push a string concat down.
> -------------------------------------------------
>
> Key: TEIID-1438
> URL: https://issues.jboss.org/browse/TEIID-1438
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: John Doyle
> Fix For: 7.1.1
>
>
> That attached VDB is invoking the yahoo quote service. Invoking the BrokenQuote procedure like this:
> Exec VGetQuote.BrokenQuote('IBM');
> results in the following exception:
> Remote org.teiid.api.exception.query.QueryPlannerException: Source command "EXEC GetQuote.invokeHttp('GET', null, concat('?f=snd1l1&s=', VGETQUOTE.BROKENQUOTE.Ticker))" contains non-pushdown constructs.
> The GetQuote and Quote procedures divide the SQL from BrokenQuote into two procedures and does not produce the exception, but I don't see why BrokenQuote does not work.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Commented: (TEIID-1438) Teiid is attempting to push a string concat down.
by John Doyle (JIRA)
[ https://issues.jboss.org/browse/TEIID-1438?page=com.atlassian.jira.plugin... ]
John Doyle commented on TEIID-1438:
-----------------------------------
I think this is likely to be a common pattern in non-SOAP HTTP service invocation, so it could show up often, so I would like to see it fixed for 7.1.1. It does have a easy enough work-around though that could be release noted.
> Teiid is attempting to push a string concat down.
> -------------------------------------------------
>
> Key: TEIID-1438
> URL: https://issues.jboss.org/browse/TEIID-1438
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: John Doyle
>
> That attached VDB is invoking the yahoo quote service. Invoking the BrokenQuote procedure like this:
> Exec VGetQuote.BrokenQuote('IBM');
> results in the following exception:
> Remote org.teiid.api.exception.query.QueryPlannerException: Source command "EXEC GetQuote.invokeHttp('GET', null, concat('?f=snd1l1&s=', VGETQUOTE.BROKENQUOTE.Ticker))" contains non-pushdown constructs.
> The GetQuote and Quote procedures divide the SQL from BrokenQuote into two procedures and does not produce the exception, but I don't see why BrokenQuote does not work.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Updated: (TEIID-1439) Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1439?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-1439:
--------------------------------
Fix Version/s: 7.1.1
7.3
Workaround Description: Turn off server side caching
Complexity: Low
Component/s: Server
> Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1439
> URL: https://issues.jboss.org/browse/TEIID-1439
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi, Server
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 7.1.1, 7.3
>
> Attachments: DeployTest.groovy, server.log_DEBUG_deploy, server.log_TRACE_deploy, weather-ds.xml, weather-vdb.xml
>
>
> See attached standalone adminshell/adminAPI test - this is a new problem in ER7.
> A sequence of 2 iterations of: datasource creation/VDB deployment and queries results in this error:
> DEPLOYMENTS IN ERROR:
> Deployment "vfsfile:/jboss/local/51_ER7/jboss-soa-p-5/jboss-as/server/production/deploy/weather-vdb.xml" is in error due to the following reason(s): java.lang.ClassCastException: java.lang.String cannot be cast to org.teiid.dqp.internal.process.SessionAwareCache$CacheID
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Resolved: (TEIID-1439) Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1439?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-1439.
---------------------------------
Resolution: Done
Expiration cache is fixed not to return the "expiration" key as the client entered cache key.
> Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1439
> URL: https://issues.jboss.org/browse/TEIID-1439
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Priority: Blocker
> Attachments: DeployTest.groovy, server.log_DEBUG_deploy, server.log_TRACE_deploy, weather-ds.xml, weather-vdb.xml
>
>
> See attached standalone adminshell/adminAPI test - this is a new problem in ER7.
> A sequence of 2 iterations of: datasource creation/VDB deployment and queries results in this error:
> DEPLOYMENTS IN ERROR:
> Deployment "vfsfile:/jboss/local/51_ER7/jboss-soa-p-5/jboss-as/server/production/deploy/weather-vdb.xml" is in error due to the following reason(s): java.lang.ClassCastException: java.lang.String cannot be cast to org.teiid.dqp.internal.process.SessionAwareCache$CacheID
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Commented: (TEIID-1439) Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1439?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-1439:
-------------------------------------
This error only occurs in the cluster profiles like "all". Teiid uses a Expiration based JBoss Cache in clustered mode. To make the expiration work, the JBoss Cache needs a data element called "expiration" stored along with the cache and its value as separate entity on the same node. However, when the keys are read back from cache all the keys were assumed to be "cache" keys and not taking the "expiration" key which is string based key into account. Thus when the client code using the cache type casts the key to a CacheID the server throws a ClassCastException.
Workaround is Turn OFF result caching in the "server". This will avoid the caching layer be used at all.
> Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1439
> URL: https://issues.jboss.org/browse/TEIID-1439
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Priority: Blocker
> Attachments: DeployTest.groovy, server.log_DEBUG_deploy, server.log_TRACE_deploy, weather-ds.xml, weather-vdb.xml
>
>
> See attached standalone adminshell/adminAPI test - this is a new problem in ER7.
> A sequence of 2 iterations of: datasource creation/VDB deployment and queries results in this error:
> DEPLOYMENTS IN ERROR:
> Deployment "vfsfile:/jboss/local/51_ER7/jboss-soa-p-5/jboss-as/server/production/deploy/weather-vdb.xml" is in error due to the following reason(s): java.lang.ClassCastException: java.lang.String cannot be cast to org.teiid.dqp.internal.process.SessionAwareCache$CacheID
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Commented: (TEIID-1438) Teiid is attempting to push a string concat down.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1438?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1438:
---------------------------------------
I know this has been fixed in 7.3 (because the pushdown check excludes procedures) but I'm not sure why it is failing as it should not see the concat parameter as needing evaluated. Does this need addressed in 7.1.1?
> Teiid is attempting to push a string concat down.
> -------------------------------------------------
>
> Key: TEIID-1438
> URL: https://issues.jboss.org/browse/TEIID-1438
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: John Doyle
>
> That attached VDB is invoking the yahoo quote service. Invoking the BrokenQuote procedure like this:
> Exec VGetQuote.BrokenQuote('IBM');
> results in the following exception:
> Remote org.teiid.api.exception.query.QueryPlannerException: Source command "EXEC GetQuote.invokeHttp('GET', null, concat('?f=snd1l1&s=', VGETQUOTE.BROKENQUOTE.Ticker))" contains non-pushdown constructs.
> The GetQuote and Quote procedures divide the SQL from BrokenQuote into two procedures and does not produce the exception, but I don't see why BrokenQuote does not work.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Moved: (TEIID-1439) Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1439?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-2787 to TEIID-1439:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1439 (was: SOA-2787)
Affects Version/s: 7.1.1
(was: 5.1.0.ER7)
Affects Testing: (was: [Regression])
Component/s: AdminApi
(was: EDS)
Security: (was: Public)
> Adminshell/API - sequence of datasource creation/VDB deployment and queries results in deployment error
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1439
> URL: https://issues.jboss.org/browse/TEIID-1439
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Priority: Blocker
> Attachments: DeployTest.groovy, server.log_DEBUG_deploy, server.log_TRACE_deploy, weather-ds.xml, weather-vdb.xml
>
>
> See attached standalone adminshell/adminAPI test - this is a new problem in ER7.
> A sequence of 2 iterations of: datasource creation/VDB deployment and queries results in this error:
> DEPLOYMENTS IN ERROR:
> Deployment "vfsfile:/jboss/local/51_ER7/jboss-soa-p-5/jboss-as/server/production/deploy/weather-vdb.xml" is in error due to the following reason(s): java.lang.ClassCastException: java.lang.String cannot be cast to org.teiid.dqp.internal.process.SessionAwareCache$CacheID
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Moved: (TEIID-1438) Teiid is attempting to push a string concat down.
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1438?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-2781 to TEIID-1438:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1438 (was: SOA-2781)
Affects Version/s: 7.1.1
(was: 5.1.0.ER6)
Fix Version/s: (was: 5.1.0 GA)
Component/s: Query Engine
(was: EDS)
Security: (was: Public)
> Teiid is attempting to push a string concat down.
> -------------------------------------------------
>
> Key: TEIID-1438
> URL: https://issues.jboss.org/browse/TEIID-1438
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: John Doyle
>
> That attached VDB is invoking the yahoo quote service. Invoking the BrokenQuote procedure like this:
> Exec VGetQuote.BrokenQuote('IBM');
> results in the following exception:
> Remote org.teiid.api.exception.query.QueryPlannerException: Source command "EXEC GetQuote.invokeHttp('GET', null, concat('?f=snd1l1&s=', VGETQUOTE.BROKENQUOTE.Ticker))" contains non-pushdown constructs.
> The GetQuote and Quote procedures divide the SQL from BrokenQuote into two procedures and does not produce the exception, but I don't see why BrokenQuote does not work.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months