[JBoss JIRA] (TEIIDSB-33) Change the example to use Spring boot Actuator to use the health checks
by Ramesh Reddy (Jira)
Ramesh Reddy created TEIIDSB-33:
-----------------------------------
Summary: Change the example to use Spring boot Actuator to use the health checks
Key: TEIIDSB-33
URL: https://issues.jboss.org/browse/TEIIDSB-33
Project: Teiid Spring Boot
Issue Type: Enhancement
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
The example uses the /$metadata API to check the liveness and readiness checks, this should be moved to use Actuator from Spring Boot.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIIDSB-24) Image security integration
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-24?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reassigned TEIIDSB-24:
-----------------------------------
Assignee: Ramesh Reddy
> Image security integration
> --------------------------
>
> Key: TEIIDSB-24
> URL: https://issues.jboss.org/browse/TEIIDSB-24
> Project: Teiid Spring Boot
> Issue Type: Sub-task
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: Q119
>
>
> Security integration has multiple considerations. From the parent issue TEIIDSB-23 we can just utilize 3scale for the initial securitization of rest services. However the usage of data roles, whether over rest or a driver needs proper role mapping.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIIDSB-19) Create Portfolio Example
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-19?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIIDSB-19:
-------------------------------------
But also in all honesty here we would like to highlight the deployment portion of the VDB into OpenShift not necessarily Teiid features (as we have other places we do this), so using the current example might suffice too.
> Create Portfolio Example
> ------------------------
>
> Key: TEIIDSB-19
> URL: https://issues.jboss.org/browse/TEIIDSB-19
> Project: Teiid Spring Boot
> Issue Type: Task
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Major
>
> - Portfolio example project that includes a representative sample of all resources a user might interact with (application.properties, VDB DDL, data source definitions, beans, etc.)
> - Portfolio example project delivered via GitHub
> - README documentation instructing a user on how to build and deploy Portfolio example
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIIDSB-19) Create Portfolio Example
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-19?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIIDSB-19:
-------------------------------------
I was hoping we create use case to showcase the federation, maybe converting the one we have is fine with me or separate one is also good.
> Create Portfolio Example
> ------------------------
>
> Key: TEIIDSB-19
> URL: https://issues.jboss.org/browse/TEIIDSB-19
> Project: Teiid Spring Boot
> Issue Type: Task
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Major
>
> - Portfolio example project that includes a representative sample of all resources a user might interact with (application.properties, VDB DDL, data source definitions, beans, etc.)
> - Portfolio example project delivered via GitHub
> - README documentation instructing a user on how to build and deploy Portfolio example
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIIDSB-31) Convert the example VDB to be defined using DDL
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-31?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIIDSB-31.
---------------------------------
Fix Version/s: 1.0.3
Resolution: Done
> Convert the example VDB to be defined using DDL
> -----------------------------------------------
>
> Key: TEIIDSB-31
> URL: https://issues.jboss.org/browse/TEIIDSB-31
> Project: Teiid Spring Boot
> Issue Type: Sub-task
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.0.3
>
>
> The VDB that is defined using xml should be converted to using DDL to define the VDB.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-4418) Pushdown of a correlated with clause contains wrong correlated reference
by Johnathon Lee (Jira)
[ https://issues.jboss.org/browse/TEIID-4418?page=com.atlassian.jira.plugin... ]
Johnathon Lee updated TEIID-4418:
---------------------------------
Fix Version/s: 8.12.17.6_4
> Pushdown of a correlated with clause contains wrong correlated reference
> ------------------------------------------------------------------------
>
> Key: TEIID-4418
> URL: https://issues.jboss.org/browse/TEIID-4418
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 9.1, 8.12.17.6_4
>
>
> A query such as:
> {code}
> select e1, e2 from pm1.g2 where e1 = (with CTE1 as /*+ no_inline */ (SELECT pm1.g2.e1 from pm1.g1) select e1 from CTE1)
> {code}
> will pushdown as:
> {code}
> SELECT g_0.e1, g_0.e2 FROM g2 AS g_0 WHERE g_0.e1 = (WITH CTE1 (e1) AS (SELECT g2.e1 AS expr1 FROM g1 AS g_0) SELECT g_1.e1 FROM CTE1 AS g_1)
> {code}
> Note the incorrect g2.e1 reference.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5655) sqlalchemy/superset does not work
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5655?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5655.
-----------------------------------
Resolution: Done
Sorry I put the wrong resolved version, it should be 11.2.3. None of these are released yet. There should be a master snapshot built tomorrow, or you may build from any of the fix branches as well.
> sqlalchemy/superset does not work
> ---------------------------------
>
> Key: TEIID-5655
> URL: https://issues.jboss.org/browse/TEIID-5655
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 11.0
> Environment: Docker jboss/teiid:latest
> Reporter: luca gioppo
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.1, 12.0.1, 11.2.3
>
>
> I have a TEIID docker container working with a VDB installed and trying to access it through superset.
> It seems that it manages to connect but cannot retrieve metadata information:
> error on TEIID is the following:
> {code:java}
> 14:37:26,443 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.443 requestID=InB1qhclEodo.0 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,444 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.444 requestID=InB1qhclEodo.0 txID=null sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,445 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.445 requestID=InB1qhclEodo.1 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT t.oid, NULL
> FROM pg_type t JOIN pg_namespace ns
> ON typnamespace = ns.oid
> WHERE typname = 'hstore'
> 14:37:26,448 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue551) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.448 requestID=InB1qhclEodo.2 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,449 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue551) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.449 requestID=InB1qhclEodo.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34a status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,450 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue552) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.45 requestID=InB1qhclEodo.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34a status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=0
> 14:37:26,450 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.45 requestID=InB1qhclEodo.3 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select version()
> 14:37:26,452 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue554) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.452 requestID=InB1qhclEodo.3 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,452 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.452 requestID=InB1qhclEodo.4 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT ''
> 14:37:26,453 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue556) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.453 requestID=InB1qhclEodo.4 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,454 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.454 requestID=InB1qhclEodo.5 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
> 14:37:26,455 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue558) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.455 requestID=InB1qhclEodo.5 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,455 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.455 requestID=InB1qhclEodo.6 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
> 14:37:26,458 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue560) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.458 requestID=InB1qhclEodo.6 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,460 DEBUG [org.teiid.COMMAND_LOG] (NIO3) fAwN5yLRkx4H START USER COMMAND: startTime=2019-02-11 14:37:26.46 requestID=fAwN5yLRkx4H.0 txID=null sessionID=fAwN5yLRkx4H applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,461 DEBUG [org.teiid.COMMAND_LOG] (NIO3) fAwN5yLRkx4H END USER COMMAND: endTime=2019-02-11 14:37:26.461 requestID=fAwN5yLRkx4H.0 txID=null sessionID=fAwN5yLRkx4H principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,462 DEBUG [org.teiid.COMMAND_LOG] (NIO3) fAwN5yLRkx4H START USER COMMAND: startTime=2019-02-11 14:37:26.462 requestID=fAwN5yLRkx4H.1 txID=null sessionID=fAwN5yLRkx4H applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT c.oid
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
> WHERE (n.nspname = 'ViewModel')
> AND c.relname = 'countries' AND c.relkind in ('r', 'v', 'm', 'f')
> 14:37:26,466 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue561) fAwN5yLRkx4H START USER COMMAND: startTime=2019-02-11 14:37:26.466 requestID=fAwN5yLRkx4H.2 txID=null sessionID=fAwN5yLRkx4H applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,467 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue561) fAwN5yLRkx4H END USER COMMAND: endTime=2019-02-11 14:37:26.467 requestID=fAwN5yLRkx4H.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:350 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=fAwN5yLRkx4H principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,468 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue562) fAwN5yLRkx4H END USER COMMAND: endTime=2019-02-11 14:37:26.468 requestID=fAwN5yLRkx4H.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:350 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=fAwN5yLRkx4H principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,471 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.471 requestID=r0qH9ETfzvCM.0 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,472 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.472 requestID=r0qH9ETfzvCM.0 txID=null sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,473 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.473 requestID=r0qH9ETfzvCM.1 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT a.attname,
> pg_catalog.format_type(a.atttypid, a.atttypmod),
> (SELECT pg_catalog.pg_get_expr(d.adbin, d.adrelid)
> FROM pg_catalog.pg_attrdef d
> WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum
> AND a.atthasdef)
> AS DEFAULT,
> a.attnotnull, a.attnum, a.attrelid as table_oid,
> pgd.description as comment
> FROM pg_catalog.pg_attribute a
> LEFT JOIN pg_catalog.pg_description pgd ON (
> pgd.objoid = a.attrelid AND pgd.objsubid = a.attnum)
> WHERE a.attrelid = 33
> AND a.attnum > 0 AND NOT a.attisdropped
> ORDER BY a.attnum
> 14:37:26,495 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.495 requestID=r0qH9ETfzvCM.-3371315444994726912 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,497 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.497 requestID=r0qH9ETfzvCM.-2569683003037246464 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,499 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.499 requestID=r0qH9ETfzvCM.-760253570742753280 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,501 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.501 requestID=r0qH9ETfzvCM.-1144088098515236864 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,504 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.504 requestID=r0qH9ETfzvCM.-4500981364408287232 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,507 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.507 requestID=r0qH9ETfzvCM.-4578430080951506944 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,508 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.508 requestID=r0qH9ETfzvCM.-7781261662498164736 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,509 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.509 requestID=r0qH9ETfzvCM.-8862428592286505984 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,511 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.511 requestID=r0qH9ETfzvCM.-1326429883415938048 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,512 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.512 requestID=r0qH9ETfzvCM.-2514831200636129280 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,514 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.514 requestID=r0qH9ETfzvCM.-1599350125892356096 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,520 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.518 requestID=r0qH9ETfzvCM.2 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,520 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.52 requestID=r0qH9ETfzvCM.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,521 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.521 requestID=r0qH9ETfzvCM.3 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,521 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.521 requestID=r0qH9ETfzvCM.3 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,521 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.521 requestID=r0qH9ETfzvCM.4 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,522 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.522 requestID=r0qH9ETfzvCM.4 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,522 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.522 requestID=r0qH9ETfzvCM.5 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,523 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.523 requestID=r0qH9ETfzvCM.5 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,523 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.523 requestID=r0qH9ETfzvCM.6 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,523 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.523 requestID=r0qH9ETfzvCM.6 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,525 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue564) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.525 requestID=r0qH9ETfzvCM.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=11
> 14:37:26,525 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.525 requestID=r0qH9ETfzvCM.-3371315444994726912 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-2569683003037246464 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-760253570742753280 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-1144088098515236864 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-4500981364408287232 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-4578430080951506944 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-7781261662498164736 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-8862428592286505984 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-1326429883415938048 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-2514831200636129280 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-1599350125892356096 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,527 DEBUG [org.teiid.COMMAND_LOG] (NIO5) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.527 requestID=iFzmjQNMXOvc.0 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,528 DEBUG [org.teiid.COMMAND_LOG] (NIO5) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.528 requestID=iFzmjQNMXOvc.0 txID=null sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,530 DEBUG [org.teiid.COMMAND_LOG] (NIO5) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.53 requestID=iFzmjQNMXOvc.1 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT t.typname as "name",
> pg_catalog.format_type(t.typbasetype, t.typtypmod) as "attype",
> not t.typnotnull as "nullable",
> t.typdefault as "default",
> pg_catalog.pg_type_is_visible(t.oid) as "visible",
> n.nspname as "schema"
> FROM pg_catalog.pg_type t
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
> WHERE t.typtype = 'd'
> 14:37:26,533 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.533 requestID=iFzmjQNMXOvc.2 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,534 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.534 requestID=iFzmjQNMXOvc.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,534 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.534 requestID=iFzmjQNMXOvc.3 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,535 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.535 requestID=iFzmjQNMXOvc.3 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,535 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.535 requestID=iFzmjQNMXOvc.4 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,535 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.535 requestID=iFzmjQNMXOvc.4 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,536 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue566) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.536 requestID=iFzmjQNMXOvc.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=0
> 14:37:26,539 DEBUG [org.teiid.COMMAND_LOG] (NIO6) o/ZspOAKOAQq START USER COMMAND: startTime=2019-02-11 14:37:26.539 requestID=o/ZspOAKOAQq.0 txID=null sessionID=o/ZspOAKOAQq applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,540 DEBUG [org.teiid.COMMAND_LOG] (NIO6) o/ZspOAKOAQq END USER COMMAND: endTime=2019-02-11 14:37:26.54 requestID=o/ZspOAKOAQq.0 txID=null sessionID=o/ZspOAKOAQq principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,544 DEBUG [org.teiid.COMMAND_LOG] (NIO7) 2bY7LmYVew3V START USER COMMAND: startTime=2019-02-11 14:37:26.543 requestID=2bY7LmYVew3V.0 txID=null sessionID=2bY7LmYVew3V applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,544 DEBUG [org.teiid.COMMAND_LOG] (NIO7) 2bY7LmYVew3V END USER COMMAND: endTime=2019-02-11 14:37:26.544 requestID=2bY7LmYVew3V.0 txID=null sessionID=2bY7LmYVew3V principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,546 DEBUG [org.teiid.COMMAND_LOG] (NIO7) 2bY7LmYVew3V START USER COMMAND: startTime=2019-02-11 14:37:26.546 requestID=2bY7LmYVew3V.1 txID=null sessionID=2bY7LmYVew3V applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT c.oid
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
> WHERE (n.nspname = 'ViewModel')
> AND c.relname = 'countries' AND c.relkind in ('r', 'v', 'm', 'f')
> 14:37:26,550 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue567) 2bY7LmYVew3V START USER COMMAND: startTime=2019-02-11 14:37:26.55 requestID=2bY7LmYVew3V.2 txID=null sessionID=2bY7LmYVew3V applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,551 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue567) 2bY7LmYVew3V END USER COMMAND: endTime=2019-02-11 14:37:26.551 requestID=2bY7LmYVew3V.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:359 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=2bY7LmYVew3V principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,552 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue568) 2bY7LmYVew3V END USER COMMAND: endTime=2019-02-11 14:37:26.552 requestID=2bY7LmYVew3V.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:359 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=2bY7LmYVew3V principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,555 DEBUG [org.teiid.COMMAND_LOG] (NIO8) P/Da0+l55xke START USER COMMAND: startTime=2019-02-11 14:37:26.555 requestID=P/Da0+l55xke.0 txID=null sessionID=P/Da0+l55xke applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,555 DEBUG [org.teiid.COMMAND_LOG] (NIO8) P/Da0+l55xke END USER COMMAND: endTime=2019-02-11 14:37:26.555 requestID=P/Da0+l55xke.0 txID=null sessionID=P/Da0+l55xke principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,557 DEBUG [org.teiid.COMMAND_LOG] (NIO8) P/Da0+l55xke START USER COMMAND: startTime=2019-02-11 14:37:26.557 requestID=P/Da0+l55xke.1 txID=null sessionID=P/Da0+l55xke applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT
> i.relname as relname,
> ix.indisunique, ix.indexprs, ix.indpred,
> a.attname, a.attnum, NULL, ix.indkey,
> i.reloptions, am.amname
> FROM
> pg_class t
> join pg_index ix on t.oid = ix.indrelid
> join pg_class i on i.oid = ix.indexrelid
> left outer join
> pg_attribute a
> on t.oid = a.attrelid and a.attnum = ANY(ix.indkey)
> left outer join
> pg_am am
> on i.relam = am.oid
> WHERE
> t.relkind IN ('r', 'v', 'f', 'm')
> and t.oid = 33
> and ix.indisprimary = 'f'
> ORDER BY
> t.relname,
> i.relname
> 14:37:26,560 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue569) P/Da0+l55xke ERROR USER COMMAND: endTime=2019-02-11 14:37:26.56 requestID=P/Da0+l55xke.1 txID=null sessionID=P/Da0+l55xke principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,560 ERROR [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue569) P/Da0+l55xke TEIID30019 Unexpected exception for request P/Da0+l55xke.1: java.lang.NullPointerException
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:571)
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:193)
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:174)
> at org.teiid.query.rewriter.QueryRewriter.evaluateCriteria(QueryRewriter.java:1347)
> at org.teiid.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:1041)
> at org.teiid.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:979)
> at org.teiid.query.optimizer.relational.rules.JoinUtil.isNullDependent(JoinUtil.java:144)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.isCriteriaValid(RulePlanOuterJoins.java:218)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.checkLeftOrdering(RulePlanOuterJoins.java:344)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.planLeftOuterJoinAssociativityBeforePlanning(RulePlanOuterJoins.java:251)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.execute(RulePlanOuterJoins.java:62)
> at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:1025)
> at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:228)
> at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:458)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:672)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:351)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> 14:37:26,561 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue569) P/Da0+l55xke END USER COMMAND: endTime=2019-02-11 14:37:26.561 requestID=P/Da0+l55xke.1 txID=null sessionID=P/Da0+l55xke principal=user vdbName=micado vdbVersion=1 finalRowCount=-1
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIID-5655) sqlalchemy/superset does not work
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5655?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5655:
----------------------------------
Fix Version/s: 11.2.3
(was: 11.2.2)
> sqlalchemy/superset does not work
> ---------------------------------
>
> Key: TEIID-5655
> URL: https://issues.jboss.org/browse/TEIID-5655
> Project: Teiid
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 11.0
> Environment: Docker jboss/teiid:latest
> Reporter: luca gioppo
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.1, 12.0.1, 11.2.3
>
>
> I have a TEIID docker container working with a VDB installed and trying to access it through superset.
> It seems that it manages to connect but cannot retrieve metadata information:
> error on TEIID is the following:
> {code:java}
> 14:37:26,443 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.443 requestID=InB1qhclEodo.0 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,444 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.444 requestID=InB1qhclEodo.0 txID=null sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,445 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.445 requestID=InB1qhclEodo.1 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT t.oid, NULL
> FROM pg_type t JOIN pg_namespace ns
> ON typnamespace = ns.oid
> WHERE typname = 'hstore'
> 14:37:26,448 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue551) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.448 requestID=InB1qhclEodo.2 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,449 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue551) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.449 requestID=InB1qhclEodo.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34a status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,450 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue552) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.45 requestID=InB1qhclEodo.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34a status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=0
> 14:37:26,450 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.45 requestID=InB1qhclEodo.3 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select version()
> 14:37:26,452 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue554) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.452 requestID=InB1qhclEodo.3 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,452 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.452 requestID=InB1qhclEodo.4 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT ''
> 14:37:26,453 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue556) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.453 requestID=InB1qhclEodo.4 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,454 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.454 requestID=InB1qhclEodo.5 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
> 14:37:26,455 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue558) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.455 requestID=InB1qhclEodo.5 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,455 DEBUG [org.teiid.COMMAND_LOG] (NIO2) InB1qhclEodo START USER COMMAND: startTime=2019-02-11 14:37:26.455 requestID=InB1qhclEodo.6 txID=null sessionID=InB1qhclEodo applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
> 14:37:26,458 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue560) InB1qhclEodo END USER COMMAND: endTime=2019-02-11 14:37:26.458 requestID=InB1qhclEodo.6 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:34d status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=InB1qhclEodo principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,460 DEBUG [org.teiid.COMMAND_LOG] (NIO3) fAwN5yLRkx4H START USER COMMAND: startTime=2019-02-11 14:37:26.46 requestID=fAwN5yLRkx4H.0 txID=null sessionID=fAwN5yLRkx4H applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,461 DEBUG [org.teiid.COMMAND_LOG] (NIO3) fAwN5yLRkx4H END USER COMMAND: endTime=2019-02-11 14:37:26.461 requestID=fAwN5yLRkx4H.0 txID=null sessionID=fAwN5yLRkx4H principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,462 DEBUG [org.teiid.COMMAND_LOG] (NIO3) fAwN5yLRkx4H START USER COMMAND: startTime=2019-02-11 14:37:26.462 requestID=fAwN5yLRkx4H.1 txID=null sessionID=fAwN5yLRkx4H applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT c.oid
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
> WHERE (n.nspname = 'ViewModel')
> AND c.relname = 'countries' AND c.relkind in ('r', 'v', 'm', 'f')
> 14:37:26,466 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue561) fAwN5yLRkx4H START USER COMMAND: startTime=2019-02-11 14:37:26.466 requestID=fAwN5yLRkx4H.2 txID=null sessionID=fAwN5yLRkx4H applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,467 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue561) fAwN5yLRkx4H END USER COMMAND: endTime=2019-02-11 14:37:26.467 requestID=fAwN5yLRkx4H.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:350 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=fAwN5yLRkx4H principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,468 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue562) fAwN5yLRkx4H END USER COMMAND: endTime=2019-02-11 14:37:26.468 requestID=fAwN5yLRkx4H.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:350 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=fAwN5yLRkx4H principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,471 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.471 requestID=r0qH9ETfzvCM.0 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,472 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.472 requestID=r0qH9ETfzvCM.0 txID=null sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,473 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.473 requestID=r0qH9ETfzvCM.1 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT a.attname,
> pg_catalog.format_type(a.atttypid, a.atttypmod),
> (SELECT pg_catalog.pg_get_expr(d.adbin, d.adrelid)
> FROM pg_catalog.pg_attrdef d
> WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum
> AND a.atthasdef)
> AS DEFAULT,
> a.attnotnull, a.attnum, a.attrelid as table_oid,
> pgd.description as comment
> FROM pg_catalog.pg_attribute a
> LEFT JOIN pg_catalog.pg_description pgd ON (
> pgd.objoid = a.attrelid AND pgd.objsubid = a.attnum)
> WHERE a.attrelid = 33
> AND a.attnum > 0 AND NOT a.attisdropped
> ORDER BY a.attnum
> 14:37:26,495 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.495 requestID=r0qH9ETfzvCM.-3371315444994726912 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,497 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.497 requestID=r0qH9ETfzvCM.-2569683003037246464 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,499 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.499 requestID=r0qH9ETfzvCM.-760253570742753280 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,501 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.501 requestID=r0qH9ETfzvCM.-1144088098515236864 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,504 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.504 requestID=r0qH9ETfzvCM.-4500981364408287232 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,507 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.507 requestID=r0qH9ETfzvCM.-4578430080951506944 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,508 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.508 requestID=r0qH9ETfzvCM.-7781261662498164736 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,509 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.509 requestID=r0qH9ETfzvCM.-8862428592286505984 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,511 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.511 requestID=r0qH9ETfzvCM.-1326429883415938048 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,512 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.512 requestID=r0qH9ETfzvCM.-2514831200636129280 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,514 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.514 requestID=r0qH9ETfzvCM.-1599350125892356096 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select typname from pg_catalog.pg_type where oid = ?
> 14:37:26,520 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.518 requestID=r0qH9ETfzvCM.2 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,520 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.52 requestID=r0qH9ETfzvCM.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,521 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.521 requestID=r0qH9ETfzvCM.3 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,521 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.521 requestID=r0qH9ETfzvCM.3 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,521 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.521 requestID=r0qH9ETfzvCM.4 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,522 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.522 requestID=r0qH9ETfzvCM.4 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,522 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.522 requestID=r0qH9ETfzvCM.5 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,523 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.523 requestID=r0qH9ETfzvCM.5 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,523 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM START USER COMMAND: startTime=2019-02-11 14:37:26.523 requestID=r0qH9ETfzvCM.6 txID=null sessionID=r0qH9ETfzvCM applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,523 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue563) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.523 requestID=r0qH9ETfzvCM.6 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,525 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue564) r0qH9ETfzvCM END USER COMMAND: endTime=2019-02-11 14:37:26.525 requestID=r0qH9ETfzvCM.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=11
> 14:37:26,525 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.525 requestID=r0qH9ETfzvCM.-3371315444994726912 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-2569683003037246464 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-760253570742753280 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-1144088098515236864 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-4500981364408287232 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-4578430080951506944 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-7781261662498164736 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-8862428592286505984 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-1326429883415938048 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-2514831200636129280 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,526 DEBUG [org.teiid.COMMAND_LOG] (NIO4) r0qH9ETfzvCM CANCEL USER COMMAND: endTime=2019-02-11 14:37:26.526 requestID=r0qH9ETfzvCM.-1599350125892356096 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:353 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=r0qH9ETfzvCM principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,527 DEBUG [org.teiid.COMMAND_LOG] (NIO5) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.527 requestID=iFzmjQNMXOvc.0 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,528 DEBUG [org.teiid.COMMAND_LOG] (NIO5) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.528 requestID=iFzmjQNMXOvc.0 txID=null sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,530 DEBUG [org.teiid.COMMAND_LOG] (NIO5) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.53 requestID=iFzmjQNMXOvc.1 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT t.typname as "name",
> pg_catalog.format_type(t.typbasetype, t.typtypmod) as "attype",
> not t.typnotnull as "nullable",
> t.typdefault as "default",
> pg_catalog.pg_type_is_visible(t.oid) as "visible",
> n.nspname as "schema"
> FROM pg_catalog.pg_type t
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
> WHERE t.typtype = 'd'
> 14:37:26,533 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.533 requestID=iFzmjQNMXOvc.2 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,534 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.534 requestID=iFzmjQNMXOvc.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,534 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.534 requestID=iFzmjQNMXOvc.3 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,535 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.535 requestID=iFzmjQNMXOvc.3 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,535 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc START USER COMMAND: startTime=2019-02-11 14:37:26.535 requestID=iFzmjQNMXOvc.4 txID=null sessionID=iFzmjQNMXOvc applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,535 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue565) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.535 requestID=iFzmjQNMXOvc.4 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,536 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue566) iFzmjQNMXOvc END USER COMMAND: endTime=2019-02-11 14:37:26.536 requestID=iFzmjQNMXOvc.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:356 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=iFzmjQNMXOvc principal=user vdbName=micado vdbVersion=1 finalRowCount=0
> 14:37:26,539 DEBUG [org.teiid.COMMAND_LOG] (NIO6) o/ZspOAKOAQq START USER COMMAND: startTime=2019-02-11 14:37:26.539 requestID=o/ZspOAKOAQq.0 txID=null sessionID=o/ZspOAKOAQq applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,540 DEBUG [org.teiid.COMMAND_LOG] (NIO6) o/ZspOAKOAQq END USER COMMAND: endTime=2019-02-11 14:37:26.54 requestID=o/ZspOAKOAQq.0 txID=null sessionID=o/ZspOAKOAQq principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,544 DEBUG [org.teiid.COMMAND_LOG] (NIO7) 2bY7LmYVew3V START USER COMMAND: startTime=2019-02-11 14:37:26.543 requestID=2bY7LmYVew3V.0 txID=null sessionID=2bY7LmYVew3V applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,544 DEBUG [org.teiid.COMMAND_LOG] (NIO7) 2bY7LmYVew3V END USER COMMAND: endTime=2019-02-11 14:37:26.544 requestID=2bY7LmYVew3V.0 txID=null sessionID=2bY7LmYVew3V principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,546 DEBUG [org.teiid.COMMAND_LOG] (NIO7) 2bY7LmYVew3V START USER COMMAND: startTime=2019-02-11 14:37:26.546 requestID=2bY7LmYVew3V.1 txID=null sessionID=2bY7LmYVew3V applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT c.oid
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
> WHERE (n.nspname = 'ViewModel')
> AND c.relname = 'countries' AND c.relkind in ('r', 'v', 'm', 'f')
> 14:37:26,550 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue567) 2bY7LmYVew3V START USER COMMAND: startTime=2019-02-11 14:37:26.55 requestID=2bY7LmYVew3V.2 txID=null sessionID=2bY7LmYVew3V applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select pg_catalog.getOid(SYS.Columns.TableUID), cast(SYS.Columns.Position as short), cast((select p.value from SYS.Properties p where p.name = 'pg_type:oid' and p.uid = SYS.Columns.uid) as integer) from SYS.Columns where Name = ? and TableName = ? and SchemaName = ?
> 14:37:26,551 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue567) 2bY7LmYVew3V END USER COMMAND: endTime=2019-02-11 14:37:26.551 requestID=2bY7LmYVew3V.2 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:359 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=2bY7LmYVew3V principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,552 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue568) 2bY7LmYVew3V END USER COMMAND: endTime=2019-02-11 14:37:26.552 requestID=2bY7LmYVew3V.1 txID=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffac1d0003:21e3de1a:5c6149ba:359 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) sessionID=2bY7LmYVew3V principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,555 DEBUG [org.teiid.COMMAND_LOG] (NIO8) P/Da0+l55xke START USER COMMAND: startTime=2019-02-11 14:37:26.555 requestID=P/Da0+l55xke.0 txID=null sessionID=P/Da0+l55xke applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=select teiid_session_set('resolve_groupby_positional', true)
> 14:37:26,555 DEBUG [org.teiid.COMMAND_LOG] (NIO8) P/Da0+l55xke END USER COMMAND: endTime=2019-02-11 14:37:26.555 requestID=P/Da0+l55xke.0 txID=null sessionID=P/Da0+l55xke principal=user vdbName=micado vdbVersion=1 finalRowCount=1
> 14:37:26,557 DEBUG [org.teiid.COMMAND_LOG] (NIO8) P/Da0+l55xke START USER COMMAND: startTime=2019-02-11 14:37:26.557 requestID=P/Da0+l55xke.1 txID=null sessionID=P/Da0+l55xke applicationName=ODBC principal=user vdbName=micado vdbVersion=1 sql=SELECT
> i.relname as relname,
> ix.indisunique, ix.indexprs, ix.indpred,
> a.attname, a.attnum, NULL, ix.indkey,
> i.reloptions, am.amname
> FROM
> pg_class t
> join pg_index ix on t.oid = ix.indrelid
> join pg_class i on i.oid = ix.indexrelid
> left outer join
> pg_attribute a
> on t.oid = a.attrelid and a.attnum = ANY(ix.indkey)
> left outer join
> pg_am am
> on i.relam = am.oid
> WHERE
> t.relkind IN ('r', 'v', 'f', 'm')
> and t.oid = 33
> and ix.indisprimary = 'f'
> ORDER BY
> t.relname,
> i.relname
> 14:37:26,560 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue569) P/Da0+l55xke ERROR USER COMMAND: endTime=2019-02-11 14:37:26.56 requestID=P/Da0+l55xke.1 txID=null sessionID=P/Da0+l55xke principal=user vdbName=micado vdbVersion=1 finalRowCount=null
> 14:37:26,560 ERROR [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue569) P/Da0+l55xke TEIID30019 Unexpected exception for request P/Da0+l55xke.1: java.lang.NullPointerException
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:571)
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:193)
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:174)
> at org.teiid.query.rewriter.QueryRewriter.evaluateCriteria(QueryRewriter.java:1347)
> at org.teiid.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:1041)
> at org.teiid.query.rewriter.QueryRewriter.rewriteCriteria(QueryRewriter.java:979)
> at org.teiid.query.optimizer.relational.rules.JoinUtil.isNullDependent(JoinUtil.java:144)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.isCriteriaValid(RulePlanOuterJoins.java:218)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.checkLeftOrdering(RulePlanOuterJoins.java:344)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.planLeftOuterJoinAssociativityBeforePlanning(RulePlanOuterJoins.java:251)
> at org.teiid.query.optimizer.relational.rules.RulePlanOuterJoins.execute(RulePlanOuterJoins.java:62)
> at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:1025)
> at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:228)
> at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:179)
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:458)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:672)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:351)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> 14:37:26,561 DEBUG [org.teiid.COMMAND_LOG] (Worker17_QueryProcessorQueue569) P/Da0+l55xke END USER COMMAND: endTime=2019-02-11 14:37:26.561 requestID=P/Da0+l55xke.1 txID=null sessionID=P/Da0+l55xke principal=user vdbName=micado vdbVersion=1 finalRowCount=-1
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIIDSB-19) Create Portfolio Example
by Van Halbert (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-19?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIIDSB-19:
----------------------------------
Assignee: Ramesh Reddy
> Create Portfolio Example
> ------------------------
>
> Key: TEIIDSB-19
> URL: https://issues.jboss.org/browse/TEIIDSB-19
> Project: Teiid Spring Boot
> Issue Type: Task
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Major
>
> - Portfolio example project that includes a representative sample of all resources a user might interact with (application.properties, VDB DDL, data source definitions, beans, etc.)
> - Portfolio example project delivered via GitHub
> - README documentation instructing a user on how to build and deploy Portfolio example
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0
[JBoss JIRA] (TEIIDSB-19) Create Portfolio Example
by Van Halbert (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-19?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIIDSB-19:
------------------------------------
With TEIIDSB-31 being completed, can this be marked resolved? Anything else you want done to the example?
> Create Portfolio Example
> ------------------------
>
> Key: TEIIDSB-19
> URL: https://issues.jboss.org/browse/TEIIDSB-19
> Project: Teiid Spring Boot
> Issue Type: Task
> Reporter: Van Halbert
> Priority: Major
>
> - Portfolio example project that includes a representative sample of all resources a user might interact with (application.properties, VDB DDL, data source definitions, beans, etc.)
> - Portfolio example project delivered via GitHub
> - README documentation instructing a user on how to build and deploy Portfolio example
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 10 months
- 1
- 0