[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)
8 years, 7 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)
8 years, 7 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)
8 years, 7 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)
8 years, 7 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)
8 years, 7 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)
8 years, 7 months
- 1
- 0
[JBoss JIRA] (TEIID-4158) Hive/Impala translator - select distinct and gorup by is not supported in one query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4158?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4158.
---------------------------------
> Hive/Impala translator - select distinct and gorup by is not supported in one query
> -----------------------------------------------------------------------------------
>
> Key: TEIID-4158
> URL: https://issues.jboss.org/browse/TEIID-4158
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.x
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5
>
>
> Hive and Impala do not support combination of SELECT DISTINCT and GROUP BY in one SQL query.
> Messages of exceptions:
> Impala - cannot combine SELECT DISTINCT with aggregate functions or GROUP BY
> Hive - SELECT DISTINCT and GROUP BY can not be in the same query.
> DDL:
> {code:sql}
> CREATE VIEW Agg2 (StringNum string)
> AS SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum HAVING BQT1.SmallA.StringNum = '1';
> {code}
> Query:
> {code:sql}
> SELECT DISTINCT StringNum FROM VQT.Agg2
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
- 1
- 0
[JBoss JIRA] (TEIID-4107) HSQL Syntax error when Teiid sends it a join query with no parenthesis
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4107?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4107.
---------------------------------
> HSQL Syntax error when Teiid sends it a join query with no parenthesis
> ----------------------------------------------------------------------
>
> Key: TEIID-4107
> URL: https://issues.jboss.org/browse/TEIID-4107
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 7.0
> Reporter: Gabriel Steinberg
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> The query
> SELECT R_NAME FROM region LEFT OUTER JOIN (customer INNER JOIN nation ON C_NATIONKEY = N_NATIONKEY) ON R_REGIONKEY = N_REGIONKEY
> When run against an HSQL DB causes a syntax error because the query passed to HSQL contains no parenthesis, and HSQL cannot handle it, as described in https://developer.jboss.org/message/953580?et=watches.email.thread#953580.
> As Steve points out there, this was solved for H2 in https://issues.jboss.org/browse/TEIID-3549. H2 and HSQL come from the same project, they split at some point in time, and I suspect they still share a lot of code.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
- 1
- 0
[JBoss JIRA] (TEIID-3971) Clob.getSubstring(int, int) returns empty or whole string
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3971?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3971.
---------------------------------
> Clob.getSubstring(int,int) returns empty or whole string
> --------------------------------------------------------
>
> Key: TEIID-3971
> URL: https://issues.jboss.org/browse/TEIID-3971
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver, Query Engine
> Affects Versions: 8.3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.1, 8.7.3.6_2
>
>
> Method java.sql.Clob.getSubstring(int,int) returns either empty string (if second argument, length, is 0) or whole string (if length >= 1).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
- 1
- 0
[JBoss JIRA] (TEIID-4151) AssertionError: Delete failed
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4151?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4151.
---------------------------------
> AssertionError: Delete failed
> -----------------------------
>
> Key: TEIID-4151
> URL: https://issues.jboss.org/browse/TEIID-4151
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.11.3
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> When using a query like
> insert into #CaresequencesDaily
> some large select;
> delete
> from #CaresequencesDaily
> where datum < (select cast(startime as date) from #period);
> delete
> from #CaresequencesDaily
> where datum > (select cast(endtime as date) from #period);
> We get the following exception on the execution of the second delete query. It seems it does not matter in what order the delete queries are executed.
> Unexpected exception for request lMZm1kGe28/C.24: java.lang.AssertionError: Delete failed
> at org.teiid.query.tempdata.TempTable.deleteTuple(TempTable.java:801) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable.access$500(TempTable.java:83) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable$2.tuplePassed(TempTable.java:775) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:257) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable.delete(TempTable.java:783) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTableDataManager$1.createTupleSource(TempTableDataManager.java:242) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.3.jar:8.11.3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_60]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_60]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_60]
> I've tried to create a reproducable example but this doesn't throw the exception. It might be helpfull to understand what is goiing on.
> insert into #tmp_params
> select parsetimestamp('2016-04-01','yyyy-MM-dd') as starttime, parsetimestamp('2016-04-15','yyyy-MM-dd') as endtime;
> insert into #tmp_dates
> select cast(parsetimestamp('2016-03-20','yyyy-MM-dd') as date) as datum, 'somevalue' as somevalue
> UNION select cast(parsetimestamp('2016-04-02','yyyy-MM-dd') as date) as datum, 'somevalue' as somevalue
> UNION select cast(parsetimestamp('2016-04-20','yyyy-MM-dd') as date) as datum, 'somevalue' as somevalue;
> delete
> from #tmp_dates
> where datum > (select cast(endtime as date) from #tmp_params);
> --error is thrown when executing this second statement
> delete
> from #tmp_dates
> where datum < (select cast(starttime as date) from #tmp_params);
> select *
> from #tmp_dates
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
- 1
- 0