[
https://issues.apache.org/jira/browse/OOZIE-2321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14647181#comment-14647181
]
Shwetha G S commented on OOZIE-2321:
------------------------------------
Even with username, there can be many rows(especially for headless users).
Instead, we should limit len to some sane value and let users use pagination if
they need more results
> Disallow bulk query without jobid or username
> ---------------------------------------------
>
> Key: OOZIE-2321
> URL: https://issues.apache.org/jira/browse/OOZIE-2321
> Project: Oozie
> Issue Type: Bug
> Reporter: Purshotam Shah
>
> {code}
> Class Name | Shallow Heap | Retained
> Heap
> --------------------------------------------------------------------------------
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af9bf8| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af9aa0| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af9948| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af97f0| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af9698| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af9540| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af93e8| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af9290| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af4478| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af4320| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af41c8| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af4070| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af3f18| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af3dc0| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af3c68| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af3b10| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af39b8| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af3860| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af1200| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8af10a8| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8ad9ad0| 160 | > 0
> org.apache.oozie.CoordinatorJobBean @ 0x7d8ad9978| 160 | > 0
> Total: 22 of 1,220,400 entries; 1,220,378 more | |
>
> --------------------------------------------------------------------------------
> {code}
> We noticed user issuing query like
> /oozie/v2/jobs?jobtype=coord&offset=0&len=1000000 which load 1,220,400 jobs
> into memory, causing memory spike.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
