[JBoss JIRA] Moved: (TEIID-1697) CLONE - java.io.NotSerializableException: java.io.PrintWriter when SHOWPLAN is DEBUG in a clustered configuration
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1697?page=com.atlassian.jira.plugin... ]
Steven Hawkins moved SOA-3243 to TEIID-1697:
--------------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1697 (was: SOA-3243)
Component/s: Query Engine
(was: EDS)
Security: (was: Public)
> CLONE - java.io.NotSerializableException: java.io.PrintWriter when SHOWPLAN is DEBUG in a clustered configuration
> -----------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1697
> URL: https://issues.jboss.org/browse/TEIID-1697
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Environment: Fedora 14, SOA-P 5.1 with CP3 (test), production configuration, clustered with another Fedora system
> Reporter: Paul Nittel
>
> While testing resultset caching, I found that when I queried (and loaded the cache) I received an exception. There is no exception when queries are sourced by the cache.
> I am using the production configuration, have Teiid logging set to DEBUG and, and "set showplan debug" prior to executing /*+ cache(ttl:10000) */ SELECT * from "PartsMatSourceOra"."PARTS" (Should do the same thing with any source model.)
> The exception is:
> 2011-08-02 15:42:50,713 ERROR [org.jboss.cache.marshall.CacheMarshaller300] (Worker14_QueryProcessorQueue74) Error while marshalling object: ReplicateCommand{cmds=PutKeyValueCommand{fqn=/Teiid/resultset/RESULTSET/CacheID-1190504654, dataVersion=null, globalTransaction=null, key=Cache Entry<NErBtH0HCuOP=user@teiid-security> params:null sql:/*+ cache(ttl:120000) */ SELECT * from "PartsMatSourceOra"."PARTS", value=org.teiid.dqp.internal.process.CachedResults@393dd5c4}}
> java.io.NotSerializableException: java.io.PrintWriter
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1164)
> at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518)
> at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483)
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400)
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
> at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518)
> at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483)
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400)
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:330)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallObject(CacheMarshaller200.java:460)
> at org.jboss.cache.marshall.CacheMarshaller300.marshallObject(CacheMarshaller300.java:47)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallCommand(CacheMarshaller200.java:519)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallObject(CacheMarshaller200.java:314)
> at org.jboss.cache.marshall.CacheMarshaller300.marshallObject(CacheMarshaller300.java:47)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallCommand(CacheMarshaller200.java:519)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallObject(CacheMarshaller200.java:314)
> at org.jboss.cache.marshall.CacheMarshaller300.marshallObject(CacheMarshaller300.java:47)
> at org.jboss.cache.marshall.CacheMarshaller200.objectToObjectStream(CacheMarshaller200.java:191)
> at org.jboss.cache.marshall.CacheMarshaller200.objectToObjectStream(CacheMarshaller200.java:131)
> at org.jboss.cache.marshall.VersionAwareMarshaller.objectToBuffer(VersionAwareMarshaller.java:183)
> at org.jboss.cache.marshall.VersionAwareMarshaller.objectToBuffer(VersionAwareMarshaller.java:52)
> at org.jboss.cache.marshall.CommandAwareRpcDispatcher$ReplicationTask.call(CommandAwareRpcDispatcher.java:383)
> at org.jboss.cache.marshall.CommandAwareRpcDispatcher$ReplicationTask.call(CommandAwareRpcDispatcher.java:355)
> at org.jboss.cache.util.concurrent.WithinThreadExecutor.submit(WithinThreadExecutor.java:82)
> at org.jboss.cache.marshall.CommandAwareRpcDispatcher.invokeRemoteCommands(CommandAwareRpcDispatcher.java:210)
> at org.jboss.cache.RPCManagerImpl.callRemoteMethods(RPCManagerImpl.java:744)
> at org.jboss.cache.RPCManagerImpl.callRemoteMethods(RPCManagerImpl.java:712)
> at org.jboss.cache.RPCManagerImpl.callRemoteMethods(RPCManagerImpl.java:717)
> at org.jboss.cache.interceptors.BaseRpcInterceptor.replicateCall(BaseRpcInterceptor.java:161)
> at org.jboss.cache.interceptors.BaseRpcInterceptor.replicateCall(BaseRpcInterceptor.java:135)
> at org.jboss.cache.interceptors.BaseRpcInterceptor.replicateCall(BaseRpcInterceptor.java:107)
> at org.jboss.cache.interceptors.ReplicationInterceptor.handleCrudMethod(ReplicationInterceptor.java:160)
> at org.jboss.cache.interceptors.ReplicationInterceptor.visitPutKeyValueCommand(ReplicationInterceptor.java:107)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:131)
> at org.jboss.cache.commands.AbstractVisitor.visitPutKeyValueCommand(AbstractVisitor.java:65)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.TxInterceptor.attachGtxAndPassUpChain(TxInterceptor.java:301)
> at org.jboss.cache.interceptors.TxInterceptor.handleDefault(TxInterceptor.java:283)
> at org.jboss.cache.commands.AbstractVisitor.visitPutKeyValueCommand(AbstractVisitor.java:65)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:119)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.InvocationContextInterceptor.handleAll(InvocationContextInterceptor.java:178)
> at org.jboss.cache.interceptors.InvocationContextInterceptor.visitPutKeyValueCommand(InvocationContextInterceptor.java:82)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.InterceptorChain.invoke(InterceptorChain.java:287)
> at org.jboss.cache.invocation.CacheInvocationDelegate.put(CacheInvocationDelegate.java:555)
> at org.jboss.cache.invocation.NodeInvocationDelegate.put(NodeInvocationDelegate.java:377)
> at org.teiid.cache.jboss.ExpirationAwareCache.put(ExpirationAwareCache.java:51)
> at org.teiid.dqp.internal.process.SessionAwareCache.put(SessionAwareCache.java:177)
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:396)
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:140)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:117)
> 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$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> 2011-08-02 15:42:50,714 ERROR [org.jboss.cache.marshall.CommandAwareRpcDispatcher] (Worker14_QueryProcessorQueue74) java.io.NotSerializableException: java.io.PrintWriter
> 2011-08-02 15:42:50,714 ERROR [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue74) Unexpected exception for request NErBtH0HCuOP.22
> java.lang.RuntimeException: Failure to marshal argument(s)
> at org.jboss.cache.marshall.CommandAwareRpcDispatcher$ReplicationTask.call(CommandAwareRpcDispatcher.java:388)
> at org.jboss.cache.marshall.CommandAwareRpcDispatcher$ReplicationTask.call(CommandAwareRpcDispatcher.java:355)
> at org.jboss.cache.util.concurrent.WithinThreadExecutor.submit(WithinThreadExecutor.java:82)
> at org.jboss.cache.marshall.CommandAwareRpcDispatcher.invokeRemoteCommands(CommandAwareRpcDispatcher.java:210)
> at org.jboss.cache.RPCManagerImpl.callRemoteMethods(RPCManagerImpl.java:744)
> at org.jboss.cache.RPCManagerImpl.callRemoteMethods(RPCManagerImpl.java:712)
> at org.jboss.cache.RPCManagerImpl.callRemoteMethods(RPCManagerImpl.java:717)
> at org.jboss.cache.interceptors.BaseRpcInterceptor.replicateCall(BaseRpcInterceptor.java:161)
> at org.jboss.cache.interceptors.BaseRpcInterceptor.replicateCall(BaseRpcInterceptor.java:135)
> at org.jboss.cache.interceptors.BaseRpcInterceptor.replicateCall(BaseRpcInterceptor.java:107)
> at org.jboss.cache.interceptors.ReplicationInterceptor.handleCrudMethod(ReplicationInterceptor.java:160)
> at org.jboss.cache.interceptors.ReplicationInterceptor.visitPutKeyValueCommand(ReplicationInterceptor.java:107)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:131)
> at org.jboss.cache.commands.AbstractVisitor.visitPutKeyValueCommand(AbstractVisitor.java:65)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.TxInterceptor.attachGtxAndPassUpChain(TxInterceptor.java:301)
> at org.jboss.cache.interceptors.TxInterceptor.handleDefault(TxInterceptor.java:283)
> at org.jboss.cache.commands.AbstractVisitor.visitPutKeyValueCommand(AbstractVisitor.java:65)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.CacheMgmtInterceptor.visitPutKeyValueCommand(CacheMgmtInterceptor.java:119)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
> at org.jboss.cache.interceptors.InvocationContextInterceptor.handleAll(InvocationContextInterceptor.java:178)
> at org.jboss.cache.interceptors.InvocationContextInterceptor.visitPutKeyValueCommand(InvocationContextInterceptor.java:82)
> at org.jboss.cache.commands.write.PutKeyValueCommand.acceptVisitor(PutKeyValueCommand.java:100)
> at org.jboss.cache.interceptors.InterceptorChain.invoke(InterceptorChain.java:287)
> at org.jboss.cache.invocation.CacheInvocationDelegate.put(CacheInvocationDelegate.java:555)
> at org.jboss.cache.invocation.NodeInvocationDelegate.put(NodeInvocationDelegate.java:377)
> at org.teiid.cache.jboss.ExpirationAwareCache.put(ExpirationAwareCache.java:51)
> at org.teiid.dqp.internal.process.SessionAwareCache.put(SessionAwareCache.java:177)
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:396)
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:140)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:117)
> 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$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.io.NotSerializableException: java.io.PrintWriter
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1164)
> at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518)
> at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483)
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400)
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
> at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518)
> at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483)
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400)
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:330)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallObject(CacheMarshaller200.java:460)
> at org.jboss.cache.marshall.CacheMarshaller300.marshallObject(CacheMarshaller300.java:47)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallCommand(CacheMarshaller200.java:519)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallObject(CacheMarshaller200.java:314)
> at org.jboss.cache.marshall.CacheMarshaller300.marshallObject(CacheMarshaller300.java:47)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallCommand(CacheMarshaller200.java:519)
> at org.jboss.cache.marshall.CacheMarshaller200.marshallObject(CacheMarshaller200.java:314)
> at org.jboss.cache.marshall.CacheMarshaller300.marshallObject(CacheMarshaller300.java:47)
> at org.jboss.cache.marshall.CacheMarshaller200.objectToObjectStream(CacheMarshaller200.java:191)
> at org.jboss.cache.marshall.CacheMarshaller200.objectToObjectStream(CacheMarshaller200.java:131)
> at org.jboss.cache.marshall.VersionAwareMarshaller.objectToBuffer(VersionAwareMarshaller.java:183)
> at org.jboss.cache.marshall.VersionAwareMarshaller.objectToBuffer(VersionAwareMarshaller.java:52)
> at org.jboss.cache.marshall.CommandAwareRpcDispatcher$ReplicationTask.call(CommandAwareRpcDispatcher.java:383)
> ... 45 more
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Updated: (TEIID-1695) CLONE - java.lang.ClassNotFoundException: nu.xom.ParsingException via Import > Teiid Designer > WSDL into Relational Source Model
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1695?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-1695:
----------------------------------
Fix Version/s: 7.4.1
Affects Version/s: 7.4.1
(was: 7.5)
We should refactor the SaxonXQueryExpression to not expose the xom/nux dependency to designer.
> CLONE - java.lang.ClassNotFoundException: nu.xom.ParsingException via Import > Teiid Designer > WSDL into Relational Source Model
> ---------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1695
> URL: https://issues.jboss.org/browse/TEIID-1695
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.4.1
> Reporter: Barry LaFond
> Assignee: Ted Jones
> Fix For: 7.4.1, 7.5
>
>
> 1) Import > Teiid Designer > WSDL into Relational Source Model
> 2) Create New WS Connection Profile by selecting the attached OnHand.wsdl file on your local file system.
> 3) Finish wizard and get following exception
> java.lang.NoClassDefFoundError: nu/xom/ParsingException
> at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:120)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:357)
> at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:168)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:273)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:580)
> at org.teiid.query.sql.lang.From.acceptVisitor(From.java:146)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:235)
> at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:106)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:294)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:147)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveEmbeddedCommand(UpdateProcedureResolver.java:338)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveStatement(UpdateProcedureResolver.java:189)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveBlock(UpdateProcedureResolver.java:164)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveCommand(UpdateProcedureResolver.java:147)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:294)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:168)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.resolveCommand(TransformationValidator.java:431)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Moved: (TEIID-1695) CLONE - java.lang.ClassNotFoundException: nu.xom.ParsingException via Import > Teiid Designer > WSDL into Relational Source Model
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1695?page=com.atlassian.jira.plugin... ]
Steven Hawkins moved TEIIDDES-1023 to TEIID-1695:
-------------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-1695 (was: TEIIDDES-1023)
Affects Version/s: 7.5
(was: 7.5)
Component/s: Query Engine
(was: Import/Export)
Fix Version/s: 7.5
(was: 7.5)
> CLONE - java.lang.ClassNotFoundException: nu.xom.ParsingException via Import > Teiid Designer > WSDL into Relational Source Model
> ---------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1695
> URL: https://issues.jboss.org/browse/TEIID-1695
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.5
> Reporter: Barry LaFond
> Assignee: Ted Jones
> Fix For: 7.5
>
>
> 1) Import > Teiid Designer > WSDL into Relational Source Model
> 2) Create New WS Connection Profile by selecting the attached OnHand.wsdl file on your local file system.
> 3) Finish wizard and get following exception
> java.lang.NoClassDefFoundError: nu/xom/ParsingException
> at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:120)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:357)
> at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:168)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72)
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:273)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:580)
> at org.teiid.query.sql.lang.From.acceptVisitor(From.java:146)
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61)
> at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:235)
> at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:106)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:294)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:147)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveEmbeddedCommand(UpdateProcedureResolver.java:338)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveStatement(UpdateProcedureResolver.java:189)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveBlock(UpdateProcedureResolver.java:164)
> at org.teiid.query.resolver.command.UpdateProcedureResolver.resolveCommand(UpdateProcedureResolver.java:147)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:294)
> at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:168)
> at com.metamatrix.modeler.transformation.validation.TransformationValidator.resolveCommand(TransformationValidator.java:431)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Resolved: (TEIID-1659) Support pagination of LDAP results when retrieving from Active Directory
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1659?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1659.
-----------------------------------
Resolution: Done
Added support for pagination based upon using a PagedResultsControl. This works for at least Active Directory and OpenLDAP. It looks like Sun/Netscape servers could also be supported, but would require non-JRE supported code.
> Support pagination of LDAP results when retrieving from Active Directory
> ------------------------------------------------------------------------
>
> Key: TEIID-1659
> URL: https://issues.jboss.org/browse/TEIID-1659
> Project: Teiid
> Issue Type: Feature Request
> Components: LDAP Connector
> Affects Versions: 7.1.1
> Environment: EDS 5.1. LDAP connection factory/translator. Active Directory as LDAP provider.
> Reporter: Ken Johnson
> Assignee: Steven Hawkins
> Fix For: 7.4.1
>
>
> Active Directory has a setting MaxPageSize that limits the number of records of query results returned in a batch. The EDS LDAP connector/translator should support this setting so it can page through the results and retrieve all results. Not just up to MaxPageSize. Ideally this would be a configurable parameter that the user must set to match the MaxPageSize value on the AD server. For more info: http://support.microsoft.com/kb/315071.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1566) More complex join: ORDER BY and LIMIT not pushed down
by Mark Addleman (JIRA)
More complex join: ORDER BY and LIMIT not pushed down
------------------------------------------------------
Key: TEIID-1566
URL: https://issues.jboss.org/browse/TEIID-1566
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Mark Addleman
Assignee: Steven Hawkins
Query: SELECT B."SYSID", B."USERID", J0.APPNAME as "SYSOFUSER@APPNAME", B."NAME", B."PROC", B."SUSPEND", B."UID", (select count(*) from (select * from notes.RETRIEVE_NOTES where OBJECT_PKEY = xmlserialize(xmlelement("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "__objecttype__" FROM "SECURITY.BASEUSER" as B left join security.sysinfo J0 on J0.sysid=B.sysid ORDER BY J0.APPNAME ASC LIMIT 9990,10; args: []
I think there are two problems with the plan for this query: First, neither the ORDER BY nor the LIMIT clause are pushed down to DB2. However, if it is was pushed down, the plan should apply the ORDER & LIMIT before it tries to join to the notes table.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1529) LIMIT not pushed down for queries with subselects and ORDER BY
by Mark Addleman (JIRA)
LIMIT not pushed down for queries with subselects and ORDER BY
--------------------------------------------------------------
Key: TEIID-1529
URL: https://issues.jboss.org/browse/TEIID-1529
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.3
Reporter: Mark Addleman
Assignee: Steven Hawkins
It doesn't look like the engine pushes down LIMIT in the following query:
SELECT B."SYSID", B."USERID", (SELECT COUNT(*) FROM
(SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "__objecttype__" FROM "SECURITY.BASEUSER" as B ORDER BY B."USERID" ASC LIMIT 10
However, the engine does push down the LIMIT in the same query without the ORDER BY:
SELECT B."SYSID", B."USERID", (SELECT COUNT(*) FROM
(SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "__objecttype__" FROM "SECURITY.BASEUSER" as B LIMIT 10
Another piece of relevant information is notes.RETRIEVE_NOTE is a stored procedure backed by java code in a translator.
Since SECURITY.BASEER contains ~20,000 rows and each row requires a select against the RETRIEVE_NOTE stored procedure, the difference in processing time is huge: about two minutes with the ORDER BY versus a few hundred milliseconds without the ORDER BY.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1562) ArrayIndexOutOfBounds and ASSERTION FAILED in models with UNION
by Claudio Venturini (JIRA)
ArrayIndexOutOfBounds and ASSERTION FAILED in models with UNION
---------------------------------------------------------------
Key: TEIID-1562
URL: https://issues.jboss.org/browse/TEIID-1562
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.3, 7.4
Environment: Teiid 7.3/7.4 beta2 deployed on JBoss AS 5.1, installed on Ubuntu Server 10.04 LTS. Three source models, two of which in MySQL 5.1.51 (on the same machine of JBoss), and one on SQLServer 2000 (on another machine).
Reporter: Claudio Venturini
Assignee: Steven Hawkins
I've three simple source models. Two of them (namely "support_phy" and "oasi_phy") are on MySQL, and one ("tricolore_phy") on SQL Server 2000. I also have three view models, one for each source model, named "support_log", "oasi_log" and "tricolore_log". Don't mind the names...
Every model has only one table. Each of these view models reflects one of the source models. In addition I have a fourth view model, named "aop", which integrates the data from the other view models using a simple UNION ALL operation. In particular this view model is defined by the following query:
{code:sql}
SELECT
TR_v.data AS data_fattura, TR_v.n_prog, TR_v.quantita
FROM
tricolore_log.misura124.tricolore.vendita_referenza AS TR_v
UNION ALL
SELECT
OA_v.data AS data_fattura, OA_v.n_prog, OA_v.quantita
FROM
oasi_log.misura124.oasi.vendita_referenza AS OA_v
{code}
One problem is that if I execute the following query, against the integrated model:
{code:sql}
SELECT
data_fattura,
n_prog,
quantita
FROM
aop.misura124.aop.vendita_referenza
WHERE n_prog = 1
{code}
I get a ArrayIndexOutOfBoundsException:
{code}
2011-04-20 17:26:26,332 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=2011-04-20 17:26:26.332 requestID=8LzPNHldNJhu.2 txID=null sessionID=8LzPNHldNJhu applicationName=JDBC principal=admin@teiid-security vdbName=misura124 vdbVersion=1sql=SELECT
data_fattura,
n_prog,
quantita
FROM
aop.misura124.aop.vendita_referenza
where n_prog = 1
2011-04-20 17:26:26,373 DEBUG [org.teiid.COMMAND_LOG] (Worker163_QueryProcessorQueue7610) ERROR USER COMMAND: endTime=2011-04-20 17:26:26.373 requestID=8LzPNHldNJhu.2 txID=null sessionID=8LzPNHldNJhu principal=admin@teiid-security vdbName=misura124 vdbVersion=1 finalRowCount=null
2011-04-20 17:26:26,373 ERROR [org.teiid.PROCESSOR] (Worker163_QueryProcessorQueue7610) Unexpected exception for request 8LzPNHldNJhu.2
java.lang.ArrayIndexOutOfBoundsException
{code}
I've tried to swap the order of the SELECTs statements in the query as follows:
{code:sql}
SELECT
OA_v.data AS data_fattura, OA_v.n_prog, OA_v.quantita
FROM
oasi_log.misura124.oasi.vendita_referenza AS OA_v
UNION ALL
SELECT
TR_v.data AS data_fattura, TR_v.n_prog, TR_v.quantita
FROM
tricolore_log.misura124.tricolore.vendita_referenza AS TR_v
{code}
Surprisingly it works!!
This was the first problem. While finding a solution to that problem, I found a second problem. The definition of the table in the "tricolore_log" model is as follows:
{code:sql}
SELECT
TR_v.DataDocumento AS data, 1 AS n_prog, CAST(SUM(TR_v.NrPezzi) AS INTEGER) AS quantita
FROM
tricolore_phy.Tricolore.dbo.DISCO_Vendita_Referenza AS TR_v INNER JOIN support_log.mediator.referenza_op AS SUP_r ON TR_v.Cod_Dsc = SUP_r.codice
WHERE
SUP_r.codop = 1
GROUP BY TR_v.DataDocumento, COALESCE(NULLIF(RTRIM(LTRIM(TR_v.NumeroDocumento)), ''), 'N.D.')
{code}
The GROUP BY clause is a little bit complex, so I tried to simplify it by removing the COALESCE function, thereby maintaining in the clause only the TR_v.DataDocumento field. I've run the same query on the integrated schema, and the result is an ASSERTION FAILED error:
{code}
2011-04-20 17:06:33,572 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-2) START USER COMMAND: startTime=2011-04-20 17:06:33.571 requestID=iMaBNssX10Nx.0 txID=null sessionID=iMaBNssX10Nx applicationName=JDBC principal=admin@teiid-security vdbName=misura124 vdbVersion=1sql=SELECT
data_fattura,
n_prog,
quantita
FROM
aop.misura124.aop.vendita_referenza
where n_prog = 1
2011-04-20 17:06:33,586 DEBUG [org.teiid.COMMAND_LOG] (Worker158_QueryProcessorQueue7536) ERROR USER COMMAND: endTime=2011-04-20 17:06:33.586 requestID=iMaBNssX10Nx.0 txID=null sessionID=iMaBNssX10Nx principal=admin@teiid-security vdbName=misura124 vdbVersion=1 finalRowCount=null
2011-04-20 17:06:33,588 ERROR [org.teiid.PROCESSOR] (Worker158_QueryProcessorQueue7536) Unexpected exception for request iMaBNssX10Nx.0
java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367)
at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:129)
at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:103)
at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108)
at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108)
at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108)
at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108)
at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:98)
at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:175)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:125)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:104)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:305)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:233)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:56)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
{code}
Worst of all, the clients seems to not recognize the error, and thus it continues to wait for a response which will never arrive. From the client point of view, the server seems to be in a infinite loop.
In addition the query works either by completely removing the GROUP BY clause, or removing the INNER JOIN and the WHERE clauses. But these can not be considered as workarounds because they change the semantics of the model.
I found the two bugs using Teiid 7.3 patched with https://issues.jboss.org/browse/TEIID-1458 and https://issues.jboss.org/browse/TEIID-1465, and then I upgraded to Teiid 7.4 beta2, which doesn't solve the problem.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months