[JBoss JIRA] (TEIID-2524) Hive metadata import leaves white characters in table name
by Filip Nguyen (JIRA)
[ https://issues.jboss.org/browse/TEIID-2524?page=com.atlassian.jira.plugin... ]
Filip Nguyen commented on TEIID-2524:
-------------------------------------
No, the chosen name is not meant to include whitespaces. Table name is just randomly appended with trailing whitespaces when the metadata are retrieved using the hive DESCRIBE.
> Hive metadata import leaves white characters in table name
> ----------------------------------------------------------
>
> Key: TEIID-2524
> URL: https://issues.jboss.org/browse/TEIID-2524
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
>
> When hive translator starts with the newest Hive it runs "describe" command which returns Hive table names with white spaces.
> Maybe just use trim() in HiveMetadataProcessor.java?
> String name = rs.getString(1).trim();
--
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, 6 months
[JBoss JIRA] (TEIID-2525) Prefetch exception with small fetch size
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2525?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2525.
-----------------------------------
Labels: 8.4CR2 (was: )
Fix Version/s: 8.4
Resolution: Done
The issue occurs when the fetch size is a smaller non-divisor of the batch size in prefetch scenarios - as the prefetched batch is inappropriately being ignored leading to effectively duplicate fetches, which are not allowed under forward-only.
Corrected the client logic to not ignore the prefetch batch and also updated the server to send a better partial batch in forward-only.
> Prefetch exception with small fetch size
> ----------------------------------------
>
> Key: TEIID-2525
> URL: https://issues.jboss.org/browse/TEIID-2525
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.4, 7.7.7
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
> Priority: Critical
> Labels: 8.4CR2
> Fix For: 8.4
>
>
> Doesn't work both in the newest Teiid and the 7.x version.
> Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2]. I run the query on oracle (select * from XYZ limit 11).
> {code:java}
> TeiidDataSource ds = new TeiidDataSource();
> ds.setDatabaseName(vdb);
> ds.setUser("user");
> ds.setPassword("user");
> ds.setServerName(host);
> ds.setPortNumber(Integer.valueOf(port));
> ds.setFetchSize(10);
> ....
> Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
> {code}
> [2]
> {code:java}
> Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
> at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
> at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
> at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
> at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
> at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
> at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
> at JDBCClient.execute(JDBCClient.java:90)
> at JDBCClient.main(JDBCClient.java:45)
> Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
> at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
> 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:722)
> Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> {code}
--
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, 6 months
[JBoss JIRA] (TEIID-2526) When VDB re-deployed with same version the the OData metadata does not reflect the new VDB metadata
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2526?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-2526.
---------------------------------
Labels: CR2 (was: )
Resolution: Done
Since OData is web based application + it does not have any session affinity it is ignorant of the VDB reloads, thus the original issue. There is clean way do this unless there is some kind event monitoring we can listen on.
The solution is elected does check the metadata store of the VDB every "skiptoken-cache-time" which is defaulted at 5 mins to refresh to the updated metadata. The user always has option to re-cycle the server to get to the updated metadata immediately. The same skiptoken value is also used for results cursoring when using OData. The skiptoken out value is also configurable.
Since VDB reloads are not common in the runtime environments, this should be acceptable solution
> When VDB re-deployed with same version the the OData metadata does not reflect the new VDB metadata
> ---------------------------------------------------------------------------------------------------
>
> Key: TEIID-2526
> URL: https://issues.jboss.org/browse/TEIID-2526
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.3
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Labels: CR2
> Fix For: 8.4
>
>
> When the same named VDB is re-deployed with same version as before, the call to
> http://host:port/odata/vdb/$metadata
> does not reflect the new metadata of the re-deployed VDB
--
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, 6 months
[JBoss JIRA] (TEIID-2521) Create a Security Guide
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2521?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2521:
-------------------------------------
No, for designing the 'custom login module' for Teiid, the security domain name needs to be configured in the 'transport' section of the teiid subsystem.
for ex:
{code}
<transport name="jdbc" protocol="teiid" socket-binding="teiid-jdbc">
<authentication security-domain="my-security-module"/>
</transport>
{code}
> Create a Security Guide
> -----------------------
>
> Key: TEIID-2521
> URL: https://issues.jboss.org/browse/TEIID-2521
> Project: Teiid
> Issue Type: Enhancement
> Components: Documentation
> Affects Versions: 8.4
> Reporter: B Long
> Assignee: Steven Hawkins
> Priority: Trivial
> Fix For: 8.4
>
> Original Estimate: 0 minutes
> Remaining Estimate: 0 minutes
>
> Create a Security Guide incorporating security sections from the Administrator's Guide and Developer's Guide.
--
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, 6 months
[JBoss JIRA] (TEIID-2525) Prefetch exception with small fetch size
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2525?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2525:
----------------------------------
Summary: Prefetch exception with small fetch size (was: Prefetch doesn't work when clause contains LIMIT keyword)
Description:
Doesn't work both in the newest Teiid and the 7.x version.
Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2]. I run the query on oracle (select * from XYZ limit 11).
{code:java}
TeiidDataSource ds = new TeiidDataSource();
ds.setDatabaseName(vdb);
ds.setUser("user");
ds.setPassword("user");
ds.setServerName(host);
ds.setPortNumber(Integer.valueOf(port));
ds.setFetchSize(10);
....
Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
{code}
[2]
{code:java}
Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
at JDBCClient.execute(JDBCClient.java:90)
at JDBCClient.main(JDBCClient.java:45)
Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
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:722)
Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
{code}
was:
Doesn't work both in the newest Teiid and the 7.x version.
Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2] when using LIMIT clause in the SQL. I run the query on oracle (select * from XYZ limit 11).
{code:java}
TeiidDataSource ds = new TeiidDataSource();
ds.setDatabaseName(vdb);
ds.setUser("user");
ds.setPassword("user");
ds.setServerName(host);
ds.setPortNumber(Integer.valueOf(port));
ds.setFetchSize(10);
....
Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
{code}
[2]
{code:java}
Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
at JDBCClient.execute(JDBCClient.java:90)
at JDBCClient.main(JDBCClient.java:45)
Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
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:722)
Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
{code}
A regression with TEIID-2504 that will need backported as well.
> Prefetch exception with small fetch size
> ----------------------------------------
>
> Key: TEIID-2525
> URL: https://issues.jboss.org/browse/TEIID-2525
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.4, 7.7.7
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
> Priority: Critical
>
> Doesn't work both in the newest Teiid and the 7.x version.
> Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2]. I run the query on oracle (select * from XYZ limit 11).
> {code:java}
> TeiidDataSource ds = new TeiidDataSource();
> ds.setDatabaseName(vdb);
> ds.setUser("user");
> ds.setPassword("user");
> ds.setServerName(host);
> ds.setPortNumber(Integer.valueOf(port));
> ds.setFetchSize(10);
> ....
> Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
> {code}
> [2]
> {code:java}
> Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
> at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
> at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
> at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
> at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
> at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
> at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
> at JDBCClient.execute(JDBCClient.java:90)
> at JDBCClient.main(JDBCClient.java:45)
> Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
> at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
> 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:722)
> Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> {code}
--
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, 6 months
[JBoss JIRA] (TEIID-2525) Prefetch doesn't work when clause contains LIMIT keyword
by Filip Nguyen (JIRA)
[ https://issues.jboss.org/browse/TEIID-2525?page=com.atlassian.jira.plugin... ]
Filip Nguyen updated TEIID-2525:
--------------------------------
Description:
Doesn't work both in the newest Teiid and the 7.x version.
Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2] when using LIMIT clause in the SQL. I run the query on oracle (select * from XYZ limit 11).
{code:java}
TeiidDataSource ds = new TeiidDataSource();
ds.setDatabaseName(vdb);
ds.setUser("user");
ds.setPassword("user");
ds.setServerName(host);
ds.setPortNumber(Integer.valueOf(port));
ds.setFetchSize(10);
....
Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
{code}
[2]
{code:java}
Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
at JDBCClient.execute(JDBCClient.java:90)
at JDBCClient.main(JDBCClient.java:45)
Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
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:722)
Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
{code}
was:
Doesn't work both in the newest Teiid and the 7.x version.
Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2] when using LIMIT clause in the SQL.
{code:java}
TeiidDataSource ds = new TeiidDataSource();
ds.setDatabaseName(vdb);
ds.setUser("user");
ds.setPassword("user");
ds.setServerName(host);
ds.setPortNumber(Integer.valueOf(port));
ds.setFetchSize(10);
....
Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
{code}
[2]
{code:java}
Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
at JDBCClient.execute(JDBCClient.java:90)
at JDBCClient.main(JDBCClient.java:45)
Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
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:722)
Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
{code}
> Prefetch doesn't work when clause contains LIMIT keyword
> --------------------------------------------------------
>
> Key: TEIID-2525
> URL: https://issues.jboss.org/browse/TEIID-2525
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.4, 7.7.7
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
> Priority: Critical
>
> Doesn't work both in the newest Teiid and the 7.x version.
> Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2] when using LIMIT clause in the SQL. I run the query on oracle (select * from XYZ limit 11).
> {code:java}
> TeiidDataSource ds = new TeiidDataSource();
> ds.setDatabaseName(vdb);
> ds.setUser("user");
> ds.setPassword("user");
> ds.setServerName(host);
> ds.setPortNumber(Integer.valueOf(port));
> ds.setFetchSize(10);
> ....
> Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
> {code}
> [2]
> {code:java}
> Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
> at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
> at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
> at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
> at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
> at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
> at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
> at JDBCClient.execute(JDBCClient.java:90)
> at JDBCClient.main(JDBCClient.java:45)
> Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
> at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
> 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:722)
> Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> {code}
--
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, 6 months
[JBoss JIRA] (TEIID-2525) Prefetch doesn't work when clause contains LIMIT keyword
by Filip Nguyen (JIRA)
[ https://issues.jboss.org/browse/TEIID-2525?page=com.atlassian.jira.plugin... ]
Filip Nguyen commented on TEIID-2525:
-------------------------------------
Please note that the fetch size must be <= number in the limit clause.
> Prefetch doesn't work when clause contains LIMIT keyword
> --------------------------------------------------------
>
> Key: TEIID-2525
> URL: https://issues.jboss.org/browse/TEIID-2525
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.4, 7.7.7
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
> Priority: Critical
>
> Doesn't work both in the newest Teiid and the 7.x version.
> Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2] when using LIMIT clause in the SQL.
> {code:java}
> TeiidDataSource ds = new TeiidDataSource();
> ds.setDatabaseName(vdb);
> ds.setUser("user");
> ds.setPassword("user");
> ds.setServerName(host);
> ds.setPortNumber(Integer.valueOf(port));
> ds.setFetchSize(10);
> ....
> Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
> {code}
> [2]
> {code:java}
> Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
> at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
> at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
> at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
> at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
> at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
> at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
> at JDBCClient.execute(JDBCClient.java:90)
> at JDBCClient.main(JDBCClient.java:45)
> Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
> at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
> 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:722)
> Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> {code}
--
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, 6 months
[JBoss JIRA] (TEIID-2525) Prefetch doesn't work when clause contains LIMIT keyword
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2525?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-2525:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=970056
> Prefetch doesn't work when clause contains LIMIT keyword
> --------------------------------------------------------
>
> Key: TEIID-2525
> URL: https://issues.jboss.org/browse/TEIID-2525
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.4, 7.7.7
> Reporter: Filip Nguyen
> Assignee: Steven Hawkins
> Priority: Critical
>
> Doesn't work both in the newest Teiid and the 7.x version.
> Not sure how critical this is. When setting the prefetch via JDBC and using FORWARD_ONLY result set [1] I am getting exceptions [2] when using LIMIT clause in the SQL.
> {code:java}
> TeiidDataSource ds = new TeiidDataSource();
> ds.setDatabaseName(vdb);
> ds.setUser("user");
> ds.setPassword("user");
> ds.setServerName(host);
> ds.setPortNumber(Integer.valueOf(port));
> ds.setFetchSize(10);
> ....
> Statement statement = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
> {code}
> [2]
> {code:java}
> Eorg.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)
> at org.teiid.jdbc.ResultSetImpl.requestBatch(ResultSetImpl.java:375)
> at org.teiid.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:226)
> at org.teiid.jdbc.BatchResults.requestNextBatch(BatchResults.java:141)
> at org.teiid.jdbc.BatchResults.hasNext(BatchResults.java:252)
> at org.teiid.jdbc.ResultSetImpl.hasNext(ResultSetImpl.java:439)
> at org.teiid.jdbc.ResultSetImpl.next(ResultSetImpl.java:251)
> at JDBCClient.execute(JDBCClient.java:90)
> at JDBCClient.main(JDBCClient.java:45)
> Caused by: org.teiid.core.TeiidException: ASSERTION FAILED: expected reference to be not null
> at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:202)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:955)
> at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
> 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:722)
> Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:305)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:782)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
> {code}
--
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, 6 months