[JBoss JIRA] (TEIID-5146) UNION of two similar JOIN queries fails with ASSERTION FAILED error if it contains table function of procedural call with arguments
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5146?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5146:
---------------------------------------
This is a timing issue with the tuple source caching logic and a nested table join.
> UNION of two similar JOIN queries fails with ASSERTION FAILED error if it contains table function of procedural call with arguments
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-5146
> URL: https://issues.jboss.org/browse/TEIID-5146
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 9.3.4
> Reporter: El Fuego
> Assignee: Steven Hawkins
>
> UNION of two similar JOINs containing table function of procedural call with arguments, like:
> {code:sql}SELECT d.col_t2 FROM "ds.test_t1", table(CALL views.pr0("arg1" => col_t1)) x
> JOIN "ds.test_t2" d
> ON true
> --
> UNION
> --
> SELECT d.col_t2 FROM "ds.test_t1", table(CALL views.pr0("arg1" => col_t1)) x
> JOIN "ds.test_t2" d
> ON true{code}
> fails with error:
> {code}2017-11-11 16:16:57,158 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue23) wbDLp863MJn9 TEIID30019 Unexpected exception for request wbDLp863MJn9.7: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:287)
> at org.teiid.dqp.internal.process.TupleSourceCache$CopyOnReadTupleSource.nextTuple(TupleSourceCache.java:103)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:394)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:211)
> at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:158)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
> at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92)
> at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:235)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:147)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:152)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:115)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:479)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.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){code}
> even if procedure doesn't use that argument at all.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month
[JBoss JIRA] (TEIID-5147) ODBC server serving unrelated results
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5147?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5147:
---------------------------------------
Can you provide a test harness for this? Or at least a trace of the ODBC message traffic? This could be related to the client / tool you are using as well. From a server perspective it's unlikely that results are being inappropriately returned, but at the protocol layer or even at the client side there may be something unexpected.
> ODBC server serving unrelated results
> -------------------------------------
>
> Key: TEIID-5147
> URL: https://issues.jboss.org/browse/TEIID-5147
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Priority: Blocker
>
> There is blocking issue with ODBC server. The results are corrupt due to interleaving queries running on the server.
> For a query:
> {code:sql}
> SELECT BQT1.SmallA.StringKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey >= 47
> {code}
> I get following result:
> ||relname||nspname||relkind||
> |HugeA|BQT1|v|
> |HugeB|BQT1|v|
> |LargeA|BQT1|v|
> |LargeB|BQT1|v|
> |MediumA|BQT1|v|
> |MediumB|BQT1|v|
> |SmallA|BQT1|v|
> |SmallB|BQT1|v|
> |HugeA|BQT2|v|
> |HugeB|BQT2|v|
> |LargeA|BQT2|v|
> |LargeB|BQT2|v|
> |MediumA|BQT2|v|
> |MediumB|BQT2|v|
> |SmallA|BQT2|v|
> |SmallB|BQT2|v|
> |dv_odbc_test|OdbcTest|r|
> |Columns|SYS|r|
> |DataTypes|SYS|r|
> |FunctionParams|SYS|r|
> |Functions|SYS|r|
> |GEOMETRY_COLUMNS|SYS|v|
> |KeyColumns|SYS|r|
> |Keys|SYS|r|
> |ProcedureParams|SYS|r|
> |Procedures|SYS|r|
> |Properties|SYS|r|
> |ReferenceKeyColumns|SYS|r|
> |Schemas|SYS|r|
> |Tables|SYS|r|
> |VirtualDatabases|SYS|r|
> |spatial_ref_sys|SYS|v|
> |MatViews|SYSADMIN|r|
> |StoredProcedures|SYSADMIN|r|
> |Triggers|SYSADMIN|r|
> |Usage|SYSADMIN|r|
> |VDBResources|SYSADMIN|r|
> |Views|SYSADMIN|r|
> |hugea|Source|r|
> |hugeb|Source|r|
> |largea|Source|r|
> |largeb|Source|r|
> |mediuma|Source|r|
> |mediumb|Source|r|
> |smalla|Source|r|
> |smallb|Source|r|
> which is a result to an internal query performed by the engine.
> See the following command log.
> Notice, that
> * j2lxLVGEBuHy.195 is the request I actually got results for
> * j2lxLVGEBuHy.200 is the requestId of my query
> {code}
> 23:33:09,507 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue68) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.507 requestID=j2lxLVGEBuHy.195 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname
> 23:33:09,508 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue68) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.508 requestID=j2lxLVGEBuHy.194 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,521 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.521 requestID=j2lxLVGEBuHy.196 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:09,523 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.523 requestID=j2lxLVGEBuHy.196 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,524 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.524 requestID=j2lxLVGEBuHy.197 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:09,527 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.527 requestID=j2lxLVGEBuHy.197 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,528 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.528 requestID=j2lxLVGEBuHy.198 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:09,530 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.53 requestID=j2lxLVGEBuHy.198 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,533 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.533 requestID=j2lxLVGEBuHy.199 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT 0
> 23:33:09,537 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.536 requestID=j2lxLVGEBuHy.200 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT BQT1.SmallA.StringKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey >= 47
> 23:33:09,542 INFO [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue72) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.542 requestID=j2lxLVGEBuHy.199 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,543 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START DATA SRC COMMAND: startTime=2017-11-11 23:33:09.543 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security sql=SELECT g_0.stringkey FROM Source.smalla AS g_0 WHERE g_0.stringkey >= '47'
> 23:33:09,544 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy SOURCE SRC COMMAND: endTime=2017-11-11 23:33:09.544 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security sourceCommand=[SELECT g_0."stringkey" FROM "smalla" AS g_0 WHERE g_0."stringkey" >= '47']
> 23:33:09,553 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.553 requestID=j2lxLVGEBuHy.195 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=46
> 23:33:10,012 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END SRC COMMAND: endTime=2017-11-11 23:33:10.012 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security finalRowCount=8 cpuTime(ns)=3924366
> 23:33:10,013 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:10.013 requestID=j2lxLVGEBuHy.201 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:10,016 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:10.016 requestID=j2lxLVGEBuHy.201 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:10,019 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:10.019 requestID=j2lxLVGEBuHy.202 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT 0
> 23:33:10,020 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:10.02 requestID=j2lxLVGEBuHy.200 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=8
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month
[JBoss JIRA] (TEIID-5147) ODBC server serving unrelated results
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5147?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-5147:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1512429
Bugzilla Update: Perform
> ODBC server serving unrelated results
> -------------------------------------
>
> Key: TEIID-5147
> URL: https://issues.jboss.org/browse/TEIID-5147
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Priority: Blocker
>
> There is blocking issue with ODBC server. The results are corrupt due to interleaving queries running on the server.
> For a query:
> {code:sql}
> SELECT BQT1.SmallA.StringKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey >= 47
> {code}
> I get following result:
> ||relname||nspname||relkind||
> |HugeA|BQT1|v|
> |HugeB|BQT1|v|
> |LargeA|BQT1|v|
> |LargeB|BQT1|v|
> |MediumA|BQT1|v|
> |MediumB|BQT1|v|
> |SmallA|BQT1|v|
> |SmallB|BQT1|v|
> |HugeA|BQT2|v|
> |HugeB|BQT2|v|
> |LargeA|BQT2|v|
> |LargeB|BQT2|v|
> |MediumA|BQT2|v|
> |MediumB|BQT2|v|
> |SmallA|BQT2|v|
> |SmallB|BQT2|v|
> |dv_odbc_test|OdbcTest|r|
> |Columns|SYS|r|
> |DataTypes|SYS|r|
> |FunctionParams|SYS|r|
> |Functions|SYS|r|
> |GEOMETRY_COLUMNS|SYS|v|
> |KeyColumns|SYS|r|
> |Keys|SYS|r|
> |ProcedureParams|SYS|r|
> |Procedures|SYS|r|
> |Properties|SYS|r|
> |ReferenceKeyColumns|SYS|r|
> |Schemas|SYS|r|
> |Tables|SYS|r|
> |VirtualDatabases|SYS|r|
> |spatial_ref_sys|SYS|v|
> |MatViews|SYSADMIN|r|
> |StoredProcedures|SYSADMIN|r|
> |Triggers|SYSADMIN|r|
> |Usage|SYSADMIN|r|
> |VDBResources|SYSADMIN|r|
> |Views|SYSADMIN|r|
> |hugea|Source|r|
> |hugeb|Source|r|
> |largea|Source|r|
> |largeb|Source|r|
> |mediuma|Source|r|
> |mediumb|Source|r|
> |smalla|Source|r|
> |smallb|Source|r|
> which is a result to an internal query performed by the engine.
> See the following command log.
> Notice, that
> * j2lxLVGEBuHy.195 is the request I actually got results for
> * j2lxLVGEBuHy.200 is the requestId of my query
> {code}
> 23:33:09,507 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue68) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.507 requestID=j2lxLVGEBuHy.195 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname
> 23:33:09,508 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue68) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.508 requestID=j2lxLVGEBuHy.194 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,521 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.521 requestID=j2lxLVGEBuHy.196 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:09,523 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.523 requestID=j2lxLVGEBuHy.196 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,524 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.524 requestID=j2lxLVGEBuHy.197 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:09,527 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.527 requestID=j2lxLVGEBuHy.197 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,528 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.528 requestID=j2lxLVGEBuHy.198 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:09,530 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.53 requestID=j2lxLVGEBuHy.198 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,533 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.533 requestID=j2lxLVGEBuHy.199 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT 0
> 23:33:09,537 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.536 requestID=j2lxLVGEBuHy.200 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT BQT1.SmallA.StringKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey >= 47
> 23:33:09,542 INFO [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue72) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.542 requestID=j2lxLVGEBuHy.199 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:09,543 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START DATA SRC COMMAND: startTime=2017-11-11 23:33:09.543 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security sql=SELECT g_0.stringkey FROM Source.smalla AS g_0 WHERE g_0.stringkey >= '47'
> 23:33:09,544 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy SOURCE SRC COMMAND: endTime=2017-11-11 23:33:09.544 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security sourceCommand=[SELECT g_0."stringkey" FROM "smalla" AS g_0 WHERE g_0."stringkey" >= '47']
> 23:33:09,553 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.553 requestID=j2lxLVGEBuHy.195 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=46
> 23:33:10,012 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END SRC COMMAND: endTime=2017-11-11 23:33:10.012 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security finalRowCount=8 cpuTime(ns)=3924366
> 23:33:10,013 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:10.013 requestID=j2lxLVGEBuHy.201 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
> 23:33:10,016 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:10.016 requestID=j2lxLVGEBuHy.201 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
> 23:33:10,019 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:10.019 requestID=j2lxLVGEBuHy.202 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT 0
> 23:33:10,020 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:10.02 requestID=j2lxLVGEBuHy.200 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=8
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month
[JBoss JIRA] (TEIID-5147) ODBC server serving unrelated results
by Jan Stastny (JIRA)
Jan Stastny created TEIID-5147:
----------------------------------
Summary: ODBC server serving unrelated results
Key: TEIID-5147
URL: https://issues.jboss.org/browse/TEIID-5147
Project: Teiid
Issue Type: Bug
Components: ODBC
Affects Versions: 8.12.x-6.4
Reporter: Jan Stastny
Assignee: Steven Hawkins
Priority: Blocker
There is blocking issue with ODBC server. The results are corrupt due to interleaving queries running on the server.
For a query:
{code:sql}
SELECT BQT1.SmallA.StringKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey >= 47
{code}
I get following result:
||relname||nspname||relkind||
|HugeA|BQT1|v|
|HugeB|BQT1|v|
|LargeA|BQT1|v|
|LargeB|BQT1|v|
|MediumA|BQT1|v|
|MediumB|BQT1|v|
|SmallA|BQT1|v|
|SmallB|BQT1|v|
|HugeA|BQT2|v|
|HugeB|BQT2|v|
|LargeA|BQT2|v|
|LargeB|BQT2|v|
|MediumA|BQT2|v|
|MediumB|BQT2|v|
|SmallA|BQT2|v|
|SmallB|BQT2|v|
|dv_odbc_test|OdbcTest|r|
|Columns|SYS|r|
|DataTypes|SYS|r|
|FunctionParams|SYS|r|
|Functions|SYS|r|
|GEOMETRY_COLUMNS|SYS|v|
|KeyColumns|SYS|r|
|Keys|SYS|r|
|ProcedureParams|SYS|r|
|Procedures|SYS|r|
|Properties|SYS|r|
|ReferenceKeyColumns|SYS|r|
|Schemas|SYS|r|
|Tables|SYS|r|
|VirtualDatabases|SYS|r|
|spatial_ref_sys|SYS|v|
|MatViews|SYSADMIN|r|
|StoredProcedures|SYSADMIN|r|
|Triggers|SYSADMIN|r|
|Usage|SYSADMIN|r|
|VDBResources|SYSADMIN|r|
|Views|SYSADMIN|r|
|hugea|Source|r|
|hugeb|Source|r|
|largea|Source|r|
|largeb|Source|r|
|mediuma|Source|r|
|mediumb|Source|r|
|smalla|Source|r|
|smallb|Source|r|
which is a result to an internal query performed by the engine.
See the following command log.
Notice, that
* j2lxLVGEBuHy.195 is the request I actually got results for
* j2lxLVGEBuHy.200 is the requestId of my query
{code}
23:33:09,507 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue68) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.507 requestID=j2lxLVGEBuHy.195 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname
23:33:09,508 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue68) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.508 requestID=j2lxLVGEBuHy.194 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
23:33:09,521 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.521 requestID=j2lxLVGEBuHy.196 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
23:33:09,523 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.523 requestID=j2lxLVGEBuHy.196 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
23:33:09,524 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.524 requestID=j2lxLVGEBuHy.197 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
23:33:09,527 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.527 requestID=j2lxLVGEBuHy.197 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
23:33:09,528 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.528 requestID=j2lxLVGEBuHy.198 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
23:33:09,530 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.53 requestID=j2lxLVGEBuHy.198 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
23:33:09,533 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.533 requestID=j2lxLVGEBuHy.199 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT 0
23:33:09,537 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:09.536 requestID=j2lxLVGEBuHy.200 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT BQT1.SmallA.StringKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringKey >= 47
23:33:09,542 INFO [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue72) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.542 requestID=j2lxLVGEBuHy.199 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
23:33:09,543 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START DATA SRC COMMAND: startTime=2017-11-11 23:33:09.543 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security sql=SELECT g_0.stringkey FROM Source.smalla AS g_0 WHERE g_0.stringkey >= '47'
23:33:09,544 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy SOURCE SRC COMMAND: endTime=2017-11-11 23:33:09.544 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security sourceCommand=[SELECT g_0."stringkey" FROM "smalla" AS g_0 WHERE g_0."stringkey" >= '47']
23:33:09,553 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue69) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:09.553 requestID=j2lxLVGEBuHy.195 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=46
23:33:10,012 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END SRC COMMAND: endTime=2017-11-11 23:33:10.012 requestID=j2lxLVGEBuHy.200 sourceCommandID=0 executionID=9 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=j2lxLVGEBuHy principal=user@teiid-security finalRowCount=8 cpuTime(ns)=3924366
23:33:10,013 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:10.013 requestID=j2lxLVGEBuHy.201 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=select attrelid, attnum, typoid from pg_catalog.matpg_relatt where attname = ? and relname = ? and nspname = ?
23:33:10,016 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:10.016 requestID=j2lxLVGEBuHy.201 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=1
23:33:10,019 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy START USER COMMAND: startTime=2017-11-11 23:33:10.019 requestID=j2lxLVGEBuHy.202 txID=null sessionID=j2lxLVGEBuHy applicationName=ODBC principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 sql=SELECT 0
23:33:10,020 INFO [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue71) j2lxLVGEBuHy END USER COMMAND: endTime=2017-11-11 23:33:10.02 requestID=j2lxLVGEBuHy.200 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-71f7cd09:5a077a80:e status: ActionStatus.RUNNING > sessionID=j2lxLVGEBuHy principal=user@teiid-security vdbName=Postgres92 vdbVersion=1 finalRowCount=8
{code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month
[JBoss JIRA] (TEIID-5144) Infinispan hotrod translator doesn't overcome error in unrelated proto-schema
by Jan Stastny (JIRA)
[ https://issues.jboss.org/browse/TEIID-5144?page=com.atlassian.jira.plugin... ]
Jan Stastny commented on TEIID-5144:
------------------------------------
[~rareddy] I know we're checking that. But the check is not proto-schema specific. It does check, that there is/isn't an error in ANY of the proto-schemas. Not only the one we are adding one line above.
> Infinispan hotrod translator doesn't overcome error in unrelated proto-schema
> -----------------------------------------------------------------------------
>
> Key: TEIID-5144
> URL: https://issues.jboss.org/browse/TEIID-5144
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
>
> Infinispan Hotrod translator can't overcome an error in any proto-schema on the JDG server.
> It ends with a message, that there's an issue with a proto-schema. Doesn't say which.
> Note, that this can be completely unrelated proto-schema to Teiid. Then the only solution is to reload JDG, or possibly clear proto-schema cache.
> If Teiid is checking for errors in .errors cache, it should be selective and look only for the newly added proto-schema.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month
[JBoss JIRA] (TEIID-5143) Infinispan hotrod translator proto-schema registered as ProtoFilePath
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5143?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-5143.
---------------------------------
Resolution: Done
Good Suggestion. Adjusted code to use "protobufName" if available when "protobufFile" in use
> Infinispan hotrod translator proto-schema registered as ProtoFilePath
> ---------------------------------------------------------------------
>
> Key: TEIID-5143
> URL: https://issues.jboss.org/browse/TEIID-5143
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Fix For: 10.1
>
>
> When using an existing protobuf file to configure source metadata and providing full path via ProtoFilePath, there are issues with how the proto-schema is being registered in JDG.
> When using ProtoFilePath, the proto-schema is being registered under the exact value of this property. This is unexpected and source of many issues. Rather the proto-schema should be registered under the package context.
> This leads to a situation, when using the same file on various machines, or when the file is moved, then the proto-schema is being registered twice with different keys in JDG proto-schema cache, this leads to an exception on JDG's side and non-deployed VDB.
> I expect the ProtobufName to be a complementary to ProtoFilePath:
> # I register a proto-schema using ProtoFilePath property
> # I use that schema in different VDB using ProtobufName property
> Then the ProtobufName used in second case needs to contain exactly the same value as ProtoFilePath in the first case. This is hard to understand.
> Could the change be to:
> # Set both ProtoFilePath and ProtobufName properties (ProtobufName is our logical descriptor) when a user want to register new protobuf file. This way the contents of a file denoted by ProtoFilePath is registered in JDG under ProtobufName key.
> # Using only ProtobufName when an already registered proto-schema is to be used.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month
[JBoss JIRA] (TEIID-5143) Infinispan hotrod translator proto-schema registered as ProtoFilePath
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5143?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-5143:
--------------------------------
Fix Version/s: 10.1
> Infinispan hotrod translator proto-schema registered as ProtoFilePath
> ---------------------------------------------------------------------
>
> Key: TEIID-5143
> URL: https://issues.jboss.org/browse/TEIID-5143
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Fix For: 10.1
>
>
> When using an existing protobuf file to configure source metadata and providing full path via ProtoFilePath, there are issues with how the proto-schema is being registered in JDG.
> When using ProtoFilePath, the proto-schema is being registered under the exact value of this property. This is unexpected and source of many issues. Rather the proto-schema should be registered under the package context.
> This leads to a situation, when using the same file on various machines, or when the file is moved, then the proto-schema is being registered twice with different keys in JDG proto-schema cache, this leads to an exception on JDG's side and non-deployed VDB.
> I expect the ProtobufName to be a complementary to ProtoFilePath:
> # I register a proto-schema using ProtoFilePath property
> # I use that schema in different VDB using ProtobufName property
> Then the ProtobufName used in second case needs to contain exactly the same value as ProtoFilePath in the first case. This is hard to understand.
> Could the change be to:
> # Set both ProtoFilePath and ProtobufName properties (ProtobufName is our logical descriptor) when a user want to register new protobuf file. This way the contents of a file denoted by ProtoFilePath is registered in JDG under ProtobufName key.
> # Using only ProtobufName when an already registered proto-schema is to be used.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month
[JBoss JIRA] (TEIID-5124) Osisoft translator - Syntax error on datasource for queries with LOCATE
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5124?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-5124.
---------------------------------
Resolution: Done
> Osisoft translator - Syntax error on datasource for queries with LOCATE
> -----------------------------------------------------------------------
>
> Key: TEIID-5124
> URL: https://issues.jboss.org/browse/TEIID-5124
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Ramesh Reddy
> Fix For: 10.1
>
>
> Running a query with LOCATE function causes a syntax error on the PI server:
> {code:sql}
> SELECT INTKEY FROM BQT1.SmallA WHERE LOCATE(2, INTKEY, 1) = 1
> {code}
> is pushed as
> {code:sql}
> SELECT g_0.IntKey AS c_0 FROM dvqe..SmallA AS g_0 WHERE cast(g_0.IntKey AS String)'2'1 = 1
> {code}
> and fails with
> {noformat}
> org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT TOP 100 g_0.IntKey AS c_0 FROM dvqe..SmallA AS g_0 WHERE cast(g_0.IntKey AS String)'2'1 = 1]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_141]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_141]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_141]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_141]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy79.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_141]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_141]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_141]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_141]
> Caused by: java.sql.SQLException: [PIOLEDBENT] [SQL Parser] [Line 1:90] Syntax error near '2'
> at com.osisoft.jdbc.StatementImpl.executeQuery(StatementImpl.java:360)
> at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> ... 18 more
> Caused by: com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Parser] [Line 1:90] Syntax error near '2'
> at com.osisoft.rdsa.Command.ExecuteReader(Native Method)
> at com.osisoft.rdsa.Command.executeReader(Command.java:79)
> at com.osisoft.jdbc.StatementImpl.executeQuery(StatementImpl.java:356)
> ... 20 more
> {noformat}
> Furthermore, query such as
> {code:sql}
> SELECT INTKEY, LOCATE(1, STRINGNUM) FROM BQT1.SmallA
> {code}
> fails on teiid (before push down) with
> {noformat}
> java.lang.IndexOutOfBoundsException: Index: 2, Size: 2
> at java.util.ArrayList.rangeCheck(ArrayList.java:653) [rt.jar:1.8.0_141]
> at java.util.ArrayList.get(ArrayList.java:429) [rt.jar:1.8.0_141]
> at org.teiid.translator.jdbc.pi.PIExecutionFactory$1.translate(PIExecutionFactory.java:89) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.JDBCExecutionFactory.translate(JDBCExecutionFactory.java:539) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.pi.PIExecutionFactory.translate(PIExecutionFactory.java:260) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:111) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.visit(SQLStringVisitor.java:834) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.visit(SQLConversionVisitor.java:306) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.DerivedColumn.acceptVisitor(DerivedColumn.java:47) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:106) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.visit(SQLStringVisitor.java:767) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.Select.acceptVisitor(Select.java:110) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.TranslatedCommand.translateCommand(TranslatedCommand.java:76) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.JDBCBaseExecution.translateCommand(JDBCBaseExecution.java:120) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:114) [translator-jdbc-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_141]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_141]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_141]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_141]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy79.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_141]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_141]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_141]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_141]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
7 years, 1 month