[teiid-issues] [JBoss JIRA] (TEIID-1937) teiid encouters java.io.StreamCorruptedException

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1937.
-----------------------------------

    Resolution: Partially Completed


Based upon feedback from Graeme, marking as partially completed.  The code changes where the additional sanity checks added in 7.7 and the ability to copy lobs in 7.7.1 as a better way of controlling the memory usage of lobs from sources, such as mysql, that do not support memory-safe lobs.  See the reference/release notes for the copyLobs translator property.  Also added a recommendation for mysql to use server side cursors if large resultsets are being fetched - as the mysql driver by default materializes the entire resultset.

I was not sucessful in locally reproducing the issue, so we may need to look at this again at some point.


                
> teiid encouters java.io.StreamCorruptedException
> ------------------------------------------------
>
>                 Key: TEIID-1937
>                 URL: https://issues.jboss.org/browse/TEIID-1937
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    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
>             Fix For: 7.7.1
>
>
> 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