October 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3130) NPE in excel translator if xlsx file is missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3130?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3130. --------------------------------- > NPE in excel translator if xlsx file is missing > ----------------------------------------------- > > Key: TEIID-3130 > URL: https://issues.jboss.org/browse/TEIID-3130 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: OS: fedora20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > Attachments: NPE_missing_excel_file.zip > > > If xlsx file, which is pointed by resource adater & source model (in VDB) is missing, then any query ends with NPE. > Actual result: NullPointerException > Expected result: some better message or exception (e.g. FileNotFoundException or some TeiidException with good mesage) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3113) Incorrect parent name for child to parent query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3113?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3113. --------------------------------- > Incorrect parent name for child to parent query > ----------------------------------------------- > > Key: TEIID-3113 > URL: https://issues.jboss.org/browse/TEIID-3113 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > The parent relationship is named based upon the foreign key column which typically is [Some Object]Id, but can be ParentId, etc. which need for example Parent rather than the object name in the source query. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3106) BufferManager Cleaner consuming 90% of total CPU time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3106?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3106. --------------------------------- > BufferManager Cleaner consuming 90% of total CPU time > ----------------------------------------------------- > > Key: TEIID-3106 > URL: https://issues.jboss.org/browse/TEIID-3106 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Environment: zOS > Reporter: Devesh Mishra > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > Attachments: BufferManagerImpl.java, BufferManagerImpl.java, CacheKey_Loog.patch, complete_log.zip, cpu monitoring.docx, dump.zip, in_local.docx, LrfuEvictionQueue.java, LrfuEvictionQueue.patch, non_high_cpu.docx > > > BufferManager Cleaner thread is consuming almost all of the CPU utilized by the jboss process. Thread dump shows following information. > 3XMTHREADINFO "BufferManager Cleaner" J9VMThread:0x0000004C41CFEB00, j9thread_t:0x0000004C52B85AE0, java/lang/Thread:0x000000481C036E20, state:CW, prio=5 > 3XMJAVALTHREAD (java/lang/Thread getId:0x76, isDaemon:true) > 3XMTHREADINFO1 (native thread ID:0x3AEC2600, native priority:0x5, native policy:UNKNOWN) > 3XMHEAPALLOC Heap bytes allocated since last GC cycle=2609184 (0x27D020) > 3XMTHREADINFO3 Java callstack: > 4XESTACKTRACE at java/util/concurrent/ConcurrentSkipListMap.doRemove(ConcurrentSkipListMap.java:1070(Compiled Code)) > 4XESTACKTRACE at java/util/concurrent/ConcurrentSkipListMap.remove(ConcurrentSkipListMap.java:1659(Compiled Code)) > 4XESTACKTRACE at org/teiid/common/buffer/impl/LrfuEvictionQueue.remove(LrfuEvictionQueue.java:60(Compiled Code)) > 4XESTACKTRACE at org/teiid/common/buffer/impl/BufferManagerImpl.doEvictions(BufferManagerImpl.java:854(Compiled Code)) > 5XESTACKTRACE (entered lock: org/teiid/common/buffer/CacheEntry@0x00000048393C2598, entry count: 1) > 4XESTACKTRACE at org/teiid/common/buffer/impl/BufferManagerImpl$Cleaner.run(BufferManagerImpl.java:108) > 4XESTACKTRACE at java/util/TimerThread.mainLoop(Timer.java:555) > 4XESTACKTRACE at java/util/TimerThread.run(Timer.java:505) > When we added log statements around the BufferManagerImpl.doEvictions() it loops through the remove and firstEntry loop. > Forum discussion link : https://community.jboss.org/message/901792 -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2787) Correlated grouping expression not properly replaced in pushdown subquery

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2787?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2787. --------------------------------- > Correlated grouping expression not properly replaced in pushdown subquery > ------------------------------------------------------------------------- > > Key: TEIID-2787 > URL: https://issues.jboss.org/browse/TEIID-2787 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7 > > > A correlated grouping expression appears in the pushdown query with the internal group name anon_grpX rather than the proper reference from the outer query. > For example the user query: > select x, (select avg\(y) from tbl1 where x = tbl2.x) from tbl2 group by x > would have > where x = anon_grp0.x -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2949) Issue querying Google Spreadsheet

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2949?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2949. --------------------------------- > Issue querying Google Spreadsheet > --------------------------------- > > Key: TEIID-2949 > URL: https://issues.jboss.org/browse/TEIID-2949 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Issue querying google spreadsheet: > Steps to Reproduce: > 1. configure resource adaptor for google in standalone.xml > <resource-adapter id="google"> > <module slot="main" id="org.jboss.teiid.resource-adapter.google"/> > <transaction-support>NoTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google"> > <config-property name="AuthMethod"> > ClientLogin > </config-property> > <config-property name="SpreadsheetName"> > testsheet > </config-property> > <config-property name="BatchSize"> > 4096 > </config-property> > <config-property name="Username"> > hokuda.test(a)gmail.com > </config-property> > <config-property name="Password"> > passpassw > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > 2. deploy dynamic vdb > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="test" version="1"> > <description>Dynamic Google Spreadsheet VDB</description> > <model name="google"> > <source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/> > </model> > </vdb> > 3. you get an exception > 16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas > on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti > ng batch 404:Not Found > at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat > aProtocolAPI.java:248) > at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat > aProtocolAPI.java:163) > at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109) > at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7 > 4) > at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147) > at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71) > at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45) > at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red > hat-7.jar:8.4.1-redhat-7] > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1 > -redhat-7.jar:8.4.1-redhat-7] > at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7] > at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7] > at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) > at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806) > at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) > at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826) > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45] > at org.jboss.threads.JBossThread.run(JBossThread.java:122) > Here's a reference to the google issue that's causing our issue: > https://code.google.com/p/google-visualization-api-issues/issues/detail?i... -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3049) odbc still commits with disableLocalTxn

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3049?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3049. --------------------------------- > odbc still commits with disableLocalTxn > --------------------------------------- > > Key: TEIID-3049 > URL: https://issues.jboss.org/browse/TEIID-3049 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9, 7.7.11 > > > With TEIID-2945 disableLocalTxn is now valid against odbc, but it is using an asynch invocation to commit which is not aware of disableLocalTxn which results in an exception that a transaction for the given session cannot be found. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3143) LOOP on UNION leads to java.lang.ClassCastException

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3143?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3143. --------------------------------- > LOOP on UNION leads to java.lang.ClassCastException > --------------------------------------------------- > > Key: TEIID-3143 > URL: https://issues.jboss.org/browse/TEIID-3143 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Alex K. > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > the following query > > {code:sql} > begin > LOOP ON ( > select a > FROM schema.table > union > select b > FROM schema.table > ) as cur > begin > end > end > {code} > results in this exception (Teiid-8.9.0-Beta-1) on my machine > > {code:java} > ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) H10b/QbWzo4K TEIID30019 Unexpected exception forrequest H10b/QbWzo4K.6: java.lang.ClassCastException: org.teiid.query.sql.lang.SetQuery cannot be casttoorg.teiid.query.sql.lang.Query > at org.teiid.query.sql.proc.LoopStatement.clone(LoopStatement.java:136) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.query.sql.LanguageObject$Util.deepClone(LanguageObject.java:57) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.query.sql.proc.Block.clone(Block.java:147) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.query.sql.proc.CreateProcedureCommand.clone(CreateProcedureCommand.java:116) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:377) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.Request.processRequest(Request.java:437) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:609) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51] > atjava.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51] > {code} -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2790) Add more options for costing during import

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2790?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2790. --------------------------------- > Add more options for costing during import > ------------------------------------------ > > Key: TEIID-2790 > URL: https://issues.jboss.org/browse/TEIID-2790 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector, Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7 > > > With many jdbc sources full cardinality is reported from the index info for non statistical indexes (such as mysql). This should be used to set the cardinality of the table. Failing that there should be an option to use an aggregate call or other source stats. > This is not quite the same as TEIID-245 as it's happening at import time, but the two do overlap. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2363) proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)"

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2363?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2363. --------------------------------- > proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)" > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-2363 > URL: https://issues.jboss.org/browse/TEIID-2363 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.4, 7.7.7 > > > The issue here is this is an outer join and the inner side (the already sorted side) will be buffered regardless. Current logic does not catch blocked exceptions from one side and pro-actively buffer the other - rather we are serially performing the sort and then continue with the loading of the inner side > For inner joins there is a clear trade-off between execution speed and buffering so this behavior may have to be hint or config driven for non-dependent non-outer joins. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3165) TeiidDataSource ignores jassName

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3165?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3165. --------------------------------- > TeiidDataSource ignores jassName > -------------------------------- > > Key: TEIID-3165 > URL: https://issues.jboss.org/browse/TEIID-3165 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > I am trying to connect to VDB through Kerberos authentication using TeiidDataSource: > TeiidDataSource tds = new TeiidDataSource(); > tds.setServerName("localhost"); > tds.setPortNumber(31000); > tds.setDatabaseName(<vdb>); > tds.setJaasName(<jassName>); > tds.setKerberosServicePrincipleName(<principalName>); > but tds.getConnection(); ends with: > TEIID20005 Client URL connection property missing "jaasName". Please add the property to connection URL > Connection through TeiidDriver works fine: > url: jdbc:teiid:<vdb>@mm://<host>:31000;jaasName=<jassName>;kerberosServicePrincipleName=<principalName> -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 5 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 October 2014