[JBoss JIRA] (TEIID-4303) Insert into temporary table fails
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIID-4303?page=com.atlassian.jira.plugin... ]
Bram Gadeyne commented on TEIID-4303:
-------------------------------------
I can confirm that the same code did run without a problem on 8.11.3.
> Insert into temporary table fails
> ---------------------------------
>
> Key: TEIID-4303
> URL: https://issues.jboss.org/browse/TEIID-4303
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.0
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Attachments: debugplan.txt
>
>
> When executing a insert query in a temporary table the execution fails with the following error:
> 2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed execution
> 2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed connection
> 2016-06-28 08:54:35,700 DEBUG [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END SRC COMMAND: endTime=2016-06-28 08:54:35.7 requestID=3bZw8VxEr4t7.26 sourceCommandID=4 executionID=30 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > modelName=iziswh translatorName=sybase sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security finalRowCount=21504 cpuTime(ns)=120503397
> 2016-06-28 08:54:35,701 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ERROR USER COMMAND: endTime=2016-06-28 08:54:35.701 requestID=3bZw8VxEr4t7.26 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=null
> 2016-06-28 08:54:35,701 WARN [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 TEIID30020 Processing exception for request 3bZw8VxEr4t7.26 'TEIID30223 javax.transaction.RollbackException: ARJUNA016083: Can't register synchronization because the transaction is in aborted state'. Originally TeiidProcessingException TransactionImple.java:396. Enable more detailed logging to see the entire stacktrace.
> 2016-06-28 08:54:35,701 WARN [com.arjuna.ats.arjuna] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ARJUNA012077: Abort called on already aborted atomic action 0:ffff7f000101:2f4a8c3a:576d4165:72fc
> 2016-06-28 08:54:35,702 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END USER COMMAND: endTime=2016-06-28 08:54:35.702 requestID=3bZw8VxEr4t7.26 txID=null sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=0
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4303) Insert into temporary table fails
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIID-4303?page=com.atlassian.jira.plugin... ]
Bram Gadeyne updated TEIID-4303:
--------------------------------
Attachment: debugplan.txt
The debugplan for the failing query
> Insert into temporary table fails
> ---------------------------------
>
> Key: TEIID-4303
> URL: https://issues.jboss.org/browse/TEIID-4303
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.0
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Attachments: debugplan.txt
>
>
> When executing a insert query in a temporary table the execution fails with the following error:
> 2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed execution
> 2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed connection
> 2016-06-28 08:54:35,700 DEBUG [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END SRC COMMAND: endTime=2016-06-28 08:54:35.7 requestID=3bZw8VxEr4t7.26 sourceCommandID=4 executionID=30 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > modelName=iziswh translatorName=sybase sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security finalRowCount=21504 cpuTime(ns)=120503397
> 2016-06-28 08:54:35,701 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ERROR USER COMMAND: endTime=2016-06-28 08:54:35.701 requestID=3bZw8VxEr4t7.26 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=null
> 2016-06-28 08:54:35,701 WARN [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 TEIID30020 Processing exception for request 3bZw8VxEr4t7.26 'TEIID30223 javax.transaction.RollbackException: ARJUNA016083: Can't register synchronization because the transaction is in aborted state'. Originally TeiidProcessingException TransactionImple.java:396. Enable more detailed logging to see the entire stacktrace.
> 2016-06-28 08:54:35,701 WARN [com.arjuna.ats.arjuna] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ARJUNA012077: Abort called on already aborted atomic action 0:ffff7f000101:2f4a8c3a:576d4165:72fc
> 2016-06-28 08:54:35,702 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END USER COMMAND: endTime=2016-06-28 08:54:35.702 requestID=3bZw8VxEr4t7.26 txID=null sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=0
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4303) Insert into temporary table fails
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-4303:
-----------------------------------
Summary: Insert into temporary table fails
Key: TEIID-4303
URL: https://issues.jboss.org/browse/TEIID-4303
Project: Teiid
Issue Type: Bug
Affects Versions: 9.0
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
When executing a insert query in a temporary table the execution fails with the following error:
2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed execution
2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed connection
2016-06-28 08:54:35,700 DEBUG [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END SRC COMMAND: endTime=2016-06-28 08:54:35.7 requestID=3bZw8VxEr4t7.26 sourceCommandID=4 executionID=30 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > modelName=iziswh translatorName=sybase sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security finalRowCount=21504 cpuTime(ns)=120503397
2016-06-28 08:54:35,701 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ERROR USER COMMAND: endTime=2016-06-28 08:54:35.701 requestID=3bZw8VxEr4t7.26 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=null
2016-06-28 08:54:35,701 WARN [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 TEIID30020 Processing exception for request 3bZw8VxEr4t7.26 'TEIID30223 javax.transaction.RollbackException: ARJUNA016083: Can't register synchronization because the transaction is in aborted state'. Originally TeiidProcessingException TransactionImple.java:396. Enable more detailed logging to see the entire stacktrace.
2016-06-28 08:54:35,701 WARN [com.arjuna.ats.arjuna] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ARJUNA012077: Abort called on already aborted atomic action 0:ffff7f000101:2f4a8c3a:576d4165:72fc
2016-06-28 08:54:35,702 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END USER COMMAND: endTime=2016-06-28 08:54:35.702 requestID=3bZw8VxEr4t7.26 txID=null sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=0
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4183) MSSQL JDBC driver invalidates kerberos ticket on Connection.close()
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-4183?page=com.atlassian.jira.plugin... ]
Juraj Duráni commented on TEIID-4183:
-------------------------------------
I built jboss-integration jar from 63-8.12.x branch (I have copied the single JAR to my JDV server. I did not build Teiid completely). I can confirm, that wrapping works. However, I can see three issues here:
- if wrapping is enabled, then JDV creates new connection to DB for each query, which is slow. Adding cache to pass-through login module solved this \[1\]. We could add a note to the documentation.
- there is a new exception \[2\] in the log during reload of the server. I did not encounter the exception before fix. But, exception maybe makes sense. However, as I wrote, there were no exception before fix in same circumstances, _Server is booting up and there is no subject to be used to authenticate against data source._ Do you know [~rareddy] what exact change in your last commit causes this issue? Is it easy to fix? It would be nice to have "old" behavior during booting phase of the server.
- *if wrapping is set to false and no cache is used \[3\], then Teiid throws _Access denied_ exception \[4\].*
-- adding cache to pass-through login module turns exception to _This ticket is no longer valid_ exception - this means, that MSSQL driver invalidates the ticket which is expected as wrapping is still disabled
-- now, the invalidation impact other test in my class. I did not encounter the impact before fix. I believe it is related to cache. What do you think Ramesh? Can you confirm this?
{code:plain|title=\[1\] Cache}
/subsystem=security/security-domain=passthrough-security:add(cache-type=default)
{code}
{code:plain|title=\[2\] Start up exception}
07:13:34,264 ERROR [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer] (MSC service thread 1-4) Exception during createSubject() for java:/SQL2012_Krb: PBOX000016: Access denied: authentication failed: java.lang.SecurityException: PBOX000016: Access denied: authentication failed
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.security.plugins.JBossSecuritySubjectFactory.createSubject(JBossSecuritySubjectFactory.java:84)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.jca.deployers.common.AbstractDsDeployer$1.run(AbstractDsDeployer.java:1086)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.jca.deployers.common.AbstractDsDeployer$1.run(AbstractDsDeployer.java:1081)
08:13:34,315 INFO [MultiPlatformProcessRunner] at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal]
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.jca.deployers.common.AbstractDsDeployer.createSubject(AbstractDsDeployer.java:1080)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.jca.deployers.common.AbstractDsDeployer.deployDataSource(AbstractDsDeployer.java:600)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.jca.deployers.common.AbstractDsDeployer.createObjectsAndInjectValue(AbstractDsDeployer.java:282)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer.deploy(AbstractDataSourceService.java:316)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.start(AbstractDataSourceService.java:120)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980)
08:13:34,315 INFO [MultiPlatformProcessRunner] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913)
08:13:34,315 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
08:13:34,315 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
08:13:34,315 INFO [MultiPlatformProcessRunner] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
{code}
{code:plain|title=\[3\] Pass-through login module - failed configuration}
/subsystem=security/security-domain=passthrough-security:add
/subsystem=security/security-domain=passthrough-security/authentication=classic:add
/subsystem=security/security-domain=passthrough-security/authentication=classic/login-module=org.teiid.jboss.PassthroughIdentityLoginModule:add(code=org.teiid.jboss.PassthroughIdentityLoginModule,flag=required,module=org.jboss.teiid,module-options=[\
userName=guest,\
password=guest,\
wrapGSSCredential=false])
{code}
{code:plain|title=\[4\] Access denied exception}
07:36:20,139 ERROR [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue22) Connector worker process failed for atomic-request=N2TxM305BvZO.1.3.6: java.lang.SecurityException: PBOX000016: Access denied: authentication failed
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.jboss.security.plugins.JBossSecuritySubjectFactory.createSubject(JBossSecuritySubjectFactory.java:84) [picketbox-4.1.2.Final-redhat-1.jar:4.1.2.Final-redhat-1]
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getSubject(AbstractConnectionManager.java:721)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:498)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:270) [translator-jdbc-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:68) [translator-jdbc-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:328)
08:36:20,142 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal]
08:36:20,142 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal]
08:36:20,142 INFO [MultiPlatformProcessRunner] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal]
08:36:20,142 INFO [MultiPlatformProcessRunner] at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal]
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
08:36:20,142 INFO [MultiPlatformProcessRunner] at com.sun.proxy.$Proxy48.execute(Unknown Source)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
08:36:20,142 INFO [MultiPlatformProcessRunner] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal]
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
08:36:20,142 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
08:36:20,142 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
08:36:20,143 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
08:36:20,143 INFO [MultiPlatformProcessRunner] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
08:36:20,143 INFO [MultiPlatformProcessRunner]
08:36:20,145 INFO [MultiPlatformProcessRunner] 07:36:20,144 ERROR [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue23) TEIID30019 Unexpected exception for request N2TxM305BvZO.1: java.lang.SecurityException: PBOX000016: Access denied: authentication failed
08:36:20,145 INFO [MultiPlatformProcessRunner] at org.jboss.security.plugins.JBossSecuritySubjectFactory.createSubject(JBossSecuritySubjectFactory.java:84) [picketbox-4.1.2.Final-redhat-1.jar:4.1.2.Final-redhat-1]
08:36:20,145 INFO [MultiPlatformProcessRunner] at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getSubject(AbstractConnectionManager.java:721) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
08:36:20,145 INFO [MultiPlatformProcessRunner] at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:498) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
08:36:20,145 INFO [MultiPlatformProcessRunner] at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:270)
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:68)
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:328) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal]
08:36:20,146 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal]
08:36:20,146 INFO [MultiPlatformProcessRunner] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal]
08:36:20,146 INFO [MultiPlatformProcessRunner] at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal]
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at com.sun.proxy.$Proxy48.execute(Unknown Source)
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal]
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,146 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,147 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
08:36:20,147 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
08:36:20,147 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
08:36:20,147 INFO [MultiPlatformProcessRunner] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
{code}
> MSSQL JDBC driver invalidates kerberos ticket on Connection.close()
> -------------------------------------------------------------------
>
> Key: TEIID-4183
> URL: https://issues.jboss.org/browse/TEIID-4183
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x, 8.7.5.6_2
> Reporter: Juraj Duráni
> Assignee: Ramesh Reddy
> Fix For: 9.1, 8.12.5
>
>
> MSSQL JDBC driver invalidate kerberos ticket on Connection.close() (related bugzilla \[1\]).
> If user creates kerberos connection, driver invalidates ticket on closing connection (Connection.close()). Therefore ticket cannot be re-used. EAP team creates a workaround for this by adding module option *wrapGSSCredential=true* with additional setting *credentialLifetime=-1* \[2, 3, 4, 5\]. This works for static kerberos authentication.
> However, passthrough authentication (org.teiid.jboss.PassthroughIdentityLoginModule) does not work, because passed ticket is not managed by EAP but by client.
> \[1\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276
> \[2\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276#c58
> \[3\] https://issues.jboss.org/browse/SECURITY-905
> \[4\] https://issues.jboss.org/browse/JBEAP-843
> \[5\] https://github.com/wildfly-security/jboss-negotiation/commit/0c7e06f58a79...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4297) Add UDF functions based on OSDQ for POC
by JieRen JieRen (JIRA)
[ https://issues.jboss.org/browse/TEIID-4297?page=com.atlassian.jira.plugin... ]
JieRen JieRen commented on TEIID-4297:
--------------------------------------
Ok, I got it. Thanks.
> Add UDF functions based on OSDQ for POC
> ---------------------------------------
>
> Key: TEIID-4297
> URL: https://issues.jboss.org/browse/TEIID-4297
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Ramesh Reddy
> Assignee: JieRen JieRen
> Fix For: 9.1
>
>
> Please add following UDF functions to Teiid library based on maven module
> http://search.maven.org/#search%7Cga%7C1%7Carrahtec
> The UDF functions needs to from this class below
> {code}
> public class Maskutil {
> /**
> * @param a
> * The string that need to randomize
> * vivek singh' will become 'ihg vkeivh'
> */
> public static String toRandomValue(String a) {
> return ShuffleRTM.shuffleString(a);
> }
> /**
> * @param a
> * This function will retrun MD5 hashcode of the string
> * @return String
> */
> public static String toHashValue(String a) {
> if (a == null)
> return "d41d8cd98f00b204e9800998ecf8427e"; // null MD5 value
> return ResultsetToRTM.getMD5(a).toString();
> }
> /**
> * @param a
> * This function will return digit characters of the string
> * @return
> *
> */
> public static String toDigitValue(String a) {
> return StringCaseFormatUtil.digitString(a);
> }
> }
> {code}
> for example Teiid should have UDF functions like
> {code}
> string random(string)
> string hash(string)
> string digit(string)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4302) Teiid console does not show session and request
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-4302:
-----------------------------------
Summary: Teiid console does not show session and request
Key: TEIID-4302
URL: https://issues.jboss.org/browse/TEIID-4302
Project: Teiid
Issue Type: Bug
Affects Versions: 9.0
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
The console does not show the session and request is not shown. There is only one session and one request at the moment.
I'm using the prepackaged version of teiid 9.0
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4297) Add UDF functions based on OSDQ for POC
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4297?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4297:
------------------------------------
I also think design as System functions should be much better, cause it's more convenient to use.
> Add UDF functions based on OSDQ for POC
> ---------------------------------------
>
> Key: TEIID-4297
> URL: https://issues.jboss.org/browse/TEIID-4297
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Ramesh Reddy
> Assignee: JieRen JieRen
> Fix For: 9.1
>
>
> Please add following UDF functions to Teiid library based on maven module
> http://search.maven.org/#search%7Cga%7C1%7Carrahtec
> The UDF functions needs to from this class below
> {code}
> public class Maskutil {
> /**
> * @param a
> * The string that need to randomize
> * vivek singh' will become 'ihg vkeivh'
> */
> public static String toRandomValue(String a) {
> return ShuffleRTM.shuffleString(a);
> }
> /**
> * @param a
> * This function will retrun MD5 hashcode of the string
> * @return String
> */
> public static String toHashValue(String a) {
> if (a == null)
> return "d41d8cd98f00b204e9800998ecf8427e"; // null MD5 value
> return ResultsetToRTM.getMD5(a).toString();
> }
> /**
> * @param a
> * This function will return digit characters of the string
> * @return
> *
> */
> public static String toDigitValue(String a) {
> return StringCaseFormatUtil.digitString(a);
> }
> }
> {code}
> for example Teiid should have UDF functions like
> {code}
> string random(string)
> string hash(string)
> string digit(string)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4200:
-------------------------------------
I reverted the change about OData WAR files, I rather see the exceptions during the install script, as they will be non fatal. However having to use the odata with out additional steps IMO is huge usability for community.
To facilitate product, I added two properties in pom.xml file
{code}
<odata-war-directory>modules/system/layers/dv/org/jboss/teiid/main/deployments</odata-war-directory>
<odata-war-prefix>#</odata-war-prefix>
{code}
"odata-war-directory" directs where to copy the file into.
"odata-war-prefix" can be used to comment out the odata files in "deployment.properties" file.
Using the combination of above, one can choose to copy anywhere they want.
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4183) MSSQL JDBC driver invalidates kerberos ticket on Connection.close()
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4183?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-4183.
---------------------------------
Fix Version/s: 9.1
(was: 9.0)
Resolution: Done
[~jdurani] Thanks. I had the previous one almost setup correctly but I forgot to copy a config file. I was able to finally duplicate the issue.
It came about, the way I was wrapping is correct, but it is alone is not sufficient. The subject I was using was not correct. Using the credential, one needs to create new subject using a security libraries, which will have a krb token for the delegated user. Then the credential matches with the user. I corrected it based on EAP implementation pattern, now it works as expected. See if you can build it locally and test (you can just copy the teiid-jboss-integration-8.12.5.jar) into the server.
> MSSQL JDBC driver invalidates kerberos ticket on Connection.close()
> -------------------------------------------------------------------
>
> Key: TEIID-4183
> URL: https://issues.jboss.org/browse/TEIID-4183
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x, 8.7.5.6_2
> Reporter: Juraj Duráni
> Assignee: Ramesh Reddy
> Fix For: 9.1, 8.12.5
>
>
> MSSQL JDBC driver invalidate kerberos ticket on Connection.close() (related bugzilla \[1\]).
> If user creates kerberos connection, driver invalidates ticket on closing connection (Connection.close()). Therefore ticket cannot be re-used. EAP team creates a workaround for this by adding module option *wrapGSSCredential=true* with additional setting *credentialLifetime=-1* \[2, 3, 4, 5\]. This works for static kerberos authentication.
> However, passthrough authentication (org.teiid.jboss.PassthroughIdentityLoginModule) does not work, because passed ticket is not managed by EAP but by client.
> \[1\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276
> \[2\] https://bugzilla.redhat.com/show_bug.cgi?id=1097276#c58
> \[3\] https://issues.jboss.org/browse/SECURITY-905
> \[4\] https://issues.jboss.org/browse/JBEAP-843
> \[5\] https://github.com/wildfly-security/jboss-negotiation/commit/0c7e06f58a79...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years