You are viewing a plain text version of this content. The canonical link for it is here.
Posted to infrastructure-issues@apache.org by "Kathey Marsden (Created) (JIRA)" <ji...@apache.org> on 2011/10/13 00:45:12 UTC
[jira] [Created] (INFRA-4026) Jira no longer allows export of more
than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
--------------------------------------------------------------------------------------------------------------------------------------------------
Key: INFRA-4026
URL: https://issues.apache.org/jira/browse/INFRA-4026
Project: Infrastructure
Issue Type: Bug
Security Level: public (Regular issues)
Components: JIRA
Reporter: Kathey Marsden
Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
e.g.
https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
now yields an error:
HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
type Status report
message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
Can you please restore the previous defaults so the data dump can occur ?
.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (INFRA-4026) Jira no longer allows export of
more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Mark Thomas (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126754#comment-13126754 ]
Mark Thomas commented on INFRA-4026:
------------------------------------
No-one should have been running queries that pull anywhere near that many issues in a single hit from the ASF Jira instance. Had the infra team been aware that the Derby community was actively encouraging users to do this then the ability to do this would have been shut down a long time ago. The Derby community was fully aware what it was doing was unreasonable as demonstrated by the "Do not do this too often as it is hard on Apache infrastructure." text on the wiki page describing this. The more I discover about what has been going on, the less sympathy I have for the problems that this limit is causing. There are plenty of ways the Derby community could have achieved the same result without placing any unnecessary strain on the ASF infrastructure.
The infrastructure team will continue to apply upgrades to Jira as they are published. Significant upgrades / changes will be notified to the community and an opportunity provided for testing (as was the case with the 3.x to 4.x upgrade). Other upgrades will be applied as volunteer effort is available - typically the weekend after any new release - and as security requirements demand. If you wish to receive more detailed information on any changes then Atlassian publishes detailed release notes with every release that I encourage you to read.
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (INFRA-4026) Jira no longer allows export of
more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Kristian Waagan (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126442#comment-13126442 ]
Kristian Waagan commented on INFRA-4026:
----------------------------------------
What's the primary reason behind the limitation?
Is it to reduce the load on the JIRA (CPU, memory, IO of the JIRA process and/or the database back end), to reduce the network bandwidth usage, or to protect JIRA against "queries gone wild"?
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (INFRA-4026) Jira no longer allows export of
more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Mark Thomas (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126718#comment-13126718 ]
Mark Thomas commented on INFRA-4026:
------------------------------------
The limit is not going to be removed. If you are updating the data every 4 months or so, then pull the data in 4 month blocks and then concatenate locally.
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (INFRA-4026) Jira no longer allows export of
more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126737#comment-13126737 ]
Kathey Marsden commented on INFRA-4026:
---------------------------------------
Well, I don't thin concatenate will really work, but the Derby community is talking about what to do about the demo. It would have been good to address the issue with our current release, but too late now. Individuals will scramble as they find things broken and cope.
If it is necessary to remove/change/restrict functionality in the future, heads up would be most appreciated and some notice most welcome.
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (INFRA-4026) Jira no longer allows export of
more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Mark Thomas (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126443#comment-13126443 ]
Mark Thomas commented on INFRA-4026:
------------------------------------
Yes to all of the above.
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (INFRA-4026) Jira no longer allows export of more
than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Gavin (Closed) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gavin closed INFRA-4026.
------------------------
Resolution: Won't Fix
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (INFRA-4026) Jira no longer allows export of
more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Kathey Marsden (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126714#comment-13126714 ]
Kathey Marsden commented on INFRA-4026:
---------------------------------------
I don't do this every day but maybe two or three times a year and then run extensive queries locally using the exported data, certainly much less pressure on Jira than run those queries against Jira itself.
Is there a way to run standard SQL queries against Jira? The querying ability in Jira seems to have improved with JQL but I don't see a standard SQL interface yet? Still i would be limited to the 1000 results, so probably not practical to use.
Whatever the new solution for each of us individually, it seems like it would be appropriate if restricting capabilities to give some notice. How about putting it back for three months and make an announcement that you will limit to 1000 Jan 15, 2012? This way people can have a chance to adjust their tooling dependent on the functionality instead of having this hit by surprise during very busy times.
Thank you for your consideration.
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (INFRA-4026) Jira no longer allows export of
more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a
result set of more than 1000 results.
Posted by "Gavin (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126240#comment-13126240 ]
Gavin commented on INFRA-4026:
------------------------------
No.
Please see the infrastructure mailing list archives where this was recently discussed.
quoting that "Re-write the query to retrieve just recent changes (i.e. those since the last query) rather than querying for every change since the beginning of the project every day."
HTH
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: INFRA-4026
> URL: https://issues.apache.org/jira/browse/INFRA-4026
> Project: Infrastructure
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: JIRA
> Reporter: Kathey Marsden
>
> Occasionally I will export the DERBY Jira issues so I can perform queries on them with Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports. Once the issues are dumped I can run lots of analytic queries with the VTI without taxing Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been reduced to 1000.
> e.g.
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira