[JBoss JIRA] Resolved: (TEIID-114) Execs of xml procedures cannot be used as correlated scalar subqueries
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-114?page=com.atlassian.jira.plugin.... ]
Steven Hawkins resolved TEIID-114.
----------------------------------
Resolution: Out of Date
Tested in 7.4 successfully and added TestXMLProcessor.testProcedureAndXML1
> Execs of xml procedures cannot be used as correlated scalar subqueries
> ----------------------------------------------------------------------
>
> Key: TEIID-114
> URL: https://issues.jboss.…
[View More]org/browse/TEIID-114
> Project: Teiid
> Issue Type: Bug
> Components: XML Planner/Processor
> Affects Versions: 6.0.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Optional
>
> Defect Tracker #24364: attempted to run select (exec BooksInfo.getXMLBooksByEdition(edition)) result from booksinfo.booksinfo from the e2e audiobooks and received the following error:
> java.lang.NullPointerException
> at com.metamatrix.query.processor.xml.RelationalPlanExecutor.<init>(RelationalPlanExecutor.java:67)
> at com.metamatrix.query.processor.xml.XMLProcessorEnvironment.createResultExecutor(XMLProcessorEnvironment.java:213)
> at com.metamatrix.query.processor.xml.ExecSqlInstruction.process(ExecSqlInstruction.java:35)
> at com.metamatrix.query.processor.xml.XMLPlan.getNextXMLChunk(XMLPlan.java:320)
> at com.metamatrix.query.processor.xml.XMLPlan.processXML(XMLPlan.java:256)
> at com.metamatrix.query.processor.xml.XMLPlan.nextBatch(XMLPlan.java:187)
> at com.metamatrix.query.processor.relational.SubqueryProcessorUtility.process(SubqueryProcessorUtility.java:231)
> at com.metamatrix.query.processor.relational.DependentProjectNode.prepareToProcessTuple(DependentProjectNode.java:96)
> at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:200)
> at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:244)
> at com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:143)
> at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:194)
> at com.metamatrix.dqp.internal.process.ProcessWorker.processDirect(ProcessWorker.java:159)
> at com.metamatrix.dqp.internal.process.ProcessWorker.process(ProcessWorker.java:89)
> at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years
[JBoss JIRA] Reopened: (TEIID-114) Execs of xml procedures cannot be used as correlated scalar subqueries
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-114?page=com.atlassian.jira.plugin.... ]
Steven Hawkins reopened TEIID-114:
----------------------------------
Assignee: Steven Hawkins
reopening to make as properly resolved
> Execs of xml procedures cannot be used as correlated scalar subqueries
> ----------------------------------------------------------------------
>
> Key: TEIID-114
> URL: https://issues.jboss.org/browse/TEIID-114
> …
[View More] Project: Teiid
> Issue Type: Bug
> Components: XML Planner/Processor
> Affects Versions: 9.x
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Optional
> Fix For: 8.0
>
>
> Defect Tracker #24364: attempted to run select (exec BooksInfo.getXMLBooksByEdition(edition)) result from booksinfo.booksinfo from the e2e audiobooks and received the following error:
> java.lang.NullPointerException
> at com.metamatrix.query.processor.xml.RelationalPlanExecutor.<init>(RelationalPlanExecutor.java:67)
> at com.metamatrix.query.processor.xml.XMLProcessorEnvironment.createResultExecutor(XMLProcessorEnvironment.java:213)
> at com.metamatrix.query.processor.xml.ExecSqlInstruction.process(ExecSqlInstruction.java:35)
> at com.metamatrix.query.processor.xml.XMLPlan.getNextXMLChunk(XMLPlan.java:320)
> at com.metamatrix.query.processor.xml.XMLPlan.processXML(XMLPlan.java:256)
> at com.metamatrix.query.processor.xml.XMLPlan.nextBatch(XMLPlan.java:187)
> at com.metamatrix.query.processor.relational.SubqueryProcessorUtility.process(SubqueryProcessorUtility.java:231)
> at com.metamatrix.query.processor.relational.DependentProjectNode.prepareToProcessTuple(DependentProjectNode.java:96)
> at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:200)
> at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:244)
> at com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:143)
> at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:194)
> at com.metamatrix.dqp.internal.process.ProcessWorker.processDirect(ProcessWorker.java:159)
> at com.metamatrix.dqp.internal.process.ProcessWorker.process(ProcessWorker.java:89)
> at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years
[JBoss JIRA] Resolved: (TEIID-239) ENHANCEMENT: Costing beyond cardinality sould be propogated
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-239?page=com.atlassian.jira.plugin.... ]
Steven Hawkins resolved TEIID-239.
----------------------------------
Labels: costing (was: )
Assignee: Steven Hawkins
Fix Version/s: 7.4
(was: 8.0)
Resolution: Done
Added logic to also set the column value estimates on each node. This will improve set query and aggregate costing, but did not yet improve ndv nnv updates with joins.
> ENHANCEMENT: …
[View More]Costing beyond cardinality sould be propogated
> -----------------------------------------------------------
>
> Key: TEIID-239
> URL: https://issues.jboss.org/browse/TEIID-239
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 6.0.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Minor
> Labels: costing
> Fix For: 7.4
>
>
> Defect Tracker #24037: Currently values for ndv and nnv are recalculated at each plan node based upon the value at the physical layer. This is not a good estimate. Instead, these values should be propagated through the plan just like the cardinality and adjusted appropriately for join, unions, etc. It may also be good to allow the use of costing metadata on virtual layers.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years
[JBoss JIRA] Closed: (TEIID-1392) Memory leak in Teiid
by Pavel Macik (JIRA)
[ https://issues.jboss.org/browse/TEIID-1392?page=com.atlassian.jira.plugin... ]
Pavel Macik closed TEIID-1392.
------------------------------
> Memory leak in Teiid
> --------------------
>
> Key: TEIID-1392
> URL: https://issues.jboss.org/browse/TEIID-1392
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.1.1
> Reporter: Pavel Macik
> …
[View More]Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 7.1.1
>
> Attachments: 510ER5-eds_long_select_100t-overview.jps, eds-qs.zip
>
>
> To reproduce:
> 1.) unzip eds-qs.zip into ${SOA-P}/jboss-as/samples/quickstarts/ directory
> 2.) copy/move ${EDS-QS}/build.properties-example to ${EDS-QS}/build.properties
> 3.) the QS deploys a VDB with 2 Oracle10g datasources (you can configure (via build.properties) both to the same DB instance)
> 4.) start the server up
> 5.) using JDBC with following configuration send following SQL:
> JDBC:
> - URL: jdbc:teiid:perf@mm://${soa-p bind address}:31000
> - driver: org.teiid.jdbc.TeiidDriver
> - username/password: according to ${SOA-P}/jboss-as/server/${profile}/conf/props/teiid-security-users.properties
> SQL:
> select * from perf.long.persons where person_id < 100
> With server max heap set to 3G the GC caused by the leak affects the server after cca 150k iterations
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years
[JBoss JIRA] Created: (TEIID-1501) Incorrect rewrite of not disjunctive criteria
by Van Halbert (JIRA)
Incorrect rewrite of not disjunctive criteria
----------------------------------------------
Key: TEIID-1501
URL: https://issues.jboss.org/browse/TEIID-1501
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 7.4
The rewrite of a condition such as "not((a or b) AND c)" …
[View More]with a,b,c predicates where c a is predicate that is negatable, such as col1 = 1. The result should have the negated form of col1 <> 1, but instead has col1 = 1. This is because the col1 = 1 predicate is repeated in the result, but not cloned and the rewriter modifies the same instance.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years, 1 month
[JBoss JIRA] Created: (TEIID-1500) StackOverflowError in DefaultCache
by Van Halbert (JIRA)
StackOverflowError in DefaultCache
----------------------------------
Key: TEIID-1500
URL: https://issues.jboss.org/browse/TEIID-1500
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.2
Environment: Windows & Linux
Reporter: Mark Addleman
Assignee: Steven Hawkins
Priority: Critical
Fix For: 7.4
Intermittently, we get the stack overflow …
[View More]error. It doesn't seem to be related to the query.
java.lang.StackOverflowError
at org.teiid.cache.DefaultCache.remove(DefaultCache.java:164)
at org.teiid.cache.DefaultCache.validate(DefaultCache.java:119)
at org.teiid.cache.DefaultCache.access$000(DefaultCache.java:36)
at org.teiid.cache.DefaultCache$1.removeEldestEntry(DefaultCache.java:86)
at java.util.LinkedHashMap.putImpl(LinkedHashMap.java:411)
at java.util.LinkedHashMap.put(LinkedHashMap.java:370)
at org.teiid.cache.DefaultCache.remove(DefaultCache.java:164)
at org.teiid.cache.DefaultCache.validate(DefaultCache.java:119)
at org.teiid.cache.DefaultCache.access$000(DefaultCache.java:36)
at org.teiid.cache.DefaultCache$1.removeEldestEntry(DefaultCache.java:86)
at java.util.LinkedHashMap.putImpl(LinkedHashMap.java:411)
at java.util.LinkedHashMap.put(LinkedHashMap.java:370)
at org.teiid.cache.DefaultCache.remove(DefaultCache.java:164)
at org.teiid.cache.DefaultCache.validate(DefaultCache.java:119)
at org.teiid.cache.DefaultCache.access$000(DefaultCache.java:36)
at org.teiid.cache.DefaultCache$1.removeEldestEntry(DefaultCache.java:86)
at java.util.LinkedHashMap.putImpl(LinkedHashMap.java:411)
at java.util.LinkedHashMap.put(LinkedHashMap.java:370)
at org.teiid.cache.DefaultCache.remove(DefaultCache.java:164)
at org.teiid.cache.DefaultCache.validate(DefaultCache.java:119)
at org.teiid.cache.DefaultCache.access$000(DefaultCache.java:36)
at org.teiid.cache.DefaultCache$1.removeEldestEntry(DefaultCache.java:86)
at java.util.LinkedHashMap.putImpl(LinkedHashMap.java:411)
at java.util.LinkedHashMap.put(LinkedHashMap.java:370)
at org.teiid.cache.DefaultCache.remove(DefaultCache.java:164)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years, 1 month
[JBoss JIRA] Created: (TEIID-1499) Teiid assumes fqns in transformations, but they are no longer required to be there
by Van Halbert (JIRA)
Teiid assumes fqns in transformations, but they are no longer required to be there
----------------------------------------------------------------------------------
Key: TEIID-1499
URL: https://issues.jboss.org/browse/TEIID-1499
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
…
[View More]Fix For: 7.4
It looks like with the uuid refactoring we no long maintain that the designer indexed transformations will contain only fully qualified group names.
This will cause a good deal of problems at runtime as partially qualified names are subject to visibility rules and can conflict with session level tables.
I would prefer to address this on the teiid though better metadata logic, rather than requiring fqns in transformation queries.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years, 1 month
[JBoss JIRA] Commented: (TEIID-1488) EDS adminshell fails to connect to server with IBM JDK
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1488?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1488:
---------------------------------------
We would need to do some vm detection logic like (TrustManagerFactory.getInstance("IbmX509", "IBMJSSE2")) and it seems like that code would require us to have a dummy truststore (to init the TrustStoreManagerFactory against).
I'm not sure that it's worth it given the workarounds.
> EDS adminshell fails to connect to server …
[View More]with IBM JDK
> ------------------------------------------------------
>
> Key: TEIID-1488
> URL: https://issues.jboss.org/browse/TEIID-1488
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER7 build
> java -version
> java version "1.6.0"
> Java(TM) SE Runtime Environment (build pxi3260sr8-20100409_01(SR8))
> IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr8-20100401_55940 (JIT enabled, AOT enabled)
> J9VM - 20100401_055940
> JIT - r9_20100401_15339
> GC - 20100308_AA)
> JCL - 20100408_01
> uname -a
> Linux soa3.qa.atl2.redhat.com 2.6.18-128.4.1.el5 #1 SMP Thu Jul 23 19:59:17 EDT 2009 i686 athlon i386 GNU/Linux
> Reporter: Len DiMaggio
> Labels: ibm-jvm, ssl
> Fix For: 7.4
>
>
> export JAVA_HOME=/opt/ibm-java-i386-60/jre
> export PATH=/opt/ibm-java-i386-60/jre/bin/:$PATH
> sh ./adminshell.sh
> ======================================================================
> Teiid AdminShell Bootstrap Environment
> TEIID_HOME = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell
> CLASSPATH = /qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/patches/*:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/teiid-adminshell-7.1.1.jar:/qa/hudson_ws/workspace/teiidAdminShell/BITS/PLATFORM/jdk/openjdk-local/label/RHEL5_x86/jbosssoa/eds/teiid/adminshell/lib/*
> JAVA = /opt/ibm-java-i386-60/jre/bin/java
> ======================================================================
> ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;]
> Groovy Shell (1.7.2, JVM: 1.6.0)
> Type 'help' or '\h' for help.
> ------------------------------------------------------------------------------------------------------------------------------------------
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "testing")
> ERROR java.lang.AssertionError:
> Assertion failed.
> at org.teiid.core.util.Assertion.failed (Assertion.java:73)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:68)
> at org.teiid.core.util.Assertion.assertTrue (Assertion.java:60)
> at org.teiid.net.socket.SocketUtil.addCipherSuite (SocketUtil.java:135)
> at org.teiid.net.socket.SocketUtil$SSLSocketFactory.getSocket (SocketUtil.java:85)
> at org.teiid.net.socket.OioOjbectChannelFactory.createObjectChannel (OioOjbectChannelFactory.java:165)
> at org.teiid.net.socket.SocketServerInstanceImpl.connect (SocketServerInstanceImpl.java:91)
> at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance (SocketServerConnectionFactory.java:276)
> at org.teiid.net.socket.SocketServerConnection.connect (SocketServerConnection.java:172)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance (SocketServerConnection.java:124)
> at org.teiid.net.socket.SocketServerConnection.<init> (SocketServerConnection.java:94)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:312)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection (SocketServerConnectionFactory.java:71)
> at org.teiid.adminapi.AdminFactory$AdminProxy.<init> (AdminFactory.java:53)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:159)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:149)
> at org.teiid.adminapi.AdminFactory.createAdmin (AdminFactory.java:120)
> at org.teiid.adminshell.AdminShell.connectAsAdmin (AdminShell.java:71)
> at org.teiid.adminshell.AdminShell$connectAsAdmin.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
> ...
> groovy:000>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
14 years, 1 month