10:29 a.m.
[
https://issues.jboss.org/browse/TEIID-1382?page=com.atlassian.jira.plugin...
]
Warren Gibson edited comment on TEIID-1382 at 1/27/11 11:28 AM:
----------------------------------------------------------------
1/27/2011- wgibson - Further testing shows the 4 vqt queries pass when db2v91 driver is
used and fail with db2v97 driver - example:
Scenario Pass Fail Total
Test v91 and v97 with v91 driver:
db2v91_vqt 1 0 1
db2v97_vqt 1 0 1
Test v91 and v97 with v97 driver:
db2v91_vqt 1 0 1
db2v97_vqt 0 1 1
This is what I find in the log:
2011-01-18 17:05:36,636 ERROR [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue4201)
Unexpected exception for session 2zl0rhpSMMx4
java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.58.82] Invalid
operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
at
org.teiid.dqp.internal.process.LobWorkItem.createLobStream(LobWorkItem.java:133)
at org.teiid.dqp.internal.process.LobWorkItem.run(LobWorkItem.java:71)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.58.82] Invalid
operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
at com.ibm.db2.jcc.am.ed.a(ed.java:660)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:94)
at com.ibm.db2.jcc.am.ee.d(ee.java:67)
at com.ibm.db2.jcc.am.fe.w(fe.java:203)
at com.ibm.db2.jcc.am.fe.getBinaryStream(fe.java:107)
at org.teiid.core.types.BlobType.getBinaryStream(BlobType.java:55)
at
org.teiid.dqp.internal.process.LobWorkItem.createLobStream(LobWorkItem.java:131)
... 7 more
was (Author: wgibson(a)jboss.org):
1/27/2011- wgibson - Further testing shows the 4 vqt queries pass when db2v91 driver
is used and fail with db2v97 driver - example:
Scenario Pass Fail Total
Test v91 and v97 with v91 driver:
db2v91_vqt 1 0 1
db2v97_vqt 1 0 1
Test v91 and v97 with v97 driver:
db2v91_vqt 1 0 1
db2v97_vqt 0 1 1
CTC test producing blank VQT errors but Squirrel does produce
expected results
-------------------------------------------------------------------------------
Key: TEIID-1382
URL: https://issues.jboss.org/browse/TEIID-1382
Project: Teiid
Issue Type: Bug
Components: Integration Tests
Reporter: Warren Gibson
Assignee: Van Halbert
Priority: Minor
4 vqt queries for DB2 97 are producting a blank XML error file.
Mapping S1001=SELECT * FROM VQT.Mapping1 ORDER BY IntKey
Mapping S1002=SELECT VQT.Mapping1.* FROM VQT.Mapping1 ORDER BY IntKey
Mapping S1003=SELECT * FROM VQT.Mapping1 AS X ORDER BY IntKey
Mapping S1004=SELECT X.* FROM VQT.Mapping1 AS X ORDER BY IntKey
An xml error file is being produced but it is completely blank. It should be noted when
I attempt to generate new test results they are also blank. The summary text
indicates the problem is related to Lob:
- Mapping1_Queries_Mapping1_S-1001~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
- Mapping1_Queries_Mapping1_S-1002~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
- Mapping1_Queries_Mapping1_S-1003~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
- Mapping1_Queries_Mapping1_S-1004~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
When I run the 4 queries in Squirrel I get results and they seem to match the expected
results so I think the queries are actually
returning the proper results. Therefore, I am marking this as a "Minor"
problem. It appears to be an issue with the query testing framework choking on Lob.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira