[JBoss JIRA] (TEIID-3983) External Materialization MATVIEW_ONERROR_ACTION WAIT problem
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3983?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reassigned TEIID-3983:
-----------------------------------
Assignee: Ramesh Reddy (was: Steven Hawkins)
> External Materialization MATVIEW_ONERROR_ACTION WAIT problem
> ------------------------------------------------------------
>
> Key: TEIID-3983
> URL: https://issues.jboss.org/browse/TEIID-3983
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.5
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
>
> When using "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT' option in materialized view definition, there's problem with blocked request.
> The blocked request is the one, that triggered the materialized view's loading (first query on the defined materialized view). After such request, one can observe, that the query execution doesn't end, but hangs.
> Meanwhile while examining the contents of 'status' table in the underlying database, the LoadNumber column's value increases regularly according to the defined ttl. Moreover the 'LOADSTATE' column changes from LOADING to LOADED in similar manner. The materialized table is populated with correct data. From this I assume, materialization is set up correctly.
> During the wait, when logging set to DEBUG, there appears regularly, apart from the logs about refreshing the mat view, this entry:
> {code:plain}
> [32m09:14:52,151 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2695) Request Thread 87XzBpSzkyk4.0 with state PROCESSING
> [32m09:14:52,151 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2695) Request Thread 87XzBpSzkyk4.0 - processor blocked
> {code}
> The log appears in 'ttl' determined intervals, each time after materialized table loading related entries.
> The thread mentioned is the one created after the original query execution was initiated.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-3925) Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3925?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3925:
----------------------------------
Issue Type: Quality Risk (was: Enhancement)
Priority: Major (was: Minor)
Affects Version/s: 9.0
(was: 9.x)
> Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
> ----------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3925
> URL: https://issues.jboss.org/browse/TEIID-3925
> Project: Teiid
> Issue Type: Quality Risk
> Components: Misc. Connectors
> Affects Versions: 9.0
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Currently, the infinispan translators and resource adapters are named:
> - translator-infinispan-cache (infinispan-cache) / connector-infinispan.6
> - translator-infinispan-dsl (infinispan-cache-dsl) / connector-infinispan-dsl
> Suggested rename to be done in version 9 to align with infinispan 7:
> - translator-infinispan-library-mode (infinispan-library-mode) / connector-infinispan-library-mode.7
> - translator-infinispan-remote-cache (infinispan-remote-cache / connector-infinispan-remote-cache.7
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-3599) Excel translator and dynamic filenames
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3599?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reassigned TEIID-3599:
-----------------------------------
Assignee: Ramesh Reddy
> Excel translator and dynamic filenames
> --------------------------------------
>
> Key: TEIID-3599
> URL: https://issues.jboss.org/browse/TEIID-3599
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: Ralph Martin Black
> Assignee: Ramesh Reddy
> Priority: Minor
> Fix For: Open To Community
>
>
> Hi all,
> All samples I've reached on how to setup a connection to xls files, set up file names as properties in the source model:
> ...
> <property name="importer.ExcelFileName" value="names.xls"/>
> ...
> Is there any way to specify filenames dynamically at run-time?
> Best regards
> MB!
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-3925) Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3925?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3925:
-------------------------------------
Ideally IMO we need to do this early on 9.x cycle
> Rename infinispan translators / resources adapters to align with running library mode versus access remote cache
> ----------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3925
> URL: https://issues.jboss.org/browse/TEIID-3925
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 9.x
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Minor
>
> Currently, the infinispan translators and resource adapters are named:
> - translator-infinispan-cache (infinispan-cache) / connector-infinispan.6
> - translator-infinispan-dsl (infinispan-cache-dsl) / connector-infinispan-dsl
> Suggested rename to be done in version 9 to align with infinispan 7:
> - translator-infinispan-library-mode (infinispan-library-mode) / connector-infinispan-library-mode.7
> - translator-infinispan-remote-cache (infinispan-remote-cache / connector-infinispan-remote-cache.7
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIID-3608) Add a translator for memcached
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3608?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-3608:
--------------------------------
Fix Version/s: Open To Community
(was: 9.x)
> Add a translator for memcached
> ------------------------------
>
> Key: TEIID-3608
> URL: https://issues.jboss.org/browse/TEIID-3608
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Kylin Soong
> Fix For: Open To Community
>
>
> memcached can be thought as a standard in Cache area, there are lots of product support memcached, like:
> * Infinispan/JBoss Data Grid
> * Redis
> * Oracle Coherence
> * Cassandra
> * ...
> If we have a memcached translator, it will more flexible in intergrate/transfer data from cache product.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months