Project

General

Profile

Actions

Defect #12947

closed

Right-click does not work with more than thousand issues

Added by T Mac over 11 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Wont fix
Affected version:

Description

Right-click does not work with more than a certain number of issues, which is a bit problematic when updating lots of issues. Steps:

1 - Set number of issues to display to 1000
2 - Select all the 1000 issues
3 - Try right clicking (no context menu pops-up. You can barely see a "loading", but that's it.

Actions #1

Updated by Jan Niggemann (redmine.org team member) over 11 years ago

Wouldn't mass data changes be better done using SQL?

Actions #2

Updated by Etienne Massip over 11 years ago

Jan Niggemann wrote:

Wouldn't mass data changes be better done using SQL?

+1

BTW, please have a look into your production.log file.

If you don't have an error herein, it's likely that Redmine takes a lot of time to display the context menu, which seems ok given the amount of issue. Else I guess it's a 414/Request-URI Too Long.

Actions #3

Updated by T Mac over 11 years ago

Jan Niggemann wrote:

Wouldn't mass data changes be better done using SQL?

Agreed, but this was brought up by a manager that is not a programmer. Anyway, I checked my logs and the production log does not actually show the context menu request. Last think it shows is me changing the per page setting.

Started GET "/projects/vaone/issues?per_page=1000" for 192.168.0.117 at 2013-01-22 08:37:14 -0800
Processing by IssuesController#index as HTML
  Parameters: {"per_page"=>"1000", "project_id"=>"vaone"}
  Current user: mac (id=3)
  Rendered queries/_filters.html.erb (5.7ms)
  Rendered queries/_columns.html.erb (1.5ms)
  Rendered issues/_list.html.erb (1940.8ms)
  Rendered issues/_sidebar.html.erb (2.7ms)
  Rendered issues/index.html.erb within layouts/base (1959.8ms)
Completed 200 OK in 2614ms (Views: 1956.6ms | ActiveRecord: 72.6ms)

Looking at the apache log it does show the context menu request:

192.168.0.117 - - [22/Jan/2013:08:37:46 -0800] "GET /issues/context_menu?utf8=%E2%9C%93&authenticity_token=3E%2F0agDghioD0XqTBdhavFSXzZJaQf0x%2BL1aTUvIbvE%3D&back_url=%2Fprojects%2Fvaone%2Fissues%3Fper_page%3D1000&ids%5B%5D=10021&ids%5B%5D=10020&ids%5B%5D=10019&ids%5B%5D=10018&ids%5B%5D=10017&ids%5B%5D=10016&ids%5B%5D=10015&ids%5B%5D=10014&ids%5B%5D=10013&ids%5B%5D=10012&ids%5B%5D=10011&ids%5B%5D=10010&ids%5B%5D=10009&ids%5B%5D=10008&ids%5B%5D=10007&ids%5B%5D=10006&ids%5B%5D=10005&ids%5B%5D=10004&ids%5B%5D=10003&ids%5B%5D=10002&ids%5B%5D=10001&ids%5B%5D=10000&ids%5B%5D=9999&ids%5B%5D=9998&ids%5B%5D=9997&ids%5B%5D=9996&ids%5B%5D=9995&ids%5B%5D=9994&ids%5B%5D=9993&ids%5B%5D=9992&ids%5B%5D=9991&ids%5B%5D=9990&ids%5B%5D=9989&ids%5B%5D=9988&ids%5B%5D=9987&ids%5B%5D=9986&ids%5B%5D=9985&ids%5B%5D=9984&ids%5B%5D=9983&ids%5B%5D=9982&ids%5B%5D=9981&ids%5B%5D=9980&ids%5B%5D=9979&ids%5B%5D=9978&ids%5B%5D=9977&ids%5B%5D=9976&ids%5B%5D=9975&ids%5B%5D=9974&ids%5B%5D=9973&ids%5B%5D=9972&ids%5B%5D=9971&ids%5B%5D=9970&ids%5B%5D=9969&ids%5B%5D=9968&ids%5B%5D=9967&ids%5B%5D=9966&ids%5B%5D=9965&ids%5B%5D=9964&ids%5B%5D=9963&ids%5B%5D=9962&ids%5B%5D=9961&ids%5B%5D=9960&ids%5B%5D=9959&ids%5B%5D=9958&ids%5B%5D=9957&ids%5B%5D=9956&ids%5B%5D=9955&ids%5B%5D=9954&ids%5B%5D=9953&ids%5B%5D=9952&ids%5B%5D=9951&ids%5B%5D=9950&ids%5B%5D=9949&ids%5B%5D=9948&ids%5B%5D=9947&ids%5B%5D=9946&ids%5B%5D=9945&ids%5B%5D=9944&ids%5B%5D=9943&ids%5B%5D=9942&ids%5B%5D=9941&ids%5B%5D=9940&ids%5B%5D=9939&ids%5B%5D=9938&ids%5B%5D=9937&ids%5B%5D=9936&ids%5B%5D=9935&ids%5B%5D=9934&ids%5B%5D=9933&ids%5B%5D=9932&ids%5B%5D=9931&ids%5B%5D=9930&ids%5B%5D=9929&ids%5B%5D=9928&ids%5B%5D=9927&ids%5B%5D=9926&ids%5B%5D=9925&ids%5B%5D=9924&ids%5B%5D=9923&ids%5B%5D=9922&ids%5B%5D=9921&ids%5B%5D=9920&ids%5B%5D=9919&ids%5B%5D=9918&ids%5B%5D=9917&ids%5B%5D=9916&ids%5B%5D=9915&ids%5B%5D=9914&ids%5B%5D=9913&ids%5B%5D=9912&ids%5B%5D=9911&ids%5B%5D=9910&ids%5B%5D=9909&ids%5B%5D=9908&ids%5B%5D=9907&ids%5B%5D=9906&ids%5B%5D=9905&ids%5B%5D=9904&ids%5B%5D=9903&ids%5B%5D=9902&ids%5B%5D=9901&ids%5B%5D=9900&ids%5B%5D=9899&ids%5B%5D=9898&ids%5B%5D=9897&ids%5B%5D=9896&ids%5B%5D=9895&ids%5B%5D=9894&ids%5B%5D=9893&ids%5B%5D=9892&ids%5B%5D=9891&ids%5B%5D=9890&ids%5B%5D=9889&ids%5B%5D=9888&ids%5B%5D=9887&ids%5B%5D=9886&ids%5B%5D=9885&ids%5B%5D=9884&ids%5B%5D=9883&ids%5B%5D=9882&ids%5B%5D=9881&ids%5B%5D=9880&ids%5B%5D=9879&ids%5B%5D=9878&ids%5B%5D=9877&ids%5B%5D=9876&ids%5B%5D=9875&ids%5B%5D=9874&ids%5B%5D=9873&ids%5B%5D=9872&ids%5B%5D=9871&ids%5B%5D=9870&ids%5B%5D=9869&ids%5B%5D=9868&ids%5B%5D=9867&ids%5B%5D=9866&ids%5B%5D=9865&ids%5B%5D=9864&ids%5B%5D=9863&ids%5B%5D=9862&ids%5B%5D=9861&ids%5B%5D=9860&ids%5B%5D=9859&ids%5B%5D=9858&ids%5B%5D=9857&ids%5B%5D=9856&ids%5B%5D=9855&ids%5B%5D=9854&ids%5B%5D=9853&ids%5B%5D=9852&ids%5B%5D=9851&ids%5B%5D=9850&ids%5B%5D=9849&ids%5B%5D=9848&ids%5B%5D=9847&ids%5B%5D=9846&ids%5B%5D=9845&ids%5B%5D=9844&ids%5B%5D=9843&ids%5B%5D=9842&ids%5B%5D=9841&ids%5B%5D=9840&ids%5B%5D=9839&ids%5B%5D=9838&ids%5B%5D=9837&ids%5B%5D=9836&ids%5B%5D=9835&ids%5B%5D=9834&ids%5B%5D=9833&ids%5B%5D=9832&ids%5B%5D=9831&ids%5B%5D=9830&ids%5B%5D=9829&ids%5B%5D=9828&ids%5B%5D=9827&ids%5B%5D=9826&ids%5B%5D=9825&ids%5B%5D=9824&ids%5B%5D=9823&ids%5B%5D=9822&ids%5B%5D=9821&ids%5B%5D=9820&ids%5B%5D=9819&ids%5B%5D=9818&ids%5B%5D=9817&ids%5B%5D=9816&ids%5B%5D=9815&ids%5B%5D=9814&ids%5B%5D=9813&ids%5B%5D=9812&ids%5B%5D=9811&ids%5B%5D=9810&ids%5B%5D=9809&ids%5B%5D=9808&ids%5B%5D=9806&ids%5B%5D=9805&ids%5B%5D=9804&ids%5B%5D=9803&ids%5B%5D=9802&ids%5B%5D=9801&ids%5B%5D=9800&ids%5B%5D=9799&ids%5B%5D=9798&ids%5B%5D=9797&ids%5B%5D=9796&ids%5B%5D=9795&ids%5B%5D=9794&ids%5B%5D=9793&ids%5B%5D=9792&ids%5B%5D=9791&ids%5B%5D=9790&ids%5B%5D=9789&ids%5B%5D=9788&ids%5B%5D=9787&ids%5B%5D=9786&ids%5B%5D=9785&ids%5B%5D=9784&ids%5B%5D=9783&ids%5B%5D=9782&ids%5B%5D=9781&ids%5B%5D=9780&ids%5B%5D=9779&ids%5B%5D=9778&ids%5B%5D=9777&ids%5B%5D=9776&ids%5B%5D=9775&ids%5B%5D=9774&ids%5B%5D=9773&ids%5B%5D=9772&ids%5B%5D=9771&ids%5B%5D=9770&ids%5B%5D=9769&ids%5B%5D=9768&ids%5B%5D=9767&ids%5B%5D=9766&ids%5B%5D=9765&ids%5B%5D=9764&ids%5B%5D=9763&ids%5B%5D=9762&ids%5B%5D=9761&ids%5B%5D=9760&ids%5B%5D=9759&ids%5B%5D=9758&ids%5B%5D=9757&ids%5B%5D=9756&ids%5B%5D=9755&ids%5B%5D=9754&ids%5B%5D=9753&ids%5B%5D=9752&ids%5B%5D=9751&ids%5B%5D=9750&ids%5B%5D=9749&ids%5B%5D=9748&ids%5B%5D=9747&ids%5B%5D=9746&ids%5B%5D=9745&ids%5B%5D=9744&ids%5B%5D=9740&ids%5B%5D=9739&ids%5B%5D=9738&ids%5B%5D=9737&ids%5B%5D=9736&ids%5B%5D=9735&ids%5B%5D=9734&ids%5B%5D=9733&ids%5B%5D=9732&ids%5B%5D=9731&ids%5B%5D=9730&ids%5B%5D=9729&ids%5B%5D=9728&ids%5B%5D=9727&ids%5B%5D=9726&ids%5B%5D=9725&ids%5B%5D=9724&ids%5B%5D=9723&ids%5B%5D=9722&ids%5B%5D=9721&ids%5B%5D=9720&ids%5B%5D=9719&ids%5B%5D=9718&ids%5B%5D=9717&ids%5B%5D=9716&ids%5B%5D=9715&ids%5B%5D=9714&ids%5B%5D=9713&ids%5B%5D=9712&ids%5B%5D=9711&ids%5B%5D=9710&ids%5B%5D=9709&ids%5B%5D=9708&ids%5B%5D=9707&ids%5B%5D=9706&ids%5B%5D=9705&ids%5B%5D=9704&ids%5B%5D=9703&ids%5B%5D=9702&ids%5B%5D=9698&ids%5B%5D=9697&ids%5B%5D=9696&ids%5B%5D=9695&ids%5B%5D=9694&ids%5B%5D=9693&ids%5B%5D=9692&ids%5B%5D=9691&ids%5B%5D=9690&ids%5B%5D=9689&ids%5B%5D=9688&ids%5B%5D=9687&ids%5B%5D=9686&ids%5B%5D=9685&ids%5B%5D=9684&ids%5B%5D=9683&ids%5B%5D=9682&ids%5B%5D=9681&ids%5B%5D=9680&ids%5B%5D=9679&ids%5B%5D=9678&ids%5B%5D=9677&ids%5B%5D=9676&ids%5B%5D=9675&ids%5B%5D=9674&ids%5B%5D=9673&ids%5B%5D=9672&ids%5B%5D=9671&ids%5B%5D=9670&ids%5B%5D=9669&ids%5B%5D=9668&ids%5B%5D=9667&ids%5B%5D=9666&ids%5B%5D=9665&ids%5B%5D=9664&ids%5B%5D=9663&ids%5B%5D=9662&ids%5B%5D=9661&ids%5B%5D=9660&ids%5B%5D=9659&ids%5B%5D=9658&ids%5B%5D=9657&ids%5B%5D=9656&ids%5B%5D=9655&ids%5B%5D=9654&ids%5B%5D=9653&ids%5B%5D=9652&ids%5B%5D=9651&ids%5B%5D=9650&ids%5B%5D=9649&ids%5B%5D=9648&ids%5B%5D=9647&ids%5B%5D=9646&ids%5B%5D=9645&ids%5B%5D=9644&ids%5B%5D=9643&ids%5B%5D=9642&ids%5B%5D=9641&ids%5B%5D=9640&ids%5B%5D=9639&ids%5B%5D=9" 414 539 "-" "-" 

I am no Redmine expert, maybe I am missing something. Is there another log I can have a look?

Actions #4

Updated by Etienne Massip over 11 years ago

T Mac wrote:

Looking at the apache log it does show the context menu request:

192.168.0.117 - - [22/Jan/2013:08:37:46 -0800] "GET /issues/context_menu?[...]" 414 539 "-" "-"

414 =)

Actions #5

Updated by T Mac over 11 years ago

  • Status changed from New to Resolved

Got me there. Thanks.

So I guess there is no "easy" way of making this work?

Actions #6

Updated by Etienne Massip over 11 years ago

  • Status changed from Resolved to Closed
  • Resolution set to Wont fix

T Mac wrote:

So I guess there is no "easy" way of making this work?

Well, you can try to increase to LimitRequestLine temporarily in your Apache configuration but I'm not sure that the Rack stack doesn't check it also.

Actions

Also available in: Atom PDF