[teiid-issues] [JBoss JIRA] (TEIID-5525) add a flag to revert to the prior behavior (TEIID-4557)

[Ramesh Reddy (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13655547#comment-13655547 ] 

Ramesh Reddy commented on TEIID-5525:
-------------------------------------

Is disk also a limitation with the above issue? I did not realize there is per query disk limitation. The right solution we either revert above or not seems to be when the query gets to a stage with the above limitation, reducing the buffer/batch sizes to half and try again, not sure if that is possible though with query processor.

> add a flag to revert to the prior behavior (TEIID-4557)
> -------------------------------------------------------
>
>                 Key: TEIID-5525
>                 URL: https://issues.jboss.org/browse/TEIID-5525
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.12.14.6_4, 8.12.15.6_4
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.0, 11.2.1
>
>
> Several customers are seeing errors[1] after https://issues.jboss.org/browse/TEIID-4557 was implemented and generally have to drop the max-active-plans to 1 for their queries to succeed.  Can a flag be added to revert to the behavior prior to TEIID-4557?
> [1]
> ERROR [org.teiid.PROCESSOR] TEIID30019 Unexpected exception for request rcX003UtoyEg.0: org.teiid.core.TeiidComponentException: TEIID31261 Max estimated size 4,963,628,721 for a single operation/table id 85 has been exceeded.  The server may need to increase the amount of disk or memory available, or decrease the number of max active plans.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)