July 2017 - teiid-issues - Jboss List Archives

[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: ------------------------------------ There appears to be an issue with the registering of descriptors, getting this error: 11:12:29,091 ERROR [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue1507) D7RRxtVf8ezY Connector worker process failed for atomic-request=D7RRxtVf8ezY.6.3.676: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for messageId=1489 returned server error (status=0x85): java.lang.IllegalArgumentException: Message descriptor not found : StockJDGSource.ST_StockCache at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:363) at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:152) at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:138) at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:60) at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:68) at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:30) at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:56) at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:68) at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:53) at org.teiid.translator.infinispan.hotrod.InfinispanResponse.fetchNextBatch(InfinispanResponse.java:70) at org.teiid.translator.infinispan.hotrod.InfinispanResponse.getNextRow(InfinispanResponse.java:86) at org.teiid.translator.infinispan.hotrod.InfinispanQueryExecution.next(InfinispanQueryExecution.java:130) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:431) [^jdg-mat-cache-vdb.xml] attached is the vdb. > 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4982) Wrong exception thrown getDataSource()

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4982?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4982. --------------------------------- Fix Version/s: 10.0 Assignee: Ramesh Reddy (was: Steven Hawkins) Resolution: Done Labels: Alpha2 (was: ) Removed the duplicate message in the i18n.properties file > Wrong exception thrown getDataSource() > -------------------------------------- > > Key: TEIID-4982 > URL: https://issues.jboss.org/browse/TEIID-4982 > Project: Teiid > Issue Type: Bug > Components: AdminApi > Affects Versions: 9.3 > Reporter: Lukáš Svačina > Assignee: Ramesh Reddy > Priority: Trivial > Labels: Alpha2 > Fix For: 10.0 > > > getDataSource(string) throws: > org.teiid.adminapi.AdminProcessingException: TEIID70008 Data Source with name NotExistingOne still exists in the system. > instead of something like "datasource not exists / not found" > Method: AdminFactory.AdminImpl#getDataSource -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 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: ------------------------------- Attachment: jdg-mat-cache-vdb.xml > 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4985) Update Quickstart to use new columns in status table

by Van Halbert (JIRA)

Van Halbert created TEIID-4985: ---------------------------------- Summary: Update Quickstart to use new columns in status table Key: TEIID-4985 URL: https://issues.jboss.org/browse/TEIID-4985 Project: Teiid Issue Type: Enhancement Components: Quick Starts Affects Versions: 9.3.1 Reporter: Van Halbert Assignee: Van Halbert The status table had new columns added (eg., NodeName and StaleCount), the quickstart needs to be updated. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4971) Infinispan Hotrod can't access remote instance

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4971?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-4971: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Infinispan Hotrod can't access remote instance > ---------------------------------------------- > > Key: TEIID-4971 > URL: https://issues.jboss.org/browse/TEIID-4971 > Project: Teiid > Issue Type: Bug > Components: Infinispan, JDG Connector > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Van Halbert > Priority: Blocker > > The Infinispan Hotrod connector writes to jdg's internal cache, which can't be accessed from remote hosts if the cache container is not secured and the user accessing the internal cache doesn't have specific privileges. > User can't authenticate via resource-adapter currently, enhancement TEIID-4904 is needed. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4971) Infinispan Hotrod can't access remote instance

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4971?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-4971: ---------------------------------- Assignee: Steven Hawkins (was: Van Halbert) > Infinispan Hotrod can't access remote instance > ---------------------------------------------- > > Key: TEIID-4971 > URL: https://issues.jboss.org/browse/TEIID-4971 > Project: Teiid > Issue Type: Bug > Components: Infinispan, JDG Connector > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Priority: Blocker > > The Infinispan Hotrod connector writes to jdg's internal cache, which can't be accessed from remote hosts if the cache container is not secured and the user accessing the internal cache doesn't have specific privileges. > User can't authenticate via resource-adapter currently, enhancement TEIID-4904 is needed. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4984) Support for netezza pushdown functions

by Kulbhushan Chaskar (JIRA)

[ https://issues.jboss.org/browse/TEIID-4984?page=com.atlassian.jira.plugin... ] Kulbhushan Chaskar updated TEIID-4984: -------------------------------------- Description: More information is available on link https://developer.jboss.org/thread/275445 Affects: User Experience > Support for netezza pushdown functions > -------------------------------------- > > Key: TEIID-4984 > URL: https://issues.jboss.org/browse/TEIID-4984 > Project: Teiid > Issue Type: Enhancement > Components: AdminApi, JDBC Connector > Affects Versions: 9.1.3 > Reporter: Kulbhushan Chaskar > Assignee: Steven Hawkins > > More information is available on link > https://developer.jboss.org/thread/275445 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4984) Support for netezza pushdown functions

by Kulbhushan Chaskar (JIRA)

Kulbhushan Chaskar created TEIID-4984: ----------------------------------------- Summary: Support for netezza pushdown functions Key: TEIID-4984 URL: https://issues.jboss.org/browse/TEIID-4984 Project: Teiid Issue Type: Enhancement Components: AdminApi, JDBC Connector Affects Versions: 9.1.3 Reporter: Kulbhushan Chaskar Assignee: Steven Hawkins -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

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

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4977: ------------------------------------- [~vhalbert2] See attached file for the example materialization that matches with the pre 9.3 methods with use of staging tables. You would need 3 different kinds of caches for this solution to work similar to previous JDG based example, but note the approach may be different entirely. You need 3 caches * MV (materializing for cached table, this name can be anything) * ST (staging per cached table, this name can be anything) * teiid-alias-naming-cache (cluster wide internal cache to keep track of aliased tables, must match the name, create as _replicated_ cache. This can be pre-configured with any Teiid deployment and keep user based configuration simple. When you enable "DirectQueryProcedure", the translator will start looking for "teiid-alias-naming-cache". If this cache is available then the aliased table feature will kick in. Also, when "DirectQueryProcedure" is enabled, there are two commands supported through this mechnisam * truncate <full-qualified-table-name> ==> clears the whole cache * swap <from-table> <to-table> ==> swaps the tables from from 2 to, to 2 from An example VDB attached, can take look and test it, and give me feedback. Also, I will let you document this for 6.4 > 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 > > > 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, 2 months

1
0
0 / 0

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

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4977: -------------------------------- Attachment: ispn-vdb.xml > 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 > > > 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, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2017