October 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3404) Teiid DatabaseAppender JPA perisist Command log consume high CPU

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3404?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3404. --------------------------------- > Teiid DatabaseAppender JPA perisist Command log consume high CPU > ---------------------------------------------------------------- > > Key: TEIID-3404 > URL: https://issues.jboss.org/browse/TEIID-3404 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.7.1 > Environment: * DV 6.1 > * dynamicvdb-datafederation quickstart > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.7.2, 8.11 > > > I have 4 - 5 concurrent client query to Portfolio VDB, this cause log DatabaseAppender JPA perisist Command log thread consume high CPU. In my test, one log threads always swallow high CPU, if the concurrent client query more than 10, it swallow 100% cpu. > [1] have detailed reproduce steps, including thread dumps. > [1] https://github.com/kylinsoong/teiid-samples/tree/master/command-logging-h... -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3557) Can't reload VDB in domain mode

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3557?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3557. --------------------------------- > Can't reload VDB in domain mode > ------------------------------- > > Key: TEIID-3557 > URL: https://issues.jboss.org/browse/TEIID-3557 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.0 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.7.1.6_2, 8.12, 8.11.1 > > > Can't reload VDB in domain mode, get the following error: > Server throws the following exception: > [Server:server-one] 12:26:45,678 ERROR [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl@4e6c9a30: java.lang.IllegalStateException: cluster 'ModeShape.1' is already connected to singleton transport: [dummy-1435055090515, loopback.1, ModeShape.1, loopback-dynamic.1, $TEIID_BM$, dummy-1435055090188, dummy-1435055205654, $TEIID_ED$, teiid-cache, ddl2-vdb.1] > [Server:server-one] at org.jgroups.stack.ProtocolStack.startStack(ProtocolStack.java:919) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1] > [Server:server-one] at org.jgroups.JChannel.startStack(JChannel.java:827) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1] > [Server:server-one] at org.jgroups.JChannel._preConnect(JChannel.java:525) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1] > [Server:server-one] at org.jgroups.JChannel.connect(JChannel.java:277) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1] > [Server:server-one] at org.jgroups.JChannel.connect(JChannel.java:268) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1] > [Server:server-one] at org.teiid.replication.jgroups.JGroupsObjectReplicator.replicate(JGroupsObjectReplicator.java:563) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.deployers.CompositeGlobalTableStore.createInstance(CompositeGlobalTableStore.java:57) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.jboss.VDBService$1.finishedDeployment(VDBService.java:156) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:352) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:308) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.jboss.VDBService.access$1100(VDBService.java:85) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.jboss.VDBService$6.run(VDBService.java:411) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2] > [Server:server-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25] > [Server:server-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25] > [Server:server-one] at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25] > [Server:server-one] at org.jboss.threads.JBossThread.run(JBossThread.java:122) > VDB reload works fine in standalone mode. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4407) Salesforce delete/update without a predicate does nothing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4407?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4407. --------------------------------- > Salesforce delete/update without a predicate does nothing > --------------------------------------------------------- > > Key: TEIID-4407 > URL: https://issues.jboss.org/browse/TEIID-4407 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.1, 8.13.7, 9.0.4 > > > An update or a delete without a where clause will not do anything as the logic to fetch ids will only happen when there are predicates. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4502) Remove references to deprecated UseConnectorMetadata in docs/examples

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4502?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4502. --------------------------------- > Remove references to deprecated UseConnectorMetadata in docs/examples > --------------------------------------------------------------------- > > Key: TEIID-4502 > URL: https://issues.jboss.org/browse/TEIID-4502 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > There are still lingering references to UseConnectorMetadata that should be replaced with the relevant usage of cache-metadata -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4384) Issue with ordered offset

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4384?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4384. --------------------------------- > Issue with ordered offset > ------------------------- > > Key: TEIID-4384 > URL: https://issues.jboss.org/browse/TEIID-4384 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.1, 9.0.3 > > > There is a regression with TEIID-4210 such that when an order by is not pushed and there is a parent offset (no limit), the wrong rows are returned. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4424) Error when factory overrides initCapabilities due WrappedConnection is what Teiid is passing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4424?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4424. --------------------------------- > Error when factory overrides initCapabilities due WrappedConnection is what Teiid is passing > -------------------------------------------------------------------------------------------- > > Key: TEIID-4424 > URL: https://issues.jboss.org/browse/TEIID-4424 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.1, 9.0.4 > > > The infinispan hotrod translator factory class is trying to override initCapabililties(Connection) but is seeing the following error on the server: > 20:34:22,861 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue5) zLiKTbTSLJkH TEIID30019 Unexpected exception for request zLiKTbTSLJkH.0: java.lang.ClassCastException: org.teiid.resource.spi.WrappedConnection cannot be cast to org.teiid.translator.object.ObjectConnection > at org.teiid.translator.infinispan.hotrod.InfinispanHotRodExecutionFactory.initCapabilities(InfinispanHotRodExecutionFactory.java:53) > at org.teiid.dqp.internal.datamgr.ConnectorManager.buildCapabilities(ConnectorManager.java:186) > at org.teiid.dqp.internal.datamgr.ConnectorManager.getCapabilities(ConnectorManager.java:163) > at org.teiid.dqp.internal.process.CachedFinder.findCapabilities(CachedFinder.java:108) -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3818) Issues with ODBC metadata foreign key queries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3818?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3818. --------------------------------- > Issues with ODBC metadata foreign key queries > --------------------------------------------- > > Key: TEIID-3818 > URL: https://issues.jboss.org/browse/TEIID-3818 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Environment: Most likely not OS / hardware dependent. > Reporter: Dave Nicodemus > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.7.2.6_2, 8.12.2, 8.13, 8.7.6 > > > The current foreign key handling should return imported key, but instead returns exported keys. > When exported keys are asked for an exception is thrown: > While attempting to use Client Microsoft's Power BI desktop using ODBC connecting to Teiid Embedded server using VDB with metadata tags. > Received the following errors : > {code} > [36.864]ERROR from backend during send_query: 'SERROR' > [36.865]ERROR from backend during send_query: 'C50000' > [36.869]ERROR from backend during send_query: 'MTEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [36.875]ERROR from backend during send_query: 'Dorg.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [37.397]STATEMENT ERROR: func=PGAPI_ForeignKeys, desc='', errnum=1, errmsg='PGAPI_ForeignKeys query error' > {code} > Due to this query being generated by the BI tool : > {code} > 'select 'ScottTestMart'::name as PKTABLE_CAT, > n2.nspname as PKTABLE_SCHEM, > c2.relname as PKTABLE_NAME, > a2.attname as PKCOLUMN_NAME, > 'ScottTestMart'::name as FKTABLE_CAT, > n1.nspname as FKTABLE_SCHEM, > c1.relname as FKTABLE_NAME, > a1.attname as FKCOLUMN_NAME, > i::int2 as KEY_SEQ, > case ref.confupdtype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as UPDATE_RULE, > case ref.confdeltype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as DELETE_RULE, > ref.conname as FK_NAME, > cn.conname as PK_NAME, > case > when ref.condeferrable then > case > when ref.condeferred then 5::int2 > else 6::int2 > end > else 7::int2 > end as DEFERRABLITY > from > ((((((( (select cn.oid, conrelid, conkey, confrelid, confkey, > generate_series(array_lower(conkey, 1), array_upper(conkey, 1)) as i, > confupdtype, confdeltype, conname, > condeferrable, condeferred > from pg_catalog.pg_constraint cn, > pg_catalog.pg_class c, > pg_catalog.pg_namespace n > where contype = 'f' > and confrelid = c.oid > and relname = 'Categories' > and n.oid = c.relnamespace > and n.nspname = 'ScottTestMart' > ) ref > inner join pg_catalog.pg_class c1 > on c1.oid = ref.conrelid) > inner join pg_catalog.pg_namespace n1 > on n1.oid = c1.relnamespace) > inner join pg_catalog.pg_attribute a1 > on a1.attrelid = c1.oid > and a1.attnum = conkey[i]) > inner join pg_catalog.pg_class c2 > on c2.oid = ref.confrelid) > inner join pg_catalog.pg_namespace n2 > on n2.oid = c2.relnamespace) > inner join pg_catalog.pg_attribute a2 > on a2.attrelid = c2.oid > and a2.attnum = confkey[i]) > left outer join pg_catalog.pg_constraint cn > on cn.conrelid = ref.confrelid > and cn.contype = 'p') > order by ref.oid, ref.i' > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4017. --------------------------------- > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.7.6, 8.12.5, 8.13.2, 8.7.5.6_2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3978) Remove AddressWrapper

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3978?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3978. --------------------------------- > Remove AddressWrapper > --------------------- > > Key: TEIID-3978 > URL: https://issues.jboss.org/browse/TEIID-3978 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.0, 8.12.5, 8.13.2, 8.7.5.6_2 > > > AddressWrapper was introduced to handle an earlier jgroups version where address objects were not directly serializable. However the deserialization code is using the thread context class loader which is not guaranteed to have the JGroups classes in the classpath. The resulting exception (where the original exception is simply swallowed) looks like: > {code} > 2016-02-16 08:45:30,140 ERROR [Incoming-1,shared=tcp-teiid-1] org.teiid.replication.jgroups.JGroupsObjectReplicator$ReplicatorRpcDispatcher - exception marshalling object > java.lang.IllegalStateException: unread block data > at java.io.ObjectInputStream$BlockDataInputStream.setBlockDataMode(ObjectInputStream.java:2421) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1382) > at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1706) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1344) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370) > at org.jgroups.blocks.MethodCall.readExternal(MethodCall.java:430) > at java.io.ObjectInputStream.readExternalData(ObjectInputStream.java:1837) > at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1796) > at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370) > at org.teiid.replication.jgroups.JGroupsObjectReplicator$ContextAwareMarshaller.objectFromBuffer(JGroupsObjectReplicator.java:611) > at org.teiid.replication.jgroups.JGroupsObjectReplicator$ReplicatorRpcDispatcher.handle(JGroupsObjectReplicator.java:106) > at org.jgroups.blocks.RequestCorrelator.handleRequest(RequestCorrelator.java:484) > at org.jgroups.blocks.RequestCorrelator.receiveMessage(RequestCorrelator.java:391) > at org.jgroups.blocks.RequestCorrelator.receive(RequestCorrelator.java:249) > at org.jgroups.blocks.MessageDispatcher$ProtocolAdapter.up(MessageDispatcher.java:600) > at org.jgroups.JChannel.up(JChannel.java:707) > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4399) Remove $levels restrictions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4399?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4399. --------------------------------- > Remove $levels restrictions > --------------------------- > > Key: TEIID-4399 > URL: https://issues.jboss.org/browse/TEIID-4399 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 9.1 > > > Once https://issues.apache.org/jira/browse/OLINGO-1009 is addressed the ODataSQLBuilder restrictions for OLINGO-1009 in the processExpandOption should be removed. Also additional unit tests will be needed. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2016