[JBoss JIRA] (TEIID-2706) Cache hint for resultset cache in user query doesn't work
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2706?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2706.
---------------------------------
> Cache hint for resultset cache in user query doesn't work
> ---------------------------------------------------------
>
> Key: TEIID-2706
> URL: https://issues.jboss.org/browse/TEIID-2706
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
…
[View More]> Affects Versions: 7.7.7
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> I enabled TRACE logging and Command Logging to see if the Resultset Cache was being used on my queries. If I use the ResultSetCacheMode=true on connection string you can see Teiid using the cache instead of pulling from source again:
> This is displayed the first time the query is run, it's loading the Cache:
> 2013-10-18 07:17:52,951 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> This displays the subsequent times the same query is run and you will not see source queries:
> 2013-10-18 07:19:21,115 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> But if I remove the connection string and just try using the Cache Hint /*+ cache*/ you see nothing in the logs in regards to the Cache loading or being used on the second query, you still see Teiid pulling the results from the source.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
11 years, 4 months
[JBoss JIRA] (TEIID-2566) standalone-teiid.xml and the CLI scripts point to different caches in the teiid subsystem
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2566?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2566.
---------------------------------
> standalone-teiid.xml and the CLI scripts point to different caches in the teiid subsystem
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-2566
> URL: https://issues.jboss.org/browse/TEIID-2566
> Project: Teiid
> …
[View More] Issue Type: Quality Risk
> Components: Build/Kits
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Minor
> Fix For: 8.4.1, 8.5
>
>
> In the standalone-teiid.xml configuration, teiid subsystem:
> <resultset-cache infinispan-container="teiid" name="resultset"/>
> <preparedplan-cache infinispan-container="teiid" name="preparedplan"/>
> In the CLI script, it contains the following:
> /subsystem=teiid:add(async-thread-pool=teiid-async, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
> and looks like the following when loaded:
> <resultset-cache infinispan-container="teiid-cache"/>
> <preparedplan-cache infinispan-container="teiid-cache"/>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
11 years, 4 months
[JBoss JIRA] (TEIID-2744) Windows 2008 ODBC Driver works but throwing exceptions on Teiid Server
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2744?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2744.
---------------------------------
> Windows 2008 ODBC Driver works but throwing exceptions on Teiid Server
> ----------------------------------------------------------------------
>
> Key: TEIID-2744
> URL: https://issues.jboss.org/browse/TEIID-2744
> Project: Teiid
> Issue Type: Bug
> …
[View More]Components: ODBC
> Affects Versions: 8.4.1
> Environment: Windows 2008
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Blocker
>
> When running ODBC driver on windows, the querying works but weird WARNinig is showed in the server console.
> The warning message:
> 03:31:58,965 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue5) TEIID30020 Processing exception for request xS0DtHsdmG7n.9 'TEIID31100 Parsing error: Encountered "('\"customer\"' AS [*]regclass[*])" at line 1, column 106.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...'. Originally QueryParserException QueryParser.java:215. Enable more detailed logging to see the entire stacktrace.
> See BZ for more details.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
11 years, 4 months
[JBoss JIRA] (TEIID-2592) Parsing error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2592?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2592.
---------------------------------
> Parsing error
> -------------
>
> Key: TEIID-2592
> URL: https://issues.jboss.org/browse/TEIID-2592
> Project: Teiid
> Issue Type: Bug
> Environment: psql (8.4.13, server 8.1.4)
> Reporter: Simon Green
> Assignee: Steven …
[View More]Hawkins
>
> Using EngVDBR, I tried the following query, and received an error
> EngVDBR=> SELECT name FROM Bugzilla.products WHERE classification_id = 5 AND id NOT IN (SELECT product_id FROM Bugzilla.milestones WHERE value != '---');ERROR: Parsing error: Encountered "SELECT product_id FROM Bugzilla.milestones WHERE value" at line 1, column 79.
> However, the following query worked as expected:
> SELECT name FROM Bugzilla.products WHERE classification_id = 5 AND id NOT IN (SELECT product_id FROM Bugzilla.milestones WHERE milestones.value != '---');
> The first query is valid, and thus I think it is a bug in TEIID.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
11 years, 4 months