[JBoss JIRA] (TEIID-2377) Query results are lost
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2377?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2377:
---------------------------------------
This seems more like a forum question rather than a issue. Also the stackTrace attachment shows no stackTraces. The approach when there is any doubt about an issue would be to narrow things down first:
1. ideally reproduce on 8.2 or preferably using 8.3 Beta1/latest
2. try reproducing with a smaller form of the query (removing views or higher level limit/order bys)
3. Examine the query plan to understand the execution flow
3.a. When you have two similar scenarios compare the two logs at a detail/trace level to see all of the relevant source counts and other information
- note that from your snippet, which I presume is from the second query, shows 18 rows returned from the source:
END SRC COMMAND: endTime=2013-02-04 23:01:45.113 requestID=5L+SB5Q54KWY.44 sourceCommandID=4 txID=null modelName=datapipe translatorName=datapipe.delegated-translator sessionID=5L+SB5Q54KWY principal=admin@chorus-login-security finalRowCount=18
etc.
In this particular case it simply appears that you are duplicating the limit/offset at multiple levels of your query. You are first pushing down limit 18, 18 and thus fetching 18 rows, then on the top level query applying limit 18, 18 again - which due to the 18 offset will not return any results.
> Query results are lost
> -----------------------
>
> Key: TEIID-2377
> URL: https://issues.jboss.org/browse/TEIID-2377
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.1
> Reporter: Vineela Gampa
> Assignee: Steven Hawkins
> Attachments: stackTrace.txt
>
>
> Hi Steve,
> We are seeing some problem incase of one usecase.
> 1)User issues a query - and server issues a query
> SELECT chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age, 'demodata.user' AS "__objecttype__" FROM (EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18', ?)) AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS sysid string, userid string, name string, phone string, zip string, age biginteger, salary bigdecimal, CHORUS_H_healthstate integer, CHORUS_C_notesForObject integer, "__objecttype__" string) AS chorus_results LIMIT 18
> 2)User scrolls down the page to fetch more results
> SELECT chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age, 'demodata.user' AS "__objecttype__" FROM (EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18, 18', ?)) AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS sysid string, userid string, name string, phone string, zip string, age biginteger, salary bigdecimal, CHORUS_H_healthstate integer, CHORUS_C_notesForObject integer, "__objecttype__" string) AS chorus_results LIMIT 18, 18
> Above queries are issues using preparedstatement.exuecute . We are calling a translator storedproc which inturn executes a asynchronous (submitExecute) query to fetch the results and store 100 records in temptable.Incase of 1 we get the results normally . Incase of 2 as the data is already stored in temptables we execute results against temptable. From the logs its evident that teiid processed the data. But the resultset output from ps.ExecuteQuery has resultset of size 0.
> Any idea of what could be hapennign would greatly help. Will attach the entire log for the second query.
> snippet of logs
> 04 Feb 2013 23:01:45,092 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Creating TupleBuffer: 1483 [chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.Integer, class java.lang.String, class java.math.BigInteger] of type PROCESSOR
> 04 Feb 2013 23:01:45,094 PST DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue2395) 5L+SB5Q54KWY.44.4.1084 Processing Close : EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18, 18', '[]')
> 04 Feb 2013 23:01:45,102 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Removing TupleBuffer: 1483
> 04 Feb 2013 23:01:45,113 PST DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue2395) END SRC COMMAND: endTime=2013-02-04 23:01:45.113 requestID=5L+SB5Q54KWY.44 sourceCommandID=4 txID=null modelName=datapipe translatorName=datapipe.delegated-translator sessionID=5L+SB5Q54KWY principal=admin@chorus-login-security finalRowCount=18
> 04 Feb 2013 23:01:45,114 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Creating TupleBuffer: 1484 [chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.Integer, class java.lang.String, class java.math.BigInteger] of type PROCESSOR
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-2377) Query results are lost
by Vineela Gampa (JIRA)
[ https://issues.jboss.org/browse/TEIID-2377?page=com.atlassian.jira.plugin... ]
Vineela Gampa updated TEIID-2377:
---------------------------------
Attachment: stackTrace.txt
> Query results are lost
> -----------------------
>
> Key: TEIID-2377
> URL: https://issues.jboss.org/browse/TEIID-2377
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.1
> Reporter: Vineela Gampa
> Assignee: Steven Hawkins
> Attachments: stackTrace.txt
>
>
> Hi Steve,
> We are seeing some problem incase of one usecase.
> 1)User issues a query - and server issues a query
> SELECT chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age, 'demodata.user' AS "__objecttype__" FROM (EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18', ?)) AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS sysid string, userid string, name string, phone string, zip string, age biginteger, salary bigdecimal, CHORUS_H_healthstate integer, CHORUS_C_notesForObject integer, "__objecttype__" string) AS chorus_results LIMIT 18
> 2)User scrolls down the page to fetch more results
> SELECT chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age, 'demodata.user' AS "__objecttype__" FROM (EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18, 18', ?)) AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS sysid string, userid string, name string, phone string, zip string, age biginteger, salary bigdecimal, CHORUS_H_healthstate integer, CHORUS_C_notesForObject integer, "__objecttype__" string) AS chorus_results LIMIT 18, 18
> Above queries are issues using preparedstatement.exuecute . We are calling a translator storedproc which inturn executes a asynchronous (submitExecute) query to fetch the results and store 100 records in temptable.Incase of 1 we get the results normally . Incase of 2 as the data is already stored in temptables we execute results against temptable. From the logs its evident that teiid processed the data. But the resultset output from ps.ExecuteQuery has resultset of size 0.
> Any idea of what could be hapennign would greatly help. Will attach the entire log for the second query.
> snippet of logs
> 04 Feb 2013 23:01:45,092 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Creating TupleBuffer: 1483 [chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.Integer, class java.lang.String, class java.math.BigInteger] of type PROCESSOR
> 04 Feb 2013 23:01:45,094 PST DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue2395) 5L+SB5Q54KWY.44.4.1084 Processing Close : EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18, 18', '[]')
> 04 Feb 2013 23:01:45,102 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Removing TupleBuffer: 1483
> 04 Feb 2013 23:01:45,113 PST DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue2395) END SRC COMMAND: endTime=2013-02-04 23:01:45.113 requestID=5L+SB5Q54KWY.44 sourceCommandID=4 txID=null modelName=datapipe translatorName=datapipe.delegated-translator sessionID=5L+SB5Q54KWY principal=admin@chorus-login-security finalRowCount=18
> 04 Feb 2013 23:01:45,114 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Creating TupleBuffer: 1484 [chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.Integer, class java.lang.String, class java.math.BigInteger] of type PROCESSOR
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-2377) Query results are lost
by Vineela Gampa (JIRA)
Vineela Gampa created TEIID-2377:
------------------------------------
Summary: Query results are lost
Key: TEIID-2377
URL: https://issues.jboss.org/browse/TEIID-2377
Project: Teiid
Issue Type: Bug
Affects Versions: 8.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Hi Steve,
We are seeing some problem incase of one usecase.
1)User issues a query - and server issues a query
SELECT chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age, 'demodata.user' AS "__objecttype__" FROM (EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18', ?)) AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS sysid string, userid string, name string, phone string, zip string, age biginteger, salary bigdecimal, CHORUS_H_healthstate integer, CHORUS_C_notesForObject integer, "__objecttype__" string) AS chorus_results LIMIT 18
2)User scrolls down the page to fetch more results
SELECT chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age, 'demodata.user' AS "__objecttype__" FROM (EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18, 18', ?)) AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS sysid string, userid string, name string, phone string, zip string, age biginteger, salary bigdecimal, CHORUS_H_healthstate integer, CHORUS_C_notesForObject integer, "__objecttype__" string) AS chorus_results LIMIT 18, 18
Above queries are issues using preparedstatement.exuecute . We are calling a translator storedproc which inturn executes a asynchronous (submitExecute) query to fetch the results and store 100 records in temptable.Incase of 1 we get the results normally . Incase of 2 as the data is already stored in temptables we execute results against temptable. From the logs its evident that teiid processed the data. But the resultset output from ps.ExecuteQuery has resultset of size 0.
Any idea of what could be hapennign would greatly help. Will attach the entire log for the second query.
snippet of logs
04 Feb 2013 23:01:45,092 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Creating TupleBuffer: 1483 [chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.Integer, class java.lang.String, class java.math.BigInteger] of type PROCESSOR
04 Feb 2013 23:01:45,094 PST DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue2395) 5L+SB5Q54KWY.44.4.1084 Processing Close : EXEC data_window('SELECT CHORUS_H_healthstate, userid, sysid, CHORUS_C_notesForObject, name, age, ''demodata.user'' AS "__objecttype__" FROM (SELECT /*+sh:''data_window'' */ CHORUS_B.*, (SELECT COALESCE(MIN(healthstatefkey), 10) FROM healthstatestream.latest_health_states WHERE latest_health_states.objfkeyxml = replace(primary_key(''demodata.user'', ''userid'', cast(CHORUS_B.userid AS String), ''sysid'', cast(CHORUS_B.sysid AS String)), ''"'', '''''''')) AS CHORUS_H_healthstate, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = primary_key(''demodata.user'', ''userid'', CHORUS_B.userid, ''sysid'', CHORUS_B.sysid)) AS foo) AS CHORUS_C_notesForObject, ''demodata.user'' AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM demodata."user") AS CHORUS_B, (SELECT * FROM chorus_time.timetable WHERE period = 30000) AS chorus_refresh_expression) AS CHORUS_B LIMIT 100) AS CHORUS_B LIMIT 18, 18', '[]')
04 Feb 2013 23:01:45,102 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Removing TupleBuffer: 1483
04 Feb 2013 23:01:45,113 PST DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue2395) END SRC COMMAND: endTime=2013-02-04 23:01:45.113 requestID=5L+SB5Q54KWY.44 sourceCommandID=4 txID=null modelName=datapipe translatorName=datapipe.delegated-translator sessionID=5L+SB5Q54KWY principal=admin@chorus-login-security finalRowCount=18
04 Feb 2013 23:01:45,114 PST DEBUG [org.teiid.BUFFER_MGR] (http--127.0.0.1-8080-2) Creating TupleBuffer: 1484 [chorus_results.CHORUS_H_healthstate, chorus_results.userid, chorus_results.sysid, chorus_results.CHORUS_C_notesForObject, chorus_results.name, chorus_results.age] [class java.lang.Integer, class java.lang.String, class java.lang.String, class java.lang.Integer, class java.lang.String, class java.math.BigInteger] of type PROCESSOR
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-2376) NPE when executinga a query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2376?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2376.
-----------------------------------
Resolution: Duplicate Issue
Dup of TEIID-2358 - please provide a reproducible scenario there if possible.
> NPE when executinga a query
> ---------------------------
>
> Key: TEIID-2376
> URL: https://issues.jboss.org/browse/TEIID-2376
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.1
> Reporter: Vineela Gampa
> Assignee: Steven Hawkins
>
> Message1: org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113) org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70) org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402) org.teiid.jdbc.ResultSetImpl.access$000(ResultSetImpl.java:63) org.teiid.jdbc.ResultSetImpl$1.onCompletion(ResultSetImpl.java:230) org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130) org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37) org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75) org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:808) org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:483) org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:318) org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) java.lang.Thread.run(Thread.java:779) Caused by: org.teiid.core.TeiidException org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172) org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:806) org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:483) org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:318) org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) java.lang.Thread.run(Thread.java:779) Caused by: java.lang.NullPointerException org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy$SingleTupleSource.get(EnhancedSortMergeJoinStrategy.java:79) org.teiid.query.processor.relational.ListNestedSortComparator.compare(ListNestedSortComparator.java:149) org.teiid.query.processor.relational.ListNestedSortComparator.compare(ListNestedSortComparator.java:59) java.util.Collections.indexedBinarySearch(Collections.java:388) java.util.Collections.binarySearch(Collections.java:376) org.teiid.common.buffer.SPage.search(SPage.java:140) org.teiid.common.buffer.STree.find(STree.java:245) org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:144) org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:203) org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:377) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82) org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91) org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:149) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:90) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82) org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:247) org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:184) org.teiid.query.processor.relational.SourceState.sort(SourceState.java:211) org.teiid.query.processor.relational.MergeJoinStrategy.loadRight(MergeJoinStrategy.java:345) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:198) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:90) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:89) org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:374) org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:318) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:174) org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:186) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82) org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91) org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:149) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148) org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146) org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112) org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382) org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291) org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) java.lang.Thread.run(Thread.java:779)
> org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:...
> Version:
> 3.0.1-SNAPSHOT [Production (Build 3490); 2013/02/04 15:00; vm9444]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-2376) NPE when executinga a query
by Vineela Gampa (JIRA)
Vineela Gampa created TEIID-2376:
------------------------------------
Summary: NPE when executinga a query
Key: TEIID-2376
URL: https://issues.jboss.org/browse/TEIID-2376
Project: Teiid
Issue Type: Bug
Affects Versions: 8.1
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Message1: org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113) org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70) org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402) org.teiid.jdbc.ResultSetImpl.access$000(ResultSetImpl.java:63) org.teiid.jdbc.ResultSetImpl$1.onCompletion(ResultSetImpl.java:230) org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130) org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37) org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75) org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:808) org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:483) org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:318) org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) java.lang.Thread.run(Thread.java:779) Caused by: org.teiid.core.TeiidException org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172) org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:806) org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:483) org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:318) org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) java.lang.Thread.run(Thread.java:779) Caused by: java.lang.NullPointerException org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy$SingleTupleSource.get(EnhancedSortMergeJoinStrategy.java:79) org.teiid.query.processor.relational.ListNestedSortComparator.compare(ListNestedSortComparator.java:149) org.teiid.query.processor.relational.ListNestedSortComparator.compare(ListNestedSortComparator.java:59) java.util.Collections.indexedBinarySearch(Collections.java:388) java.util.Collections.binarySearch(Collections.java:376) org.teiid.common.buffer.SPage.search(SPage.java:140) org.teiid.common.buffer.STree.find(STree.java:245) org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:144) org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:203) org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:377) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82) org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91) org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:149) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:90) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82) org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:247) org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:184) org.teiid.query.processor.relational.SourceState.sort(SourceState.java:211) org.teiid.query.processor.relational.MergeJoinStrategy.loadRight(MergeJoinStrategy.java:345) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:198) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:90) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:89) org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:374) org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:318) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:174) org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:186) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82) org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91) org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:149) org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148) org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146) org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112) org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382) org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291) org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219) org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249) org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) java.lang.Thread.run(Thread.java:779)
org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:...
Version:
3.0.1-SNAPSHOT [Production (Build 3490); 2013/02/04 15:00; vm9444]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months
[JBoss JIRA] (TEIID-1854) OData server
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1854?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-1854:
-------------------------------------
Implemented the $skiptoken functionality based on resultset caching; What I have seen other implementations do is they never have session affinity to keep track of single result set based on logged in user. Teiid implementation also does not force the user to keep the session tracking, but if the same user (based on http basic, can also easily be user name token) logged in with skip token, since original results are stored using user scoped cache, it will fetch next batch from it. If the results are expired then it will fetch from source again and reposition the cursor. If the results are expired and source is queried again there is no guarantee that same set of results are returned. If there is no ordering specified on the query the key based ordering is used on the results so that absolute positions can be used on the result sets.
Also odata transport is added with defined security-domain to be used by the odata calls.
remaining todo is ALL functionality before I can close this out.
> OData server
> ------------
>
> Key: TEIID-1854
> URL: https://issues.jboss.org/browse/TEIID-1854
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Mark Addleman
> Assignee: Ramesh Reddy
> Fix For: 8.3
>
>
> Teiid should act as an OData server as well as a JDBC server. This is not TEIID-1757 as that is about Teiid being an OData client.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months