[
https://issues.jboss.org/browse/TEIID-1812?page=com.atlassian.jira.plugin...
]
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