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

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

Sep 23, 2006, 11:43 PM

Post #1 of 13 (4658 views)

#3779: Reports takes minutes to compleet
----------------------------+-----------------------------------------------
Reporter: omry@yadan.net | 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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Sep 25, 2006, 6:04 AM

Post #2 of 13 (4576 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Sep 25, 2006, 6:11 AM

Post #3 of 13 (4591 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Sep 25, 2006, 8:37 AM

Post #4 of 13 (4566 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Sep 25, 2006, 10:30 AM

Post #5 of 13 (4563 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Sep 25, 2006, 10:42 AM

Post #6 of 13 (4572 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Sep 30, 2006, 2:38 PM

Post #7 of 13 (4589 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Sep 30, 2006, 3:38 PM

Post #8 of 13 (4569 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Oct 1, 2006, 4:30 AM

Post #9 of 13 (4562 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Oct 1, 2006, 4:33 AM

Post #10 of 13 (4564 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Oct 1, 2006, 6:28 AM

Post #11 of 13 (4559 views)

Permalink

#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@yadan.net):

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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Oct 6, 2006, 3:36 AM

Post #12 of 13 (4561 views)

Permalink

#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@yadan.net):

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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---

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

noreply at edgewall

Oct 6, 2006, 3:48 AM

Post #13 of 13 (4563 views)

Permalink

#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@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---