10:56 a.m.
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union
select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:47 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://jira.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins commented on TEIID-1283:
---------------------------------------
In your example, is r.next returning true with the very next getString call failing? That
should never happen regardless of the underlying plan. Then next call should only return
true if the row has been loaded by the client otherwise it will block until the next or no
more rows are available.
Can you provide more of your JDBC code and the query plan from "set showplan
on"?
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:40 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://jira.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin.s...
]
Howard Abrams commented on TEIID-1283:
--------------------------------------
Sorry for the delay; I wasn't notified of your comment.
Here is the actual code, but I don't think it will be any more help than my example
code:
PreparedStatement prep = this.connection.prepareStatement("SELECT
name, visibleName, headerTemplate FROM metadata.objects WHERE name=?");
prep.setString(1, name);
ResultSet r = prep.executeQuery();
if (r.next())
{
rval.setName(r.getString(1));
Here is the query plan:
SortNode
+ Output Columns:
0: name (string)
1: visibleName (string)
2: headerTemplate (string)
+ Statistics:
0: Node Output Rows: 1
1: Node Process Time: 0
2: Node Cumulative Process Time: 0
3: Node Cumulative Next Batch Process Time: 2
4: Node Next Batch Calls: 2
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Child 0:
UnionAllNode
+ Output Columns:
0: name (string)
1: visibleName (string)
2: headerTemplate (string)
+ Statistics:
0: Node Output Rows: 1
1: Node Process Time: 0
2: Node Cumulative Process Time: 0
3: Node Cumulative Next Batch Process Time: 1
4: Node Next Batch Calls: 4
5: Node Blocks: 3
+ Child 0:
ProjectNode
+ Output Columns:
0: name (string)
1: visibleName (string)
2: headerTemplate (string)
+ Statistics:
0: Node Output Rows: 1
1: Node Process Time: 0
2: Node Cumulative Process Time: 2
3: Node Cumulative Next Batch Process Time: 1
4: Node Next Batch Calls: 2
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Child 0:
JoinNode
+ Output Columns:
0: name (string)
1: visibleName (string)
2: headerTemplate (string)
+ Statistics:
0: Node Output Rows: 1
1: Node Process Time: 1
2: Node Cumulative Process Time: 2
3: Node Cumulative Next Batch Process Time: 1
4: Node Next Batch Calls: 2
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Child 0:
ProjectNode
+ Output Columns:file (clob)
+ Statistics:
0: Node Output Rows: 1
1: Node Process Time: 0
2: Node Cumulative Process Time: 1
3: Node Cumulative Next Batch Process Time: 0
4: Node Next Batch Calls: 2
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Child 0:
AccessNode
+ Output Columns:
0: file (clob)
1: filePath (string)
+ Statistics:
0: Node Output Rows: 1
1: Node Process Time: 1
2: Node Cumulative Process Time: 1
3: Node Cumulative Next Batch Process Time: 0
4: Node Next Batch Calls: 2
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Query:EXEC file.getTextFiles('metadata-objects.txt')
+ Model Name:file
+ Select Columns:file.getTextFiles.ResultSet.file
+ Child 1:
SelectNode
+ Output Columns:
0: name (string)
1: visibleName (string)
2: headerTemplate (string)
+ Statistics:
0: Node Output Rows: 1
1: Node Process Time: 0
2: Node Cumulative Process Time: 1
3: Node Cumulative Next Batch Process Time: 1
4: Node Next Batch Calls: 1
5: Node Blocks: 0
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Child 0:
TextTableNode
+ Output Columns:
0: name (string)
1: visibleName (string)
2: headerTemplate (string)
+ Statistics:
0: Node Output Rows: 5
1: Node Process Time: 1
2: Node Cumulative Process Time: 1
3: Node Cumulative Next Batch Process Time: 1
4: Node Next Batch Calls: 1
5: Node Blocks: 0
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Criteria:OBJECTS.name = 'preferences.preference'
+ Join Strategy:NESTED TABLE JOIN
+ Join Type:CROSS JOIN
+ Join Criteria
+ Select Columns:
0: OBJECTS.name
1: OBJECTS.visibleName
2: OBJECTS.headerTemplate
+ Child 1:
AccessNode
+ Output Columns:
0: NAME (string)
1: VISIBLE_NAME (string)
2: HEADERTEMPLATE (string)
+ Statistics:
0: Node Output Rows: 0
1: Node Process Time: 0
2: Node Cumulative Process Time: 0
3: Node Cumulative Next Batch Process Time: 0
4: Node Next Batch Calls: 3
5: Node Blocks: 3
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Query:SELECT cia_metadata.CHORUS_META_OBJECT.NAME,
cia_metadata.CHORUS_META_OBJECT.VISIBLE_NAME,
cia_metadata.CHORUS_META_OBJECT.HEADERTEMPLATE FROM cia_metadata.CHORUS_META_OBJECT WHERE
cia_metadata.CHORUS_META_OBJECT.NAME = 'preferences.preference'
+ Model Name:cia_metadata
+ Sort Mode:DUP_REMOVE
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:26 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://jira.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins commented on TEIID-1283:
---------------------------------------
It looks like this can be caused if the first batch to the client contains only a single
row and the next batch has the wrong final row. I'll look into why that may be case.
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:38 a.m.
New subject: [JBoss JIRA] Work started: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://jira.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin.s...
]
Work on TEIID-1283 started by Steven Hawkins.
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:48 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://jira.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins commented on TEIID-1283:
---------------------------------------
I've applied some changes that may address this issue. I was never able to fully
reproduce, but I did see that we were returning a batch that should have indicated it was
the last and should have been making a better check of isAfterLast. Let me know if you
still see this in 7.2 beta1 or later.
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:14 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://jira.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin.s...
]
Howard Abrams commented on TEIID-1283:
--------------------------------------
It appears 7.2 does resolve the problem. Thanks!
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:19 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://jira.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin.s...
]
Steven Hawkins resolved TEIID-1283.
-----------------------------------
Fix Version/s: 7.1.1
Resolution: Done
marking as resolved
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://jira.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Fix For: 7.1.1
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:32 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1283) Race condition results in bad resultset for query on union
[
https://issues.jboss.org/browse/TEIID-1283?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1283.
---------------------------------
Race condition results in bad resultset for query on union
----------------------------------------------------------
Key: TEIID-1283
URL: https://issues.jboss.org/browse/TEIID-1283
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: MaxOS 10.6.4, JBoss 5.1.0
Reporter: Howard Abrams
Assignee: Steven Hawkins
Fix For: 7.1.1
Take a table, call it 'A', in a physical model backed by a database (DB2 on Z/OS
in this case)
Take a view, call it 'B', backed by a file connector
From JDBC, make the query:
Select * from (select * from A union select * from B) where foo='bar'.
where 'bar' is only found in B, not A.
Execute the query get back a resultset:
ResultSet r = statement.executeQuery();
but this code will fail with a "resultset cursor is after the last row"
if ( r.next )
String foo = r.getString(1);
but this code will work correctly:
Thread.sleep(1000);
if ( r.next )
String foo = r.getString(1);
Putting the union in a materialized view also works.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5018
days inactive
5119
days old
8 comments
2 participants
participants (2)
-
Howard Abrams (JIRA) -
Steven Hawkins (JIRA)