[JBoss JIRA] Created: (TEIID-1680) issues with correlation and aggregation
by Steven Hawkins (JIRA)
issues with correlation and aggregation
---------------------------------------
Key: TEIID-1680
URL: https://issues.jboss.org/browse/TEIID-1680
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
subqueries used in the having/select clause of a query with grouping only understand correlated element symbols - not correlated grouping expressions or correlated aggregate values.
If a nested aggregate contains only outer references, then it should be treated as a correlated value.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 3 months
[JBoss JIRA] (TEIID-1937) Pentaho Client pulling data from teiid encouters java.io.StreamCorruptedException
by Graeme Gillies (JIRA)
Graeme Gillies created TEIID-1937:
-------------------------------------
Summary: Pentaho Client pulling data from teiid encouters java.io.StreamCorruptedException
Key: TEIID-1937
URL: https://issues.jboss.org/browse/TEIID-1937
Project: Teiid
Issue Type: Bug
Affects Versions: 7.6
Environment: java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.10) (rhel-1.23.1.9.10.el5_7-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
Running on RHEL 5, teiid 7.6 inside of JBoss EAP 5.1.1
teiid has a bunch of backports from 7.7 applied (see comments)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Hi,
We have someone integrating with our teiid system using pentaho, which apparently runs in java 1.5.
Most of the integration works fine but they hit the following error which shows on the client and the server
{noformat}
2012-02-13 04:38:29,741 ERROR [org.teiid.PROCESSOR] (Worker22_QueryProcessorQueue4539) Unexpected exception for request urrun2neqkMl.278
[TeiidComponentException]Error reading 34,471
1 [StreamCorruptedException]invalid type code: 00
at org.teiid.common.buffer.impl.BufferFrontedFileStoreCache.get(BufferFrontedFileStoreCache.java:727)
at org.teiid.common.buffer.impl.BufferFrontedFileStoreCache.get(BufferFrontedFileStoreCache.java:100)
at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:287)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:219)
at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:615)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:395)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
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: java.io.StreamCorruptedException: invalid type code: 00
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1373)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:368)
at org.teiid.common.buffer.impl.DataObjectInputStream.readObject(DataObjectInputStream.java:102)
at org.teiid.core.types.Streamable.readExternal(Streamable.java:115)
at org.teiid.client.BatchSerializer$ClobColumnSerializer1.readObject(BatchSerializer.java:174)
at org.teiid.client.BatchSerializer$ColumnSerializer.readColumn(BatchSerializer.java:276)
at org.teiid.client.BatchSerializer.readBatch(BatchSerializer.java:578)
at org.teiid.client.BatchSerializer.readBatch(BatchSerializer.java:561)
at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.deserialize(BufferManagerImpl.java:226)
at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.deserialize(BufferManagerImpl.java:144)
at org.teiid.common.buffer.impl.BufferFrontedFileStoreCache.get(BufferFrontedFileStoreCache.java:724)
... 14 more
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] Created: (TEIID-1715) Simplify ODBC buffers
by Steven Hawkins (JIRA)
Simplify ODBC buffers
---------------------
Key: TEIID-1715
URL: https://issues.jboss.org/browse/TEIID-1715
Project: Teiid
Issue Type: Quality Risk
Components: ODBC
Affects Versions: 7.4.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.5
The results message is being built separately then copied into results buffer. These should use a single buffer. Also we are mistakenly using direct buffers. Beyond the possible memory implications in heavy usage scenarios, direct buffers cannot grow which means that any result over the ODBCPacketSize (such as a lob) will cause an exception.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months