Bug 1130985
| Summary: | Exception with unclear message | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Juraj Duráni <jdurani> | ||||||||
| Component: | Teiid | Assignee: | Van Halbert <vhalbert> | ||||||||
| Status: | CLOSED DUPLICATE | QA Contact: | |||||||||
| Severity: | unspecified | Docs Contact: | |||||||||
| Priority: | unspecified | ||||||||||
| Version: | 6.0.0 | CC: | vhalbert | ||||||||
| Target Milestone: | --- | ||||||||||
| Target Release: | 6.1.0 | ||||||||||
| Hardware: | x86_64 | ||||||||||
| OS: | Linux | ||||||||||
| Whiteboard: | |||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||
| Doc Text: | Story Points: | --- | |||||||||
| Clone Of: | Environment: | ||||||||||
| Last Closed: | 2014-08-18 12:53:03 UTC | Type: | Bug | ||||||||
| Regression: | --- | Mount Type: | --- | ||||||||
| Documentation: | --- | CRM: | |||||||||
| Verified Versions: | Category: | --- | |||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||
| Embargoed: | |||||||||||
| Attachments: |
|
||||||||||
Created attachment 927806 [details]
java application exception stack trace
Created attachment 927807 [details]
Server log after query
Steven Hawkins <shawkins> updated the status of jira TEIID-3085 to Resolved *** This bug has been marked as a duplicate of bug 1131020 *** Steven Hawkins <shawkins> updated the status of jira TEIID-3085 to Closed |
Created attachment 927805 [details] Full server log. Description of problem: Unexpected exception. Returned exception indicates that query failed but there is no reason in message. Version-Release number of selected component (if applicable): How reproducible: Source databse - Greenplum VDB view model - BQT1 tables: smalla - `INTKEY` integer primary key, `STRINGKEY` varing(10), `INTNUM` integer, `STRINGNUM` varing(10), `FLOATNUM` real, `LONGNUM` bigint, `DOUBLENUM` double, `BYTENUM` smallint, `DATEVALUE` date, `TIMEVALUE` time, `TIMESTAMPVALUE` timestamp, `BOOLEANVALUE` boolean, `CHARVALUE` character(1), `SHORTVALUE` smallint, `BIGINTEGERVALUE` bigint, `BIGDECIMALVALUE` decimal(10,0), `OBJECTVALUE` bytea SQL Query - SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a Steps to Reproduce: 1. 2. 3. Actual results: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."timevalue", cast(g_0."bytenum" AS smallint), (SELECT g_1."floatnum" FROM "smalla" AS g_1 WHERE g_1."intkey" = g_0."intkey" AND g_1."intkey" = (SELECT g_2."intkey" FROM "smalla" AS g_2 WHERE g_2."stringnum" > '10' AND g_2."intkey" = g_1."intkey")) FROM "smalla" AS g_0] Expected results: Remote org.postgresql.util.PSQLException: ERROR: Interconnect Error: Unexpected Motion Node Id: 2. This means a motion node that wasn't setup is requesting interconnect resources. Additional info: Log and exception stack trace in attachment.