October 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5425) Concurrency/timing issues observed with travis builds

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5425?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5425: --------------------------------------- #1, 2, 4 - are still issues. 1. Not easily reproduced. Implies we are not sufficiently locking/synchronizing in the odbc logic. 2. It's apparently possible for the loadcount to restart at 1. I haven't see seen why this is possible. 4. Seems to be more related to networking issues in the travis environment rather than a code problem. > Concurrency/timing issues observed with travis builds > ----------------------------------------------------- > > Key: TEIID-5425 > URL: https://issues.jboss.org/browse/TEIID-5425 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Several unit tests have been observed to fail during travis builds occasionally: > 1. TestODBCSocketTransport.testRegClass:757 Â» PSQL ResultSet not positioned prope... > 2. TestExternalMatViews.testLazyUpdate:930 expected:<2> but was:<1> (see https://api.travis-ci.org/v3/job/405801976/log.txt) > 3. [ERROR] TestLocalConnections.testWaitForLoadTimeout:475 > 4. From https://api.travis-ci.org/v3/job/415138409/log.txt > [ERROR] testReplication(org.teiid.systemmodel.TestReplication) Time elapsed: 35.21 s <<< FAILURE! > java.lang.AssertionError: expected:<0.9164140964242746> but was:<0.18750528722359294> > at org.teiid.systemmodel.TestReplication.testReplication(TestReplication.java:122) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5481) Evaluate JSONPATH as expression language for Json payload to table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5481: ---------------------------------- Fix Version/s: 11.x > Evaluate JSONPATH as expression language for Json payload to table > ------------------------------------------------------------------ > > Key: TEIID-5481 > URL: https://issues.jboss.org/browse/TEIID-5481 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 11.x > > > Currently in Teiid in order to turn a JSON document to a relational structure, JSONTOXML function is used then XPATH used on it to retrieve data using XMLTABLE. > Investigate the feasibility of using JSONPATH [1] directly on JSON document to build a JSONTABLE construct. > [1] https://code.google.com/archive/p/json-path/ -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5478) Add engine support for nth_value

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5478?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5478. ----------------------------------- Resolution: Done Updated the logic to pass in the frame information to the aggregate computation to get the value. This could be generalized to the others, such as lead/lag. > Add engine support for nth_value > -------------------------------- > > Key: TEIID-5478 > URL: https://issues.jboss.org/browse/TEIID-5478 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.2 > > > Due to TEIID-5475 engine support for nth_value was removed. It should be added back with frame clause support. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5485) JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments fails

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-5485?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-5485: --------------------------------- Fix Version/s: 8.12.16.6_4 > JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments fails > -------------------------------------------------------------------------------------------------------------- > > Key: TEIID-5485 > URL: https://issues.jboss.org/browse/TEIID-5485 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 11.1 > Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 11.2, 11.0.3, 10.3.5, 8.12.16.6_4, 11.1.2 > > > JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments, like: > {code:sql} > SELECT t2.i > FROM ( > SELECT DISTINCT 1 a, b from test_tables_pg.test_x) t1, > table(CALL "views.pr"(arg => t1.a) > ) sub > JOIN test_tables_pg.test_y t2 ON true ;; > {code} > fails with the following stack trace: > {code:noformat} > 2018-09-25 17:47:15,024 ERROR [org.teiid.TRANSPORT] (NIO1) TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core > .TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.Boolean". Please ensure that the column's modeled datatype matc > hes the expected data. > at org.teiid.transport.ObjectEncoder.write(ObjectEncoder.java:132) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite0(AbstractChannelHandlerContext.java:738) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:730) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:816) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:723) > at io.netty.channel.ChannelDuplexHandler.write(ChannelDuplexHandler.java:106) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite0(AbstractChannelHandlerContext.java:738) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:730) > at io.netty.channel.AbstractChannelHandlerContext.access$1900(AbstractChannelHandlerContext.java:38) > at io.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.write(AbstractChannelHandlerContext.java:1089) > at io.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.run(AbstractChannelHandlerContext.java:1078) > at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:163) > at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:403) > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:442) > at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.Boolean". Please ensure that the colum > n's modeled datatype matches the expected data. > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:874) > at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:315) > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459) > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430) > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178) > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348) > at org.teiid.net.socket.Message.writeExternal(Message.java:57) > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459) > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430) > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178) > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348) > at org.teiid.transport.ObjectEncoder.write(ObjectEncoder.java:112) > ... 15 more > Caused by: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.lang.Integer > at org.teiid.client.BatchSerializer$IntColumnSerializer.writeObject(BatchSerializer.java:559) > at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:530) > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:863) > ... 26 more > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5444) Upgrade to Olingo-4.5

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-5444?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-5444: --------------------------------- Fix Version/s: 8.12.16.6_4 > Upgrade to Olingo-4.5 > --------------------- > > Key: TEIID-5444 > URL: https://issues.jboss.org/browse/TEIID-5444 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 11.1, 8.12.16.6_4 > > > Upgrade the olingo library to latest 4.5 version -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5478) Add engine support for nth_value

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5478?page=com.atlassian.jira.plugin... ] Work on TEIID-5478 started by Steven Hawkins. --------------------------------------------- > Add engine support for nth_value > -------------------------------- > > Key: TEIID-5478 > URL: https://issues.jboss.org/browse/TEIID-5478 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.2 > > > Due to TEIID-5475 engine support for nth_value was removed. It should be added back with frame clause support. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2018