June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4260) Accumulo: Resource adapter fails to load

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4260?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4260: ------------------------------------- Yes, I will pull it. > Accumulo: Resource adapter fails to load > ---------------------------------------- > > Key: TEIID-4260 > URL: https://issues.jboss.org/browse/TEIID-4260 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.0, 8.13.x > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0 > > > "org/apache/commons/configuration" module seemed to be removed, this needs to be corrected. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4260) Accumulo: Resource adapter fails to load

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4260?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4260: --------------------------------------- Do you want this in 8.13.x as well? > Accumulo: Resource adapter fails to load > ---------------------------------------- > > Key: TEIID-4260 > URL: https://issues.jboss.org/browse/TEIID-4260 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.0, 8.13.x > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0 > > > "org/apache/commons/configuration" module seemed to be removed, this needs to be corrected. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4260) Accumulo: Resource adapter fails to load

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4260?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4260. --------------------------------- Fix Version/s: 9.0 Resolution: Done added missing "commons-configuration" dependency into the modules directory > Accumulo: Resource adapter fails to load > ---------------------------------------- > > Key: TEIID-4260 > URL: https://issues.jboss.org/browse/TEIID-4260 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.0, 8.13.x > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0 > > > "org/apache/commons/configuration" module seemed to be removed, this needs to be corrected. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4260) Accumulo: Resource adapter fails to load

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4260?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-4260: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > Accumulo: Resource adapter fails to load > ---------------------------------------- > > Key: TEIID-4260 > URL: https://issues.jboss.org/browse/TEIID-4260 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.0, 8.13.x > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > > "org/apache/commons/configuration" module seemed to be removed, this needs to be corrected. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4258) Cannot connect to Teiid if server runs on JVM 1.6

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4258?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4258: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1343956|https://bugzilla.redhat.com/show_bug.cgi?id=1343956] from NEW to MODIFIED > Cannot connect to Teiid if server runs on JVM 1.6 > ------------------------------------------------- > > Key: TEIID-4258 > URL: https://issues.jboss.org/browse/TEIID-4258 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.5 > Environment: JVM 1.6 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.12.5 > > > If Teiid runs on JVM 1.6. connection fails with EOFException \[1\] > \[1\] Exception thrown (used squirrel client) > {code:plain} > java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:206) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104) > ... 5 more > Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) > at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66) > at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107) > at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55) > at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167) > ... 7 more > Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161) > at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95) > at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316) > at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64) > ... 11 more > Caused by: java.io.EOFException > at java.io.DataInputStream.readInt(DataInputStream.java:392) > at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365) > at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117) > at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128) > at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96) > at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277) > at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239) > at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125) > ... 14 more > {code} > I have tried several combinations: > |client|server|result| > |JVM 1.6| JVM 1.6|fail| > |JVM 1.8| JVM 1.6|fail| > |JVM 1.6| JVM 1.8|OK| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4258) Cannot connect to Teiid if server runs on JVM 1.6

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4258?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4258. ----------------------------------- Fix Version/s: 8.12.5 Resolution: Done The issue was with a change in how the host name is determined the method is not accessible in 1.6, but is in 1.7+. Added a catch block and additional logging. > Cannot connect to Teiid if server runs on JVM 1.6 > ------------------------------------------------- > > Key: TEIID-4258 > URL: https://issues.jboss.org/browse/TEIID-4258 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.5 > Environment: JVM 1.6 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.12.5 > > > If Teiid runs on JVM 1.6. connection fails with EOFException \[1\] > \[1\] Exception thrown (used squirrel client) > {code:plain} > java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:206) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104) > ... 5 more > Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) > at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66) > at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107) > at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55) > at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167) > ... 7 more > Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161) > at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95) > at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316) > at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64) > ... 11 more > Caused by: java.io.EOFException > at java.io.DataInputStream.readInt(DataInputStream.java:392) > at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365) > at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117) > at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128) > at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96) > at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277) > at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239) > at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125) > ... 14 more > {code} > I have tried several combinations: > |client|server|result| > |JVM 1.6| JVM 1.6|fail| > |JVM 1.8| JVM 1.6|fail| > |JVM 1.6| JVM 1.8|OK| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3929) Accumulo does not return null values

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3929?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3929: ------------------------------------- [~jstastny] Did you update Teiid libraries in Accumulo's lib directory after the last update? > Accumulo does not return null values > ------------------------------------ > > Key: TEIID-3929 > URL: https://issues.jboss.org/browse/TEIID-3929 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.3 > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Accumulo doesn't return null values when a whole 'column' is being selected. > For a command in accumulo shell like: > {code:plain} > scan -c name:BYTENUM > {code} > Accumulo returns only non-empty values, this is expected behaviour. > Equivalent query in Teiid would be: > {code:sql} > SELECT ByteNum FROM SmallA > {code} > Which returns the same results as Accumulo does. That means, no NULL values, if there are rowids without specified column families/qualifiers missing. But when a user has his schema defined in a vdb, he probably expects, that he will get as many rows as there are in the table. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4237) INNER JOIN returns incorrect results

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4237?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4237: --------------------------------- Fix Version/s: 8.7.7.6_2 > INNER JOIN returns incorrect results > ------------------------------------ > > Key: TEIID-4237 > URL: https://issues.jboss.org/browse/TEIID-4237 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.7.6, 8.12.5, 8.7.7.6_2, 8.13.5 > > > Running the following query: > {code:sql} > select avg(t1.a) from > (select 3 as a, 3 as b union all > select 1 as a, 1 as b union all > select 3 as a, 3 as b) as t1 > join (select 1 as a, 1 as b union all > select 1 as a, 1 as b union all > select 2 as a, 2 as b union all > select 2 as a, 2 as b union all > select 3 as a, 3 as b union all > select 3 as a, 3 as b) as t2 on t1.a=t2.a > {code} > on teiid causes incorrect result: 2 in comparing with mysql which returns 2.333. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4192) If a column is blank the TEXTAGG function excludes it from the output

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4192?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4192: --------------------------------- Fix Version/s: 8.7.7.6_2 > If a column is blank the TEXTAGG function excludes it from the output > ---------------------------------------------------------------------- > > Key: TEIID-4192 > URL: https://issues.jboss.org/browse/TEIID-4192 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.5.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.7.7.6_2, 8.13.5 > > > If a column value is blank, it is excluding it in the result, causing incorrect output. > TEXTAGG(FOR Last_Name, > First_Name, > Middle_initial, > Currency_Code > DELIMITER '|' QUOTE '"' > ) > In the above example, if middle name is blank, then it should still show one empty column with "|" delimiter as shown below. > Steigner|Debbie||USD > But it returns output as excluding middle name since it is blank. > Steigner|Debbie|USD -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4192) If a column is blank the TEXTAGG function excludes it from the output

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4192?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4192: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1333514|https://bugzilla.redhat.com/show_bug.cgi?id=1333514] from NEW to MODIFIED > If a column is blank the TEXTAGG function excludes it from the output > ---------------------------------------------------------------------- > > Key: TEIID-4192 > URL: https://issues.jboss.org/browse/TEIID-4192 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.5.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.5 > > > If a column value is blank, it is excluding it in the result, causing incorrect output. > TEXTAGG(FOR Last_Name, > First_Name, > Middle_initial, > Currency_Code > DELIMITER '|' QUOTE '"' > ) > In the above example, if middle name is blank, then it should still show one empty column with "|" delimiter as shown below. > Steigner|Debbie||USD > But it returns output as excluding middle name since it is blank. > Steigner|Debbie|USD -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016