]
Steven Hawkins updated TEIID-5564:
----------------------------------
Fix Version/s: 11.1.2
Batch removed during large temp table load
------------------------------------------
Key: TEIID-5564
URL:
https://issues.jboss.org/browse/TEIID-5564
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
Fix For: 11.1.2, 12.0, 11.2.2
For a sufficiently large temp operation, such as a merge over 2.5 million rows, you can
see:
java.lang.AssertionError: Batch not found in storage 58804
at
org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:382)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
at org.teiid.common.buffer.SPage.getValues(SPage.java:240)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
at org.teiid.common.buffer.SPage.search(SPage.java:139)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
at org.teiid.common.buffer.STree.find(STree.java:249)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
at org.teiid.common.buffer.STree.remove(STree.java:429)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
at org.teiid.query.tempdata.TempTable.deleteTuple(TempTable.java:802)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
at org.teiid.query.tempdata.TempTable.access$500(TempTable.java:83)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
at
org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.undo(TempTable.java:159)
[teiid-engine-8.12.16.6_4-redhat-64-2.jar:8.12.16.6_4-redhat-64-2]
Which occurs during undo/rollback of an operation and masks the underlying exception.
The actual error will typically be the same as TEIID-5439, the proactive removal of the
managed batches once a space limit has been reached.
This did not occur after the TEIID-5439 fix upstream, but it appears it could have still
occurred - and did occur on 8.12.x.