[JBoss JIRA] (TEIID-2442) Blocking during with clause processing has adverse affects
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2442?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2442.
-----------------------------------
Resolution: Done
The temptable datamanager will catch unexpected blocks and return a tuplesource that may throw blocked exceptions at a later time.
> Blocking during with clause processing has adverse affects
> ----------------------------------------------------------
>
> Key: TEIID-2442
> URL: https://issues.jboss.org/browse/TEIID-2442
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.1
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 8.4
>
>
> A blocked exception, such that is typically thrown while waiting for results, that happens during the with clause load will cause the parent command to be rexecuted. This can lead to erroneous source queries and eventually exhaust connections.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2442) Blocking during with clause processing has adverse affects
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2442:
-------------------------------------
Summary: Blocking during with clause processing has adverse affects
Key: TEIID-2442
URL: https://issues.jboss.org/browse/TEIID-2442
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 8.4
A blocked exception, such that is typically thrown while waiting for results, that happens during the with clause load will cause the parent command to be rexecuted. This can lead to erroneous source queries and eventually exhaust connections.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2429) Large sort performance
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2429?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2429.
-----------------------------------
Resolution: Done
changed the overhead handling and improved the copy into memory from file. also switched to a more accurate and foolproof tracking of reservations via the commandcontext (ideally we'll move away from the threadlocal later but that would have been significantly more changes). updated the release notes.
local testing shows a significant increase in performance for truly large sorts (those making use of disk). however a significant amount of testing will be needed and there is a degredation in performance of smaller primary/secondary cache only sorts - this is something that may still need to be addressed as under heavy load the old strategy did not proactively persist batches enough, but under light load with the new logic we persist batches too quickly (generally this means that the cleaner is running all the time and we specifically two eviction queues in the buffer manager).
also added reverse iteration during the initial sorting phase to better purge/retrieve batches from cache - however this means that larger sorts will not quite be in the same order (not stable). this is allowed by the spec, but we'll have to see if the apparent performance gain warrents a behavioral change.
> Large sort performance
> ----------------------
>
> Key: TEIID-2429
> URL: https://issues.jboss.org/browse/TEIID-2429
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Affects Versions: 7.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4
>
>
> Large sorts (high data volume over above several hundred thousand rows) experience a disproportionate performance degradation as the data set grows larger.
> This is due to the SortUtility default collection strategy that will create intermediate sort buffers too proactively.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2440) Unable to create JDBC connection to Teiid 8.3 Final from Designer
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIID-2440?page=com.atlassian.jira.plugin... ]
Paul Richardson commented on TEIID-2440:
----------------------------------------
This has been confirmed as a problem with designer's version of the teiid 8.3.x code. However, it does demonstrate a brittleness in teiid's code in its reliance on version number:
* Teiid uses a version value in the handshake communication with the server;
* The version is gleaned from the application.properties file, which starts out in the source version as ${project.version};
* In the build version, maven replaces this variable with the version of teiid, ie. 8.3.0.Final;
* Designer's eclipse build never did this substitution since it was never required. Consequently, the plugin version sends the value '${project.version}' to the server in the handshake;
* The version is used for determining whether to wrap message contents in a SealedObject;
* If the version is less than 8.3 then SealedObject is used;
* The odd thing is that version is also gleaned from a serialized handshake object and this
correctly sets the client version to 8.3.0.Final. Consequently, although the client version is set correctly the server version is set to '${project.version} and as a result the client sends messages without SealedObject but the server returns messages wrapped in SealedObjects, leading to the observed ClassCastException.
* Designer has modified the properties file by filling in the correct values rather than relying on variables.
* Maybe consider avoiding the use of version variables in the code and instead prefer to remove SealedObject message wrapping entirely. If the server is older and does return SealedObject messages then simply test the class of the message content and unseal accordingly. Difficult to see the benefit of keeping such code in the client/server if it is effectively deprecated.
> Unable to create JDBC connection to Teiid 8.3 Final from Designer
> -----------------------------------------------------------------
>
> Key: TEIID-2440
> URL: https://issues.jboss.org/browse/TEIID-2440
> Project: Teiid
> Issue Type: Bug
> Reporter: Barry LaFond
> Assignee: Steven Hawkins
>
> Upgraded Teiid designer to 8.3 Final bits
> Tried to Preview a table and received following exception:
> !ENTRY org.teiid.designer.dqp.ui 4 0 2013-03-19 11:33:24.518
> !MESSAGE javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> !STACK 0
> java.lang.ClassCastException: javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> at sun.proxy.$Proxy27.logon(Unknown Source)
> at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:173)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
> at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:92)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:1)
> at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:83)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
> at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
> at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)
> at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
> at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:621)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:398)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:263)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2440) Unable to create JDBC connection to Teiid 8.3 Final from Designer
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2440?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2440:
---------------------------------------
Yes, this should either be an issue with your classloading (the client for example could be using the wrong build info properties and is reporting itself as an older client) or you are using a 8.3 pre-release version of the server.
> Unable to create JDBC connection to Teiid 8.3 Final from Designer
> -----------------------------------------------------------------
>
> Key: TEIID-2440
> URL: https://issues.jboss.org/browse/TEIID-2440
> Project: Teiid
> Issue Type: Bug
> Reporter: Barry LaFond
> Assignee: Steven Hawkins
>
> Upgraded Teiid designer to 8.3 Final bits
> Tried to Preview a table and received following exception:
> !ENTRY org.teiid.designer.dqp.ui 4 0 2013-03-19 11:33:24.518
> !MESSAGE javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> !STACK 0
> java.lang.ClassCastException: javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> at sun.proxy.$Proxy27.logon(Unknown Source)
> at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:173)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
> at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:92)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:1)
> at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:83)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
> at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
> at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)
> at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
> at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:621)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:398)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:263)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2440) Unable to create JDBC connection to Teiid 8.3 Final from Designer
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2440?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2440:
-------------------------------------
If you can connect from SquirreL, then what assertion that you make that the issue in the Teiid? Did your debugging reveal anything? I believe this may be due to some eclipse classloading.
> Unable to create JDBC connection to Teiid 8.3 Final from Designer
> -----------------------------------------------------------------
>
> Key: TEIID-2440
> URL: https://issues.jboss.org/browse/TEIID-2440
> Project: Teiid
> Issue Type: Bug
> Reporter: Barry LaFond
> Assignee: Steven Hawkins
>
> Upgraded Teiid designer to 8.3 Final bits
> Tried to Preview a table and received following exception:
> !ENTRY org.teiid.designer.dqp.ui 4 0 2013-03-19 11:33:24.518
> !MESSAGE javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> !STACK 0
> java.lang.ClassCastException: javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> at sun.proxy.$Proxy27.logon(Unknown Source)
> at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:173)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
> at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:92)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:1)
> at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:83)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
> at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
> at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)
> at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
> at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:621)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:398)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:263)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2440) Unable to create JDBC connection to Teiid 8.3 Final from Designer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIID-2440?page=com.atlassian.jira.plugin... ]
Barry LaFond commented on TEIID-2440:
-------------------------------------
* The VDB deployment is fine
* Can connect to Teiid and VDB via SQuirrel using Teiid 8.3 Final jdbc jar
> Unable to create JDBC connection to Teiid 8.3 Final from Designer
> -----------------------------------------------------------------
>
> Key: TEIID-2440
> URL: https://issues.jboss.org/browse/TEIID-2440
> Project: Teiid
> Issue Type: Bug
> Reporter: Barry LaFond
> Assignee: Steven Hawkins
>
> Upgraded Teiid designer to 8.3 Final bits
> Tried to Preview a table and received following exception:
> !ENTRY org.teiid.designer.dqp.ui 4 0 2013-03-19 11:33:24.518
> !MESSAGE javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> !STACK 0
> java.lang.ClassCastException: javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
> at sun.proxy.$Proxy27.logon(Unknown Source)
> at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:173)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
> at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:92)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:1)
> at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:83)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
> at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
> at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
> at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)
> at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
> at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:621)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:398)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:263)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2440) Unable to create JDBC connection to Teiid 8.3 Final from Designer
by Barry LaFond (JIRA)
Barry LaFond created TEIID-2440:
-----------------------------------
Summary: Unable to create JDBC connection to Teiid 8.3 Final from Designer
Key: TEIID-2440
URL: https://issues.jboss.org/browse/TEIID-2440
Project: Teiid
Issue Type: Bug
Reporter: Barry LaFond
Assignee: Steven Hawkins
Upgraded Teiid designer to 8.3 Final bits
Tried to Preview a table and received following exception:
!ENTRY org.teiid.designer.dqp.ui 4 0 2013-03-19 11:33:24.518
!MESSAGE javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
!STACK 0
java.lang.ClassCastException: javax.crypto.SealedObject cannot be cast to org.teiid.client.security.LogonResult
at sun.proxy.$Proxy27.logon(Unknown Source)
at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:173)
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:92)
at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:1)
at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:83)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:621)
at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:398)
at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:263)
at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2439) jdbc socket transport support in teiid embedded mode
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2439?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2439:
----------------------------------
Assignee: (was: Steven Hawkins)
Fix Version/s: (was: 8.4)
As Ramesh says, remote JDBC is not too compelling for the original envisioning of embedded. For completeness of TEIID-2416 remote access primarily via odbc makes sense, which is basically the same effort as exposing remote jdbc.
> jdbc socket transport support in teiid embedded mode
> ----------------------------------------------------
>
> Key: TEIID-2439
> URL: https://issues.jboss.org/browse/TEIID-2439
> Project: Teiid
> Issue Type: Feature Request
> Components: Embedded
> Reporter: Himanshu Kapoor
> Fix For: Open To Community
>
>
> As a teiid embedded user there must be JDBC socket transport in embedded mode so that external java application (outside the application server in which teiid embedded has been hosted) can connect to the vdb's using the teiid jdbc driver and can perform operation on it.
> This feature will really help the teiid embedded users to start using this feature in enterprises level applications .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months