[teiid-issues] [JBoss JIRA] (TEIID-1812) Client Recieving java.lang.IndexOutOfBoundsException when performing query

[Graeme Gillies (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1812?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12642409#comment-12642409 ] 

Graeme Gillies commented on TEIID-1812:
---------------------------------------

Hi,

Applied the patch and managed to get the full stacktrace of the exception.

We also noticed this exception happening for other queries as well using the SFDC connector

{noformat}
2011-11-13 19:40:12,251 INFO  [org.teiid.PROCESSOR.MATVIEWS] (Worker0_QueryProcessorQueue2) Loaded materialized view table #MAT_PG_CATALOG.MATPG_RELATT with row count 4,292.
2011-11-13 19:40:43,741 ERROR [org.teiid.ODBC] (Worker3_QueryProcessorQueue32) Unexpected error occurred
java.lang.IndexOutOfBoundsException
	at org.jboss.netty.buffer.AbstractChannelBuffer.writerIndex(AbstractChannelBuffer.java:60)
	at org.teiid.transport.PgBackendProtocol.startMessage(PgBackendProtocol.java:789)
	at org.teiid.transport.PgBackendProtocol.sendDataRow(PgBackendProtocol.java:446)
	at org.teiid.transport.PgBackendProtocol.access$600(PgBackendProtocol.java:74)
	at org.teiid.transport.PgBackendProtocol$ResultsWorkItem.processRow(PgBackendProtocol.java:144)
	at org.teiid.transport.PgBackendProtocol$ResultsWorkItem.run(PgBackendProtocol.java:130)
	at org.teiid.transport.PgBackendProtocol$ResultsWorkItem$1.onCompletion(PgBackendProtocol.java:123)
	at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
	at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
	at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
	at org.teiid.jdbc.ResultSetImpl$1.onCompletion(ResultSetImpl.java:248)
	at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
	at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
	at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
	at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:630)
	at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:491)
	at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:173)
	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:148)
	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:352)
	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278)
	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
	at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:207)
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:194)
	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)
{noformat}
                
> Client Recieving java.lang.IndexOutOfBoundsException when performing query
> --------------------------------------------------------------------------
>
>                 Key: TEIID-1812
>                 URL: https://issues.jboss.org/browse/TEIID-1812
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 7.5
>         Environment: java version "1.6.0_20"
> OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64)
> OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
> Running on RHEL 5, teiid inside of JBoss EAP 5.1.1
> Client is postgresql command line tool version postgresql-9.1.1-1.fc16.x86_64
> Using the command line command
> psql -h teiid-01.app.eng.bos.redhat.com -p 35432 -U teiid -d EngVDBF
>            Reporter: Graeme Gillies
>            Assignee: Steven Hawkins
>         Attachments: PgBackendProtocol.java.patch
>
>
> When attempting to perform the following query using the postgres command line client connecting to teiids postgres emulation layer, we get the following error
> {code}
> SELECT components.name, COUNT(bug_id) FROM BugzillaS.bugs bugs, BugzillaS.components components, BugzillaS.profiles profiles WHERE (bugs.component_id = 
>             components.id AND bugs.reporter = profiles.userid AND bugs.creation_ts>='2011-10-04') GROUP BY components.name ORDER BY components.name limit 1500;
> {code}
> {code}
> ERROR:  java.lang.IndexOutOfBoundsException
> DETAIL:  org.teiid.jdbc.TeiidSQLException: java.lang.IndexOutOfBoundsException
> {code}
> Watching the server logs we don't see any such exception reported there, so I'd need some advice on how to get you some more information.
> Regards,
> Graeme

--
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