Modify

Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#2821 closed defect (wontfix)

apache application error

Reported by: laughsmile Owned by: coderanger
Priority: normal Component: PrivateTicketsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

I am using the private tickets plugin.
When I login with a user with the TICKET_VIEW_GROUP permission, and try to view some reports, it execute very slowly.and sometimes I meet apache application error which I attach .

so I debug the source code.I found the bottleneck is At
http://trac-hacks.org/browser/privateticketsplugin/0.10/privatetickets/report.py#L52

when I delete this line .program will be executed very quickly.

I found someone else may also meet the same problem.
http://trac-hacks.org/ticket/2237
http://trac-hacks.org/ticket/1433

Attachments (1)

Apache Error.png (6.1 KB) - added by anonymous 7 years ago.
apache error reported by windows

Download all attachments as: .zip

Change History (9)

Changed 7 years ago by anonymous

apache error reported by windows

comment:1 in reply to: ↑ description Changed 7 years ago by anonymous

I use:
Python2.4
trac-0.10.4
Apache 2.0.63
DataBase:SQLite

Replying to laughsmile:

I am using the private tickets plugin.
When I login with a user with the TICKET_VIEW_GROUP permission, and try to view some reports, it execute very slowly.and sometimes I meet apache application error which I attach .

so I debug the source code.I found the bottleneck is At
http://trac-hacks.org/browser/privateticketsplugin/0.10/privatetickets/report.py#L52

when I delete this line .program will be executed very quickly.

I found someone else may also meet the same problem.
http://trac-hacks.org/ticket/2237
http://trac-hacks.org/ticket/1433

comment:2 in reply to: ↑ description Changed 7 years ago by anonymous

when I delete http://trac-hacks.org/browser/privateticketsplugin/0.10/privatetickets/report.py#L52 .

program will be executed very quickly And there is also no Apache error.

comment:3 Changed 7 years ago by coderanger

  • Resolution set to wontfix
  • Status changed from new to closed

This would result in data leakage. You could reconstruct counts of secure information by looking at the size of the gaps in the HDF.

Just the last two tickets you cited, there is still nothing I can do about this. If you need a more powerful server, I suggest you purchase one.

comment:4 Changed 7 years ago by laughsmile

  • Resolution wontfix deleted
  • Status changed from closed to reopened

It is so kind of you to answer my question so quickly.

Thank you so much!

I don't want to delete http://trac-hacks.org/browser/privateticketsplugin/0.10/privatetickets/report.py#L52

I just want to point out where is the bottleneck and hope I can do something to help to improve the performance.

forget to say,My PC's Os is windows XP SP2.
I also install the environment in other Power Server.(OS:Windows Server 2003 RS2.Spec:Intel Xeon Cpu X3210 @2.13GHZ,2.24GHZ,1GB RAM).
the apache error disappear but the speed is also very slow.
there is very little(more than one hundred)records in my table and I access it in local Pc.

comment:5 follow-up: Changed 7 years ago by coderanger

  • Resolution set to wontfix
  • Status changed from reopened to closed

Nope, no way to improve it really. Also the 0.10 version of this plugin is now abandoned by me anyway. Someone was kind enough to do an initial port to 0.11 for me, so a nice new version should be available in a bit.

comment:6 in reply to: ↑ 5 Changed 7 years ago by laughsmile

  • Resolution wontfix deleted
  • Status changed from closed to reopened

thank you so much for your reply!

I am so sorry to bother you again.

now I test that in that power server again and again.
It seem to be sometimes very quick but sometimes very slow(especially when I restart the apache).

by the way,now I found the copy function in http://trac-hacks.org/browser/privateticketsplugin/0.10/privatetickets/report.py#L52 seem to be invoked like:
report.py→Python24\Lib\site-packages\trac\web\clearsilver.py→
Python24\Lib\site-packages\neo_cgi.pyd

I found hdf_copy function is used in neo_util.c of clearsilver,and I also found the help info in the url below.
http://linux.die.net/man/3/hdf_copy

is hdf_copy function a linux library function which will work well in linux but be crazy in windows?

btw,if I am not new to python,I want to do something to help to create a artwork.
:)

comment:7 Changed 7 years ago by coderanger

  • Resolution set to wontfix
  • Status changed from reopened to closed

If you reopen this ticket again I will delete it out of spite. Have a nice day.

comment:8 Changed 7 years ago by laughsmile

I am so sorry!
I don't know you are so care about that.
I will not reopen the ticket now.
I also hope if sometime you have time ,would you please answer my question.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.