Mailing List Archive: Trac: Tickets

[The Trac Project] #3779: Reports takes minutes to compleet

Index | Next | Previous | View Threaded

noreply at edgewall

Sep 23, 2006, 11:43 PM

Post #1 of 13 (2140 views)
Permalink

[The Trac Project] #3779: Reports takes minutes to compleet

#3779: Reports takes minutes to compleet
----------------------------+-----------------------------------------------
Reporter: omry [at] yadan | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Keywords:
----------------------------+-----------------------------------------------
My database contains about 35 tickets.
recently reports started to work very slowly.
when I open a report, apache cpu usage spikes to 100% for a few minutes
(!) and then I get the results.
I insterted the sql query directly into sqlite3, and it returned instantly

--
Ticket URL: <http://trac.edgewall.org/ticket/3779>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Sep 25, 2006, 6:04 AM

Post #2 of 13 (2075 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Comment (by omry):

if you need my database or anything else to reproduce, just ask.

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:1>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Sep 25, 2006, 6:11 AM

Post #3 of 13 (2089 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Comment (by cboos):

Can you first try if this is reproductible for you using [TracStandalone
tracd]?

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:2>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Sep 25, 2006, 8:37 AM

Post #4 of 13 (2076 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: needinfo |
-----------------------------------+----------------------------------------
Changes (by mgood):

* keywords: => needinfo

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:3>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Sep 25, 2006, 10:30 AM

Post #5 of 13 (2074 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: needinfo |
-----------------------------------+----------------------------------------
Comment (by omry):

it is.

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:4>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Sep 25, 2006, 10:42 AM

Post #6 of 13 (2074 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: needinfo |
-----------------------------------+----------------------------------------
Comment (by omry):

I mean, it is reproduceable with tracd.

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:5>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Sep 30, 2006, 2:38 PM

Post #7 of 13 (2086 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone: 0.10.1
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Changes (by omry):

* keywords: needinfo =>
* milestone: => 0.10.1

Comment:

assigned to milestone 0.10.1

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:6>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Sep 30, 2006, 3:38 PM

Post #8 of 13 (2077 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Changes (by eblot):

* milestone: 0.10.1 =>

Comment:

Do not assign a milestone without providing a reason or a patch.

Please describe your environment (version of the OS, Python, Svn,
Pysqlite, etc.)

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:7>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Oct 1, 2006, 4:30 AM

Post #9 of 13 (2066 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Comment (by omry):

Debian etch.
Kernel 2.6.15.
Python 2.4
SVN 1.3.2
pysqlite:
1.1.7-2 AND 2.3.2-1 (could this be the problem?)

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:8>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Oct 1, 2006, 4:33 AM

Post #10 of 13 (2064 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Comment (by anonymous):

and sqlite 3.3.7

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:9>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Oct 1, 2006, 6:28 AM

Post #11 of 13 (2058 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Comment (by trac [at] yadan):

registered email.

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:10>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Oct 6, 2006, 3:36 AM

Post #12 of 13 (2066 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: daniel
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Comment (by trac [at] yadan):

figured it out:
ticket 35 in the attached database had a long message insife ![brackets].
when I deleted it from the database all went back to normal.

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:11>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

noreply at edgewall

Oct 6, 2006, 3:48 AM

Post #13 of 13 (2068 views)
Permalink

Re: [The Trac Project] #3779: Reports takes minutes to compleet [In reply to]

#3779: Reports takes minutes to compleet
-----------------------------------+----------------------------------------
Reporter: omry at yadan dot net | Owner: cboos
Type: defect | Status: new
Priority: high | Milestone:
Component: report system | Version: 0.10b1
Severity: critical | Resolution:
Keywords: |
-----------------------------------+----------------------------------------
Changes (by cboos):

* owner: daniel => cboos

Comment:

hm, that's not a good reason to take minutes...
Can you please copy/paste that message in a block, here? (or attach it?)

--
Ticket URL: <http://trac.edgewall.org/ticket/3779#comment:12>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets [at] googlegroups
To unsubscribe from this group, send email to trac-tickets-unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads