[JBoss JIRA] (TEIID-4254) PG transport SSL Warning during the client connection
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4254?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4254.
-----------------------------------
Fix Version/s: 9.0
Resolution: Done
Simply removed the handshake call.
> PG transport SSL Warning during the client connection
> -----------------------------------------------------
>
> Key: TEIID-4254
> URL: https://issues.jboss.org/browse/TEIID-4254
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 9.0
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> While using a ODBC client with SSL is throwing this following exception on server at the time of connection. I used the script here https://developer.jboss.org/wiki/JDBCODBCSSLConnectionUsingSelf-signedSSL...
> It seemed to work fine after that
> {code}
> 5:42:02,651 WARNING [io.netty.util.concurrent.DefaultPromise] (NIO2) An exception was thrown by org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(): io.netty.util.concurrent.BlockingOperationException: SslHandler$LazyChannelPromise@5a8a25ae(incomplete)
> at io.netty.util.concurrent.DefaultPromise.checkDeadLock(DefaultPromise.java:390)
> at io.netty.util.concurrent.DefaultPromise.await(DefaultPromise.java:251)
> at io.netty.util.concurrent.DefaultPromise.sync(DefaultPromise.java:218)
> at io.netty.util.concurrent.DefaultPromise.sync(DefaultPromise.java:32)
> at org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(PgBackendProtocol.java:90)
> at org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(PgBackendProtocol.java:77)
> at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:567)
> at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:406)
> at io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:82)
> at io.netty.channel.ChannelOutboundBuffer.safeSuccess(ChannelOutboundBuffer.java:639)
> at io.netty.channel.ChannelOutboundBuffer.remove(ChannelOutboundBuffer.java:259)
> at io.netty.channel.ChannelOutboundBuffer.removeBytes(ChannelOutboundBuffer.java:334)
> at io.netty.channel.socket.nio.NioSocketChannel.doWrite(NioSocketChannel.java:317)
> at io.netty.channel.AbstractChannel$AbstractUnsafe.flush0(AbstractChannel.java:750)
> at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.flush0(AbstractNioChannel.java:303)
> at io.netty.channel.AbstractChannel$AbstractUnsafe.flush(AbstractChannel.java:719)
> at io.netty.channel.DefaultChannelPipeline$HeadContext.flush(DefaultChannelPipeline.java:1119)
> at io.netty.channel.AbstractChannelHandlerContext.invokeFlush(AbstractChannelHandlerContext.java:735)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:765)
> at io.netty.channel.AbstractChannelHandlerContext.writeAndFlush(AbstractChannelHandlerContext.java:753)
> at org.teiid.transport.PgBackendProtocol.sendSslResponse(PgBackendProtocol.java:591)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.transport.PgBackendProtocol.write(PgBackendProtocol.java:219)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:705)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:763)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:698)
> at io.netty.channel.ChannelDuplexHandler.write(ChannelDuplexHandler.java:106)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:705)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:763)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:698)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:684)
> at io.netty.channel.DefaultChannelPipeline.write(DefaultChannelPipeline.java:940)
> at io.netty.channel.AbstractChannel.write(AbstractChannel.java:234)
> at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:93)
> at org.teiid.transport.ODBCClientInstance$1.invoke(ODBCClientInstance.java:60)
> at com.sun.proxy.$Proxy58.sendSslResponse(Unknown Source)
> at org.teiid.odbc.ODBCServerRemoteImpl.sslRequest(ODBCServerRemoteImpl.java:1034)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127)
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116)
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:212)
> at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218)
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)
> at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)
> at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4256) Hive translator - types in IN predicate should be of same type
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4256?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4256:
---------------------------------------
> Teiid seems to not fully translate convert(..., date) expression
I think the issue was that date support was added to hive after the initial translator development, so the code just defaulted to the string literal form - which would work in places that allow for implicit conversion. So we'll update this to be explicit.
> Hive translator - types in IN predicate should be of same type
> --------------------------------------------------------------
>
> Key: TEIID-4256
> URL: https://issues.jboss.org/browse/TEIID-4256
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Teiid seems to not fully translate convert(..., date) expression. The source-specific command contains only string representation of the date. But hive treats this as string, not date.
> *SQL query:*
> {code:sql}
> SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.DateValue IN (convert('2000-01-12', date), convert('2000-02-02', date))
> {code}
> *Source-specific command:*
> {code:sql}
> SELECT g_0.intkey AS c_0 FROM smalla g_0 WHERE g_0.datevalue IN ('2000-01-12', '2000-02-02')
> {code}
> *Exception:*
> {code:plain}
> 11:54:54,680 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue17) TEIID30020 Processing exception for request /2VwN2gwljfj.7 'TEIID30504 Source: 10014 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla g_0 WHERE g_0.datevalue IN ('2000-01-12', '2000-02-02') LIMIT 100]'. Originally TeiidProcessingException 'org.apache.hadoop.hive.ql.parse.SemanticException:Line 1:61 Wrong arguments ''2000-02-02'': The arguments for IN should be the same type! Types are: {date IN (string, string)}' TypeCheckProcFactory.java:1324.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 10014 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla g_0 WHERE g_0.datevalue IN ('2000-01-12', '2000-02-02') LIMIT 100]
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:391) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
> Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 10014 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla g_0 WHERE g_0.datevalue IN ('2000-01-12', '2000-02-02') LIMIT 100]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal]
> at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at com.sun.proxy.$Proxy47.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-5.jar:8.12.5.redhat-5]
> ... 6 more
> Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10014]: Line 1:61 Wrong arguments ''2000-02-02'': The arguments for IN should be the same type! Types are: {date IN (string, string)}
> at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:258)
> at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:244)
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:247)
> at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:378)
> at org.apache.hive.jdbc.HivePreparedStatement.executeQuery(HivePreparedStatement.java:109)
> at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
> ... 18 more
> Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10014]: Line 1:61 Wrong arguments ''2000-02-02'': The arguments for IN should be the same type! Types are: {date IN (string, string)}
> at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:315)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:112)
> at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:181)
> at org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:419)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:406)
> at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:274)
> at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)
> at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1317)
> at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1302)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
> at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.8.0-internal]
> ... 1 more
> Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.parse.SemanticException:Line 1:61 Wrong arguments ''2000-02-02'': The arguments for IN should be the same type! Types are: {date IN (string, string)}
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:1324)
> at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:95)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:79)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:133)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:110)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:213)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:157)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genAllExprNodeDesc(SemanticAnalyzer.java:10507)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10463)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10431)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:2818)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:2799)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:8848)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9743)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9636)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10109)
> at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:329)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10120)
> at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:211)
> at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:227)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:456)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:316)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1181)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1175)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)
> ... 15 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4181) Accumulo translator: AccumuloDataTypeManager various data types issues
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4181?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4181:
------------------------------------------------
Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1331693|https://bugzilla.redhat.com/show_bug.cgi?id=1331693] from ON_QA to VERIFIED
> Accumulo translator: AccumuloDataTypeManager various data types issues
> ----------------------------------------------------------------------
>
> Key: TEIID-4181
> URL: https://issues.jboss.org/browse/TEIID-4181
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.5
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.0, 8.12.5
>
>
> When using Accumulo 1.6.5 as datasource I experience problem when querying accumulo tables using accumulo translator. It seems to be data type related issue.
> Vdb used:
> {code:plain}
> <vdb name="accumulo" version="1">
> <model name="accumulo">
> <property name="importer.ColumnNamePattern" value="{CQ}" />
> <source name="node-one" translator-name="accumulo" connection-jndi-name="java:/accumulo-ds"/>
> <metadata type="DDL">
> <![CDATA[
> CREATE FOREIGN TABLE "SmallA" (
> rowid integer OPTIONS (UPDATABLE FALSE, SEARCHABLE 'All_Except_Like'),
> BigDecimalValue bigdecimal OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'BIGDECIMALVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> IntNum integer OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'INTNUM', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> BigIntegerValue biginteger OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'BIGINTEGERVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> BooleanValue boolean OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'BOOLEANVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> ByteNum byte OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'BYTENUM', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> CharValue char OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'CHARVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> DateValue date OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'DATEVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> DoubleNum double OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'DOUBLENUM', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> FloatNum float OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'FLOATNUM', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> LongNum long OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'LONGNUM', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> ShortValue short OPTIONS(SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'SHORTVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> StringKey string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'STRINGKEY', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> StringNum string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'STRINGNUM', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> TimestampValue timestamp OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'TIMESTAMPVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> TimeValue time OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'TIMEVALUE', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> ObjectValue object OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'objectvalue', "teiid_accumulo:VALUE-IN" '{VALUE}'),
> CONSTRAINT PK0 PRIMARY KEY(rowid)
> );
> ]]>
> </metadata>
> </model>
> </vdb>
> {code}
> * rowid of type integer:
> {code:plain}
> 09:09:52,927 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=47 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 09:09:52,930 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue9) Request Thread V4Nk+ZmH4VoM.3 with state NEW
> 09:09:52,930 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue9) V4Nk+ZmH4VoM.3 Command has no cache hint and result set cache mode is not on.
> 09:09:52,930 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue9) V4Nk+ZmH4VoM.3 executing SELECT rowid FROM accumulo.SMallA
> 09:09:52,932 DEBUG [org.teiid.PLANNER] (Worker0_QueryProcessorQueue9) [LOW [Relational Planner] limit not supported by source accumulo - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}, LOW [Relational Planner] limit not supported by source accumulo - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[accumulo.SmallA.rowid]}]
> 09:09:52,933 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue9) ProcessTree for V4Nk+ZmH4VoM.3 LimitNode(0) output=[accumulo.SmallA.rowid] limit 100
> AccessNode(1) output=[accumulo.SmallA.rowid] SELECT accumulo.SmallA.rowid FROM accumulo.SmallA
> 09:09:52,933 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue9) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@748e7221(V4Nk+ZmH4VoM)
> 09:09:52,933 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue9) after getOrCreateTransactionContext : V4Nk+ZmH4VoM NONE ID:NONE
> 09:09:52,933 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue9) Creating TupleBuffer: 3 [accumulo.SmallA.rowid] [class java.lang.Integer] batch size 2048 of type PROCESSOR
> 09:09:52,933 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue9) V4Nk+ZmH4VoM.3.1.3 Create State
> 09:09:52,934 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue9) V4Nk+ZmH4VoM.3.1.3 Blocking on source query V4Nk+ZmH4VoM.3.1.3
> 09:09:52,934 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue10) Running task for parent thread Worker0_QueryProcessorQueue9
> 09:09:52,934 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue9) V4Nk+ZmH4VoM.3 Blocking on source request(s).
> 09:09:52,934 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue10) V4Nk+ZmH4VoM.3.1.3 Processing NEW request: SELECT accumulo.SmallA.rowid FROM accumulo.SmallA
> 09:09:52,934 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue9) Request Thread V4Nk+ZmH4VoM.3 - processor blocked
> 09:09:52,934 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue10) V4Nk+ZmH4VoM.3.1.3 Obtained execution
> 09:09:52,935 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue10) V4Nk+ZmH4VoM.3.1.3 Executed command
> 09:09:52,935 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue10) V4Nk+ZmH4VoM.3.1.3 Processing MORE request
> 09:09:52,935 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue10) V4Nk+ZmH4VoM.3.1.3 Getting results from connector
> 09:09:53,679 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue10) Connector worker process failed for atomic-request=V4Nk+ZmH4VoM.3.1.3: java.lang.IllegalArgumentException: Unexpected length 48
> at org.apache.accumulo.core.client.lexicoder.UIntegerLexicoder.decode(UIntegerLexicoder.java:58) [accumulo-core-1.6.4.jar:1.6.4]
> at org.apache.accumulo.core.client.lexicoder.IntegerLexicoder.decode(IntegerLexicoder.java:36) [accumulo-core-1.6.4.jar:1.6.4]
> at org.teiid.translator.accumulo.AccumuloDataTypeManager.fromLexiCode(AccumuloDataTypeManager.java:257) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.translator.accumulo.AccumuloQueryExecution.nextRow(AccumuloQueryExecution.java:193) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.translator.accumulo.AccumuloQueryExecution.next(AccumuloQueryExecution.java:171) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:429) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:229) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_51]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy125.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_51]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_51]
> 09:09:53,689 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) Request Thread V4Nk+ZmH4VoM.3 with state PROCESSING
> 09:09:53,690 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) TEIID30019 Unexpected exception for request V4Nk+ZmH4VoM.3: java.lang.IllegalArgumentException: Unexpected length 48
> at org.apache.accumulo.core.client.lexicoder.UIntegerLexicoder.decode(UIntegerLexicoder.java:58)
> at org.apache.accumulo.core.client.lexicoder.IntegerLexicoder.decode(IntegerLexicoder.java:36)
> at org.teiid.translator.accumulo.AccumuloDataTypeManager.fromLexiCode(AccumuloDataTypeManager.java:257)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.nextRow(AccumuloQueryExecution.java:193)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.next(AccumuloQueryExecution.java:171)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:429) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:229) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_51]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy125.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_51]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_51]
> 09:09:53,694 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) QueryProcessor: closing processor
> 09:09:53,694 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue11) V4Nk+ZmH4VoM.3.1.3 Remove State
> 09:09:53,695 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue11) V4Nk+ZmH4VoM.3.1.3 Processing Close : SELECT accumulo.SmallA.rowid FROM accumulo.SmallA
> 09:09:53,695 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue11) V4Nk+ZmH4VoM.3.1.3 Closed execution
> 09:09:53,695 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue11) V4Nk+ZmH4VoM.3.1.3 Closed connection
> 09:09:53,698 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) Removing tuplesource for the request V4Nk+ZmH4VoM.3
> 09:09:53,699 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue11) Removing TupleBuffer: 3
> 09:09:53,699 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) V4Nk+ZmH4VoM.3 Finished Processing
> 09:09:53,700 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) java.lang.IllegalArgumentException: Unexpected length 48 Sending error to client V4Nk+ZmH4VoM.3
> 09:09:53,701 DEBUG [org.teiid.TRANSPORT] (Worker0_QueryProcessorQueue11) send message: MessageHolder: key=47 contents=ResultsMessage rowCount=0 finalRow=-1
> {code}
> * column of type string/char/bigdecimal/long/integer:
> {code:plain}
> 09:11:28,927 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=50 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 09:11:28,928 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue12) Request Thread V4Nk+ZmH4VoM.4 with state NEW
> 09:11:28,928 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue12) V4Nk+ZmH4VoM.4 Command has no cache hint and result set cache mode is not on.
> 09:11:28,928 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue12) V4Nk+ZmH4VoM.4 executing SELECT Stringkey FROM accumulo.SMallA
> 09:11:28,929 DEBUG [org.teiid.PLANNER] (Worker0_QueryProcessorQueue12) [LOW [Relational Planner] limit not supported by source accumulo - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}, LOW [Relational Planner] limit not supported by source accumulo - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[accumulo.SmallA.StringKey]}]
> 09:11:28,929 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue12) ProcessTree for V4Nk+ZmH4VoM.4 LimitNode(0) output=[accumulo.SmallA.StringKey] limit 100
> AccessNode(1) output=[accumulo.SmallA.StringKey] SELECT accumulo.SmallA.StringKey FROM accumulo.SmallA
> 09:11:28,929 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue12) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@748e7221(V4Nk+ZmH4VoM)
> 09:11:28,929 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue12) after getOrCreateTransactionContext : V4Nk+ZmH4VoM NONE ID:NONE
> 09:11:28,929 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue12) Creating TupleBuffer: 4 [accumulo.SmallA.StringKey] [class java.lang.String] batch size 1024 of type PROCESSOR
> 09:11:28,929 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue12) V4Nk+ZmH4VoM.4.1.4 Create State
> 09:11:28,929 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue12) V4Nk+ZmH4VoM.4.1.4 Blocking on source query V4Nk+ZmH4VoM.4.1.4
> 09:11:28,930 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue12) V4Nk+ZmH4VoM.4 Blocking on source request(s).
> 09:11:28,930 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue13) Running task for parent thread Worker0_QueryProcessorQueue12
> 09:11:28,930 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue12) Request Thread V4Nk+ZmH4VoM.4 - processor blocked
> 09:11:28,930 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) V4Nk+ZmH4VoM.4.1.4 Processing NEW request: SELECT accumulo.SmallA.StringKey FROM accumulo.SmallA
> 09:11:28,930 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) V4Nk+ZmH4VoM.4.1.4 Obtained execution
> 09:11:28,931 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) V4Nk+ZmH4VoM.4.1.4 Executed command
> 09:11:28,931 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) V4Nk+ZmH4VoM.4.1.4 Processing MORE request
> 09:11:28,932 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) V4Nk+ZmH4VoM.4.1.4 Getting results from connector
> 09:11:29,462 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) Connector worker process failed for atomic-request=V4Nk+ZmH4VoM.4.1.4: java.io.EOFException
> at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2335) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2804) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:802) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream.<init>(ObjectInputStream.java:299) [rt.jar:1.8.0_51]
> at org.teiid.translator.accumulo.AccumuloDataTypeManager.deserialize(AccumuloDataTypeManager.java:164) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.translator.accumulo.AccumuloQueryExecution.nextRow(AccumuloQueryExecution.java:196) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.translator.accumulo.AccumuloQueryExecution.next(AccumuloQueryExecution.java:171) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:429) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:229) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_51]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy125.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_51]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_51]
> 09:11:29,468 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) Request Thread V4Nk+ZmH4VoM.4 with state PROCESSING
> 09:11:29,469 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue14) V4Nk+ZmH4VoM.4.1.4 Remove State
> 09:11:29,469 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue14) V4Nk+ZmH4VoM.4.1.4 Processing Close : SELECT accumulo.SmallA.StringKey FROM accumulo.SmallA
> 09:11:29,470 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue14) V4Nk+ZmH4VoM.4.1.4 Closed execution
> 09:11:29,470 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue14) V4Nk+ZmH4VoM.4.1.4 Closed connection
> 09:11:29,472 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) QueryProcessor: closing processor
> 09:11:29,473 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30020 Processing exception for request V4Nk+ZmH4VoM.4 'TEIID30504 node-one: null'. Originally TeiidProcessingException ObjectInputStream.java:2335.: org.teiid.core.TeiidProcessingException: TEIID30504 node-one: null
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:374) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:470) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_51]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_51]
> Caused by: org.teiid.translator.TranslatorException
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleError(ConnectorWorkItem.java:303) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:231) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_51]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy125.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> ... 6 more
> Caused by: java.io.EOFException
> at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2335) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2804) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:802) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream.<init>(ObjectInputStream.java:299) [rt.jar:1.8.0_51]
> at org.teiid.translator.accumulo.AccumuloDataTypeManager.deserialize(AccumuloDataTypeManager.java:164)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.nextRow(AccumuloQueryExecution.java:196)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.next(AccumuloQueryExecution.java:171)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:429) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:229) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> ... 17 more
> 09:11:29,481 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) Removing tuplesource for the request V4Nk+ZmH4VoM.4
> 09:11:29,481 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue14) Removing TupleBuffer: 4
> 09:11:29,482 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) V4Nk+ZmH4VoM.4 Finished Processing
> 09:11:29,482 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) org.teiid.core.TeiidProcessingException: TEIID30504 node-one: null Sending error to client V4Nk+ZmH4VoM.4
> 09:11:29,486 DEBUG [org.teiid.TRANSPORT] (Worker0_QueryProcessorQueue14) send message: MessageHolder: key=50 contents=ResultsMessage rowCount=0 finalRow=-1
> {code}
> * timestamp/time/date/boolean/short/float/double column (the streamheader values differ for each type)
> {code:plain}
> 09:12:25,270 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=51 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 09:12:25,272 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) Request Thread V4Nk+ZmH4VoM.5 with state NEW
> 09:12:25,272 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) V4Nk+ZmH4VoM.5 Command has no cache hint and result set cache mode is not on.
> 09:12:25,272 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) V4Nk+ZmH4VoM.5 executing SELECT Timestampvalue FROM accumulo.SMallA
> 09:12:25,273 DEBUG [org.teiid.PLANNER] (Worker0_QueryProcessorQueue15) [LOW [Relational Planner] limit not supported by source accumulo - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}, LOW [Relational Planner] limit not supported by source accumulo - limit node not pushed TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[accumulo.SmallA.TimestampValue]}]
> 09:12:25,273 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) ProcessTree for V4Nk+ZmH4VoM.5 LimitNode(0) output=[accumulo.SmallA.TimestampValue] limit 100
> AccessNode(1) output=[accumulo.SmallA.TimestampValue] SELECT accumulo.SmallA.TimestampValue FROM accumulo.SmallA
> 09:12:25,273 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue15) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@748e7221(V4Nk+ZmH4VoM)
> 09:12:25,273 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue15) after getOrCreateTransactionContext : V4Nk+ZmH4VoM NONE ID:NONE
> 09:12:25,273 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue15) Creating TupleBuffer: 5 [accumulo.SmallA.TimestampValue] [class java.sql.Timestamp] batch size 2048 of type PROCESSOR
> 09:12:25,273 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue15) V4Nk+ZmH4VoM.5.1.5 Create State
> 09:12:25,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue15) V4Nk+ZmH4VoM.5.1.5 Blocking on source query V4Nk+ZmH4VoM.5.1.5
> 09:12:25,274 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue16) Running task for parent thread Worker0_QueryProcessorQueue15
> 09:12:25,274 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue15) V4Nk+ZmH4VoM.5 Blocking on source request(s).
> 09:12:25,274 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) Request Thread V4Nk+ZmH4VoM.5 - processor blocked
> 09:12:25,274 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue16) V4Nk+ZmH4VoM.5.1.5 Processing NEW request: SELECT accumulo.SmallA.TimestampValue FROM accumulo.SmallA
> 09:12:25,274 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue16) V4Nk+ZmH4VoM.5.1.5 Obtained execution
> 09:12:25,275 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue16) V4Nk+ZmH4VoM.5.1.5 Executed command
> 09:12:25,275 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue16) V4Nk+ZmH4VoM.5.1.5 Processing MORE request
> 09:12:25,275 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue16) V4Nk+ZmH4VoM.5.1.5 Getting results from connector
> 09:12:25,930 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue16) Connector worker process failed for atomic-request=V4Nk+ZmH4VoM.5.1.5: java.io.StreamCorruptedException: invalid stream header: 32303030
> at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:806) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream.<init>(ObjectInputStream.java:299) [rt.jar:1.8.0_51]
> at org.teiid.translator.accumulo.AccumuloDataTypeManager.deserialize(AccumuloDataTypeManager.java:164) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.translator.accumulo.AccumuloQueryExecution.nextRow(AccumuloQueryExecution.java:196) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.translator.accumulo.AccumuloQueryExecution.next(AccumuloQueryExecution.java:171) [translator-accumulo-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:429) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:229) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_51]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy125.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_51]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_51]
> 09:12:25,934 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue17) Request Thread V4Nk+ZmH4VoM.5 with state PROCESSING
> 09:12:25,935 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue17) V4Nk+ZmH4VoM.5.1.5 Remove State
> 09:12:25,935 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue17) V4Nk+ZmH4VoM.5.1.5 Processing Close : SELECT accumulo.SmallA.TimestampValue FROM accumulo.SmallA
> 09:12:25,935 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue17) V4Nk+ZmH4VoM.5.1.5 Closed execution
> 09:12:25,935 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue17) V4Nk+ZmH4VoM.5.1.5 Closed connection
> 09:12:25,936 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue17) QueryProcessor: closing processor
> 09:12:25,937 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue17) TEIID30020 Processing exception for request V4Nk+ZmH4VoM.5 'TEIID30504 node-one: invalid stream header: 32303030'. Originally TeiidProcessingException ObjectInputStream.java:806.: org.teiid.core.TeiidProcessingException: TEIID30504 node-one: invalid stream header: 32303030
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:374) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:470) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_51]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_51]
> Caused by: org.teiid.translator.TranslatorException: invalid stream header: 32303030
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleError(ConnectorWorkItem.java:303) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:231) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_51]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy125.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_51]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> ... 6 more
> Caused by: java.io.StreamCorruptedException: invalid stream header: 32303030
> at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:806) [rt.jar:1.8.0_51]
> at java.io.ObjectInputStream.<init>(ObjectInputStream.java:299) [rt.jar:1.8.0_51]
> at org.teiid.translator.accumulo.AccumuloDataTypeManager.deserialize(AccumuloDataTypeManager.java:164)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.nextRow(AccumuloQueryExecution.java:196)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.next(AccumuloQueryExecution.java:171)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:429) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:229) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> ... 17 more
> 09:12:25,941 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue17) Removing tuplesource for the request V4Nk+ZmH4VoM.5
> 09:12:25,941 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue17) Removing TupleBuffer: 5
> 09:12:25,941 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue17) V4Nk+ZmH4VoM.5 Finished Processing
> 09:12:25,942 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue17) org.teiid.core.TeiidProcessingException: TEIID30504 node-one: invalid stream header: 32303030 Sending error to client V4Nk+ZmH4VoM.5
> 09:12:25,942 DEBUG [org.teiid.TRANSPORT] (Worker0_QueryProcessorQueue17) send message: MessageHolder: key=51 contents=ResultsMessage rowCount=0 finalRow=-1
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4254) PG transport SSL Warning during the client connection
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4254?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4254:
-------------------------------------
I do not have any more on this, you can take this. Thanks.
> PG transport SSL Warning during the client connection
> -----------------------------------------------------
>
> Key: TEIID-4254
> URL: https://issues.jboss.org/browse/TEIID-4254
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 9.0
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
>
> While using a ODBC client with SSL is throwing this following exception on server at the time of connection. I used the script here https://developer.jboss.org/wiki/JDBCODBCSSLConnectionUsingSelf-signedSSL...
> It seemed to work fine after that
> {code}
> 5:42:02,651 WARNING [io.netty.util.concurrent.DefaultPromise] (NIO2) An exception was thrown by org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(): io.netty.util.concurrent.BlockingOperationException: SslHandler$LazyChannelPromise@5a8a25ae(incomplete)
> at io.netty.util.concurrent.DefaultPromise.checkDeadLock(DefaultPromise.java:390)
> at io.netty.util.concurrent.DefaultPromise.await(DefaultPromise.java:251)
> at io.netty.util.concurrent.DefaultPromise.sync(DefaultPromise.java:218)
> at io.netty.util.concurrent.DefaultPromise.sync(DefaultPromise.java:32)
> at org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(PgBackendProtocol.java:90)
> at org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(PgBackendProtocol.java:77)
> at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
> at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:567)
> at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:406)
> at io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:82)
> at io.netty.channel.ChannelOutboundBuffer.safeSuccess(ChannelOutboundBuffer.java:639)
> at io.netty.channel.ChannelOutboundBuffer.remove(ChannelOutboundBuffer.java:259)
> at io.netty.channel.ChannelOutboundBuffer.removeBytes(ChannelOutboundBuffer.java:334)
> at io.netty.channel.socket.nio.NioSocketChannel.doWrite(NioSocketChannel.java:317)
> at io.netty.channel.AbstractChannel$AbstractUnsafe.flush0(AbstractChannel.java:750)
> at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.flush0(AbstractNioChannel.java:303)
> at io.netty.channel.AbstractChannel$AbstractUnsafe.flush(AbstractChannel.java:719)
> at io.netty.channel.DefaultChannelPipeline$HeadContext.flush(DefaultChannelPipeline.java:1119)
> at io.netty.channel.AbstractChannelHandlerContext.invokeFlush(AbstractChannelHandlerContext.java:735)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:765)
> at io.netty.channel.AbstractChannelHandlerContext.writeAndFlush(AbstractChannelHandlerContext.java:753)
> at org.teiid.transport.PgBackendProtocol.sendSslResponse(PgBackendProtocol.java:591)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.transport.PgBackendProtocol.write(PgBackendProtocol.java:219)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:705)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:763)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:698)
> at io.netty.channel.ChannelDuplexHandler.write(ChannelDuplexHandler.java:106)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:705)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:763)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:698)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:684)
> at io.netty.channel.DefaultChannelPipeline.write(DefaultChannelPipeline.java:940)
> at io.netty.channel.AbstractChannel.write(AbstractChannel.java:234)
> at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:93)
> at org.teiid.transport.ODBCClientInstance$1.invoke(ODBCClientInstance.java:60)
> at com.sun.proxy.$Proxy58.sendSslResponse(Unknown Source)
> at org.teiid.odbc.ODBCServerRemoteImpl.sslRequest(ODBCServerRemoteImpl.java:1034)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127)
> at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116)
> at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:212)
> at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218)
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)
> at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
> at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
> at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)
> at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)
> at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4259) "TEIID30259 Cannot introduce new expressions" when using formattimestamp
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIID-4259?page=com.atlassian.jira.plugin... ]
Bram Gadeyne updated TEIID-4259:
--------------------------------
Workaround Description:
change the query to
select v.*, formattimestamp(v.tijdstip, 'dd/MM/yyyy HH:mm')
from (
... query with original w.valuetime as tijdstip
) v
Workaround: Workaround Exists
> "TEIID30259 Cannot introduce new expressions" when using formattimestamp
> ------------------------------------------------------------------------
>
> Key: TEIID-4259
> URL: https://issues.jboss.org/browse/TEIID-4259
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.11.3
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
>
> A certain query executes fine when using the normal timestamp column (w.valuetime). When this is changed to formattimestamp(w.valuetime, 'dd/MM/yyyy HH:mm') we get an exception complaining about a case statement that is part of the select a few columns after the particular valuetime column.
> 14:00:00,055 WARN [org.teiid.PROCESSOR] (Worker17615_QueryProcessorQueue95374) 7OLMH/JCvk3W TEIID30020 Processing exception for request 7OLMH/JCvk3W.48 'TEIID30259 Cannot introduce new expressions [CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END] in duplicate removal.'. Originally QueryPlannerException RuleAssignOutputElements.java:407. Enable more detailed logging to see the entire stacktrace.
> This was the query that caused the problem:
> select w.patientid as Patientid,
> formattimestamp(w.valuetime,'yyyy-MM-dd HH:mm') as t2,
> w.valuetime as Tijdstip,
> max(w.bed) as Bed, max(w.Naam) as Naam,
> case when convert(max(w.opname), date) = timestampadd(SQL_TSI_DAY, -1, convert(now() , date)) then 'Gisteren'
> else
> case when convert(max(w.opname), date) = convert(now(), date) then 'Vannacht' else
> '' end end as Opname,
> case when count(w.MondZorgAantal) is null then 'Niet gemeten' else 'OK' end as Comfort,
> case when count(w.EvaluatieMond) > 0 then 'OK' else 'Ontbreekt' end as NRS
> from
> (
> select pi.patientid as Patientid, null as ValueTime, pi.bedabbr as Bed, concat(pi.PatientLastName, concat(', ',pi.PatientFirstName)) as Naam, pi.AdmTime as opname, null as MondZorgAantal, null as EvaluatieMond, patientStatusID
> from prod_PV_PatientInfo pi
> where pi.PatientStatusID = 1 and PatGroupAbbr like 'PICU%' and cast(pi.admTime as date) <> cast(now() as date)
> union
> select v.PatientID as Patientid, v.ValueTime, null as Bed, null as Naam, null as opname,
> v.c as MondZorgAantal, null as EvaluatieMond, v.PatientStatusID from
> (select obs1.PatientID, obs1.ValueTime, count(*) as c , pi.PatientStatusID
> from prod_PV_DerivedVariables obs1
> join prod_PV_PatientInfo pi on pi.PatientID = obs1.PatientID and pi.PatientStatusID = 1 and cast(pi.admTime as date) <> cast(now() as date) and PatGroupAbbr like 'PICU%'
> where obs1.variableid = 30010003
> and cast(valuetime as date) = timestampadd(SQL_TSI_DAY, -1, cast(now() as date))
> group by obs1.patientid, obs1.ValueTime, timestampadd(SQL_TSI_DAY, -1, cast(now() as date)), pi.PatientStatusID)v
> union
> select v.PatientID as Patientid, v.ValueTime, null as Bed, null as Naam, null as opname, null as MondZorgAantal, v.c as EvaluatieMond, v.PatientStatusID from
> (select obs1.PatientID, obs1.ValueTime, count(*) as c , pi.PatientStatusID
> from prod_PV_ObservationVariables obs1
> join prod_PV_PatientInfo pi on pi.PatientID = obs1.PatientID and pi.PatientStatusID = 1 and cast(pi.admTime as date) < cast(now() as date) and PatGroupAbbr like 'PICU%'
> where obs1.variableid = 15005534
> and cast(obs1.valuetime as date) = timestampadd(SQL_TSI_DAY, -1, cast(now() as date))
> group by obs1.patientid, obs1.ValueTime, timestampadd(SQL_TSI_DAY, -1, cast(now() as date)), pi.PatientStatusID)v
> ) w
> group by w.patientid, w.ValueTime
> order by max(w.bed)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4259) "TEIID30259 Cannot introduce new expressions" when using formattimestamp
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-4259:
-----------------------------------
Summary: "TEIID30259 Cannot introduce new expressions" when using formattimestamp
Key: TEIID-4259
URL: https://issues.jboss.org/browse/TEIID-4259
Project: Teiid
Issue Type: Bug
Affects Versions: 8.11.3
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
A certain query executes fine when using the normal timestamp column (w.valuetime). When this is changed to formattimestamp(w.valuetime, 'dd/MM/yyyy HH:mm') we get an exception complaining about a case statement that is part of the select a few columns after the particular valuetime column.
14:00:00,055 WARN [org.teiid.PROCESSOR] (Worker17615_QueryProcessorQueue95374) 7OLMH/JCvk3W TEIID30020 Processing exception for request 7OLMH/JCvk3W.48 'TEIID30259 Cannot introduce new expressions [CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END] in duplicate removal.'. Originally QueryPlannerException RuleAssignOutputElements.java:407. Enable more detailed logging to see the entire stacktrace.
This was the query that caused the problem:
select w.patientid as Patientid,
formattimestamp(w.valuetime,'yyyy-MM-dd HH:mm') as t2,
w.valuetime as Tijdstip,
max(w.bed) as Bed, max(w.Naam) as Naam,
case when convert(max(w.opname), date) = timestampadd(SQL_TSI_DAY, -1, convert(now() , date)) then 'Gisteren'
else
case when convert(max(w.opname), date) = convert(now(), date) then 'Vannacht' else
'' end end as Opname,
case when count(w.MondZorgAantal) is null then 'Niet gemeten' else 'OK' end as Comfort,
case when count(w.EvaluatieMond) > 0 then 'OK' else 'Ontbreekt' end as NRS
from
(
select pi.patientid as Patientid, null as ValueTime, pi.bedabbr as Bed, concat(pi.PatientLastName, concat(', ',pi.PatientFirstName)) as Naam, pi.AdmTime as opname, null as MondZorgAantal, null as EvaluatieMond, patientStatusID
from prod_PV_PatientInfo pi
where pi.PatientStatusID = 1 and PatGroupAbbr like 'PICU%' and cast(pi.admTime as date) <> cast(now() as date)
union
select v.PatientID as Patientid, v.ValueTime, null as Bed, null as Naam, null as opname,
v.c as MondZorgAantal, null as EvaluatieMond, v.PatientStatusID from
(select obs1.PatientID, obs1.ValueTime, count(*) as c , pi.PatientStatusID
from prod_PV_DerivedVariables obs1
join prod_PV_PatientInfo pi on pi.PatientID = obs1.PatientID and pi.PatientStatusID = 1 and cast(pi.admTime as date) <> cast(now() as date) and PatGroupAbbr like 'PICU%'
where obs1.variableid = 30010003
and cast(valuetime as date) = timestampadd(SQL_TSI_DAY, -1, cast(now() as date))
group by obs1.patientid, obs1.ValueTime, timestampadd(SQL_TSI_DAY, -1, cast(now() as date)), pi.PatientStatusID)v
union
select v.PatientID as Patientid, v.ValueTime, null as Bed, null as Naam, null as opname, null as MondZorgAantal, v.c as EvaluatieMond, v.PatientStatusID from
(select obs1.PatientID, obs1.ValueTime, count(*) as c , pi.PatientStatusID
from prod_PV_ObservationVariables obs1
join prod_PV_PatientInfo pi on pi.PatientID = obs1.PatientID and pi.PatientStatusID = 1 and cast(pi.admTime as date) < cast(now() as date) and PatGroupAbbr like 'PICU%'
where obs1.variableid = 15005534
and cast(obs1.valuetime as date) = timestampadd(SQL_TSI_DAY, -1, cast(now() as date))
group by obs1.patientid, obs1.ValueTime, timestampadd(SQL_TSI_DAY, -1, cast(now() as date)), pi.PatientStatusID)v
) w
group by w.patientid, w.ValueTime
order by max(w.bed)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4258) Cannot connect to Teiid if server runs on JVM 1.6
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-4258?page=com.atlassian.jira.plugin... ]
Juraj Duráni updated TEIID-4258:
--------------------------------
Description:
If Teiid runs on JVM 1.6. connection fails with EOFException \[1\]
\[1\] Exception thrown (used squirrel client)
{code:plain}
java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 5 more
Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more
Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161)
at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)
at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64)
... 11 more
Caused by: java.io.EOFException
at java.io.DataInputStream.readInt(DataInputStream.java:392)
at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365)
at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)
at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128)
at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96)
at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277)
at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239)
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
... 14 more
{code}
I have tried several combinations:
|client|server|result|
|JVM 1.6| JVM 1.6|fail|
|JVM 1.8| JVM 1.6|fail|
|JVM 1.6| JVM 1.8|OK|
was:
If Teiid runs on JVM 1.6. connection fails with EOFException \[1\]
\[1\] Exception thrown (used squirrel client)
{code:plain}
java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 5 more
Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more
Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161)
at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)
at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64)
... 11 more
Caused by: java.io.EOFException
at java.io.DataInputStream.readInt(DataInputStream.java:392)
at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365)
at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)
at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128)
at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96)
at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277)
at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239)
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
... 14 more
{code}
> Cannot connect to Teiid if server runs on JVM 1.6
> -------------------------------------------------
>
> Key: TEIID-4258
> URL: https://issues.jboss.org/browse/TEIID-4258
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.5
> Environment: JVM 1.6
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Blocker
>
> If Teiid runs on JVM 1.6. connection fails with EOFException \[1\]
> \[1\] Exception thrown (used squirrel client)
> {code:plain}
> java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:206)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
> ... 5 more
> Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)
> at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
> ... 7 more
> Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161)
> at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64)
> ... 11 more
> Caused by: java.io.EOFException
> at java.io.DataInputStream.readInt(DataInputStream.java:392)
> at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97)
> at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365)
> at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)
> at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128)
> at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96)
> at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277)
> at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
> ... 14 more
> {code}
> I have tried several combinations:
> |client|server|result|
> |JVM 1.6| JVM 1.6|fail|
> |JVM 1.8| JVM 1.6|fail|
> |JVM 1.6| JVM 1.8|OK|
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4168) Odd resolving error with implicit temp groups
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4168?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4168.
---------------------------------
> Odd resolving error with implicit temp groups
> ---------------------------------------------
>
> Key: TEIID-4168
> URL: https://issues.jboss.org/browse/TEIID-4168
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> If a query expression is used to insert into an implicit temporary table and no columns are specified the resolver will complain when the query column names do not match those defined on the implicit table. For example:
> insert into #tmp_dates ... defines the temp table ...
> insert into #tmp_dates select <some expression>
> Will complain that 'expr1' is not defined by #tmp_dates. Rather the column definitions should be assumed from the earlier statement.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4170) Correct documentation on materialized view indexes
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4170?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4170.
---------------------------------
> Correct documentation on materialized view indexes
> --------------------------------------------------
>
> Key: TEIID-4170
> URL: https://issues.jboss.org/browse/TEIID-4170
> Project: Teiid
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> The documentation covering materialized view indexing is out of date and should be made more precise.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4173) Using PI JDBC Adapter, server does not start up using simple queries
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4173?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4173.
---------------------------------
> Using PI JDBC Adapter, server does not start up using simple queries
> --------------------------------------------------------------------
>
> Key: TEIID-4173
> URL: https://issues.jboss.org/browse/TEIID-4173
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver
> Affects Versions: 8.13.3
> Environment: Issue was discovered using Windows Server 2012 OS and Teiid 8.13.3
> Reporter: Al S
> Assignee: Steven Hawkins
> Labels: JDBC, PI
>
> Using the following model along with the PI JDBC 2015 adapter, the error below was seen at startup of Wildfly.
> <vdb name="PIAF2" version="1">
> <description>OSIsoft PI AF</description>
> <model name="PIAF-Physical" type="PHYSICAL">
> <property name="importer.useFullSchemaName" value="false"/>
> <property name="importer.tableTypes" value="TABLE,VIEW"/>
> <source name="piaf-connector" translator-name="osisoft-pi" connection-jndi-name="java:/pi-ds"/>
> </model>
> <model name="PIAF-Virtual" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW IceDataTwo (
> tag varchar(max)
> ) AS
> select tag from pipoint.pipoint where tag='sinusoid'
> ]]> </metadata>
> </model>
> </vdb>
> Error:
> 21:26:59,420 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
> ol -- 61) WFLYCLINF0002: Started resultset cache from teiid container
> 21:26:59,514 WARN [org.teiid.RUNTIME] (Worker1_async-teiid-threads1) TEIID5003
> 6 VDB PIAF2.1 model "PIAF-Virtual" metadata failed to load. Reason:TEIID30386 or
> g.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Enco
> untered "tag varchar([*]max[*]) )" at line 3, column 25.
> Was expecting: <UNSIGNEDINTEGER>: org.teiid.metadata.ParseException: TEIID30386
> org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: En
> countered "tag varchar([*]max[*]) )" at line 3, column 25.
> Was expecting: <UNSIGNEDINTEGER>
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetada
> taRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadM
> etadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
> ningMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
> text.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
> n(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
> xecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
> java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsin
> g error: Encountered "tag varchar([*]max[*]) )" at line 3, column 25.
> Was expecting: <UNSIGNEDINTEGER>
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser
> .java:214)
> ... 13 more
> 21:26:59,514 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
> ol -- 60) WFLYCLINF0002: Started resultset-repl cache from teiid container
> 21:26:59,529 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
> ol -- 62) WFLYCLINF0002: Started preparedplan cache from teiid container
> 21:27:00,732 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teii
> d Engine 8.13.3 Started = Mon Apr 25 21:27:00 PDT 2016
> 21:27:00,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50038 Teii
> d Embedded transport enabled. Bound to: teiid/queryengine/odata
> 21:27:00,998 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50038 Teii
> d Embedded transport enabled. Bound to: teiid/queryengine/embedded
> 21:27:01,748 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Deploying javax.ws.rs.core.Application: class org.teiid.odata.
> TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.MetadataR
> esource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding provider class org.odata4j.producer.resources.ODataBatc
> hProvider from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding provider class org.teiid.odata.TeiidProducerProvider fr
> om Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.EntityReq
> uestResource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.EntitiesR
> equestResource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding provider class org.teiid.odata.ODataExceptionMappingPro
> vider from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.ServiceDo
> cumentResource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50012 Teii
> d JDBC - Name = jdbc, Host = 127.0.0.1, Port = 31000, SSL = OFF, security-domai
> ns = teiid-security
> 21:27:01,967 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50037 Teii
> d ODBC - Name = odbc, Host = 127.0.0.1, Port = 35432, SSL = OFF, security-domai
> ns = teiid-security
> 21:27:02,076 INFO [org.hibernate.validator.internal.util.Version] (ServerServic
> e Thread Pool -- 65) HV000001: Hibernate Validator 5.1.3.Final
> 21:27:02,592 INFO [org.teiid.CONNECTOR] (Worker0_async-teiid-threads0) PIExecu
> tionFactory Commit=true;DatabaseProductName=PI SQL Data Access Server 1.4.1.403
> using PIOLEDB;DatabaseProductVersion=PIOLEDB: 3.3.1.2;DriverMajorVersion=1;Drive
> rMajorVersion=4;DriverName=com.osisoft.jdbc.Driver;DriverVersion=1.4.1.404;Isola
> tionLevel=0
> 21:27:02,607 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -
> - 65) WFLYUT0021: Registered web context: /odata
> 21:27:02,795 INFO [org.jboss.as.server] (ServerService Thread Pool -- 35) WFLY
> SRV0010: Deployed "PIJDBCDriver.jar" (runtime-name : "PIJDBCDriver.jar")
> 21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 35) WFLY
> SRV0010: Deployed "PIAF-vdb.xml" (runtime-name : "PIAF-vdb.xml")
> 21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 55) WFLY
> SRV0010: Deployed "teiid-olingo-8.13.3-odata4.war" (runtime-name : "teiid-olingo
> -8.13.3-odata4.war")
> 21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 55) WFLY
> SRV0010: Deployed "teiid-odata-8.13.3-odata2.war" (runtime-name : "teiid-odata-8
> .13.3-odata2.war")
> 21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http ma
> nagement interface listening on http://127.0.0.1:9990/management
> 21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin c
> onsole listening on http://127.0.0.1:9990
> 21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly
> Full 9.0.2.Final (WildFly Core 1.0.2.Final) started in 25094ms - Started 596 of
> 836 services (305 services are lazy, passive or on-demand)
> 21:27:03,920 WARN [org.teiid.RUNTIME] (Worker0_async-teiid-threads0) TEIID5003
> 6 VDB PIAF2.1 model "PIAF-Physical" metadata failed to load. Reason:TEIID11010 j
> ava.sql.SQLException: java.lang.Integer cannot be cast to java.lang.Short: org.t
> eiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: java.lang
> .Integer cannot be cast to java.lang.Short
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
> ionFactory.java:297)
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
> ionFactory.java:68)
> at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeM
> etadataRepository.java:92)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(Native
> MetadataRepository.java:60)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
> ningMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
> text.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
> n(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
> xecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
> java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.sql.SQLException: java.lang.Integer cannot be cast to java.lang.
> Short
> at com.osisoft.jdbc.ResultSetImpl.getShort(ResultSetImpl.java:544)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.getPrimaryKeys(JDBCMet
> dataProcessor.java:495)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(J
> DBCMetdataProcessor.java:162)
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
> ionFactory.java:295)
> ... 12 more
> 21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool -- 63)
> WFLYDR0009: Content C:\apps\teiid-8.13.3\standalone\data\content\14\344c87647a15
> e57fe72a46b9754cd996f71dff is obsolete and will be removed
> 21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool -- 63)
> WFLYDR0002: Content removed from location C:\apps\teiid-8.13.3\standalone\data\c
> ontent\14\344c87647a15e57fe72a46b9754cd996f71dff\content
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
- 1
- 0