July 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2776) ArrayIndexOutOfBoundsException

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2776?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2776. --------------------------------- > ArrayIndexOutOfBoundsException > ------------------------------ > > Key: TEIID-2776 > URL: https://issues.jboss.org/browse/TEIID-2776 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.5 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Priority: Critical > Labels: exception, teiid > Fix For: 8.6 > > > When executing the following query: > insert into #tmp_labres > select f.patientid as admissionid, f.variableid, f.sampledate, f.value, f.stringvalue, f.status > from ( > select v.*, rank() over(partition by v.patientid,v.VariableID, v.sampledate order by v.SampleTime,v.resultno desc) as resultrank > from #tmp_labrestimecast v > ) f > where f.resultrank = 1; > I get and ArrayIndexOutOfBoundsException. In the logs it only says "11:31:44,537 ERROR [org.teiid.PROCESSOR] (Worker15031_QueryProcessorQueue278439) yfgMWpMOgQdg TEIID30019 Unexpected exception for request yfgMWpMOgQdg.43: java.lang.ArrayIndexOutOfBoundsException > " > A few log entries before this I find a stack trace for an ArrayIndexOutOfBoundsException. Since I have executed this query multiple times I think it's a stack trace for the same query. I suppose this has something to do with the rank function. A normal select on #tmp_labrestimecast works without a problem. > 16:25:39,765 ERROR [org.teiid.PROCESSOR] (Worker13352_QueryProcessorQueue214542) 90UM8pskkEDH TEIID30019 Unexpected exception for request 90UM8pskkEDH.255: java.lang.ArrayIndexOutOfBoundsException: 1 > at java.util.Arrays$ArrayList.get(Arrays.java:2866) [rt.jar:1.7.0_25] > at org.teiid.query.processor.relational.WindowFunctionProjectNode.nextBatchDirect(WindowFunctionProjectNode.java:270) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:104) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.ProjectIntoNode.nextBatchDirect(ProjectIntoNode.java:138) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:155) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.5.0.Final.jar:8.5.0.Final] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25] > at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25] -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2746) Add additional metadata validation rules

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2746?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2746. --------------------------------- > Add additional metadata validation rules > ---------------------------------------- > > Key: TEIID-2746 > URL: https://issues.jboss.org/browse/TEIID-2746 > Project: Teiid > Issue Type: Quality Risk > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.6 > > > In situations where metadata is constructed manually in a custom translator (not through the MetadataFactory, vdb, nor DDL), we do not validate all aspects for correctness. We should validate some additional scenarios that could lead to issues - for example one possible scenario is https://community.jboss.org/message/846138 -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2681) Test Case failures in teiid-engine

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2681?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2681. --------------------------------- > Test Case failures in teiid-engine > ---------------------------------- > > Key: TEIID-2681 > URL: https://issues.jboss.org/browse/TEIID-2681 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Affects Versions: 8.5 > Environment: Teiid8.5 and Windows7 with > Java HotSpot(TM) 64-Bit Server VM (build 22.1-b02, mixed mode) > Reporter: Rakesh Balguri > Assignee: Steven Hawkins > Fix For: 8.6 > > Attachments: org.teiid.query.function.TestFunction.txt, org.teiid.query.parser.TestCreateDrop.txt, org.teiid.query.parser.TestDDLParser.txt, org.teiid.query.parser.TestParser.txt > > > Attached are the surefire reports. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2719) IllegalAccessError When OData URL is invoked

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2719?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2719. --------------------------------- > IllegalAccessError When OData URL is invoked > -------------------------------------------- > > Key: TEIID-2719 > URL: https://issues.jboss.org/browse/TEIID-2719 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Affects Versions: 8.6 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.6 > > > Any OData access invoked throws exception > {code} > Caused by: java.lang.IllegalAccessError: tried to access class org.teiid.jdbc.SocketProfile from class org.teiid.jdbc.TeiidDriver > at org.teiid.jdbc.TeiidDriver.<init>(TeiidDriver.java:72) [teiid-admin-8.6.0.Alpha3-SNAPSHOT.jar:8.6.0.Alpha3-SNAPSHOT] > at org.teiid.jdbc.TeiidDriver.<clinit>(TeiidDriver.java:60) [teiid-admin-8.6.0.Alpha3-SNAPSHOT.jar:8.6.0.Alpha3-SNAPSHOT] > at org.teiid.odata.LocalClient.<init>(LocalClient.java:89) [classes:] > at org.teiid.odata.TeiidProducerProvider.getContext(TeiidProducerProvider.java:78) [classes:] > at org.teiid.odata.TeiidProducerProvider.getContext(TeiidProducerProvider.java:37) [classes:] > at org.odata4j.producer.resources.BaseResource.getODataProducer(BaseResource.java:119) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:] > at org.odata4j.producer.resources.EntitiesRequestResource.getEntities(EntitiesRequestResource.java:264) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35] > at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35] > at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.7.Final.jar:] > at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.7.Final.jar:] > at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.7.Final.jar:] > at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.7.Final.jar:] > at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.7.Final.jar:] > ... 20 more > {code} -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2778) The artifact name contains .6 (infinispan-remote-cache.6), remove it

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2778?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2778. --------------------------------- > The artifact name contains .6 (infinispan-remote-cache.6), remove it > -------------------------------------------------------------------- > > Key: TEIID-2778 > URL: https://issues.jboss.org/browse/TEIID-2778 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > The quick start infinispan-remote-cache has its artifact name set to: infinispan-remote-cache.6 > The '.6' should be removed. This will resolve the issue where the pogo jar name will then match the module name. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2668) Teiid procedure input parameter has limit for bulk data

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2668?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2668. --------------------------------- > Teiid procedure input parameter has limit for bulk data > ------------------------------------------------------- > > Key: TEIID-2668 > URL: https://issues.jboss.org/browse/TEIID-2668 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Affects Versions: 8.3 > Environment: Teiid 8.3. > Reporter: Jane Li > Assignee: Steven Hawkins > > We wrote a Teiid procedure, one of the input parameters is List<List<Double>>. We found if we give too many data in there, e.g. 200x375, Teiid will throw out exception before go to my translator: > org.teiid.jdbc.TeiidSQLException: Error Code:TEIID20013 Message:Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:559) > at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:201) > at MyTest.testHorizon3DWrite(MyTest.java:102) > at MyTest.main(MyTest.java:27) > Caused by: [TeiidComponentException] TEIID20013: Error Code:TEIID20013 Message:Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error > 1 [SingleInstanceCommunicationException] TEIID20013: Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error > 2 [ExecutionException]java.net.SocketException: Connection reset by peer: socket write error > 3 [SocketException]Connection reset by peer: socket write error > at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:61) > at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:374) > at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:243) > at $Proxy7.executeRequest(Unknown Source) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:629) > ... 4 more > Caused by: [SingleInstanceCommunicationException] TEIID20013: Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error > 1 [ExecutionException]java.net.SocketException: Connection reset by peer: socket write error > 2 [SocketException]Connection reset by peer: socket write error > at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:177) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:102) > at $Proxy1.send(Unknown Source) > at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:362) > ... 7 more > Caused by: java.util.concurrent.ExecutionException: java.net.SocketException: Connection reset by peer: socket write error > at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:100) > at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:95) > at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:174) > ... 14 more > Caused by: java.net.SocketException: Connection reset by peer: socket write error > at java.net.SocketOutputStream.socketWrite0(Native Method) > at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) > at java.net.SocketOutputStream.write(SocketOutputStream.java:136) > at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105) > at java.io.DataOutputStream.write(DataOutputStream.java:90) > at org.teiid.netty.handler.codec.serialization.ObjectEncoderOutputStream.writeObjectOverride(ObjectEncoderOutputStream.java:65) > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:326) > at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.write(OioOjbectChannelFactory.java:130) > at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:173) > ... 14 more > But if we give less number of data in that param, e.g. 100x375, it works fine. > Thanks. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2748) Ensure pushdown of multisource column expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2748?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2748. --------------------------------- > Ensure pushdown of multisource column expressions > ------------------------------------------------- > > Key: TEIID-2748 > URL: https://issues.jboss.org/browse/TEIID-2748 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Labels: 8.6.0.CR1 > Fix For: 8.6 > > > > The issue is that the criteria is not making it into the proper position for the multisource logic to have an effect. It is implicit that multisource required a translator that supported equality comparison at least. In this case adding the xpathValue function, because of weaknesses with the detection of a fully evaluatable, is then inhibiting the proper placement. That last one is easy to fix and I can ensure that more complex cases are covered as well. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2708) DataRolePolicyDecider configuration

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2708?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2708. --------------------------------- > DataRolePolicyDecider configuration > ----------------------------------- > > Key: TEIID-2708 > URL: https://issues.jboss.org/browse/TEIID-2708 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > In the conversion over to AS 7 the bean properties for DataRolePolicyDecider were not added to the configuration. More than likely this was because the bean itself is pluggable. > We either need to add these properties to the configuration or add an alternative mechanism for setting them (system and/or vdb properties would probably be just fine). -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2773) MATVIEW corrupted after SYSADMIN.refreshMatView()

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2773?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2773. --------------------------------- > MATVIEW corrupted after SYSADMIN.refreshMatView() > ------------------------------------------------- > > Key: TEIID-2773 > URL: https://issues.jboss.org/browse/TEIID-2773 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine, Server > Affects Versions: 7.7.5 > Environment: EDS 5.3.1 > Reporter: Hisanobu Okuda > Assignee: Steven Hawkins > Fix For: 7.7.9 > > > After CALL SYSADMIN.refreshMatView(viewname=>TABLE_NAME, invalidate=>false) against Materialized View, querying "select * from TABLE_NAME", one of columns shows a value of another column. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2731) Add an option to perform stable sorts

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2731?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2731. --------------------------------- > Add an option to perform stable sorts > ------------------------------------- > > Key: TEIID-2731 > URL: https://issues.jboss.org/browse/TEIID-2731 > Project: Teiid > Issue Type: Quality Risk > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > Related to TEIID-2429, we allow for sorts to reverse the initial working buffer. Although stable sorts are not required by the spec., it may be desired. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2014