apache application error

[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

[anonymous]

apache error reported by windows

[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

[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.

[Noah Kantrowitz]

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.

[laughsmile]

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.

[Noah Kantrowitz]

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.

[laughsmile]

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. :)

[Noah Kantrowitz]

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

[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.