[Trac] Trac is very slow when modifying a ticket
Hi, I have some troubles with trac performance. It's quite slow and mainly when modifying tickets (it can take 20 seconds). I've checked tickets in trac about that : #7785 #7490 In my log, I also have plenty of : Trac[__init__] DEBUG: 17130 unreachable objects found. but also hundreds like that : 2009-09-30 10:39:52,434 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,440 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,446 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,451 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,456 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,462 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,467 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,473 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,478 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,483 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,489 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,494 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,499 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,504 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,510 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,515 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,520 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,526 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,531 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,536 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,542 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,547 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,552 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,557 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,563 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,568 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* 2009-09-30 10:39:52,573 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* I'm running version 0.11.2.1, using apache with mod_python, sqlite3. Any idea ? Thanks ! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Login not working.
On Wed, Sep 30, 2009 at 2:12 AM, Andrew Nelson nelso...@pobox.com wrote: Location /login AuthType Basic AuthName Trac AuthUserFile /srv/www/red**.htpass Require valid-user /Location /VirtualHost -Andrew Hello, Do you have any plugins installed? I have Location /login, so without the quotes. I don't know if this makes a difference for apache. Joeri --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Internal Error for TracForge with Trac 0.11
Hi, Does anyone know whats this error? I am trying this, so that I can recommend the setup to a org. Vishnu --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Trac is very slow when modifying a ticket
Fabien wrote: Hi, I have some troubles with trac performance. It's quite slow and mainly when modifying tickets (it can take 20 seconds). I've checked tickets in trac about that : #7785 #7490 In my log, I also have plenty of : Trac[__init__] DEBUG: 17130 unreachable objects found. but also hundreds like that : 2009-09-30 10:39:52,434 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* ... 2009-09-30 10:39:52,573 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* Well it seems wrong to have that many checks (you don't have 100s of attachments to that ticket, do you?). The Trac[__init__] part looks suspicious, this must come from some plugin (check your [trac] permission_policies setting in trac.ini, to see which permission policies are in use). Also, here we've only spent 140 ms: if you measure the time span for the whole range of such lines, does this account for the 20s? -- Christian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Trac is very slow when modifying a ticket
On Wed, Sep 30, 2009 at 3:09 PM, Christian Boos cb...@neuf.fr wrote: Fabien wrote: Hi, I have some troubles with trac performance. It's quite slow and mainly when modifying tickets (it can take 20 seconds). I've checked tickets in trac about that : #7785 #7490 In my log, I also have plenty of : Trac[__init__] DEBUG: 17130 unreachable objects found. but also hundreds like that : 2009-09-30 10:39:52,434 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* ... 2009-09-30 10:39:52,573 Trac[__init__] DEBUG: Checking TICKET_MODIFY on ticket:1...@* Well it seems wrong to have that many checks (you don't have 100s of attachments to that ticket, do you?). No :) The Trac[__init__] part looks suspicious, this must come from some plugin (check your [trac] permission_policies setting in trac.ini, to see which permission policies are in use). I have that : permission_policies = AuthzPolicy, DefaultPermissionPolicy, LegacyAttachmentPolicy Also, here we've only spent 140 ms: if you measure the time span for the whole range of such lines, does this account for the 20s? It takes 5 or 6 seconds. We just discovered that it's also related to restrict_users problem : http://trac.edgewall.org/ticket/4245 When restrict_owner = false, it's ok. We have around 1000 registered users... -- Fabien --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Trac Report SQL Query and Last Modified Date
I have something like this going right now. Decided I was going to try and do it in hours and then work it to days strftime('%s','now') - strftime('%s','changetime') / 3600 That doesn't seem to work at present although I am pretty sure that it should. On Sep 28, 2:30 pm, Erik Bray hyugaricd...@gmail.com wrote: On Sun, Sep 27, 2009 at 1:43 PM, zdgman zdg...@gmail.com wrote: Hello All, I am trying to get the lastmodified column in this query on the Trac Dev Site http://trac.edgewall.org/report/20 I know how to create lastmodified as a date but can't seem to get it listed out as a day's since last updated. Would it be possible for me to see the SQL query from the edgewall site? Thanks. If you want the number of days since the ticket was last modified, that's just simple math: Take the current date/time as a unix timestamp, subtract the modified time, and divide by (3600 * 24). --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Trac Report SQL Query and Last Modified Date
Here is the actual query (I did not write this) that works for me, just in case anyone else needs: SELECT p.value AS __color__, id AS ticket, summary, component, version, milestone, t.severity AS severity, (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner, (CASE WHEN strftime('%s','now') - changetime 86400 THEN round((strftime('%s','now') - changetime)/86400,0) || ' days' WHEN strftime('%s','now') - changetime 3600 THEN round((strftime('%s','now') - changetime)/3600,0) || ' hours' ELSE (strftime('%s','now') - changetime)/60 || ' mins' END) AS Modified, author as Modified_By, description AS _description, reporter AS _reporter FROM ticket t, enum p, (SELECT ticket, author, MAX(time) FROM ticket_change WHERE field = 'comment' GROUP BY ticket) tc WHERE status IN ('new', 'assigned', 'reopened') AND p.name = t.priority AND p.type = 'priority' AND t.id = tc.ticket ORDER BY changetime desc, p.value, milestone, t.severity, time On Sep 30, 11:32 am, zdgman zdg...@gmail.com wrote: I have something like this going right now. Decided I was going to try and do it in hours and then work it to days strftime('%s','now') - strftime('%s','changetime') / 3600 That doesn't seem to work at present although I am pretty sure that it should. On Sep 28, 2:30 pm, Erik Bray hyugaricd...@gmail.com wrote: On Sun, Sep 27, 2009 at 1:43 PM, zdgman zdg...@gmail.com wrote: Hello All, I am trying to get the lastmodified column in this query on the Trac Dev Site http://trac.edgewall.org/report/20 I know how to create lastmodified as a date but can't seem to get it listed out as a day's since last updated. Would it be possible for me to see the SQL query from the edgewall site? Thanks. If you want the number of days since the ticket was last modified, that's just simple math: Take the current date/time as a unix timestamp, subtract the modified time, and divide by (3600 * 24). --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] customize milestone view?
I've implemented a custom ticket workflow in 11.5 that adds a verify status for qa purposes, it works exactly as I need it to. The only thing that isn't working the way I would like it to now is the milestone page, it shows closed, active and total tickets. I would like to add a new summary for tickets that are status verify. Is this something I can write a plugin for? Modify existing code? Cheers Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Emails Blank
We are running on Trac 10.4 and are having issues where some of the emails show up blank. Does not seem to be a consistant issue. Also the issues seems to only really have to do with outlook because the same email coming to my iPhone has the content. If this were one computer I'd say say it's just an issue with that machine but it happens to every machine in the office, and the same emails will be blank across all machines. What's even more interesting is that rules and filters based on content within the email all seem to work. Anyone have any idea what might be going on or has anyone seen this before. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Emails Blank
On Wed, Sep 30, 2009 at 10:39:55AM -0700, David Herman wrote: We are running on Trac 10.4 and are having issues where some of the emails show up blank. Does not seem to be a consistant issue. Also the issues seems to only really have to do with outlook because the same email coming to my iPhone has the content. If this were one computer I'd say say it's just an issue with that machine but it happens to every machine in the office, and the same emails will be blank across all machines. What's even more interesting is that rules and filters based on content within the email all seem to work. Anyone have any idea what might be going on or has anyone seen this before. I don't know if this is possible with outlook, but I would start by looking at the raw content of the incoming email (including headers) and trying to figure out why outlook isn't displaying it. If it works fine on the iPhone, I'm guessing there is content there, but outlook doesn't like it. Jeff --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: customize milestone view?
pagameba wrote: I've implemented a custom ticket workflow in 11.5 that adds a verify status for qa purposes, it works exactly as I need it to. The only thing that isn't working the way I would like it to now is the milestone page, it shows closed, active and total tickets. I would like to add a new summary for tickets that are status verify. You're looking for http://trac.edgewall.org/wiki/TracRoadmapCustomGroups Is this something I can write a plugin for? Modify existing code? No, it's part of the base ticket module, you don't need anything else. -- Christian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Emails Blank
According to outlook there are no headers at all. very strange On Sep 30, 2:12 pm, Jeff Hammel jham...@openplans.org wrote: On Wed, Sep 30, 2009 at 10:39:55AM -0700, David Herman wrote: We are running on Trac 10.4 and are having issues where some of the emails show up blank. Does not seem to be a consistant issue. Also the issues seems to only really have to do with outlook because the same email coming to my iPhone has the content. If this were one computer I'd say say it's just an issue with that machine but it happens to every machine in the office, and the same emails will be blank across all machines. What's even more interesting is that rules and filters based on content within the email all seem to work. Anyone have any idea what might be going on or has anyone seen this before. I don't know if this is possible with outlook, but I would start by looking at the raw content of the incoming email (including headers) and trying to figure out why outlook isn't displaying it. If it works fine on the iPhone, I'm guessing there is content there, but outlook doesn't like it. Jeff --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Emails Blank
Sounds to me like an issue with Outlook's handling of multipart emails. I wouldn't be surprised if it silently preferred an HTML version, and you're Trac (or something downstream of it in the stack) is delivering message w/ an empty HTML part. A quick Google for 'emails blank in outlook' has ~ 7.5 million hits. Ross -- Ross Reedstrom, Ph.D. reeds...@rice.edu Systems Engineer Admin, Research Scientistphone: 713-348-6166 The Connexions Project http://cnx.orgfax: 713-348-3665 Rice University MS-375, Houston, TX 77005 GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE On Wed, Sep 30, 2009 at 10:39:55AM -0700, David Herman wrote: We are running on Trac 10.4 and are having issues where some of the emails show up blank. Does not seem to be a consistant issue. Also the issues seems to only really have to do with outlook because the same email coming to my iPhone has the content. If this were one computer I'd say say it's just an issue with that machine but it happens to every machine in the office, and the same emails will be blank across all machines. What's even more interesting is that rules and filters based on content within the email all seem to work. Anyone have any idea what might be going on or has anyone seen this before. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: Internal Error for TracForge with Trac 0.11
On Wed, Sep 30, 2009 at 7:22 AM, vishnu vishnu.ku...@mahiti.org wrote: Hi, Does anyone know whats this error? I am trying this, so that I can recommend the setup to a org. Vishnu From TracForge's setup.py: 4 import os 5 if os.getlogin() != 'coderanger': 6 print 'DO NOT USE THIS CODE YET.' 7 import sys 8 sys.exit(1) That's there for a reason. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
[Trac] Re: customize milestone view?
perfect, thanks to both Christian and yoheeb, the custom groups thing did the trick but I think I want to add some more groups now and will need the css options for that. Cheers Paul On 2009-09-30, at 2:55 PM, yoheeb wrote: On Sep 30, 6:16 pm, Christian Boos cb...@neuf.fr wrote: pagameba wrote: I've implemented a custom ticket workflow in 11.5 that adds a verify status for qa purposes, it works exactly as I need it to. The only thing that isn't working the way I would like it to now is the milestone page, it shows closed, active and total tickets. I would like to add a new summary for tickets that are status verify. You're looking forhttp://trac.edgewall.org/wiki/TracRoadmapCustomGroups Is this something I can write a plugin for? Modify existing code? No, it's part of the base ticket module, you don't need anything else. -- Christian you may also want to create some custom milestone related css stuff, and add that to you site.css as recommended here: http://trac.edgewall.org/wiki/TracInterfaceCustomization specificall the ProjectTemplates section at the bottom. for reference, I am including mine, I use bot the built in Red, green, yellow, and a couple custom ones in my roadmap for special states, 4 states are enough (red, green, yellow, wite) then there is no need for the css stuff. The states are active, closed, moreinfo, new, and reqsverfication. Of note, both closed and reqsverification counts towards overall completion percentage as done I also point the site.css to a separate css file for the roadmaps, probably over kill, but I did this so I can use a global file for most, or, as in this case, use something specifically local, which is in the htdocs directory of the project. Anyway, hope it helps trac.ini: [milestone-groups] active = * active.css_class = open active.label = in progress active.order = 4 closed = closed closed.css_class = closed closed.order = 0 closed.overall_completion = true closed.query_args = group=resolution moreinfo = needmoreinfo,needinfo moreinfo.css_class = moreInfo moreinfo.label = Need Info moreinfo.order = 2 new = new new.css_class = newticket new.label = New new.order = 3 reqsverification = reqsVerification reqsverification.css_class = new reqsverification.label = Unverified reqsverification.order = 1 reqsverification.overall_completion = true reqsverification.query_args = group=owner site.css: html xmlns=http://www.w3.org/1999/xhtml; xmlns:py=http://genshi.edgewall.org/; py:strip= !--! Custom match templates go here -- !--! Add site-specific style sheet -- head py:match=head py:attrs=select('@*') ${select('*|comment()|text()')} link rel=stylesheet type=text/css href=${href.chrome('site/rm.css')} / /head /html rm.css: table.progress td.moreInfo { background: #ff} table.progress td.newticket { background: #AA} --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---