July 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4983) Couchbase tests rely on unpredictable order

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4983?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4983. ----------------------------------- Resolution: Done Adding sorting of the attributes and creation of json in the expected results. > Couchbase tests rely on unpredictable order > ------------------------------------------- > > Key: TEIID-4983 > URL: https://issues.jboss.org/browse/TEIID-4983 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0, 8.12.x-6.4 > > > The insert tests and others have metadata built off of json which depending upon the jre may return elements in a different order. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-4977 at 7/11/17 8:30 AM: ------------------------------------------------------------- Changing to using only the clustered configuration fixed the issue. The clarification on the syntax order and the changes to clear the cache. Testing looks good. Also tested scaling JDG down to zero and restarting, multiple times. Materialization restarted, as expected, and querying continued without having to reconnect. was (Author: van.halbert): Changing to using only the clustered configuration fixed the issue. The clarification on the syntax order and the changes to clear the cache. Testing looks good. > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan, Quick Starts > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.12.x-6.4, 9.3.2 > > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4977: ------------------------------------ Changing to using only the clustered configuration fixed the issue. The clarification on the syntax order and the changes to clear the cache. Testing looks good. > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.12.x-6.4, 9.3.2 > > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4977: ------------------------------- Component/s: Quick Starts > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan, Quick Starts > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.12.x-6.4, 9.3.2 > > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4977: ------------------------------- Fix Version/s: 8.12.x-6.4 9.3.2 > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.12.x-6.4, 9.3.2 > > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4977: ------------------------------------ Regarding the 'renaming' process, when the cache names are swapped, the 'ST' cache is cleared. Immediately reducing the total memory footprint in JDG/infinispan. > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-4977 at 7/11/17 7:59 AM: ------------------------------------------------------------- Format for -vdb.xml for the BEFORE and AFTER: {code} "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {modelname}.native(''truncate {modelName}.{ST}'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {modelname}native(''rename {modelName}.{ST} {modelName}.{MV}'');', {code} Example: {code} "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute StockJDGSource.native(''rename StockJDGSource.ST_StockCache StockJDGSource.StockCache'');', {code} was (Author: van.halbert): Format for -vdb.xml for the BEFORE and AFTER: {code} "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {modelname}.native(''truncate {modelName}.{stagingCacheName}'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {modelname}native(''rename {modelName}.{materializedCacheName} {modelName}.{stagingCacheName}'');', {code} Example: {code} "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute StockJDGSource.native(''rename StockJDGSource.StockCache StockJDGSource.ST_StockCache'');', {code} > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-4977 at 7/11/17 7:57 AM: ------------------------------------------------------------- The issue was resolved by change JDG to use the clustered configuration with the following caches: {code} <replicated-cache name="teiid-alias-naming-cache" configuration="replicated"/> <distributed-cache name="stockCache" /> <distributed-cache name="st_stockCache" /> {code} Since all use cases will be based on clustering, the use of JDG/infinispan in standalone will no longer be considered. was (Author: van.halbert): The issue was resolved by change JDG to use the clustered configuration with the following caches: {code} <replicated-cache name="teiid-alias-naming-cache" configuration="replicated"/> <distributed-cache name="memcachedCache"/> <distributed-cache name="stockCache" /> <distributed-cache name="st_stockCache" /> {code} Since all use cases will be based on clustering, the use of JDG/infinispan in standalone will no longer be considered. > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4977: ------------------------------------ Format for -vdb.xml for the BEFORE and AFTER: {code} "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {modelname}.native(''truncate {modelName}.{stagingCacheName}'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {modelname}native(''rename {modelName}.{materializedCacheName} {modelName}.{stagingCacheName}'');', {code} Example: {code} "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute StockJDGSource.native(''rename StockJDGSource.StockCache StockJDGSource.ST_StockCache'');', {code} > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4977: ------------------------------------ The issue was resolved by change JDG to use the clustered configuration with the following caches: {code} <replicated-cache name="teiid-alias-naming-cache" configuration="replicated"/> <distributed-cache name="memcachedCache"/> <distributed-cache name="stockCache" /> <distributed-cache name="st_stockCache" /> {code} Since all use cases will be based on clustering, the use of JDG/infinispan in standalone will no longer be considered. > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 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 July 2017