Blocking query in trackers code
- Status
- Closed
- Subject
- Blocking query in trackers code
- Version
- 2.x
3.x - Category
- Error
- Dogfood on a *.tiki.org site
- Feature
- Trackers
Performance / Speed / Load / Compression / Cache - Resolution status
- Out of Date
- Submitted by
- amette
- Lastmod by
- Marc Laporte
- Rating
- Description
Every now and then dev.tw.o becomes unaccessible. The site gets slower and slower and eventually it stops working. The problem is with the database. Line 767 in lib/trackers/trackerlib.php
$query_cant = 'SELECT count(DISTINCT ttif.`itemId`) FROM '.$base_tables.$sort_tables.$cat_table.$mid;
Under some circumstances this query never returns from the database, runs forever and blocks the complete dev.tw.o database, making the site unresponsive.
- Importance
- 9 high
- Priority
- 45
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 2549
- Created
- Friday 05 June, 2009 13:33:32 UTC
by Unknown - LastModif
- Saturday 17 September, 2011 00:54:38 UTC