[
https://issues.apache.org/jira/browse/TRAFODION-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16610183#comment-16610183
]
ASF GitHub Bot commented on TRAFODION-3192:
-------------------------------------------
GitHub user sandhyasun opened a pull request:
https://github.com/apache/trafodion/pull/1712
Follow on to [TRAFODION-3192] that caused one regression failure
Follow on to TRAFODION-3192 that caused one regression failure on Jenkins
alone since the queue resizing caused the executor/TEST106 that tests cancel to
not work as expected. The upsert subtest was running too fast to get cancelled.
So added some CQDs to use smaller queue sizes and override dynamic queue
resizing.Now it runs long enough like it used to to allow getting canceled and
give expected results.
Also reverted an inadvertant change to the NJ down queue size that was used
for debugging. Reverted it back to what it was (2048)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/trafodion sandhyas_queue_work
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1712.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1712
----
commit 859f071e7dd962e2c464461c16cc56a56935b72b
Author: Sandhya Sundaresan <sandhya@...>
Date: 2018-09-11T07:02:08Z
Follow on to TRAFODION-3192 that caused one regression failure on Jenkins
alone since the queue resizing caused the executor/TEST106 that tests cancel to
not work as expected. The upsert subtest was running too fast to get cancelled.
So added some CQds to use smaller queue sizes and override dynamic queue
resizing.Now it runs long enough to get canceled and give expected results.
----
> UNION ALL up and down queue size default value too small, or not dynamically
> adjusted
> -------------------------------------------------------------------------------------
>
> Key: TRAFODION-3192
> URL: https://issues.apache.org/jira/browse/TRAFODION-3192
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: any
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Priority: Major
> Fix For: 2.4
>
>
> The union up queue size is hardcoded in nadefaults.cpp as a start value as 16
> which
> is very low if large number of rows are being returned. Scan operator has it
> set to 2048.
> Some operators further adjust this up size from the original value based on
> estimate of
> the number of rows being returned. We can do that for union codegen method and
> also change the original up queue size to 2048.
>
> Noticed that Transpose, Sequence also have the same issue and dynamic queue
> resizing is missing.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
