[rt-devel] RT 2.0.10-test3 BROKEN
Feargal Reilly
feargal at thecia.ie
Tue Dec 18 14:35:26 EST 2001
Experiencing _very_ badly broken 'New Search' with Pg.
WebUI working fine with queue/ticket listings, but when I hit 'New' or 'Advanced' search, the client hangs, while the backend keeps querying the db.
I've 9 out of 11 queues active, and 8 enabled users.
I just hit Search/Listing.html?NewSearch=1&Debug=1, grabbed some food, and 28 minutes later, there were 14,246 queries in the postgres log, and the client was still loading...
It seems to have built a list of watchers, and is then querying based on each one - in my case I've 15,365 in the watchers table.
Here's a sample of the logs:
2001-12-18 19:24:02 DEBUG: query: SELECT DISTINCT main.* FROM Watchers main WHERE ((main.Value = '12922')) AND ((main.Type = 'Requestor')) AND ((main.Scope = 'Ticket'))
2001-12-18 19:24:02 DEBUG: query: SELECT DISTINCT main.* FROM Watchers main WHERE ((main.Value = '12923')) AND ((main.Type = 'Requestor')) AND ((main.Scope = 'Ticket'))
2001-12-18 19:24:02 DEBUG: query: SELECT * FROM Users WHERE id = '455'
2001-12-18 19:24:02 DEBUG: query: SELECT DISTINCT main.* FROM Watchers main WHERE ((main.Value = '12924')) AND ((main.Type = 'Requestor')) AND ((main.Scope = 'Ticket'))
2001-12-18 19:24:02 DEBUG: query: SELECT DISTINCT main.* FROM Watchers main WHERE ((main.Value = '12925')) AND ((main.Type = 'Requestor')) AND ((main.Scope = 'Ticket'))
2001-12-18 19:24:02 DEBUG: query: SELECT * FROM Users WHERE id = '158'
2001-12-18 19:24:03 DEBUG: query: SELECT DISTINCT main.* FROM Watchers main WHERE ((main.Value = '12926')) AND ((main.Type = 'Requestor')) AND ((main.Scope = 'Ticket'))
2001-12-18 19:24:03 DEBUG: query: SELECT DISTINCT main.* FROM Watchers main WHERE ((main.Value = '12927')) AND ((main.Type = 'Requestor')) AND ((main.Scope = 'Ticket'))
2001-12-18 19:24:03 DEBUG: query: SELECT DISTINCT main.* FROM Watchers main WHERE ((main.Value = '12928')) AND ((main.Type = 'Requestor')) AND ((main.Scope = 'Ticket'))
Note the second "select * from users where id = '455'"
The 455 is the value for owner/created/lastupdated returned by the pervious query on the watchers table.
It appears to be only doing the query on the users table when it gets a new owner/created/lastupdated value.
Using test3 of both rt and DBIx, previous test2 versions were running beautifully.
Let me know if you want more debugging.
-Feargal.
On Mon, 17 Dec 2001 15:26:20 -0500
Jesse Vincent <jesse at bestpractical.com> wrote:
>
> RT 2.0.10-test3 is out (along with DBIx::SearchBuilder 0.48-test3, which it requires). 2.0.10 has a _lot_ of cleanups in it, along with a big performance
> boost for RT on postgres. There are one or two minor things that I need
> to do before 2.0.10, but I'd really love to hear how this works for folks.
>
> -j
>
>
>
>
> 2001-12-17 15:13 jesse
>
> * Makefile:
>
> Bumped the version to 2.0.10-test3
>
> 2001-12-17 14:58 jesse
>
> * lib/RT/User.pm, tools/insertdata, webrt/Admin/Users/Modify.html:
>
> RT-Ticket: 935
> RT-Status: resolved
>
> cleaned up seph's patch. this enabled me to actually really properly support
> users with no email address, which meant there were a couple other cleanups
> to go through too.
>
> 2001-12-17 14:26 jesse
>
> * lib/RT/Ticket.pm:
>
> Some small cleanups to the IsWatcher stuff.
>
> Added checks to make sure that watchers aren't duplicated to ticket.pm
>
> 2001-12-17 13:04 jesse
>
> * webrt/Ticket/Elements/ShowTransaction:
>
> Fixed an unclosed anchor which caused IE to render ticket listings wrong.
>
> 2001-12-14 18:29 jesse
>
> * lib/Makefile.PL, tools/testdeps:
>
> Bumped DBIx::SearchBuilder dependency to 0.48
>
> 2001-12-14 18:28 jesse
>
> * tools/testdeps, webrt/Elements/Login:
>
> Removed code to special case for bugs in mason < 1.01.
> Moved us up to a mason 1.02 dependency
>
> 2001-12-14 18:26 jesse
>
> * bin/rt:
>
> bin/rt: added support for --version, fixed --status = !closed, docced --merge-into
>
> 2001-12-14 18:25 jesse
>
> * Makefile:
>
> Some stylistic cleanups to the makefile from blair.
>
> 2001-12-14 16:42 jesse
>
> * bin/rtadmin:
>
> rtadmin had some issues where it would assume a 'name' if called without --name for user group and queue editing.
>
> 2001-12-14 16:06 jesse
>
> * lib/RT/Tickets.pm:
>
>
> Ticket listings will no longer show tickets which have been merged into others.
>
> -j
>
> 2001-12-14 15:27 jesse
>
> * lib/RT/User.pm:
>
> Prevent users from futzing with nobody or rt_System, unless you're setting an email address.
> (Arguably, that's a bug too)
>
> 2001-12-14 14:03 jesse
>
> * lib/RT/: ACE.pm, Group.pm, GroupMember.pm, Keyword.pm,
> KeywordSelect.pm, Queue.pm, Scrip.pm, Template.pm, Ticket.pm:
>
> Standardised on "Permission Denied" instead of having some "Permission denied". Thanks simon.
>
> -j
>
> 2001-12-14 13:46 jesse
>
> * lib/RT/Interface/Web.pm:
>
> Reordered the order that Basics actions are committed, so that Queue changes
> come after other changes, so that users don't move tickets out of a queue before they have a
> chance to update them.
>
> 2001-12-13 02:18 jesse
>
> * lib/RT/Ticket.pm:
>
> Addition to Ticket->Import, so you can set owner by name.
>
> Fix for a bug in Ticket->AddWatcher that would let privileged watchers without
> email addresses add others as watchers.
>
> 2001-12-03 20:13 jesse
>
> * Makefile, lib/RT/EasySearch.pm, lib/RT/Keyword.pm,
> lib/RT/Record.pm, lib/RT/Tickets.pm, lib/RT/User.pm:
>
> more work on making sure that only the things we want are case sensitive
> (IE name, content email address should always be insensitive. when loading a row by any field other than ID, that should be case-insensitive)
>
> 2001-12-03 19:17 jesse
>
> * Makefile:
>
> bumped the version to 2.0.10-test1
>
> 2001-12-03 19:14 jesse
>
> * lib/RT/EasySearch.pm:
>
> We now default to case sensitive searches, rather than case-insensitive ones.
> (This should speed up Pg a LOT. We'll be adding in case-insensitive searching
> for the 13 attributes that matter:
>
> Watcher->Email
> User->name
> User->email
> User->gecos
> Ticket->Subject
> Queue->name
> KeywordSelect->name
> Keyword->Name
> ObjectKeyword->Name
> Attachment->Subject
> Attachment->Content
> Attachment->Headers
>
> 2001-12-03 19:13 jesse
>
> * webrt/: Admin/Queues/Modify.html, Admin/Queues/People.html,
> Elements/GotoTicket:
>
> Some small UI cleanups from Hakke
>
> 2001-11-29 03:50 jesse
>
> * webrt/: Elements/SelectEqualityOperator, Elements/SelectOwner,
> Search/PickRestriction:
>
> SelectOwner now passes a ticket up the line.
>
> Priority can now have = and != searches
>
> 2001-11-29 03:49 jesse
>
> * tools/insertdata:
>
> Cleaned up a template to display Ticket subject, if no transaction subject is given.
>
> 2001-11-29 03:48 jesse
>
> * webrt/Ticket/: Update.html, Elements/EditPeople:
>
> Now pass in ticket Id, so that "owner" can be someone who only has rights to that tikcet.
>
> 2001-11-29 03:47 jesse
>
> * lib/RT/Ticket.pm:
>
> FinalPriority should never get set to null if a ticket doesn't have the attribute set on create
>
> Untake's arguments were debognifed
>
> 2001-11-29 03:45 jesse
>
> * webrt/SelfService/Elements/Header:
>
> "Logout" no longer shows up when using external auth with SelfService
>
> 2001-11-29 03:44 jesse
>
> * bin/rt:
>
> Fix for setting priority when creating tickets with the cli
>
> 2001-11-29 03:42 jesse
>
> * bin/rt-mailgate:
>
> Added support for --ticket-id-from-extension to rt-mailgate
>
> --
> http://www.bestpractical.com/products/rt -- Trouble Ticketing. Free.
>
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
>
--
Feargal Reilly, | Communications House,
Systems Administrator. | 1a Lower Pembroke Street,
The CIA - http://www.thecia.ie/ | Dublin 2,
Ph: +353-1-6768230 Fax: +353-1-6767720 | Ireland.
PGP fingerprint: 9EA0 F62E 2345 6062 E522 00F2 31D0 B1B0 D678 96DB
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20011218/a8ffc216/attachment.pgp
More information about the Rt-devel
mailing list